Connect your Google Sheets account to Goodweek to read, create, and update spreadsheets stored in Google Drive directly from your AI workspace.
ℹ️ Governance note
Goodweek will never exceed the access levels granted to the user within Google Sheets, guaranteeing alignment with your organization's governance policies. Outcomes and available features may vary depending on each user's specific permissions and authenticated access.
📋 Prerequisites
Before any user can see and connect the Google Sheets integration, your organization admin must first enable it from the Goodweek Admin Panel under the Integrations tab.
Admin Setup
Personal Google accounts (@gmail.com)
No admin setup required. Connect directly following the User Connection steps below.
Google Workspace accounts (work or school)
Depending on your organization's API access policy, one of the following scenarios may apply.
Scenario 1 — Default (unrestricted third-party access)
Any user can connect directly without admin intervention.
Scenario 2 — Third-party access is restricted (admin_policy_enforced error)
A Google Workspace Super Admin must mark Composio as a trusted app:
Log in to admin.google.com as a Super Admin.
Go to Security → Access and data control → API controls → Manage Third-Party App Access.
Click Configure new app, search for Composio, select it, set access to Trusted, and click Save.
Scenario 3 — All third-party API access is blocked
Go to admin.google.com → Security → API controls and review the "Third-party app access to Google APIs" setting. If blocked, the admin must create an exception for Composio before following Scenario 2.
User Connection
In Goodweek, go to Integrations.
Find Google Sheets and click Connect.
You will be redirected to Google, where you will be asked to sign in.
Review the requested permissions and click Allow to return to Goodweek.
Important Notes
Each user must connect their own account individually.
Goodweek can only access the spreadsheets that your individual user account has permission to see.
If you have multiple Google accounts, make sure you select the correct one during the connection step.
You can revoke Goodweek's access at any time from myaccount.google.com → Security → Third-party apps with account access.
Available Tools
Tool | Description | Type |
Create a Google Sheet | Creates a new Google Spreadsheet in Google Drive with an optional title. | Write |
Get Spreadsheet Info | Retrieves metadata for a Google Spreadsheet including ID, title, and sheet properties. | Read |
Get Sheet Names | Lists all worksheet names within a specified Google Spreadsheet. | Read |
Search Spreadsheets | Searches for Google Spreadsheets using filters including name, content, and date ranges. | Read |
Get Spreadsheet Values | Reads values from a specified cell range in a Google Sheet. | Read |
Batch Get Spreadsheet | Retrieves data from multiple specified cell ranges in a Google Spreadsheet in one request. | Read |
Update Spreadsheet Values | Writes or overwrites values in a specified range of a Google Spreadsheet. | Write |
Batch Update Spreadsheet Values | Sets values in multiple ranges of a spreadsheet in a single operation. | Write |
Append Values to Spreadsheet | Appends new data to the end of an existing table in a Google Sheet. | Read |
Upsert Rows | Updates existing rows by key or appends new ones, handling column mapping and partial updates. | Read |
Look Up Spreadsheet Row | Finds the first row where a cell's content exactly matches a query string. | Write |
Aggregate Column Data | Searches for rows matching a value in one column and performs math operations on another column. | Read |
Find and Replace in Spreadsheet | Finds and replaces text across a Google Spreadsheet, useful for bulk corrections or updates. | Read |
Add Sheet to Spreadsheet | Adds a new worksheet to an existing spreadsheet. | Write |
Create Spreadsheet Row | Inserts a new empty row into a specified sheet at a given index. | Write |
Create Spreadsheet Column | Creates a new column in a Google Spreadsheet at a specified position. | Write |
Format Cell | Applies text and background cell formatting to a specified range in a worksheet. | Read |
Set Data Validation Rule | Sets or clears data validation rules (including dropdown lists) on a range in Google Sheets. | Read |
Sort Range | Sorts data within a specified range based on one or more sort criteria. | Read |
Create Chart in Google Sheets | Creates a chart in a spreadsheet using specified data range and chart type. | Write |
Update Chart in Google Sheets | Modifies the specification of an existing chart in a spreadsheet. | Write |
Update Sheet Properties | Updates properties of a worksheet such as title, index, visibility, and tab color. | Write |
Copy Sheet to Another Spreadsheet | Duplicates a worksheet into a different spreadsheet. | Read |
Clear Spreadsheet Values | Clears cell content from a specified range while preserving formatting and notes. | ⚠️ Destructive |
Delete Sheet | Removes a worksheet (tab) from a spreadsheet permanently. | ⚠️ Destructive |
Delete Dimension (Rows/Columns) | Deletes specified rows or columns from a sheet. | ⚠️ Destructive |
Use Cases
Read and analyse spreadsheet data in context. Retrieve data from any Google Sheet your account has access to and bring it into a Goodweek conversation to review figures, identify trends, or answer questions based on the data.
Update spreadsheets with new data. Write or append new rows, update specific cells, or batch-update ranges in a Google Sheet directly from Goodweek — for example, adding weekly sales figures or updating a project tracker.
Create new spreadsheets and structure them. Create a new Google Sheet, add worksheets, define column headers, and apply data validation rules from Goodweek when setting up a new tracking or reporting document.
Find and correct data quickly. Use find-and-replace or row lookup tools to locate and fix specific values in large spreadsheets without scrolling manually.
Troubleshooting
"Error 400: admin_policy_enforced" when connecting
Your organization's admin has restricted third-party app access. Only a Google Workspace Super Admin can resolve this by following Scenario 2 above.
Integration not visible in Goodweek
Make sure your organization admin has enabled the Google Sheets integration from the Goodweek Admin Panel under the Integrations tab.