G
Google Sheets
by Google
Read, write, and manage data in Google Sheets spreadsheets
Data & SpreadsheetsFreeOAuth 2.0spreadsheetdatagoogledatabasestorage
How agents use Google Sheets
- ✓Agent reads a sheet to retrieve a list of tasks, contacts, or rules before starting a workflow
- ✓Agent appends a new row to log the result of each completed workflow run or processed item
- ✓Agent updates a cell or row to reflect the current status of a task or record it has processed
- ✓Agent uses a sheet as a lightweight database to look up reference data during decision-making
- ✓Agent writes a structured summary — metrics, outputs, errors — to a sheet for human review
Agent actions
Read RangeRead data from a range of cells
Inputs: range
Returns: values, range
Write RangeWrite data to a range of cells
Inputs: range, values
Returns: updatedCells, updatedRange
Append RowsAppend rows to the end of a sheet
Inputs: sheet, values
Returns: updatedRows
Create SheetCreate a new sheet/tab in the spreadsheet
Inputs: title, rows, columns
Returns: sheetId
Clear RangeClear values from a range of cells
Inputs: range
Batch UpdatePerform multiple updates in a single request
Inputs: requests
Example workflows
1
Customer data storage
Store customer information in a Google Sheet
2
Daily report generation
Append daily metrics to a tracking sheet
About Google Sheets
- Vendor
- Pricing Always review details with the vendor
- Free — Free with Google Account, subject to API quotas
- Authentication
- OAuth 2.0
- Rate limit Always review details with the vendor
- 60 requests / minute
- Compatible nodes
- AgentResourceInputOutput
- Website
- https://sheets.google.com
Build an AI workflow with Google Sheets
Use the Agentic Planner to design, visualize, and connect Google Sheets with your other tools.
Open Agentic Planner