Google Sheets
The Google Sheets integration lets you programmatically create and edit spreadsheets, manage data, and automate spreadsheet-based workflows directly from Helios.
How to connect
| Method | Type | Description |
|---|---|---|
| Helios Google Sheets App (Recommended) | OAuth 2.0 | Pre-configured scopes for spreadsheet operations |
| BYO Google Sheets App | OAuth 2.0 | Custom OAuth app for enterprise requirements |
Helios Google Sheets App (Recommended)
The Helios Google Sheets App provides seamless setup with pre-configured permissions for most common spreadsheet use cases.
Permissions
The Helios Google Sheets App includes scopes for:
- Read and write spreadsheet data
- Read-only access to Google Drive for spreadsheet discovery
- File-level access to Drive for spreadsheet management
BYO Google Sheets App
Create your own Google OAuth application for custom control over scopes and branding.
Setup Steps
- Go to Google Cloud Console
- Create a new project or select an existing one
- Enable the Google Sheets 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
- Copy the client ID and client secret into Helios
Learn more in the Google Sheets API documentation.
Functionality
The Google Sheets integration lets your workflows create spreadsheets, read and write data, manage formatting, and automate data-driven processes without writing custom code.
| Category | Features |
|---|---|
| Data Operations | Read, write, append, clear cell data |
| Spreadsheet Management | Create spreadsheets, manage sheets and tabs |
| Formatting | Cell formatting, conditional formatting, data validation |
| Analysis | Formulas, charts, pivot tables, filters |
Last updated on
Gmail
The Gmail integration lets you programmatically send and receive emails, manage labels, organize your inbox, and automate email-based workflows directly from Helios.
HubSpot
The HubSpot integration lets you programmatically manage CRM data, automate sales processes, sync marketing activities, and integrate with HubSpot's comprehensive platform directly from Helios.