Google Sheets
Connect Google Sheets to enable intelligent agents that can work with your data. This integration provides 51 capabilities for building context-aware agents.
Agent capabilities
51Create Spreadsheet
Creates a new Google Sheets spreadsheet with an optional title.
Rename Spreadsheet
Renames a Google Sheets spreadsheet and optionally updates its description. Requires Google Drive to be connected.
Get Spreadsheet Info
Gets essential information about a Google Sheets spreadsheet: title, sheet names, sizes (row/column counts), and column headers. Use this to understand the structure of a spreadsheet before reading or writing data.
Batch Get Values
Reads values from one or more ranges in a single request. Use this to read multiple ranges at once (e.g. A1:C10 and E1:F10). For reading a single range, prefer VALUES_GET which is simpler. Returns first 100 rows per range by default (set preview_only=false for full data).
Get Spreadsheet Values
Reads values from a single range (e.g. "Sheet1!A1:C10"). Simpler than BATCH_GET when you only need one range. Use BATCH_GET to read multiple ranges in one request.
What's included
Real-time data access
Agents access live data for up-to-date insights
Smart agent actions
Agents can take actions based on your data
Contextual understanding
Agents understand your business context
Custom training
Train agents on your specific workflows
