Add Sheet to Existing SpreadsheetAdd a GRID sheet with rows and columns to an existing spreadsheet.
Aggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Append DimensionTool to append new rows or columns to a sheet, increasing its size.
Auto-Resize Rows or ColumnsAuto-fit column widths or row heights for a dimension range using batchUpdate.
Batch Clear Values By Data FilterClears one or more ranges of values from a spreadsheet using data filters.
Batch get spreadsheetRetrieves data from specified cell ranges in a Google Spreadsheet.
Batch Update Values by Data FilterTool to update values in ranges matching data filters.
Clear Basic FilterTool to clear the basic filter from a sheet.
Clear spreadsheet 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.
Create Chart in Google SheetsCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type.
Create a Google SheetCreates a new Google Spreadsheet in Google Drive.
Create spreadsheet columnCreates a new column in a Google Spreadsheet.
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.
Delete Chart from Google SheetsDelete an existing chart from a Google Sheets spreadsheet.
Delete Dimension (Rows/Columns)Tool to delete specified rows or columns from a sheet in a Google Spreadsheet.
Delete SheetTool to delete a sheet (worksheet) from a spreadsheet.
Export Drive SpreadsheetExport an entire native spreadsheet as XLSX, ODS, PDF, ZIP, CSV, or TSV; use Export Sheet as PDF for print layout and range controls.
Export Sheet as PDFRender one sheet tab or rectangular range as PDF with orientation, gridline, margin, and fit-to-width controls.
Find and Replace in SpreadsheetTool to find and replace text in a Google Spreadsheet.
Format cellApplies text and background cell formatting to a specified range in a Google Sheets worksheet.
Get conditional format rulesList conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
Get Data Validation RulesTool to extract data validation rules from a Google Sheets spreadsheet.
Get Drive File MetadataGet JSON metadata for one Drive file without downloading its content.
Get sheet namesLists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
Get Spreadsheet by Data FilterReturns the spreadsheet at the given ID, filtered by the specified data filters.
Get spreadsheet infoRetrieves metadata for a Google Spreadsheet using its ID.
Insert Dimension in Google SheetTool to insert new rows or columns into a sheet at a specified location.
List Charts in Google SheetsLists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.
List Drive ChangesStart a Drive change monitor or list one page after an existing token.
Look up 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.
Move or Resize Chart in Google SheetsMove or resize an existing chart on a Google Sheets spreadsheet.
Move Spreadsheet to FolderMove an existing Google Spreadsheet to a different Google Drive folder.
Mutate conditional format rulesAdd, update, delete, or reorder conditional format rules on a Google Sheet.
Search Developer MetadataTool to search for developer metadata in a spreadsheet.
Search SpreadsheetsSearch for Google Spreadsheets using various filters including name, content, date ranges, and more.
Set Basic FilterTool to set a basic filter on a sheet in a Google Spreadsheet.
Set Data Validation RuleTool to set or clear data validation rules (including dropdowns) on a range in Google Sheets.
Sort RangeSorts data within a specified range in a Google Sheet based on one or more sort criteria.
Copy Sheet to Another SpreadsheetTool to copy a single sheet from a spreadsheet to another spreadsheet.
Append Values to SpreadsheetTool to append values to a spreadsheet.
Batch Clear Spreadsheet ValuesTool to clear one or more ranges of values from a spreadsheet.
Batch Get Spreadsheet Values by Data FilterTool to return one or more ranges of values from a spreadsheet that match the specified data filters.
Update Chart in Google SheetsUpdate the specification of an existing chart in a Google Sheets spreadsheet.
Update Dimension Properties (Hide/Unhide & Resize)Tool to hide/unhide rows or columns and set row heights or column widths.
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 Spreadsheet PropertiesTool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.
Batch update spreadsheet valuesTool to set values in one or more ranges of a spreadsheet.
Upsert Rows (Smart Update/Insert)Upsert rows - update existing rows by key, append new ones.
Get spreadsheet valuesReturns a range of values from a spreadsheet.
Update spreadsheet valuesTool to set values in a range of a Google Spreadsheet.
