How do I connect Google Sheets to Operator?

You authorize Google Sheets once from your Operator dashboard. Operator holds the connection and refreshes the access token for you, so your agent keeps working with Google Sheets without you signing in again.

Can my agent manage tasks and projects in Google Sheets?

Yes. It can create and update items, move them between stages, add notes, and read the current state back to you. Use it to file new work as it arrives, check status without opening the app, or keep Google Sheets aligned with what is happening elsewhere.

Do I need to write code or manage Google Sheets API keys?

No code and no API keys. You authorize Google Sheets through a normal sign in and Operator handles the connection, so there is nothing to wire up or host.

Can my agent use Google Sheets together with my other apps?

Yes. The same agent reaches every app you connect, so it can move between Google Sheets and tools like Notion, Linear, Jira in one job, reading from one and acting in another without you wiring anything between them.

← All integrations

Connect Google Sheets to OpenClaw on Operator.io

Google Sheets is a cloud-based spreadsheet tool for real-time collaboration and data analysis. It lets teams work together from anywhere, updating information instantly.

Productivity & Project Management42 actions

Get started

Automate Google Sheets with AI

On Operator, an OpenClaw agent pilots Google Sheets for you. It reads your message, plans the steps, and runs them in Google Sheets, using actions like add sheet to existing spreadsheet, aggregate column data, append dimension.

Your agent reaches Google Sheets directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh for you, so there is nothing to wire up and no API keys to paste.

What your agent can do with Google Sheets

Your agent can call any of these Google Sheets actions by name as part of a larger task. Ask for the outcome you want and it picks the right ones.

Add Sheet to Existing Spreadsheet

Adds 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 contai...

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. Use when you need to automatically adjust row heights or column widths to fit content after writing data.

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. Ranges matching any of the specified data filters will be cleared. Only values are cleared...

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. Conditional requirements: - Provide either a simple chart via chart_type + data_range (basicChart), OR supply a full chart_spec supporting all c...

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. If no title is provided, Google will create a spreadsheet with a default name like 'Untitled spreadsheet'. Optional...

Create spreadsheet column

Creates 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).

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. This action is irreversible — once a chart is deleted, it cannot be recovered. T...

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. Common use cases: - Fix #ERROR! cells by replacing with empty string or correc...

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. 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

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. 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....

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. Use the fields parameter for comprehensive metadata or specific fields.

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. Supports four operations: ADD (create new r...

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. Use when you need to apply dropdown lists, range-based dropdowns, or custom formula validation to cells.

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. Use when you need to retrieve specific data sets based on filtering criteria rather than entire sheets or fixed ranges.

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 visual settings. This...

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. Use this when you need to modify the metadata or appearance of a specific sheet.

Update Spreadsheet Properties

Tool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings. Use when you need to modify the overall configuration of a Google Spreadsheet. NOTE: To update individual SHE...

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. Use for: CRM syncs (match Lead ID), transaction imports (match Transaction ID), inventory updates (match SKU), calendar...

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.

How to connect Google Sheets

You authorize Google Sheets once from your dashboard. Operator holds the connection and refreshes the access tokens on its own, so your agent keeps working with Google Sheets without you signing in again. The same setup unlocks every other app your agent can reach, so you only do it once.

When you are ready, the get started guide walks through standing up your OpenClaw agent.

Common questions about Google Sheets

How do I connect Google Sheets to Operator?: You authorize Google Sheets once from your Operator dashboard. Operator holds the connection and refreshes the access token for you, so your agent keeps working with Google Sheets without you signing in again.
Can my agent manage tasks and projects in Google Sheets?: Yes. It can create and update items, move them between stages, add notes, and read the current state back to you. Use it to file new work as it arrives, check status without opening the app, or keep Google Sheets aligned with what is happening elsewhere.
Do I need to write code or manage Google Sheets API keys?: No code and no API keys. You authorize Google Sheets through a normal sign in and Operator handles the connection, so there is nothing to wire up or host.
Can my agent use Google Sheets together with my other apps?: Yes. The same agent reaches every app you connect, so it can move between Google Sheets and tools like Notion, Linear, Jira in one job, reading from one and acting in another without you wiring anything between them.