Google Sheets Tools
Google Sheets 是一款基于云端的电子表格工具，可实现实时协作、数据分析，并与其他 Google Workspace 应用集成。
让 AI 智能体使用 Google Sheets Tools
Aident Loadout 让 Claude Code、Codex、Cursor 和其他受支持的智能体调用 Google Sheets Tools。可选择 45 个受支持的操作。 可在 Audit 中审核每次执行。
通过 Aident Vault 连接一次 Google Sheets Tools。智能体无需获取底层凭证即可使用受支持的操作。
分类
Productivity Project Management价格与支付
- 价格
- 在 Loadout 中免费。使用个人连接的账号时，服务提供商可能收费。
- 统一支付
- 暂不支持。需要时请连接服务提供商账号。
包含的操作
- 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 个操作