Googlesheets Get Spreadsheet Info

Retrieves metadata for a Google Spreadsheet using its ID. By default, returns essential information (ID, title, sheet properties) to avoid payload size issues. Use the fields parameter for comprehensive metadata or specific fields.

价格

免费操作

统一支付

暂不支持

• fieldsstring
  Optional. Field mask specifying which fields to return. Uses Google's field mask syntax (comma-separated, dot-notation for nested fields). If not specified, a default mask returning common fields (spreadsheet ID, title, sheet properties) is applied to avoid payload size issues.…
• rangesarray
  Optional. The ranges to retrieve from the spreadsheet, specified using A1 notation (e.g., 'Sheet1!A1:D5', 'Sheet2!A1:C4'). Multiple ranges can be requested simultaneously. If not specified, metadata for the entire spreadsheet is returned without grid data.
• spreadsheet_idstring
  Required. The Google Sheets spreadsheet ID or full URL. Accepts either the ID alone (e.g., '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms') or a full Google Sheets URL (e.g., 'https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit'). The ID will…
• include_grid_databoolean
  Optional. If true, grid data will be returned. This parameter is ignored if a field mask was set in the request. When false or not specified, only metadata is returned without cell values.
• exclude_tables_in_banded_rangesboolean
  Optional. If true, tables within banded ranges will be omitted from the response. Default is false when not specified.

• data

  必填
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必填
  Whether or not the action execution was successful or not

尚未关联经过验证的相关使用场景。