Connect Google Sheets to Claude Sonnet (Anthropic) to unlock the power of AI automation

Google Sheets MCP tools

Use Google Sheets tools through chat to streamline your workflows.

Google Sheets connector for other AI models (LLMs)

Ravenala support other LLMs to connect with Google Sheets.

ChatGPT

By OpenAI

Grok

By xAI

Gemini

By Google

Sonar

By Anthropic

Claude Opus

By Anthropic

Mistral

By MistralAI

DeepSeek Chat

By DeepSeek

Llama

By Meta

Need inspiration? What's in your stack?

Explore use cases that combine Google Sheets with other apps in your stack.

Airtable

17 actions

Canva

32 actions

GitHub

823 actions

6 triggers

Gmail

24 actions

1 trigger

Google Drive

51 actions

1 trigger

HubSpot

329 actions

2 triggers

Notion

28 actions

5 triggers

Salesforce

97 actions

2 triggers

View more apps

Conversational AI use cases to explore

SalesAI use cases
MarketingAI use cases
ProductAI use cases
Customer SupportAI use cases
EngineeringAI use cases
DesignAI use cases
Human ResourcesAI use cases
FinanceAI use cases
LegalAI use cases
OperationsAI use cases

Connect Google Sheets to Claude Sonnet (Anthropic) to unlock the power of AI automation

Google Sheets MCP tools

add-sheetAdds a new sheet (worksheet) to a spreadsheet.

add-sheet

aggregate-column-dataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.

aggregate-column-data

append-dimensionTool to append new rows or columns to a sheet, increasing its size.

append-dimension

batch-getRetrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.

batch-get

batch-updateUpdates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.

batch-update

batch-update-values-by-data-filterTool to update values in ranges matching data filters.

batch-update-values-by-data-filter

clear-basic-filterTool to clear the basic filter from a sheet.

clear-basic-filter

clear-valuesClears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.

clear-values

create-chartCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type.

create-chart

create-google-sheet1Creates a new google spreadsheet in google drive using the provided title.

create-google-sheet1

create-spreadsheet-columnCreates a new column in a google spreadsheet, requiring a valid `spreadsheet id` and an existing `sheet id`; an out-of-bounds `insert index` may append/prepend the column.

create-spreadsheet-column

create-spreadsheet-rowInserts a new, empty row into a specified sheet of a google spreadsheet at a given index, optionally inheriting formatting from the row above.

create-spreadsheet-row

delete-dimensionTool to delete specified rows or columns from a sheet in a google spreadsheet.

delete-dimension

delete-sheetTool to delete a sheet (worksheet) from a spreadsheet.

delete-sheet

execute-sqlExecute sql queries against Google Sheets tables.

execute-sql

find-worksheet-by-titleFinds a worksheet by its exact, case-sensitive title within a google spreadsheet; returns a boolean indicating if found and the complete metadata of the entire spreadsheet, regardless of whether the target worksheet is found.

find-worksheet-by-title

format-cellApplies text and background cell formatting to a specified range in a Google Sheets worksheet.

format-cell

get-sheet-namesLists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations.

get-sheet-names

get-spreadsheet-by-data-filterReturns the spreadsheet at the given id, filtered by the specified data filters.

get-spreadsheet-by-data-filter

get-spreadsheet-infoRetrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.

get-spreadsheet-info

get-table-schemaThis action is used to get the schema of a table in a google spreadsheet, call this action to get the schema of a table in a spreadsheet before you query the table.

get-table-schema

insert-dimensionTool to insert new rows or columns into a sheet at a specified location.

insert-dimension

list-tablesThis action is used to list all tables in a google spreadsheet, call this action to get the list of tables in a spreadsheet.

list-tables

lookup-spreadsheet-rowFinds the first row in a google spreadsheet where a cell's entire content exactly matches the query string, searching within a specified a1 notation range or the first sheet by default.

lookup-spreadsheet-row

query-tableThis action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet.

query-table

search-developer-metadataTool to search for developer metadata in a spreadsheet.

search-developer-metadata

search-spreadsheetsSearch for google spreadsheets using various filters including name, content, date ranges, and more.

search-spreadsheets

set-basic-filterTool to set a basic filter on a sheet in a google spreadsheet.

set-basic-filter

sheet-from-jsonCreates a new google spreadsheet and populates its first worksheet from `sheet json`, which must be non-empty as its first item's keys establish the headers.

sheet-from-json

spreadsheets-sheets-copy-toTool to copy a single sheet from a spreadsheet to another spreadsheet.

spreadsheets-sheets-copy-to

spreadsheets-values-appendTool to append values to a spreadsheet.

spreadsheets-values-append

spreadsheets-values-batch-clearTool to clear one or more ranges of values from a spreadsheet.

spreadsheets-values-batch-clear

spreadsheets-values-batch-clear-by-data-filterClears one or more ranges of values from a spreadsheet using data filters.

spreadsheets-values-batch-clear-by-data-filter

spreadsheets-values-batch-get-by-data-filterTool to return one or more ranges of values from a spreadsheet that match the specified data filters.

spreadsheets-values-batch-get-by-data-filter

update-sheet-propertiesTool to update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties.

update-sheet-properties

update-spreadsheet-propertiesTool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings.

update-spreadsheet-properties

new-rows-triggerSimple polling trigger that monitors Google Sheets for new rows.

new-rows-trigger

new-sheet-added-triggerPolling trigger that detects when a new sheet is added to a Google Spreadsheet.

new-sheet-added-trigger

Google Sheets connector for other AI models (LLMs)

ChatGPT