Googlesheets Batch Get
Aident Loadout を通じて Google Sheets Tools の Googlesheets Batch Get を使用します。実行前に入力、出力、設定、料金、リスクを確認できます。
書き込み Actionリスクレベル 2/5OAuth 接続無料 Action
プロバイダーの説明
Retrieves data from specified cell ranges in a Google Spreadsheet.
Aident Loadout を通じて Google Sheets Tools の Googlesheets Batch Get を使用します。実行前に入力、出力、設定、料金、リスクを確認できます。
Retrieves data from specified cell ranges in a Google Spreadsheet.
rangesarrayA list of cell ranges in A1 notation from which to retrieve data. If this list is omitted, empty, or contains only empty strings, all data from the first sheet of the spreadsheet will be fetched. Empty strings in the list are automatically filtered out. Supported formats: (1) Ba…
majorDimensionstringThe major dimension for organizing data in results.
spreadsheet_id必須stringThe unique identifier of the Google Spreadsheet from which data will be retrieved. This is the ID found in the spreadsheet URL after /d/. You can provide either the spreadsheet ID directly or a full Google Sheets URL (the ID will be extracted automatically).
valueRenderOptionstringHow values should be rendered in the output. FORMATTED_VALUE: Values are calculated and formatted (default). UNFORMATTED_VALUE: Values are calculated but not formatted. FORMULA: Values are not calculated; the formula is returned instead.
dateTimeRenderOptionstringHow dates and times should be rendered in the output. SERIAL_NUMBER: Dates are returned as serial numbers (default). FORMATTED_STRING: Dates returned as formatted strings.
empty_strings_filteredbooleanIndicates whether empty strings were filtered from the response.
data必須Data from the action execution
errorstringError if any occurred during the execution of the action
successful必須booleanWhether or not the action execution was successful or not
OAuth 接続。リスクレベル 2/5。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。