Google Sheets Tools
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
Use Google Sheets Tools with AI agents
Aident Loadout lets Claude Code, Codex, Cursor, and other supported agents call Google Sheets Tools. Choose from 45 supported Actions. Review each execution in Audit.
Connect Google Sheets Tools once through Aident Vault. Your agent can use the supported Actions without receiving the underlying credential.
Category
Productivity Project ManagementPricing and payment
- Pricing
- Free in Loadout. Provider charges may apply when using a personally connected account.
- Unified payment
- Not currently supported. Connect a provider account when required.
Included Actions
- Googlesheets Add SheetAdds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spreadsheet with rows/columns. Use properties to set dimensions, tab color, etc. - OBJECT: Sheet containing a chart. Requires objectSheetConfig w…
- Googlesheets Aggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- Googlesheets 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.
- Googlesheets Auto Resize DimensionsAuto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.
- Googlesheets 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 DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared -- all other properties of the cell (such…
- Googlesheets Batch GetRetrieves data from specified cell ranges in a Google Spreadsheet.
- Googlesheets 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 than fixed cell ranges.
- Googlesheets 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 Spreadsheet.
- Googlesheets Clear 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.
- Googlesheets Create ChartCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: - Provide either a simple chart via chart_type + data_range (basicChart), OR supply a full chart_spec supporting all chart types. Exactly one approach should be…
- Googlesheets 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 provided, Google will create a spreadsheet with a default name like 'Untitled spreadsheet'. Optionally create the spreadsheet in a specific fo…
- Googlesheets 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, defaults to the first sheet (sheet_id=0).
- Googlesheets 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.
- Googlesheets 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 to be replaced. This action is irreversible — once a chart is deleted, it cannot be recovered. The chart data source (the cells containing…
- Googlesheets 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.
- Googlesheets Delete SheetTool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document.
- Googlesheets 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 replacements across cells. Common use cases: - Fix #ERROR! cells by replacing with empty string or correct formula - Update old values with new one…
- Googlesheets Format CellApplies text and background cell formatting to a specified range in a Google Sheets worksheet.
- Googlesheets 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, or prepare to modify conditional format rules.
- Googlesheets Get Data Validation RulesTool to extract data validation rules from a Google Sheets spreadsheet. Use when you need to understand dropdown lists, allowed values, custom formulas, or other validation constraints for cells.
- Googlesheets Get Sheet NamesLists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
- Googlesheets Get Spreadsheet By Data FilterReturns the spreadsheet at the given ID, filtered by the specified data filters. Use this tool when you need to retrieve specific subsets of data from a Google Sheet based on criteria like A1 notation, developer metadata, or grid ranges. Important: This action is designed for fi…
- Googlesheets Get Spreadsheet InfoRetrieves metadata for a Google Spreadsheet using its ID. By default, returns essential information (ID, title, sheet properties) to avoid payload size issues. Use the fields parameter for comprehensive metadata or specific fields.
- Googlesheets Insert DimensionTool to insert new rows or columns into a sheet at a specified location. Use when you need to add empty rows or columns within an existing Google Sheet.
- Googlesheets List ChartsLists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position. Use this action when you need to discover what charts exist in a spreadsheet, retrieve chart IDs for update or delete operations, or inspect ch…
- Googlesheets Lookup 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.
- Googlesheets Move ChartMove or resize an existing chart on a Google Sheets spreadsheet. Use this action when you need to reposition a chart to a different location on the same or different sheet, move it to a brand-new sheet, or change its size. This action wraps the updateEmbeddedObjectPosition batch…
- Googlesheets Mutate Conditional Format RulesAdd, update, delete, or reorder conditional format rules on a Google Sheet. Use when you need to create, modify, or remove conditional formatting without manually building batchUpdate requests. Supports four operations: ADD (create new rule), UPDATE (replace existing rule), DELE…
- Googlesheets Search Developer MetadataTool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on filters.
- +16 Actions
Provider sources
Skills that use Google Sheets Tools
Related AI agent Apps
- Ably ToolsAbly is a real-time messaging platform helping developers build live features, including chat and data synchronization, with global scalability and robust reliability for modern applications
- Abstract ToolsAbstract API provides a suite of APIs for developers to automate various tasks, including data validation, enrichment, and more.
- AbuseIPDB ToolsAbuseIPDB is a project dedicated to helping make the internet safer by providing a central repository for reporting and checking IP addresses associated with malicious activities.
- Abyssale ToolsAbyssale is a creative automation platform that enables users to generate images, videos, GIFs, PDFs, and HTML5 content programmatically, streamlining visual content production.