Get Spreadsheet Details

The Get Spreadsheet Details action reads workbook-level metadata without loading cell data. Use it to validate a spreadsheet or discover the sheets it contains.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account used to read the spreadsheet.
Spreadsheet ID or URL	String	Yes	Direct spreadsheet ID or standard Google Sheets URL.

Outputs

Output	Type	Description
Spreadsheet ID	String	Unique spreadsheet identifier.
Title	String	Spreadsheet title.
URL	String	URL that opens the spreadsheet.
Sheets	List of sheets	Sheet metadata in workbook order.

Each Sheets item contains:

Field	Type	Description
Sheet ID	String	Numeric Google sheet ID represented as a string.
Title	String	Sheet tab name.
Index	Number	Zero-based position of the sheet tab.

A spreadsheet is the whole file; a sheet is one tab inside it. Most table and row actions expect a sheet title, not the numeric Sheet ID.

Get Table Row Range(s)Read one or more inclusive row ranges as table objects.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

​Inputs

​Outputs

Inputs

Outputs