Skip to main content
The List Sheets node retrieves information about all sheets (tabs) within a Google Sheets workbook. Perfect for discovering sheet structure and managing multi-sheet workbooks. This is an AI-powered node that can understand natural language instructions.

​
When to Use It

  • Discover all sheets in a workbook before processing
  • Get sheet names and IDs for dynamic workflows
  • Analyze workbook structure and organization
  • Validate sheet existence before operations
  • Build workflows that work with multiple sheets
  • Audit and manage large workbooks with many tabs

​
Inputs

FieldTypeRequiredDescription
SpreadsheetTextYesGoogle Sheets spreadsheet URL or ID

​
Spreadsheet Input Options

URL Format: 
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
Spreadsheet ID Format: 
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

​
Output

Returns detailed information about all sheets in the workbook: 
{
  "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
  "spreadsheet_title": "Marketing Dashboard 2024",
  "total_sheets": 4,
  "sheets": [
    {
      "sheet_id": 0,
      "sheet_name": "Overview",
      "index": 0,
      "row_count": 1000,
      "column_count": 26,
      "is_hidden": false,
      "tab_color": null
    },
    {
      "sheet_id": 123456789,
      "sheet_name": "Q4 Data",
      "index": 1,
      "row_count": 500,
      "column_count": 15,
      "is_hidden": false,
      "tab_color": {
        "red": 0.2,
        "green": 0.6,
        "blue": 0.9
      }
    },
    {
      "sheet_id": 987654321,
      "sheet_name": "Archive",
      "index": 2,
      "row_count": 2000,
      "column_count": 20,
      "is_hidden": true,
      "tab_color": null
    }
  ]
}

​
Output Fields:

FieldDescription
spreadsheet_idUnique Google Sheets spreadsheet ID
spreadsheet_titleTitle of the workbook
total_sheetsNumber of sheets in the workbook
sheetsArray of sheet details

​
Sheet Details:

FieldDescription
sheet_idUnique numerical ID for the sheet
sheet_nameDisplay name of the sheet tab
indexPosition of the sheet (0-based)
row_countMaximum number of rows
column_countMaximum number of columns
is_hiddenWhether the sheet is hidden from view
tab_colorRGB color of the sheet tab (if set)

​
Credit Cost

  • Cost per run: 1 credit

​
Common Workflows

Dynamic Sheet Processing: 
[List Sheets] → [Filter by Name Pattern] → [Process Each Sheet] → [Combine Results]
Workbook Analysis: 
[List Sheets] → [Get Sheet Sizes] → [Identify Large Sheets] → [Optimize or Archive]
Multi-Sheet Reports: 
[List Sheets] → [Read Data from Each] → [Combine Data] → [Generate Summary Report]
Sheet Management: 
[List Sheets] → [Find Hidden Sheets] → [Unhide or Delete] → [Reorganize Workbook]

​
Use Cases

​
Sheet Discovery

Find specific sheets by pattern: 
- List all sheets
- Filter names containing "2024"
- Process only current year data

​
Workbook Validation

Ensure required sheets exist: 
- List all sheets
- Check for "Data", "Summary", "Archive" sheets
- Create missing sheets if needed

​
Dynamic Processing

Process all data sheets: 
- List sheets
- Skip sheets named "Template" or "Config"
- Read data from remaining sheets
- Combine into master dataset

​
Organization Audit

Analyze workbook structure: 
- List sheets
- Count hidden vs visible sheets
- Identify sheets with custom colors
- Generate workbook organization report

​
Tips

Sheet Identification:
  • Use sheet_id for programmatic operations (more reliable)
  • Use sheet_name for user-friendly workflows
  • Check is_hidden to skip hidden sheets in processing
  • Use index to understand sheet order
Workflow Integration:
  • Always list sheets first in multi-sheet workflows
  • Cache sheet list if processing multiple operations on same workbook
  • Filter sheets based on naming patterns or properties
  • Handle empty workbooks gracefully (check total_sheets > 0)
Performance:
  • Quick operation - lists metadata only, doesn’t read sheet content
  • Use before expensive operations to validate targets
  • Combine with conditional logic to process only relevant sheets
⌘I