[Google] Get Sheet Info
The [Google] Get Sheet Info block retrieves metadata from a Google Spreadsheet, including the spreadsheet's title and details about each sheet it contains.
Retrieve metadata from any Google Spreadsheet
The [Google] Get Sheet Info block retrieves metadata from a Google Spreadsheet, including the spreadsheet's title and details about each sheet it contains. It does not read cell data — instead, it returns structural information such as sheet names, row counts, and column counts for every sheet in the document.
The block takes a Google Spreadsheet ID or URL as its primary input, along with an optional Google OAuth connection ID and a destination variable where the result will be stored. The output is an object containing the spreadsheet title and an array of sheet objects, each with a numeric sheet ID, a title, a row count, and a column count.
This block fits into workflows where a subsequent step needs to know the structure of a spreadsheet before reading or writing data — for example, dynamically selecting which sheet to target, validating that a sheet exists, or checking the dimensions of a sheet before iterating over its rows. It is commonly used as a setup or discovery step at the beginning of a larger Google Sheets workflow.
What you can build
Real-world workflows powered by the [Google] Get Sheet Info block.
Dynamic Sheet Selection
Retrieve all sheet names from a spreadsheet so a later block can programmatically select the correct sheet to read from or write to.
Spreadsheet Structure Validation
Check that a required sheet exists and has the expected number of columns before processing data, preventing errors in downstream blocks.
Row Count Pre-Check
Fetch the row count of a sheet before iterating over its contents, allowing the workflow to set loop boundaries or skip empty sheets.
Multi-Sheet Report Discovery
List all sheets in a reporting spreadsheet to build a summary or index of available data tabs without reading each sheet's contents.
Automated Audit Logging
Capture the current sheet dimensions of a spreadsheet at a point in time to log structural changes as part of a data governance workflow.
Conditional Workflow Routing
Use the returned sheet count or sheet titles to route a workflow down different branches depending on the spreadsheet's structure.
Ready to add [Google] Get Sheet Info to your workflow?
Get Started FreeCommon questions about [Google] Get Sheet Info
What are the required parameters for this block?
The only required parameter is a Google Spreadsheet ID or URL, supplied via the documentId field. A Google OAuth connection ID (connectionId) is optional but needed to authenticate with Google. You can also specify a destination variable (destinationVar) to store the result for use in later blocks.
What does this block return?
The block returns an object with two fields: a title string containing the spreadsheet's name, and a sheets array. Each item in the sheets array includes a numeric sheetId, a title string, a rowCount, and a columnCount.
Does this block return cell data from the spreadsheet?
No. This block only returns metadata about the spreadsheet's structure — its title and the dimensions of each sheet. It does not read or return any cell values.
What kinds of workflows commonly use this block?
This block is typically used at the start of workflows that interact with Google Sheets, where the workflow needs to discover or validate the spreadsheet's structure before reading, writing, or iterating over sheet data.
How do I reference the output in later blocks?
You can specify a variable name in the destinationVar field. The block will store the returned object — including the title and sheets array — in that variable, making it accessible to subsequent blocks in the workflow.
Related capabilities
[Google] Create Google Doc
Create a new Google Document and optionally populate it with content.
[Google] Update Google Doc
Update the contents of an existing Google Document.
[Google] Fetch Google Doc
Fetch the contents of an existing Google Document.
[Google] Create Google Sheet
Create a new Google Spreadsheet and populate it with CSV data.
[Google] Update Google Sheet
Update a Google Spreadsheet with new data.
[Google] Fetch Google Sheet
Fetch contents of a Google Spreadsheet range.
Add [Google] Get Sheet Info to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.