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