Productivity

Connect Google Sheets to any app

Connecting Google Sheets to APIANT lets your AI client build automations that read, add, look up and update rows in your spreadsheets. For example: when a new row is added to a sheet, create the contact in HubSpot and write the new record ID back into the row.

Managed connectiongoogleapis.com
16 triggers46 actions

What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.

Build solutions, not workarounds.

What do you want to automate with Google Sheets?

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Connect your AI client

Give your AI client this address.

https://mcp.apiant.ai

One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.

Set it up in your client
Claude Code

Run this in the directory you want to work in.

claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai

Start Claude Code there, approve the server, and sign in in the browser page it opens.

Claude Code guide (opens in a new tab)
Claude, web and desktop

Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.

Setup guide (opens in a new tab)
Cursor

Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.

Setup guide (opens in a new tab)
Zed

Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.

Setup guide (opens in a new tab)
Codex and the ChatGPT desktop app

Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.

Setup guide (opens in a new tab)
Any other MCP client

Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.

Setup guide (opens in a new tab)

Ask in plain language and your agent picks the Google Sheets operations, maps the fields both ways, and tests every scenario before the automation runs.

Build from the assistant inside APIANT, or from your own AI client over MCP. Either way the automation lands in the same account, and the free plan covers both.

Popular

Google Sheets with the apps people pair it with most

Pair it

Connect Google Sheets with another app

What your agent can do with Google Sheets

Triggers and actions 16 triggers · 46 actions

  • Trigger
    Aggregate Metric Changed

    Fires when an aggregate metric (sum/avg/count/…) over a column changes.

  • Trigger
    Cell Range Values Changed

    Fires when the values in a specific cell range change.

  • Trigger
    Conditional Format Rule Changed

    Fires when a conditional-format rule changes.

  • Trigger
    Data Validation Rule Changed

    Fires when a data-validation rule changes.

  • Trigger
    Developer Metadata Changed

    Fires when developer metadata changes.

  • Trigger
    Filtered Range Values Changed

    Fires when the values in a filtered range change.

  • Trigger
    New Rows

    Fires when new rows are appended to a Google Sheet.

  • Trigger
    New Sheet Added

    Fires when a new sheet (tab) is added to a spreadsheet.

  • Trigger
    New Spreadsheet Created

    Fires when a new spreadsheet is created in the account.

  • Trigger
    Spreadsheet Metadata Changed

    Fires when spreadsheet metadata changes.

  • Trigger
    Spreadsheet Properties Changed

    Fires when spreadsheet properties change.

  • Trigger
    Spreadsheet Row Changed

    Fires when a row matching a query changes.

  • Trigger
    Spreadsheet Search Match

    Fires when a spreadsheet matching search criteria is found.

  • Trigger
    Table Query Result Changed

    Fires when the result of a SQL-style table query changes.

  • Trigger
    Table Schema Changed

    Fires when a table's column schema changes.

  • Trigger
    Worksheet Names Changed

    Fires when worksheet (tab) names change.

  • Action
    Add Row

    Append a row to a Google Sheet

  • Action
    Aggregate Column Data

    Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).

  • Action
    Auto-Resize Rows or Columns

    Auto-fit row heights or column widths over an index range via autoResizeDimensions.

  • Action
    Change Sheet Properties

    Update a worksheet's grid properties (row/column count) using an explicit field mask.

  • Action
    Clear Basic Filter

    Remove the basic filter from a sheet via clearBasicFilter.

  • Action
    Clear Spreadsheet Row(s)

    Clear the values in a range (formatting preserved).

  • Action
    Copy Range

    Copy a source cell range to a destination range within the spreadsheet.

  • Action
    Copy Worksheet

    Copy a worksheet into a destination spreadsheet.

  • Action
    Create Chart

    Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.

  • Action
    Create Conditional Formatting Rule

    Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.

  • Action
    Create Multiple Spreadsheet Rows

    Append many rows in one call.

  • Action
    Create Spreadsheet

    Create a new Google Sheets spreadsheet with the given title.

  • Action
    Create Spreadsheet Column

    Insert a blank column at a given index.

  • Action
    Create Spreadsheet Row

    Append a single row of values to a sheet range.

  • Action
    Create Spreadsheet Row at Top

    Insert a blank row just below the header (row 2), then write the given values into it in one operation.

  • Action
    Create Worksheet

    Add a new worksheet (tab) to an existing spreadsheet.

  • Action
    Delete Chart

    Delete an embedded chart via deleteEmbeddedObject.

  • Action
    Delete Sheet

    Delete a worksheet from a spreadsheet by sheetId (gid).

  • Action
    Delete Spreadsheet Row(s)

    Delete a contiguous block of rows by index.

  • Action
    Find and Replace

    Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).

  • Action
    Find Spreadsheet

    Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).

  • Action
    Find Worksheet

    Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.

  • Action
    Format Cell Range

    Apply background color and bold formatting to a cell range via repeatCell.

  • Action
    Format Spreadsheet Row

    Apply a background color across an entire row via repeatCell over a row range.

  • Action
    Get Conditional Format Rules

    List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).

  • Action
    Get Data Range

    Read all values in one or more ranges via batchGet.

  • Action
    Get Data Validation Rules

    Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).

  • Action
    Get Many Spreadsheet Rows (Advanced)

    Read multiple ranges at once via batchGet.

  • Action
    Get Row by ID

    Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.

  • Action
    Get Sheet Names

    Return the titles of all sheets (tabs) in the spreadsheet.

  • Action
    Get Spreadsheet by ID

    Fetch spreadsheet metadata (title, sheets, gids, grid properties).

  • Action
    List Charts

    List all embedded charts (chartId + title) across every sheet in the spreadsheet.

  • Action
    Lookup Spreadsheet Row

    Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

  • Action
    Lookup Spreadsheet Rows (Advanced)

    Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

  • Action
    Move Chart

    Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.

  • Action
    Rename Sheet

    Rename a worksheet's title.

  • Action
    Search Spreadsheets

    Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.

  • Action
    Set Basic Filter

    Apply a basic filter to a range on a sheet via setBasicFilter.

  • Action
    Set Data Validation

    Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.

  • Action
    Sort Range

    Sort a cell range by one column in ascending or descending order.

  • Action
    Update Chart

    Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.

  • Action
    Update Conditional Format Rules

    Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.

  • Action
    Update Data Validation Rule

    Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).

  • Action
    Update Spreadsheet Row

    Overwrite the values at a specific range.

  • Action
    Update Spreadsheet Row(s)

    Update one or more disjoint ranges in a single batch.

  • Action
    Upsert Row

    Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).

Related apps

More in Productivity

Reviews

What our customers say

Questions

Google Sheets, answered

Is there a Google Sheets MCP server?

APIANT's MCP server at https://mcp.apiant.ai works with Google Sheets. Add that address to any AI client that takes a remote MCP server, Claude Code included, sign in once in your browser, and your client can build, test and run automations that use Google Sheets's triggers and actions. Nothing to install, and calls over MCP use no assistant credits.

How does Google Sheets authentication work?

Google Sheets connects through a managed sign-in: pick Google Sheets on the Connections page and sign in to your Google account on the vendor's own page. The first time, the dialog may also ask for an API key for the managed sign-in service. Connection credentials are stored encrypted. Details are in the Connections guide at https://apiant.ai/docs/apps/connections.

What can start an automation from Google Sheets?

Any of Google Sheets's 16 triggers in the catalog, including Aggregate Metric Changed, Cell Range Values Changed, Conditional Format Rule Changed and Data Validation Rule Changed. Describe the moment in plain language and your agent picks the right one.

What can your agent do in Google Sheets?

Any of Google Sheets's 46 actions, including Create Chart, Create Conditional Formatting Rule, Create Multiple Spreadsheet Rows and Create Spreadsheet. Your agent maps the data both ways and tests every scenario before it ships.

Can I use Google Sheets directly from Claude, ChatGPT or Cursor?

Yes. Connect your AI client to APIANT once and it works with Google Sheets two ways. Ask it to do something in Google Sheets once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running on its own. A one-off action uses your plan's tasks the same way an automation step does.

Do I need to write code against the Google Sheets API?

No. APIANT connects to the Google Sheets API for you, over a managed connection. Describe what you want in plain language and your agent builds it on the Google Sheets triggers and actions in the catalog. If you need an endpoint that is not there yet, your agent reads the Google Sheets API documentation and adds it.

Which apps can Google Sheets connect to?

Any app in the catalog; the list on this page pairs Google Sheets with each of them. If the other app is missing, point your agent at its API documentation and it builds the connector.

What happens when something fails?

Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.

Is there a free plan?

Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.