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.

मूल्य

मुफ़्त Action

एकीकृत भुगतान

अभी समर्थित नहीं

• 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

अभी कोई सत्यापित संबंधित उपयोग मामला लिंक नहीं है।