Google Sheets
Create spreadsheets and read, replace, or append range values
Connect Google Sheets when an app needs structured spreadsheet data from a shared Google account or each published app user.
Available operations
| Operation | What it does | Limit per minute |
|---|---|---|
create_spreadsheet | Creates a spreadsheet with a title | 60 |
get_values | Reads values from an A1 range | 60 |
update_values | Replaces values in an A1 range | 60 |
append_values | Appends rows to an A1 range | 60 |
The connection requests Google Sheets access. Treat spreadsheet IDs and ranges as untrusted input in a published app; derive permitted documents on the server instead of accepting arbitrary IDs from the browser.
Connect Google Sheets
An administrator must configure the Google OAuth app and enable Google Sheets under Admin > Settings > Integrations. In project chat, describe the data shape and owner. For example:
- “Append approved expense rows to our team's
Expenses!A:Frange.” - “Let each signed-in user connect Google Sheets and read
Dashboard!A1:D20.”
Choose an existing connection or select Connect new and authorize Google. Use published app-user mode when each user owns a different spreadsheet account.
Verify Google Sheets
- Create a spreadsheet with a unique test title.
- Write a header and one test row with
update_values. - Read the same range and compare every returned value.
- Append another row and confirm it in Google Sheets.
- Delete the test spreadsheet in Google Drive.
If Google reports an invalid range, use A1 notation such as Sheet1!A1:C10. If the app can read but cannot update, confirm the connected Google identity has edit access to the spreadsheet, then reconnect if its authorization was revoked.
Keep connector calls in generated server routes. Disconnecting the account stops Swarmz access but does not delete spreadsheets or undo prior edits.