Google Sheets
The Google Sheets integration lets Helios agents search the Google Sheets API and call any endpoint to create spreadsheets, read and write data, and manage formatting.
What your agents can do
Agents don't pick from a preset list of actions. They semantically search the entire Google Sheets API and call whatever endpoint a task needs, using your connected credentials. Because the Sheets integration can also reach the Google Drive API, an agent can locate a spreadsheet in Drive and then open and edit it in Sheets.
- Create new spreadsheets from a prompt or template
- Read, write, append, and clear cell ranges
- Add, rename, and reorganize sheets and tabs
- Apply formatting, formulas, and data validation
- Find a spreadsheet in Drive and edit it in Sheets
Authentication
| Method | Type | Description |
|---|---|---|
| Helios Google app (recommended) | OAuth 2.0 | Per-user consent with pre-configured spreadsheet scopes |
| BYO Google app | OAuth 2.0 | Bring your own Google OAuth app and credentials |
Helios Google app (recommended)
Connect in one click. Helios runs the Google OAuth redirect flow and asks each user for consent (access_type=offline, prompt=consent) so agents can act on your behalf, including when you're offline.
The Helios Google app requests scopes to:
- Read and write spreadsheet data (
spreadsheets,spreadsheets.readonly) - Discover spreadsheets in Google Drive, read-only (
drive.readonly) - Access the specific Drive files you open with Helios (
drive.file)
BYO Google app
Bring your own Google OAuth application when you need custom scopes or branding.
- Go to Google Cloud Console
- Create a new project or select an existing one
- Enable the Google Sheets API (and the Google Drive API)
- Configure the OAuth consent screen
- Create OAuth 2.0 credentials (client ID and client secret)
- Add the Helios redirect URI to your OAuth client
- In Helios, supply your client ID, client secret, an access token, a refresh token, and the Google account email
Learn more in the Google Sheets API documentation.
Triggers
Google Sheets does not currently emit event triggers into Helios. Use it from Chat, or from a Workflow driven by a schedule, webhook, or manual run.
Last updated on