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.
Guides using Google Sheets
More productivity apps on the same server
Browse all MCP appsNotion
The all-in-one workspace
Airtable
Low‒code platform to build apps.
Google Calendar
Get organized and stay on schedule
Microsoft Outlook
Microsoft Excel 365
Spreadsheet software by Microsoft
Trello
Project management tool for teams