Google Sheets
Create, read, and modify spreadsheets with Google Sheets
Actions
| Name | Description |
|---|---|
list_spreadsheetsList all Google Sheets spreadsheets in your Drive | List all Google Sheets spreadsheets in your Drive |
get_spreadsheetGet metadata for a specific spreadsheet | Get metadata for a specific spreadsheet |
read_rangeRead values from a specified range in a spreadsheet | Read values from a specified range in a spreadsheet |
write_rangeWrite values to a specified range in a spreadsheet | Write values to a specified range in a spreadsheet |
append_rowAppend a row of values to the end of a sheet | Append a row of values to the end of a sheet |
create_spreadsheetCreate a new Google Sheets spreadsheet | Create a new Google Sheets spreadsheet |
clear_rangeClear values from a specified range in a spreadsheet | Clear values from a specified range in a spreadsheet |
custom_api_callMake a custom API call to the Google Sheets API | Make a custom API call to the Google Sheets API |
Triggers
| Name | Description |
|---|---|
new_rowTriggers when a new row is added to a spreadsheet | Triggers when a new row is added to a spreadsheet |
row_updatedTriggers when any row is updated in a spreadsheet (compares full sheet snapshot) | Triggers when any row is updated in a spreadsheet (compares full sheet snapshot) |
Quick Start
import { WeavzClient } from '@weavz/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute({
integrationName: 'google-sheets',
actionName: 'list_spreadsheets',
input: { /* ... */ },
connectionId: 'conn_id',
workspaceId: 'ws_id',
})Related Integrations
Works well with
Frequently Asked Questions
How do I connect Google Sheets to my app?
Use Weavz Hosted Connect for OAuth2 authentication. Install the SDK, create a connection through the connect portal or API, then execute actions programmatically.
What actions does Google Sheets support?
Google Sheets supports 8 actions including List Spreadsheets, Get Spreadsheet, Read Range, Write Range, Append Row, and more.
Can I use Google Sheets with AI agents?
Yes. Add Google Sheets to an MCP server in TOOLS mode or CODE mode. CODE mode provides 80-98% context reduction with 3 meta-tools for efficient agent access.
What authentication does Google Sheets use?
Google Sheets uses OAuth2. Weavz handles token management, refresh, and secure credential storage automatically.
How much does the Google Sheets integration cost?
The Google Sheets integration is included on all Weavz plans including the free tier with 1,000 actions per month. No credit card required.
What triggers does Google Sheets support?
Google Sheets supports 2 triggers including New Row, Row Updated.
Connect Google Sheets in 2 minutes
Get 1,000 free actions every month. No credit card required.