Introduction
Connect Google Sheets to Sana to read, write and manage your spreadsheets. Look up data, add or update rows, create new spreadsheets and worksheets, and keep your data organized. In summary, the connector has the following key characteristics:
Category: Documents
Connector type: Real-time
Auth type: OAuth
Hosting type: Managed
Capabilities
This connector is able to do the following:
Capability |
List spreadsheets |
Read spreadsheets |
Create spreadsheets |
Add worksheets |
Find rows |
Add rows |
Update rows |
Generate formulas |
Tools
While the capabilities above describe what the connector can do at a high level, the underlying tools show exactly which operations the agent can use when you ask Sana about Google Sheets. In practice, the agent may call one or more tools to achieve a single capability.
Tool |
Add rows |
Add worksheet |
Find rows |
Get spreadsheet info |
List spreadsheets |
New spreadsheet |
Read rows |
Update rows |
Scope and permissions
This connector uses OAuth. When you connect your account, you will need to sign into your account and grant the required permissions:
Scope | Purpose |
Know which Google account you use | |
profile | See your basic account info |
Access and update your Google Sheets in Drive |
Set up instructions
Prerequisites:
Your Sana workspace admin has enabled this integration – if the workspace admin has disabled the integration it won't appear in the list of available integrations.
Step 1: Go to the integrations page in Sana
In Sana, click on ... More in the sidebar, then select Integrations
Step 2: Find Google Sheets in the list of available integrations
Scroll to the Available integrations section and locate Google Sheets.
Step 3: Connect the integration
Click the integration card and select "Connect just for me", this will open a pop-up powered by Pipedream. Follow the steps in the pop-up to complete the set-up.
Step 4: Sign in to Google Sheets and approve the requested scopes
You'll be redirected to Google Sheets to go through their OAuth flow. Sign in and approve the scopes Sana needs to operate the connector.
Step 5: Complete the set up
You've successfully connected your Google Sheets account. Click Continue to complete the setup and start using the connector.
Known limitations
Spreadsheet operations: The connector cannot change spreadsheet settings or delete spreadsheets — it can only read and edit cells within an existing spreadsheet.
Comments: The connector cannot attach comments to individual cells; comments can only be added at the spreadsheet level.