Skip to main content

Google Sheets

Deploys up to 28 MCP tools for reading, writing, and managing Google Sheets spreadsheets.

Shared Configuration​

FieldRequiredDescription
OAuth ConnectionYesGoogle OAuth connection. Set up in the Connections page first. Make sure to enable the Google Sheets API and add the auth/spreadsheets scope.

Included Tools​

ToolDescription
google_sheets_create_spreadsheetCreate a new Google Sheets spreadsheet
google_sheets_create_columnCreate a new column in a specific spreadsheet
google_sheets_create_rowCreate a new row in a specific spreadsheet
google_sheets_create_rowsCreate one or more new rows in a specific spreadsheet (with line item support)
google_sheets_create_row_at_topCreate a new spreadsheet row at the top (after the header row)
google_sheets_change_sheet_propertiesUpdate properties like frozen rows/columns, sheet position, and visibility
google_sheets_create_conditional_formattingApply conditional formatting to cells based on their values
google_sheets_copy_rangeCopy data from one range to another within a spreadsheet
google_sheets_copy_worksheetCreate a new worksheet by copying an existing one
google_sheets_create_worksheetCreate a new worksheet in a spreadsheet
google_sheets_clear_rowsClear row contents while keeping the rows intact
google_sheets_delete_worksheetPermanently delete a worksheet from a spreadsheet
google_sheets_delete_rowsDelete selected rows and all associated data
google_sheets_format_cellsApply date, number, or style formatting to a range of cells
google_sheets_format_rowFormat a row in a specific spreadsheet
google_sheets_rename_worksheetRename a worksheet in a spreadsheet
google_sheets_set_data_validationSet data validation rules on a range of cells
google_sheets_sort_rangeSort data within a specified range by a chosen column
google_sheets_update_rowUpdate a row in a specific spreadsheet
google_sheets_update_rowsUpdate one or more rows in a specific spreadsheet (with line item support)
google_sheets_lookup_rowsFind up to 500 rows based on a column and value
google_sheets_find_worksheetFind a worksheet by title
google_sheets_get_data_rangeGet the data range of a worksheet
google_sheets_get_rowsReturn up to 1,500 rows as JSON or line items
google_sheets_get_rowGet a specific row by its row number
google_sheets_get_spreadsheetGet a specific spreadsheet by its ID
google_sheets_lookup_rowFind a specific row based on a column and value
google_sheets_find_or_create_worksheetFind or create a specific worksheet