Team
Shared credential for production and unattended runs.
Connect Google Sheets with Hookshot™ and your stack
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
Tools and triggers
What Agents can do in Google Sheets
Available tools and events after Google Sheets is connected.
-
Add Sheet to Existing Spreadsheet
This action creates a new worksheet within a specified Google Sheet. Supports three sheet types: GRID (standard spreadsheet), OBJECT (chart on its own sheet), and DATA_SOURCE (connected to BigQuery). Users can define…
-
Aggregate Column Data
This action searches for specific rows in a Google Sheets spreadsheet based on a given column's value. It then performs selected mathematical operations on another column's data to provide aggregated results.
-
Append Dimension
This action appends new rows or columns to a specified sheet in a Google Spreadsheet. Use it to increase the size of the sheet by adding empty rows or columns as needed.
-
Append Values to Spreadsheet
This action appends values to the specified range in a Google Sheets spreadsheet. It allows users to add new data seamlessly to existing tables.
-
Auto-Resize Rows or Columns
Auto-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.
-
Batch Clear Spreadsheet Values
This action clears specified ranges of values from a given spreadsheet. It allows you to selectively remove data while preserving the overall structure and formatting of the spreadsheet.
-
Batch Clear Values by Data Filter
Clears cell values from a Google Sheet based on data filters. Only the values are removed while keeping cell formatting, data validation, and other properties intact.
-
Batch Get Spreadsheet
This action retrieves data from specific cell ranges in a Google Spreadsheet. Users can specify which ranges to get the values from, and the action handles the necessary authentication and API requests.
-
Batch Get Spreadsheet Values by Data Filter
This action retrieves specific ranges of values from a Google Spreadsheet based on defined data filters. It allows users to extract relevant data without needing to access entire sheets or predefined ranges.
-
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.
-
Batch Update Values by Data Filter
Updates values in a Google Sheet by matching data filters instead of fixed cell ranges. Use this when you need to update cells based on specific criteria like developer metadata or grid ranges.
-
Clear Basic Filter
This action clears any existing basic filter from the specified sheet of a Google Spreadsheet. It allows users to reset the sheet's filter settings for better data visibility.
-
Clear Spreadsheet Values
This action clears the content from a specified range in a Google Spreadsheet, using the provided A1 notation. The formatting and notes within the cells remain intact, making it ideal for resetting data without losing…
-
Copy Sheet to Another Spreadsheet
Copies a single sheet from one Google Spreadsheet to another. Use this when you need to duplicate a sheet's data and formatting into a different spreadsheet.
-
Create a Google Sheet
Creates a new Google Spreadsheet in your Google Drive. Optionally specify a 'title' for the new spreadsheet and a 'folder_id' or 'folder_name' to place it in a specific folder.
-
Create Chart in Google Sheets
This action creates a chart in a specified Google Sheets spreadsheet. Users can define the type of chart and the data range from which the chart will draw its data.
-
Create Spreadsheet Column
This action creates a new column in the specified Google Spreadsheet. You can specify the target sheet by its numeric ID (sheet_id) or by name (sheet_name). If neither is provided, the column is added to the first sheet.
-
Create Spreadsheet Row
This action creates a new row in the specified Google Spreadsheet at the given index. It can also inherit formatting from the preceding row if requested.
-
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. This action is irreversible — once a chart is deleted, it…
-
Delete Dimension (Rows/Columns)
Deletes rows or columns from a Google Sheet. Specify the range of rows or columns you want to remove, and they will be permanently deleted from the spreadsheet.
-
Delete Sheet
This action deletes a specified sheet from a given spreadsheet. It ensures that the selected sheet, along with its associated data sources if applicable, is removed from the document.
-
Find and Replace in Spreadsheet
Finds and replaces text across cells in a Google Sheet. Useful for bulk text updates, fixing formula errors, or cleaning up data formatting issues throughout your spreadsheet.
-
Format Cell
This action formats a specific range of cells in a Google Sheet. It allows the user to apply various text and background styling options to enhance the appearance of the selected cells.
-
Get Conditional Format Rules
List 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.
-
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
This action retrieves the names of all sheets in a specified Google Spreadsheet. It helps users to identify available sheets before performing further operations on them.
-
Get Spreadsheet by Data Filter
Retrieves specific data from a Google Sheet using filters (A1 notation ranges, developer metadata, or grid ranges). Recommended: Use GOOGLESHEETS_GET_SPREADSHEET_INFO for unfiltered spreadsheet metadata retrieval.
-
Get Spreadsheet Info
This action retrieves information about a Google Spreadsheet. By default, it returns essential metadata (spreadsheet ID, title, locale, timezone, and basic sheet properties like sheetId, title, index, sheetType…
-
Get Spreadsheet Values
This action retrieves specified values from a Google Spreadsheet. It allows users to access data from particular cells or ranges, facilitating data extraction for further processing.
-
Insert Dimension in Google Sheet
This action inserts new rows or columns at a specified index within a Google Sheet. It allows users to expand their spreadsheet dynamically by adding empty dimensions where needed.
-
List Charts in Google Sheets
Lists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.
-
Look Up Spreadsheet Row
This action searches for a specific text within a designated range of a Google Spreadsheet. It returns the first matching row where the entire content of a cell matches the provided query string.
-
Move or Resize Chart in Google Sheets
Moves or resizes an existing chart by chartId — supports moving to a new sheet, moving to an existing sheet, or repositioning via overlay pixel coordinates.
-
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. Supports four…
-
Search Developer Metadata
Searches for developer metadata within a Google Sheet. Use this to find specific metadata entries that have been attached to rows, columns, or sheets based on your filter criteria.
-
Search Spreadsheets
Searches for Google Spreadsheets in your Drive using various filters like name, content, creation date, and modification date. Useful for finding specific spreadsheets among many files.
-
Set Basic Filter
Sets up a basic filter on a Google Sheet to filter or sort data within a specific range. Useful for organizing and viewing only the data that meets your criteria.
-
Set Data Validation Rule
Tool to set or clear data validation rules (including dropdowns) on a range in Google Sheets. Use when you need to apply dropdown lists, range-based dropdowns, or custom formula validation to cells.
-
Sort Range
Sorts a range of cells in a Google Sheet by one or more columns. Useful for organizing data in ascending or descending order based on specific columns.
-
Update Chart in Google Sheets
Update the specification of an existing chart in a Google Sheets spreadsheet. Use this action when you need to modify an existing chart's properties such as its title, chart type, data ranges, colors, axes, or other…
-
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
This action updates properties of a specified sheet within a Google Spreadsheet. You can modify attributes such as the sheet's title, index, visibility, and other visual properties.
-
Update Spreadsheet Properties
Updates the overall SPREADSHEET-LEVEL properties of a Google Spreadsheet like its title, locale, time zone, and auto-recalculation settings. Use this to modify the spreadsheet's configuration. For updating individual…
-
Update Spreadsheet Values
This action updates the specified range in a Google Spreadsheet with new values. It allows you to overwrite existing cell data or set values in an unfilled range.
-
Upsert Rows (Smart Update/Insert)
This action updates existing rows and inserts new ones in a Google Sheet based on a unique key column. It automatically handles missing columns and supports partial updates of the data, ensuring that unnecessary data…
-
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and…
-
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
-
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
-
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
-
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
-
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
-
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
-
New Sheet Added in Google Spreadsheet
Polling trigger that detects when a new sheet is added to a Google Spreadsheet.
-
New Spreadsheet Created
Triggers when a new Google Spreadsheet is created. This trigger monitors Google Spreadsheets and fires when new spreadsheets are detected. Uses timestamp filtering to efficiently detect newly created spreadsheets.
-
Spreadsheet Metadata Changed
Polling trigger that detects when a Google Spreadsheet's metadata changes. Uses snapshot-based diffing to detect any changes in spreadsheet properties, sheets, named ranges, developer metadata, data sources, etc.
-
Spreadsheet Properties Changed
Polling trigger that detects when a Google Spreadsheet's top-level properties change. Monitors properties such as title, locale, timeZone, and autoRecalc settings.
-
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row…
-
Spreadsheet Search Match
Triggers when a new spreadsheet appears that matches a saved search. This trigger uses snapshot-based diffing to detect when spreadsheets matching the search criteria are newly created or become visible to the user.
-
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table…
-
Table Schema Changed
Polling trigger that detects when a table's schema changes in Google Sheets. Monitors columns added/removed/renamed and inferred type/format changes. Uses snapshot-based diffing to compare schemas between polls.
-
Worksheet Names Changed
Triggers when the set of worksheet/tab names changes in a Google Spreadsheet. Detects when sheets are added, deleted, or renamed.
Setup
Connect Google Sheets in Hookshot™
Pick a scope, then confirm what can start a Protege and what it can do.
Trigger Access
What can start a Protege from this app.
Tool Access
What a Protege can do after it starts.
Connection scope
Prefer team for production.
Personal
Tied to one user—only when the workflow needs their account.
Chat
Team-scoped for supported chat surfaces.
Build with us
See Hookshot™ in your stack.
Request early access or book a live walkthrough with the team.
