How do I connect Google Sheets?

Add the Google Sheets piece to a flow, then authenticate with OAuth 2.0 or Custom auth. Once connected, its 4 triggers and 27 actions are available anywhere in the builder.

What can I automate with Google Sheets?

"New or Updated Row" can start a flow that runs "Add Row", and you can chain Google Sheets together with any of 760+ other apps and AI steps in between.

Can I self-host the Google Sheets integration?

Yes. Activepieces is fully self-hostable, so you can run the Google Sheets piece on your own infrastructure with your connections and your data staying in your environment.

Can my AI agent use Google Sheets as a tool?

Yes. Every piece you connect can be exposed over one Activepieces MCP server, so Claude, Cursor, Windsurf or any MCP client can call Google Sheets actions as tools.

Google Sheets integration

Create, edit, and collaborate on spreadsheets online

Start building Use Google Sheets with your AI

Actions: 27
Triggers: 4
Auth: OAuth 2.0 or Custom auth
License: MIT, open source
Updated: September 2026

About the Google Sheets integration

Add the Google Sheets piece to a flow, connect your account once, and the rest of the builder can read from it and write to it. Because the piece is open source you can run it on our cloud or self-host it, and combine Google Sheets with 760+ other apps in the same flow.

Triggers

Start a flow the moment something happens in Google Sheets

Each trigger below can start a flow on its own, either instantly or on a schedule.

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

Actions

Everything Activepieces can do in Google Sheets

Drop any of these into a flow and fill in the fields. No code is required.

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

Use Google Sheets in a flow

Connect Google Sheets once and every trigger and action above is yours to drop into the builder, alongside 760+ other apps. Free to start, on our cloud or your own servers.

Build a Google Sheets flow Talk to sales

Google Sheets, answered.

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