Google Sheets MCP
Use Google Sheets with Claude Desktop, Cursor, or Windsurf to let AI read, act, and automate — no code required.
Use Google Sheets MCPHow to use this MCP
Connect Your Google Sheets Account
Sign up and connect your Google Sheets account to Activepieces.
Get Your MCP Server URL
Get your MCP URL and install it in Claude Desktop, Cursor, or Windsurf.
Ask AI to Act
Ask your AI assistant to read emails, manage your calendar, and more.
Google Sheets Triggers
New or Updated Row
Triggers when a new row is added or modified in a spreadsheet.
New Row Added
Triggers when a new row is added to bottom of a spreadsheet.
New Spreadsheet
Triggers when a new spreadsheet is created.
New Worksheet
Triggers when a worksheet is created in a spreadsheet.
Google Sheets Actions
Add Row
Add a new row of data to a specific spreadsheet.
Add Row at Top
Inserts a new row at the top of a worksheet, just below the header row.
Add Multiple Rows
Add multiple rows of data at once to a specific spreadsheet.
Update Row
Update the data in an existing row.
Update Multiple Rows
Updates multiple rows in a specific spreadsheet.
Delete Row
Delete a specific row from the selected sheet.
Delete Multiple Rows
Deletes a contiguous range of rows, or a list of specific row numbers. Row numbers are 1-based.
Find Rows
Look up rows in a worksheet based on a column value.
Find or Create Row
Look up a row by column value; if no match is found, create a new row with the provided values.
Create Spreadsheet
Creates a blank spreadsheet.
Create Worksheet
Create a new blank worksheet with a title.
Find or Create Worksheet
Look up a worksheet by title in a spreadsheet; if not found, create it with optional headers.
Clear Sheet
Clears all rows on an existing sheet.
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.
Delete Worksheet
Permanently delete a specific worksheet.
Rename Worksheet
Rename specific worksheet.
Format Row(s)
Format one or multiple rows in specific spreadsheet.
Get Single Row by ID
Retrieve a specific row using its unique ID.
Get next row(s)
Get next group of rows from a specifiec workheet
Get All Rows
Get all the rows from a specific sheet.
Read Data Range
Read cells from a range using A1 notation (e.g. A1:D10). Returns rows and the resolved range.
Find Spreadsheet(s)
Find spreadsheet(s) by name.
Find Worksheet(s)
Finds a worksheet(s) by title.
Copy Worksheet
Creates a new worksheet by copying an existing one.
Create Spreadsheet Column
Creates a new column in a specific spreadsheet.
Export Worksheet
Download a worksheet as a CSV or TSV file.
Custom API Call
Make a custom API call to a specific endpoint
