Connect Google Sheets to Agaro ERP
Connect Google Sheets to Agaro so your team and the AGARO Assistant can read, write, and update spreadsheet data, with the same permissions and audit trail as everything else in your workspace.
Supported tools
Every Google Sheets action Agaro can use out of the box.
Add Sheet to Existing Spreadsheet
Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Append Dimension
Tool 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 Rows or Columns
Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.
Batch Clear Values By Data Filter
Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters.
Batch get spreadsheet
Retrieves data from specified cell ranges in a Google Spreadsheet.
Batch Update Values by Data Filter
Tool 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.
Clear Basic Filter
Tool 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.
Clear spreadsheet values
Clears 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 Sheets
Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.
Create a Google Sheet
Creates a new Google Spreadsheet in Google Drive. If a title is provided, the spreadsheet will be created with that name.
Create spreadsheet column
Creates a new column in a Google Spreadsheet. Specify the target sheet using sheet_id (numeric) or sheet_name (text).
Create spreadsheet row
Inserts 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 Sheets
Delete 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.
Delete Dimension (Rows/Columns)
Tool 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 Sheet
Tool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document.
Find and Replace in Spreadsheet
Tool 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.
Format cell
Applies text and background cell formatting to a specified range in a Google Sheets worksheet.
Get conditional format rules
List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
Get Data Validation Rules
Tool 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.
Get sheet names
Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
Get Spreadsheet by Data Filter
Returns the spreadsheet at the given ID, filtered by the specified data filters.
Get spreadsheet info
Retrieves metadata for a Google Spreadsheet using its ID. By default, returns essential information (ID, title, sheet properties) to avoid payload size issues.
Insert Dimension in Google Sheet
Tool 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.
Look up spreadsheet row
Finds 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.
Mutate conditional format rules
Add, 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.
Search Developer Metadata
Tool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on filters.
Search Spreadsheets
Search for Google Spreadsheets using various filters including name, content, date ranges, and more.
Set Basic Filter
Tool to set a basic filter on a sheet in a Google Spreadsheet. Use when you need to filter or sort data within a specific range on a sheet.
Set Data Validation Rule
Tool to set or clear data validation rules (including dropdowns) on a range in Google Sheets.
Copy Sheet to Another Spreadsheet
Tool to copy a single sheet from a spreadsheet to another spreadsheet. Use when you need to duplicate a sheet into a different spreadsheet.
Append Values to Spreadsheet
Tool to append values to a spreadsheet. Use when you need to add new data to the end of an existing table in a Google Sheet.
Batch Clear Spreadsheet Values
Tool to clear one or more ranges of values from a spreadsheet. Use when you need to remove data from specific cells or ranges while keeping formatting and other properties intact.
Batch Get Spreadsheet Values by Data Filter
Tool to return one or more ranges of values from a spreadsheet that match the specified data filters.
Update Chart in Google Sheets
Update 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. Use when you need to change visibility or pixel sizing of dimensions in a Google Sheet.
Update Sheet Properties
Tool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties.
Update Spreadsheet Properties
Tool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.
Batch update spreadsheet values
Tool to set values in one or more ranges of a spreadsheet. Use when you need to update multiple ranges in a single operation for better performance.
Upsert Rows (Smart Update/Insert)
Upsert rows - update existing rows by key, append new ones. Automatically handles column mapping and partial updates.
Get spreadsheet values
Returns a range of values from a spreadsheet. Use when you need to read data from specific cells or ranges in a Google Sheet.
Update spreadsheet values
Tool to set values in a range of a Google Spreadsheet. Use when you need to update or overwrite existing cell values in a specific range.
Nothing matches that search.
Microsoft ExcelMicrosoft Excel is a robust spreadsheet application for organizing, analyzing, and visualizing data. It's the go-to tool for calculations, reporting, and flexible data management.
Google DriveGoogle Drive is a cloud storage platform for uploading, sharing, and collaborating on files. It's perfect for keeping your documents accessible and organized across devices.
Google DocsGoogle Docs is a cloud-based word processor that enables document creation and real-time collaboration. Its seamless sharing and version history make team editing and content management a breeze.
Put Google Sheets to work inside Agaro.
Tell us how your team uses Google Sheets today and we will show you how it connects.