Automate Google Sheets without writing code.

• Add sheetAdds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spread
• 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. Use when you need to add empty rows or columns to an existing sheet.
• Auto resize dimensionsAuto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjus
• Batch clear values by data filterClears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFi
• Batch getRetrieves data from specified cell ranges in a Google Spreadsheet.
• Batch updateDEPRECATED: Use GOOGLESHEETS_VALUES_UPDATE instead. Write values to ONE range in a Google Sheet, or append as new rows if no start cell is g
• Batch update values by data filterTool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather
• Clear basic filterTool to clear the basic filter from a sheet. Use when you need to remove an existing basic filter from a specific sheet within a Google Spre
• Clear valuesClears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond
• Create chartCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: - Provide either a si
• Create google sheet1Creates a new Google Spreadsheet in Google Drive. If a title is provided, the spreadsheet will be created with that name. If no title is pro
• Create spreadsheet columnCreates a new column in a Google Spreadsheet. Specify the target sheet using sheet_id (numeric) or sheet_name (text). If neither is provided
• 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 abov
• Delete chartDelete an existing chart from a Google Sheets spreadsheet. Use this action when you need to remove a chart that is no longer needed or needs
• Delete dimensionTool to delete specified rows or columns from a sheet in a Google Spreadsheet. Use when you need to remove a range of rows or columns.
• Delete sheetTool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document.
• Execute sqlDEPRECATED: Use direct Google Sheets actions instead: - GOOGLESHEETS_VALUES_GET / GOOGLESHEETS_BATCH_GET for reads - GOOGLESHEETS_VALUES_UPD
• Find replaceTool to find and replace text in a Google Spreadsheet. Use when you need to fix formula errors, update values, or perform bulk text replacem
• Find worksheet by titleDEPRECATED: Use GetSpreadsheetInfo instead. Finds a worksheet by its exact, case-sensitive title within a Google Spreadsheet; returns a bool
• Format cellApplies text and background cell formatting to a specified range in a Google Sheets worksheet.
• Get batch valuesDEPRECATED: Use GOOGLESHEETS_BATCH_GET instead. Tool to return one or more ranges of values from a spreadsheet. Use when you need to retriev
• Get conditional format rulesList conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form. Use when you need to view, audit,
• Get data validation rulesTool to extract data validation rules from a Google Sheets spreadsheet. Use when you need to understand dropdown lists, allowed values, cust

+ 29 more