IntegrationsBuilt-in Providers
Google Sheets
Connect Google Sheets to your Appstrate agents.
Overview
Google Sheets is Google's online spreadsheet tool, allowing your agents to read, write, and manipulate spreadsheets.
Authentication Mode
| Property | Value |
|---|---|
| Type | oauth2 |
| Header | Authorization: Bearer <token> |
| Default scopes | spreadsheets.readonly |
Available Scopes
| Scope | Description |
|---|---|
spreadsheets | Full spreadsheet access |
spreadsheets.readonly | Read-only access |
drive.file | Per-file access (recommended) |
Authorized URIs
The agent can access the following endpoints through the sidecar proxy:
https://sheets.googleapis.com/*
Connect Google Sheets
- Create a Google Cloud project and enable the Google Sheets API
- Configure the OAuth consent screen
- Create OAuth 2.0 credentials (Client ID and Client Secret)
- Add the Appstrate redirect URI as an authorized redirect URI
- Enter the Client ID and Client Secret in the Google Sheets provider settings on Appstrate
Usage in an Agent
Once connected, the agent can call Google Sheets APIs through the sidecar proxy. Example prompt:
Read the "Q1 Sales" spreadsheet and calculate the total per salesperson.
Add a totals row at the bottom of the table and update the sheet.