Skip to content
Google Sheets logo

Google Sheets MCP server

Create, edit, and collaborate on spreadsheets online

Google Sheets is not a separate install. One Activepieces MCP server exposes it alongside 760+ other apps, behind a single URL.

Tools
27
Works with
Any MCP client
Auth
OAuth 2.0 or Custom auth
License
MIT, open source
Updated
September 2026

About the Google Sheets MCP server

Connect Google Sheets once in Activepieces and every action it ships becomes a tool your assistant can call, behind the same server URL as the rest of your apps. Your agent reaches Google Sheets and 760+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

Google Sheets tools your AI can run

Once connected, your assistant can call any of these Google Sheets actions by asking in plain language.

  • Add Row

    Add a new row of data to a specific spreadsheet.

    6 fields

  • Add Row at Top

    Inserts a new row at the top of a worksheet, just below the header row.

    7 fields

  • Add Multiple Rows

    Add multiple rows of data at once to a specific spreadsheet.

    10 fields

  • Update Row

    Update the data in an existing row.

    6 fields

  • Update Multiple Rows

    Updates multiple rows in a specific spreadsheet.

    6 fields

  • Delete Row

    Delete a specific row from the selected sheet.

    4 fields

  • Delete Multiple Rows

    Deletes a contiguous range of rows, or a list of specific row numbers. Row numbers are 1-based.

    7 fields

  • Find Rows

    Look up rows in a worksheet based on a column value.

    10 fields

  • Find or Create Row

    Look up a row by column value; if no match is found, create a new row with the provided values.

    11 fields

  • Create Spreadsheet

    Creates a blank spreadsheet.

    3 fields

  • Create Worksheet

    Create a new blank worksheet with a title.

    4 fields

  • Find or Create Worksheet

    Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers.

    4 fields

  • Clear Sheet

    Clear every row on a worksheet, keeping the worksheet itself.

    5 fields

  • Clear Row(s)

    Clears the contents of one or more rows without removing the rows themselves. Useful when you want to keep formatting and references stable.

    5 fields

  • Delete Worksheet

    Permanently delete a specific worksheet.

    3 fields

  • Rename Worksheet

    Give an existing worksheet a new title.

    4 fields

  • Format Row(s)

    Apply colour and text styling to one or more rows.

    10 fields

  • Get Row by Number

    Retrieve one row by its row number.

    6 fields

  • Get Next Rows

    Read the next batch of rows from a worksheet, continuing where the last run left off.

    9 fields

  • Get All Rows

    Read every row from a worksheet.

    4 fields

  • Read Data Range

    Read cells from a range using A1 notation (e.g. A1:D10). Returns rows and the resolved range.

    6 fields

  • Find Spreadsheet(s)

    Find spreadsheet(s) by name.

    3 fields

  • Find Worksheet(s)

    Find worksheets in a spreadsheet by title.

    4 fields

  • Copy Worksheet

    Creates a new worksheet by copying an existing one.

    4 fields

  • Create Column

    Add a new column to a worksheet.

    5 fields

  • Export Worksheet

    Download a worksheet as a CSV or TSV file.

    5 fields

  • Custom API Call

    Make a custom API call to a specific endpoint

    10 fields

Triggers

Google Sheets events your agent can watch

These start a run the moment something happens in Google Sheets, so work gets picked up on its own.

  • New or Updated Row

    Triggers when a new row is added or modified in a spreadsheet.

    5 fields

  • New Row Added

    Triggers when a new row is added to the bottom of a worksheet.

    4 fields

  • New Spreadsheet

    Triggers when a new spreadsheet is created.

    1 field

  • New Worksheet

    Triggers when a worksheet is created in a spreadsheet.

    2 fields

Give your assistant Google Sheets

Connect Google Sheets once and every tool above is callable from Claude, Cursor or any MCP client, behind the same server URL as 760+ other apps. Free to start.

Google Sheets MCP, answered.

No. That is the point of it. One Activepieces server exposes Google Sheets alongside every other piece you connect, so your client keeps a single connection.

Yes. Activepieces is open source and free to start, and the MCP server is included on every plan, from the free cloud tier to any self-hosted deployment.

Connect Google Sheets in Activepieces, enable the server under Settings → MCP Server, then paste your server URL into your client config. It authenticates over OAuth on first use.

It can call 27 tools, including Add Row, Add Row at Top, Add Multiple Rows, and chain them with steps in other apps inside the same run.

Connections use OAuth2 with limited scopes and are stored under 256-bit encryption, with no API to read them back, so an agent gets scoped access rather than your keys.