Google Sheets
Create, read, and modify spreadsheets with Google Sheets
Actions
| Name | Description |
|---|---|
list_spreadsheetsList Google Sheets spreadsheets in Drive | List Google Sheets spreadsheets in Drive |
get_spreadsheetGet metadata for a specific spreadsheet | Get metadata for a specific spreadsheet |
list_sheetsList worksheets in a spreadsheet | List worksheets in a spreadsheet |
get_sheetGet metadata for a worksheet | Get metadata for a worksheet |
read_rangeRead values from a specified range in a spreadsheet | Read values from a specified range in a spreadsheet |
list_rowsList rows from a sheet with optional header mapping | List rows from a sheet with optional header mapping |
get_rowGet a single row from a sheet | Get a single row from a sheet |
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 |
append_rowsAppend multiple rows of values to the end of a sheet | Append multiple rows of values to the end of a sheet |
update_rowUpdate all values in a specific row | Update all values in a specific row |
find_rowsFind rows by matching a value in one column | Find rows by matching a value in one column |
clear_rangeClear values from a specified range in a spreadsheet | Clear values from a specified range in a spreadsheet |
clear_rowClear values in a row without deleting the row | Clear values in a row without deleting the row |
delete_rowDelete a row from a sheet and shift following rows up | Delete a row from a sheet and shift following rows up |
create_spreadsheetCreate a new Google Sheets spreadsheet | Create a new Google Sheets 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 17 actions including List Spreadsheets, Get Spreadsheet, List Sheets, Get Sheet, Read Range, 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 3 meta-tools with on-demand API discovery for efficient agent access.
What authentication does Google Sheets use?
Google Sheets uses OAuth2. Weavz stores OAuth credentials securely and refreshes tokens when supported by the provider.
How much does the Google Sheets integration cost?
The Google Sheets integration is included on all Weavz plans including the free tier with 20,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 minutes
Get 1,000 free actions every month. No credit card required.