Google Sheets
Productivity

Google Sheets Connector

Connect to Google Sheets to manage spreadsheets and cell data.

$pip install "toolsconnector[gsheets]"
16
Actions
Productivity
Category
Free
Apache 2.0

All 16 Actions

Action Description Parameters Returns
add_sheet ⚠Add a new sheet tabspreadsheet_id, title  [row_count, column_count]Sheet
append_values ⚠Append values after a rangespreadsheet_id, range, values  [input_option]AppendResult
auto_resize_columnsAuto-resize columns to fit contentspreadsheet_id, sheet_id  [start_column, end_column]dict
batch_get_valuesBatch get values from multiple rangesspreadsheet_id, rangeslist
batch_update_spreadsheet ⚠Apply structural changes to a spreadsheetspreadsheet_id, requestsdict
batch_update_values ⚠Batch update values across multiple rangesspreadsheet_id, data  [input_option]BatchUpdateResult
clear_values ⚠Clear values from a rangespreadsheet_id, rangeClearResult
copy_sheetCopy a sheet to another spreadsheetspreadsheet_id, sheet_id, destination_spreadsheet_idSheet
create_spreadsheet ⚠Create a new spreadsheettitle  [sheet_names]Spreadsheet
delete_sheet ⚠Delete a sheet tabspreadsheet_id, sheet_idNoneType
get_sheet_metadataGet sheet metadata for all tabsspreadsheet_idlist
get_spreadsheetGet spreadsheet metadata and sheetsspreadsheet_idSpreadsheet
get_valuesGet values from a rangespreadsheet_id, rangeSheetValues
merge_cells ⚠Merge cells in a rangespreadsheet_id, sheet_id, start_row, end_row, start_column, end_column  [merge_type]dict
rename_sheet ⚠Rename a sheet tab within a spreadsheetspreadsheet_id, sheet_id, new_titledict
update_values ⚠Update values in a rangespreadsheet_id, range, values  [input_option]UpdateResult
Open Interactive Docs & Playground →

Full schema explorer, code generation, and live API testing