Documentation Index
Fetch the complete documentation index at: https://docs.markifact.com/llms.txt
Use this file to discover all available pages before exploring further.
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
| Field | Type | Required | Description |
|---|
| Spreadsheet | Text | Yes | Google Sheets spreadsheet URL or ID |
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
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:
| Field | Description |
|---|
| spreadsheet_id | Unique Google Sheets spreadsheet ID |
| spreadsheet_title | Title of the workbook |
| total_sheets | Number of sheets in the workbook |
| sheets | Array of sheet details |
Sheet Details:
| Field | Description |
|---|
| sheet_id | Unique numerical ID for the sheet |
| sheet_name | Display name of the sheet tab |
| index | Position of the sheet (0-based) |
| row_count | Maximum number of rows |
| column_count | Maximum number of columns |
| is_hidden | Whether the sheet is hidden from view |
| tab_color | RGB color of the sheet tab (if set) |
Credit Cost
Common Workflows
Dynamic Sheet Processing:
[List Sheets] → [Filter by Name Pattern] → [Process Each Sheet] → [Combine Results]
[List Sheets] → [Get Sheet Sizes] → [Identify Large Sheets] → [Optimize or Archive]
[List Sheets] → [Read Data from Each] → [Combine Data] → [Generate Summary Report]
[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
