Skip to main content
Google Sheets is a cloud-based spreadsheet application that lets agents create, read, and update spreadsheet data to support data entry, analysis, and collaboration workflows.

​
Setup

  1. In Agent Studio, go to Tools → Google Sheets → Connect
  2. Sign in with your Google account and authorize access
  3. Review the requested permissions and click Allow

​
Available actions

​
Adding to an agent

  1. Open your agent in Agent Studio → Agent Builder
  2. Go to Tools and enable Google Sheets
  3. Select only the actions your agent needs
  4. Set auth mode: Shared (agent acts on one account) or Per-user (each end-user connects their own account)

​
Example use cases

Automated report generation: An agent can create a new spreadsheet and populate it with processed data, such as weekly sales figures or aggregated survey results, ready for review without manual data entry. Real-time data logging: Use the append action to have an agent continuously log events, form submissions, or sensor readings to a running sheet, building an auditable time-series record automatically. Bulk data updates: An agent can read values from one range, apply transformations or enrichments, and write the results back using a batch update, keeping a master spreadsheet in sync with external data sources.