使用 Google Sheets Tools 执行 Googlesheets Batch Get

rangesarray

A 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…

majorDimensionstring

The major dimension for organizing data in results.

spreadsheet_idstring

必填

The 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).

valueRenderOptionstring

How 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.

dateTimeRenderOptionstring

How 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_filteredboolean

Indicates whether empty strings were filtered from the response.

Googlesheets Batch Get

服务提供商说明

Googlesheets Batch Get

服务提供商说明

价格与限制

输入

可观察输出

使用此操作的技能

使用此操作的技能

相关使用场景

官方来源

使用此操作的技能