Read rows

• Type sheets.readRows
• Group Apps
• Role action
• Risk reads only
• Side effect safe to repeat
• Runs once per execution
• Needs network
• Credentials oauth2

Reads rows of a Google Sheet as items

Also available to AI agents and over MCP as a tool.

Parameters

credentialId

Credential · string · optional

A saved credential from the vault; it adds the authentication for you.

spreadsheetId

Spreadsheet id · string · required

range

Range · string · required

headerRow

First row has the column names · boolean · optional · default true

limit

Limit · integer · optional · range 1 – 100000

Outputs

• main

← All nodes