Google Sheets

Read Google Sheet

Read all rows from a Google Sheets tab with a connected Google account.

1 creditRuns in your Google Sheets account

Endpoint

Name	Type	Required	Note
identifieraccount · required	account	required	Google account to use. Select from your connected integrations.
spreadsheetIdstring · required	string	required	The spreadsheet to read from.
sheetNamestring · required	string	required	The tab (sheet) within the spreadsheet to read from. Example: `Sheet1`
startColumnstring · optional	string	optional	First column to include in the read range. Leave blank to start from column A. Example: `A (first column)`
endColumnstring · optional	string	optional	Last column to include in the read range. Leave blank to read all columns. Example: `All columns`
startRownumber · optional	number	optional	Row number to start reading from (1-based). Defaults to row 1. Example: `1`
endRownumber · optional	number	optional	Row number to stop reading at (inclusive). Leave blank to read all rows. Example: `0`
filtersobject · optional	object	optional	Optional column filters (AND/OR groups). Only matching rows are returned.
limitnumber · optional	number	optional	Maximum rows to return after filtering. Leave blank for all (hard cap 50000). Recommended when you only need the first N matches — the worker stops scanning early. Example: `All rows`

{
  "type": "object",
  "properties": {
    "data": {
      "type": "object",
      "description": "API response data"
    }
  }
}