Add Sheet to Existing SpreadsheetAdd a GRID sheet with rows and columns to an existing spreadsheet.
Aggregate Column DataAggregates data from a column in a Google Sheet, either across all rows or rows matching column-value filters.
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 values 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 a specified data range and chart type, or an optional full chart specification.
Create a Google SheetCreates a new Google Spreadsheet in Drive with an optional title and folder ID or exact folder name.
Create spreadsheet columnInserts a new column in a Google Spreadsheet at a specified index.
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 SpreadsheetFinds and replaces text across cells in a Google Spreadsheet, scoped to a sheet, range, or all sheets; if no scope is specified, it searches all sheets.
Format cellFormats a specified cell 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 specified A1 range or the first sheet where a cell matches the query after Unicode and invisible-character normalization.
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 accessible in Drive by name, content, dates, and other filters, including starred and shared-with-me status.
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 FilterRetrieves one or more ranges of values from a Google Spreadsheet using data filters.
Update Chart in Google SheetsUpdates an existing chart in a Google Sheets spreadsheet by replacing its chart specification.
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)Upserts rows in a Google Sheet by matching a key column: updates matching rows and appends new ones.
Get spreadsheet valuesReturns a range of values from a spreadsheet.
Update spreadsheet valuesSets or overwrites values in a Google Spreadsheet range, adjusting the range to fit the supplied values and potentially expanding the sheet by default.