Skip to main content

​
What it does

The Read Google Sheet tool extracts data from Google Sheets documents. Perfect for accessing spreadsheet data, importing datasets for analysis, and integrating with existing Google Sheets workflows.
Requires Google Sheets Integration: You need to set up a Google Sheets integration before agents can use this tool.

​
Key features

  • Read data from any accessible Google Sheet
  • Select specific sheets/tabs within a workbook
  • Filter by row ranges for targeted data extraction
  • Choose specific columns to reduce data volume
  • Automatic header detection and table formatting

​
Parameters

ParameterTypeRequiredDescription
sheet_idstringYesThe Google Sheet ID (from the URL)
sheet_namestringNoName of the specific sheet/tab (default: first sheet)
startRownumberNoStarting row number, 1-based (default: 1)
endRownumberNoEnding row number, inclusive (default: last row)
columnsarrayNoArray of column names to fetch (default: all columns)

​
Common use cases

​
Read entire sheet

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
sheet_name: "Class Data"
Get all data from a specific sheet.

​
Read specific rows

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
sheet_name: "Sales Data"
startRow: 2
endRow: 100
Skip headers and read rows 2-100.

​
Read specific columns

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
columns: ["Name", "Email", "Score"]
Only fetch specific columns to reduce data volume.

​
Read data range

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
sheet_name: "Q4 Results"
startRow: 5
endRow: 50
columns: ["Product", "Revenue", "Units Sold"]
Get a specific data range with selected columns.

​
Finding the Sheet ID

The Sheet ID is found in the Google Sheets URL: 
https://docs.google.com/spreadsheets/d/SHEET_ID/edit#gid=0
For example, in this URL: 
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
The Sheet ID is: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

​
What you get back

  • Headers: Column names from the first row
  • Data: Structured table data as rows and columns
  • Formatted Table: Clean, organized data ready for analysis

​
Best practices

  • Ensure the Google Sheet is shared with your integration account
  • Use specific row ranges for large sheets to improve performance
  • Select only needed columns to reduce data transfer
  • Use descriptive sheet names for multi-tab workbooks
  • Keep headers in the first row for automatic detection

​
Troubleshooting

“Sheet not found” or “Access denied”
  • Verify the Sheet ID is correct
  • Ensure the sheet is shared with your Google Sheets integration
  • Check that the sheet name exists (case-sensitive)
“Invalid range”
  • Check that startRow and endRow numbers are valid
  • Ensure startRow is less than or equal to endRow
  • Verify the sheet has data in the specified range
“Column not found”
  • Check that column names match exactly (case-sensitive)
  • Ensure the columns exist in the sheet
  • Verify headers are in the first row
“Integration not configured”
  • Set up the Google Sheets integration first
  • Verify the integration has proper permissions
  • Check that the integration is active
⌘I