Overview
Performance
Usage
Integrate
Read, write, and format spreadsheet data. Manage sheets, run formulas, and collaborate on structured data in real time.
Integrate this server via the CLI, MCP SDK, or AI SDK. Smithery handles OAuth, token refresh, and session management for you.
1. Install Smithery CLI
2. Create a namespace
3. Use this server
# Add this server
smithery mcp add googlesheets
# List available tools
smithery tool list {connection}
# Call a tool
smithery tool call {connection} {tool_name} '{"key": "value"}'batch_getbatch_updateformat_cellspreadsheets_values_appendget_sheet_namesspreadsheets_values_batch_get_by_data_filterget_spreadsheet_infoadd_sheetbatch_update_values_by_data_filterget_spreadsheet_by_data_filterclear_valuesupdate_sheet_propertieslookup_spreadsheet_rowexecute_sqldelete_dimensioncreate_google_sheet1search_spreadsheetsaggregate_column_dataquery_tabledelete_sheetinsert_dimensionspreadsheets_values_batch_clearlist_tablesfind_worksheet_by_titlesheet_from_jsonspreadsheets_sheets_copy_toappend_dimensionupsert_rowscreate_chartupdate_spreadsheet_propertiesset_basic_filterget_table_schemaget_formulacreate_spreadsheet_columnspreadsheets_values_batch_clear_by_data_filtergooglesheets_format_cellget_cellupdate_cellscreate_spreadsheetget_valuesupdate_valuescreate_spreadsheet_rowclear_basic_filtergooglesheets_batch_getspreadsheets_values_updateappendupdatelistwriteset_cellclearsetvalues_updatewrite_valueswrite_rangeappend_valuesread_spreadsheetappend_rowsset_valueswrite_cellupdate_celldelete_rowsinsert_rowupdate_rangeinsert_valuesreplace_valuesbatch_update_valuesspreadsheets_batch_updatesearch_developer_metadatagooglesheets_spreadsheets_values_appendgooglesheets_get_spreadsheet_infoget_rowsrenamecreatetheninsertcell_rowsortadd_rowfindset_rowgetbatchputadd_datacopy_rowexecuteremoveset_datamoveread_roweditadd_cellfind_rowformatlist_rowdeletesearchcheckget_datareplacesort_rowcellreadpatchset_rowsedit_rowadd_rowscopyget_rowmove_rowaddget_sheetput_cell_valueappend_rangecheck_cellrename_rowsoverwrite_rangesearch_dataremove_rangeformat_sheetremove_valuescheck_rowsmove_celldelete_cellgetValuesoverwritecopy_valuesvalues_appendcopy_sheetrepeat_celledit_valueswrite_sheetset_sheetsort_sheetsearch_rowedit_sheetauto_resizerename_valuessort_valuescell_cellwrite_dataclear_rowlist_sheetvalues_writerename_rangeadd_rangelist_valuesreplace_sheetreplace_rowremove_rowsrename_rowsort_cellcell_valuessearch_valuescell_sheetcheck_dataedit_cellread_rangecopy_cellwrite_to_rangecreate_sheetreplace_rowsread_rowsremove_databatch_rowlist_cellread_datasearch_rangeinsert_cellappend_datacheck_sheetupdate_sheetcheck_rangevalues_setfind_rangerename_datawrite_rowssearch_rowsrange_updatewrite_cell_valueset_column_widthcheck_valuesset_sheet_valueslist_sheetsfind_rowsappend_rowcreate_cellrange_writemove_valuesmove_sheetsearch_filesbatchupdateget_spreadsheetfind_datainsert_sheetsheets_updateremove_rowappend_sheetupdate_datacheck_rowreplace_cellresize_dimensionmove_rangeremove_sheetcreate_databatch_sheetformat_rangerename_cellcell_updatefind_sheetmove_rowsformat_valuesbatch_datafind_valuessearch_toolswrite_by_rangeset_range_valuesmove_databatch_valuesinsert_dataappend_cellcell_rowscreate_rowdelete_valuesbatch_clearcell_dataupdate_rowclear_rowsremove_cellbatch_rangeread_valuesclear_cellrename_sheetread_sheetreplace_dataformat_rowsdelete_rangecell_rangeedit_dataset_rangecopy_rowssort_dataadd_valuescopy_datadelete_rowlist_rangesearch_toolboxcreate_valuesbatch_rowsinsert_rowssort_rowsedit_rowscreate_rangesort_rangebatch_cellformat_datalist_rowsclear_rangeedit_rangesearch_sheetcopy_rangeread_celllist_datadelete_datacreate_rowsreplace_rangeupdate_by_rangeclear_sheetupdate_rowslist_filesget_rangewrite_rowspreadsheets_getrange_valuesclear_datafind_cellformat_rowsearch_cellinsert_rangeupdate_range_valuesupdate_single_cellgooglesheets_add_sheetupdate_cell_valueupdate_sheet_valuesspreadsheet_batch_updatevalues_batchUpdatebatch_values_updatespreadsheets_values_getupdate_dimensionsautoresize_dimensionsspreadsheet_values_getvalues_batch_updateauto_resize_dimensionsdimension_propertiesvalues_update_rangespreadsheets.values.getspreadsheets_batchUpdateupdate_with_rangebatch_update_spreadsheetget_toolbox_statusGOOGLESHEETS_ADD_SHEETvalues_write_rangewrite_range_valueslist_spreadsheetsgooglesheets_update_sheet_propertiesupdate_spreadsheet_valuesGOOGLESHEETS_CREATE_SPREADSHEETGOOGLESHEETS_AGGREGATE_COLUMN_DATAList available spreadsheetsupdate_dimension_propertiesgooglesheets_get_spreadsheet_by_data_filtergooglesheets_batch_updatespreadsheet_values_updategooglesheets_create_spreadsheet_rowspreadsheets_values_batchUpdate
