How to get started with Google Sheets on Zapier

Written by Owner

Updated at August 20th, 2025

+ More

Table of Contents

Prerequisites Connect Google Sheets to Zapier About Google Sheets's app Triggers, searches, and actions Limitations Templates Use cases Additional Google Sheets resources

Google Sheets and Zapier can automate your spreadsheets by creating workflows. You can use triggers like new or updated rows to automatically create, update, or find data in a sheet.

Prerequisites

To use the Google Sheets app on Zapier, you must have:

No paid Google Sheets plan required.
Permissions required:
- For trigger and search actions: viewer, commenter, or editor permissions.
- For create and update actions: editor permissions.
- If using Google Workspace (formerly G Suite): third-party app access must be enabled.

Connect Google Sheets to Zapier

To create an app connection to Google Sheets on Zapier:

Go to the Apps page.
Click + Add connection.
A new dialog box will appear. Search for and select Google Sheets.
Click Add connection.
A new browser tab or window will open.
Log into Google Sheets to authenticate.
Grant Zapier permission to access your account if prompted to.

Your Google Sheets account is now successfully connected to Zapier.

About Google Sheets's app

Triggers, searches, and actions

Triggers

New Spreadsheet Row (Team Drive) - Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
New Spreadsheet - Triggers when a new spreadsheet is created.
New or Updated Spreadsheet Row - Triggers when a new row is added or modified in a spreadsheet.
New Spreadsheet Row - Triggers when a new row is added to the bottom of a spreadsheet. (Instant)
New or Updated Spreadsheet Row (Team Drive) - Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
New Worksheet - Triggers when a worksheet is created in a spreadsheet.

Searches

Find Worksheet - Finds a worksheet by title.
Lookup Spreadsheet Row - Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.
Find or Create Row - Finds or creates a specific lookup row.
Lookup Spreadsheet Rows (Advanced) - Find up to 500 rows based on a column and value as line items.
Get Many Spreadsheet Rows (Advanced) - Return up to 1,500 rows as a single JSON value or as line items.
Find or Create Worksheet - Finds or creates a specific find worksheet.

Actions

Create Spreadsheet Column - Create a new column in a specific spreadsheet.
Create Multiple Spreadsheet Rows - Create one or more new rows in a specific spreadsheet (with line item support).
Copy Worksheet - Creates a new worksheet by copying an existing worksheet.
Create Worksheet - Creates a new worksheet in a Google Sheet.
Delete Spreadsheet Row(s) - Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.
Update Spreadsheet Row - Update a row in a specific spreadsheet with optional formatting.
API Request (Beta) - This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
Create Spreadsheet Row - Create a new row in a specific spreadsheet.
Create Spreadsheet Row at Top - Creates a new spreadsheet row at the top of a spreadsheet (after the header row).
Create Spreadsheet - Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
Clear Spreadsheet Row(s) - Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
Format Spreadsheet Row - Format a row in a specific spreadsheet.
Update Spreadsheet Row(s) - Update one or more rows in a specific spreadsheet (with line item support).

Limitations

Google Sheets triggers are limited to 30MB or less, while actions can handle files up to 50MB. Spreadsheets exceeding these limits may prevent Zapier from accessing and processing your data effectively.
API Usage limits:
- 6,000 read requests per minute per user
- 1,800 read requests per minute per user.
Using Google Sheets requires strict spreadsheet formatting requirements. Learn more in working with Google Sheets in Zaps.
When using the Create Spreadsheet Row action, steps may briefly appear as "Delayed" in the Zap history. This is normal and should last only a few seconds.

Templates

View all of Google Sheets's templates .

How to get started with Google Sheets on Zapier

Contact Us

Prerequisites

Connect Google Sheets to Zapier

About Google Sheets's app

Triggers, searches, and actions

Limitations

Templates

Use cases

Additional Google Sheets resources

Related Articles