Resources · Zapier integration

Google Sheets Zapier integrationAutomate Google Sheets with Zapier.

The Google Sheets Zapier integration gives you 7 triggers, 21 actions and 8 searches. Rows that start Zaps the moment they land, rows written, formatted or cleared for you, and lookups that find the right line before anything gets overwritten.

See the 36 operations

Verified Trustpilot reviews · AI, automation & growth agency

Overview

What the Google Sheets Zapier integration does for your spreadsheets

The Google Sheets Zapier integration plugs your spreadsheets into Zapier, so a row can start an automation and an automation can write, reshape or clean a sheet for you. It is not a premium app: all 36 visible operations work from the free plan, three of the triggers are instant, and the whole catalog covers rows, worksheets and whole spreadsheets.

Start with the choice that matters most on a free plan. Google Sheets offers two versions of several row triggers. New Spreadsheet Row, New or Updated Spreadsheet Row and Updated Spreadsheet Row are instant: Google tells Zapier as soon as the row changes, whatever your plan. Their Team Drive siblings poll, so on Free you wait up to 15 minutes. The Team Drive versions are the ones Zapier labels for files kept in a Team Drive; for any other file, the instant version spares you the wait.

Then three results show up on almost every account. A sheet that fills itself: Create Spreadsheet Row, Create Multiple Spreadsheet Rows and Create Spreadsheet Row at Top write data coming from earlier steps. A sheet that stays readable: Format Spreadsheet Row, Create Conditional Formatting Rule, Sort Range and Set Data Validation keep things tidy without anyone opening the file. Rows updated instead of duplicated: Lookup Spreadsheet Row finds the line, Update Spreadsheet Row rewrites it.

What Zapier does not do here: there is no trigger for a deleted row, no action to share a spreadsheet with someone, and anything outside the list goes through API Request (Beta). If you are comparing tools, the Google Sheets Make integration page covers the same app on Make, and our Make vs Zapier comparison lays out the criteria.

Vocabulary

Zapier vocabulary in one minute

Seven words carry the rest of this page. Each keeps the meaning given here.

Zap
The automation you build on Zapier: one trigger, then one or more actions that run every time the trigger event happens.
Trigger
The event in an app that starts the Zap. Once the Zap is on, Zapier waits for that event and reacts to nothing else.
Action
What the Zap does once it has started: the step that writes, formats or moves something for you in the app.
Task
The unit Zapier bills. One task is one action that completed successfully, and your plan is a monthly count of those.
Polling vs instant
A polling trigger is checked by Zapier on a timer. An instant trigger is reported by the app itself the moment the event happens.
Filter
A step that lets the Zap carry on only when what arrived meets your condition, and quietly stops it otherwise.
Search step
A step that looks up something already in an app, a row or a sheet, so the steps after it can reuse what it found.
Cost

What a Google Sheets Zap really costs

Google Sheets is not a premium app, so every operation on this page works on the free plan. The bill depends on actions, never on checks.

  • Premium appNo, works on the free plan
  • Free plan100 tasks a month, two-step Zaps only
  • What countsEach successful action, one task each
  • Instant triggers3 of the 7, no waiting on any plan

The trigger costs nothing, however often Zapier looks for new rows. Each action that succeeds counts as one task, and a failed one is not counted. Free gives you 100 tasks a month and unlimited Zaps, but each Zap stops at two steps. The classic Sheets pattern, look up a row then update it, is already a search plus an action: multi-step, so paid. Same thing as soon as you add a filter or a second action.

Connect

Connect Google Sheets to Zapier in three steps

  1. 01

    Open the Apps page

    In your Zapier account, open Apps and click + Add connection. A connection is your Google account linked once, then reused by every step that touches Google Sheets.

  2. 02

    Pick Google Sheets

    Type Google Sheets in the search box of the dialog that appears, select it in the results, then click Add connection. A new tab opens on the Google sign-in screen.

  3. 03

    Sign in and grant access

    Log in with the Google account that can open the spreadsheets, then allow Zapier to access it. For any file you do not own, that account needs read or write access shared first.

First Zap

Your first Zap: flag urgent support requests

GoalA support team logs every incoming request as a new row. When the Priority column says High, Zapier bolds that row and re-sorts the sheet so it rises to the top.

  1. 01

    Create the Zap

    Start a new Zap in the editor. With a filter and two actions it is multi-step, so it needs a paid plan, and each run that passes costs two tasks.

  2. 02

    Set the instant trigger

    Pick Google Sheets, then New Spreadsheet Row, your spreadsheet and worksheet. The test brings back the three most recent rows, so you map on real data.

  3. 03

    Add the filter

    Click the plus icon, choose Filter, then set the field (Priority), the rule (a text rule) and the value High. Rows that fail it stop here, at no cost.

  4. 04

    Format the row

    Add Format Spreadsheet Row, choose the same spreadsheet and worksheet, map the row ID from the trigger rather than picking a fixed row, and tick Bold.

  5. 05

    Sort the range

    Add Sort Range, enter the cell range in A1 notation, then the column letter that holds Priority and the sort order you want, so High rises first.

  6. 06

    Test, then publish

    Run each step once and read what came back before going further. When the row looks right, click Publish to switch the Zap on.

Triggers

Google Sheets triggers

7 events start a Zap when something happens in Google Sheets, and 3 of them are instant: the app calls Zapier straight away, whatever your plan.

1

New Spreadsheet Row (Team Drive)

Polling trigger

In Zapier“Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.”

Starts the Zap when a row is appended at the bottom of a spreadsheet stored in a Google Team Drive, and passes that row's columns to the next steps.

How it fires
Zapier goes and looks at regular intervals, and how often depends on your plan: every 15 minutes on the free one
When to use it
an operations team whose lead tracker sits in a shared Team Drive and needs each new lead sent on.
Watch out
only rows added at the bottom count. Keep the intake at the end of the sheet.
2

New Spreadsheet Row

Instant trigger

In Zapier“Triggers when a new row is added to the bottom of a spreadsheet.”

The everyday trigger: a row appears at the bottom of the sheet and the Zap gets its values at once, column by column.

How it fires
the app tells Zapier the moment it happens, so the Zap starts right away, whatever your plan
When to use it
a recruiter whose job form drops each applicant into a sheet and wants the hiring manager told without delay.
Watch out
if the Zap itself writes new rows into this same worksheet, it will start itself again and again. Write elsewhere, or guard with a filter.
3

New Spreadsheet

Polling trigger

In Zapier“Triggers when a new spreadsheet is created.”

Watches the Google account for spreadsheets that did not exist before, and hands each new file to the steps that follow.

How it fires
Zapier goes and looks at regular intervals, and how often depends on your plan: every 15 minutes on the free one
When to use it
an accountant who opens one workbook per client and wants a standard worksheet added to each new file.
Watch out
files created before the Zap was published are never picked up. Only what appears after it goes live counts.
4

New or Updated Spreadsheet Row (Team Drive)

Polling trigger

In Zapier“Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.”

Reacts to both kinds of change in a Team Drive sheet: a fresh row, or an existing one edited. Built for files that live in a Team Drive.

How it fires
Zapier goes and looks at regular intervals, and how often depends on your plan: every 15 minutes on the free one
When to use it
a shared order book in a Team Drive where both new orders and status edits must reach another tool.
Watch out
any edit counts, even a typo fixed. Add a filter on the column you care about, knowing it makes the Zap multi-step.
5

New or Updated Spreadsheet Row

Instant trigger

In Zapier“Triggers when a new row is added or modified in a spreadsheet.”

The instant cousin of the previous one, for regular spreadsheets: a row added or a row modified starts the Zap.

How it fires
the app tells Zapier the moment it happens, so the Zap starts right away, whatever your plan
When to use it
a sales rep who keeps a deal list by hand and wants the CRM in step whether a deal is new or just moved forward.
Watch out
an update action in the same Zap that writes back into this sheet will fire the trigger again. That loop burns tasks fast.
6

Updated Spreadsheet Row

Instant trigger

In Zapier“Triggers when an existing row is updated in a spreadsheet. New rows do not trigger this; use New or Updated Spreadsheet Row for that.”

Fires only when an existing row changes. New rows are ignored, which is the whole point: you track edits, not entries.

How it fires
the app tells Zapier the moment it happens, so the Zap starts right away, whatever your plan
When to use it
a project lead who wants an alert when someone flips a task from In progress to Done.
Watch out
if you need new rows too, this is the wrong trigger. Use New or Updated Spreadsheet Row instead.
7

New Worksheet

Polling trigger

In Zapier“Triggers when a worksheet is created in a spreadsheet.”

Notices a new tab created inside a given spreadsheet, and gives the next steps its details to work with.

How it fires
Zapier goes and looks at regular intervals, and how often depends on your plan: every 15 minutes on the free one
When to use it
a planning workbook where each month gets its own tab and you want that tab prepared the same way every time.
Watch out
tabs added before the Zap went live stay invisible to it, and a Zap that creates worksheets in this file will retrigger itself.
Actions

Google Sheets actions

Google Sheets gives you 21 actions. For each one: what it does for you, when to reach for it, and what to watch out for.

1

Create Spreadsheet Column

Action

In Zapier“Create a new column in a specific spreadsheet.”

Adds a new column to a chosen spreadsheet, for when the structure itself has to grow.

When to use it
a weekly tracker that needs a fresh column each time a new period opens in another tool.
Watch out
any other Zap that writes to this sheet should be retested once the structure changes.
2

Create Spreadsheet Row

Action

In Zapier“Create a new row in a specific spreadsheet.”

Appends one row to the worksheet you pick, each column filled with data from earlier steps. The workhorse of the app.

When to use it
logging every paid invoice from your billing tool in a finance sheet.
Watch out
an option decides whether date values are formatted with the timezone set up in the spreadsheet. Decide it on purpose before the first real run.
3

Create Multiple Spreadsheet Rows

Action

In Zapier“Create one or more new rows in a specific spreadsheet (with line item support).”

Writes one or several rows in one go, using line items, the lists some apps send for things like order lines. One step can then carry a whole list instead of one row per run.

When to use it
splitting an e-commerce order into one row per product, so each line stays readable and can be summed later.
4

Create Spreadsheet Row at Top

Action

In Zapier“Creates a new spreadsheet row at the top of a spreadsheet (after the header row).”

Inserts the new row just under the header row instead of at the bottom, so the latest entry is always the first one you read.

When to use it
a feed of incoming orders where the newest must sit at the top.
Watch out
the row goes right after the header, so the sheet needs a header row for this to land where you expect.
5

Change Sheet Properties

Action

In Zapier“Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.”

Adjusts how a worksheet behaves: frozen rows or columns, its position among the tabs, whether it is visible.

When to use it
hiding a calculation tab in every file you send to a client.
Watch out
you cannot hide the only visible sheet of a spreadsheet, so the step fails if you try.
6

Create Conditional Formatting Rule

Action

In Zapier“Apply conditional formatting to cells in a Google Sheets spreadsheet based on their values.”

Sets a rule that colors or styles cells depending on their value, so the sheet highlights things on its own afterwards.

When to use it
turning overdue payments red in every new client file you generate.
Watch out
Spreadsheet, Worksheet, Cell Range and Condition Type are all required, so the target file has to exist before this step runs.
7

Copy Range

Action

In Zapier“Copy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).”

Copies a block of cells to another spot in the same spreadsheet, with options for what to paste, values or formatting.

When to use it
freezing this week's totals into an archive area before they recalculate.
Watch out
Source Range and Destination Range are both required and written in A1 notation; the destination can be a single cell such as E1 or a full range.
8

Copy Worksheet

Action

In Zapier“Creates a new worksheet by copying an existing worksheet.”

Builds a new tab by copying an existing one. You choose the source spreadsheet and the worksheet to copy, both required.

When to use it
rolling a monthly template tab forward when the month changes.
Watch out
both the spreadsheet holding the tab and the tab itself are required, so the template must already exist.
9

Create Spreadsheet

Action

In Zapier“Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.”

Produces a whole new spreadsheet: blank, copied from an existing one, or started with the headers you specify.

When to use it
opening a standard budget file for every new client signed.
Watch out
pick the variant on purpose: a blank file, a copy of an existing one or a file with headers do not give the same starting point.
10

Create Worksheet

Action

In Zapier“Creates a new worksheet in a Google Sheet.”

Adds a tab to an existing spreadsheet. Spreadsheet and Title are required.

When to use it
one tab per event in a single registration workbook.
Watch out
an option lets it overwrite a worksheet that already has the same title. Leave it off unless losing that tab is the plan.
11

Clear Spreadsheet Row(s)

Action

In Zapier“Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.”

Empties the contents of one or more rows but leaves the rows in place, so nothing below shifts up.

When to use it
wiping a booking slot that was cancelled while keeping the calendar grid intact.
Watch out
you can enter one row, a list such as 1, 3, 5, or a range such as 1-5.
12

Delete Sheet

Action

In Zapier“Permanently delete a worksheet from a Google Sheets spreadsheet. Warning: This action cannot be undone.”

Permanently deletes a worksheet from a spreadsheet, and Zapier warns that it cannot be undone.

When to use it
clearing out temporary tabs once their data has been archived.
Watch out
a required Confirm Deletion field asks you to type DELETE. That is your last guard, so test on a copy.
13

Delete Spreadsheet Row(s)

Action

In Zapier“Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.”

Removes rows completely, with all their data: unlike a clear, the rows themselves are gone.

When to use it
pruning unsubscribed contacts from a mailing list sheet.
Watch out
the data goes with the rows. If the row structure has to stay, Clear Spreadsheet Row(s) empties the cells and keeps the rows.
14

Format Cell Range

Action

In Zapier“Apply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.”

Applies date, number or style formatting to a whole range: colors, bold, italic, strikethrough.

When to use it
making sure the amounts column always shows as numbers after an import.
Watch out
Cell Range and Format Type are required, and the range takes A1 notation such as A1:C10 or A:A.
15

Format Spreadsheet Row

Action

In Zapier“Format a row in a specific spreadsheet.”

Changes how a row looks: bold, italic, strikethrough. Spreadsheet, worksheet and row are required.

When to use it
striking through a task line when it is closed in your project tool.
Watch out
like Update Spreadsheet Row, a row picked from the list is fixed. Use a custom value to format a different row each run.
16

Rename Sheet

Action

In Zapier“Rename a worksheet in a Google Sheets spreadsheet.”

Gives a worksheet a new name. Spreadsheet, worksheet and New Sheet Name are required.

When to use it
renaming the Current tab to the closing date once a period ends.
Watch out
Find Worksheet looks tabs up by title, so any Zap that searches for the old name needs updating.
17

Set Data Validation

Action

In Zapier“Set data validation rules on a range of cells in Google Sheets to control what data can be entered.”

Puts input rules on a range so people can only enter what fits the rule you choose.

When to use it
locking a Status column to a few allowed values in a freshly created tracker.
Watch out
Strict Validation decides whether input that breaks the rule is rejected.
18

Sort Range

Action

In Zapier“Sort data within a specified range in Google Sheets by a chosen column in ascending or descending order.”

Sorts a range by one column, ascending or descending. You give the range, the column letter and the order.

When to use it
keeping a leaderboard ranked after every new score.
Watch out
the column to sort by is a letter such as A or AB, not the column's header name.
19

Update Spreadsheet Row

Action

In Zapier“Update a row in a specific spreadsheet with optional formatting.”

Rewrites an existing row, with optional bold, italic or strikethrough. The Row field is required.

When to use it
marking a lead as Contacted once your email tool confirms the send.
Watch out
pick a fixed row and it updates that same row every time. Map a row number from a lookup to hit the right one. Overwrite All Columns blanks every unmapped cell.
20

Update Spreadsheet Row(s)

Action

In Zapier“Update one or more rows in a specific spreadsheet (with line item support).”

Updates one or many rows in a single step, using line items to carry the row numbers and their new values.

When to use it
refreshing stock levels for every product a supplier sends in one delivery note.
Watch out
the row numbers have to arrive with the line items, so run a real test and check which rows were touched before going live.
21

API Request (Beta)

Action

In Zapier“This is an advanced action which makes a raw HTTP request that includes this integration's authentication.”

An advanced step that sends a raw request to Google Sheets with your existing connection. It covers whatever the ready-made operations leave out.

When to use it
a developer on your team needs a call Zapier never packaged.
Watch out
it is in beta, only reaches domains tied to the app, and you decide whether an error stops the step.
Searches

Google Sheets searches

8 search steps look for data that already exists in Google Sheets, so a later step can use it.

Searches sit at the bottom of the action list under their own SEARCH heading, and some fields offer + Add search step to insert one for you. Three settings decide what happens when the result is not the one expected.

1

Lookup Spreadsheet Rows (Advanced)

Search

In Zapier“Find up to 500 rows based on a column and value as line items.”

Finds up to 500 rows whose lookup column holds a given value, and returns them as line items.

When to use it
pulling every open ticket of one customer before writing them a summary.
Watch out
Lookup column and Lookup value are required. To match blank cells, type [:empty:] as the value.
2

Find Spreadsheet

SearchFind or create

In Zapier“Finds a spreadsheet by name.”

Looks up a spreadsheet by its name, or part of it, so later steps can work in a file you did not pick by hand.

When to use it
routing data to the right client workbook based on the client's name.
Watch out
the editor also shows Find or Create Spreadsheet. It is this same search with creation ticked, not an extra operation.
3

Find Worksheet

SearchFind or create

In Zapier“Finds a worksheet by title.”

Finds a tab by its title inside a spreadsheet and hands it to the next steps.

When to use it
writing to the tab named after the current month, whatever the date.
Watch out
Find or Create Worksheet is the same search with creation switched on. Use it so the first entry of a new month opens its tab.
4

Get Data Range

Search

In Zapier“Get data from a specific range in a Google Spreadsheet using A1 notation (e.g., "A1:D10", "B2:E5").”

Reads a block of cells in A1 notation, such as A1:D10 or a whole column like B:B.

When to use it
fetching a small price table to use in a quote built later in the Zap.
Watch out
spreadsheet, worksheet and A1 Range are all required, so the step cannot run on a guess.
5

Get Many Spreadsheet Rows (Advanced)

Search

In Zapier“Return up to 1,500 rows as a single JSON value or as line items.”

Returns up to 1,500 rows in one go, either as a single block or as line items, from the columns you specify.

When to use it
sending a full member list to another tool in one step.
Watch out
Columns and Row count are required, and the count cannot go above 1,500.
6

Get Row by ID

Search

In Zapier“Get a specific spreadsheet row by its row number (ID). Row 1 is typically the header row.”

Fetches one row by its number. Row 1 is usually the header, so data typically starts at row 2.

When to use it
reading a settings row that always sits at the same place.
Watch out
the step reads a position, not a value: it returns whatever sits in that row number.
7

Get Spreadsheet by ID

Search

In Zapier“Get a specific Google Spreadsheet by its ID. Returns the raw spreadsheet data from the Google Sheets API.”

Returns a spreadsheet's raw data from its ID, the code you read in the file's web address.

When to use it
checking the list of tabs of a file before writing to it.
Watch out
with Include Grid Data off, you only get the spreadsheet and sheet properties, not the cell contents.
8

Lookup Spreadsheet Row

SearchFind or create

In Zapier“Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.”

Finds one row from a column and a value and returns the whole row, ready for an update.

When to use it
finding a customer's line by email before changing their status.
Watch out
Find or Create Row is this same search with creation on: a match is returned, a miss creates the row. Search from last row reads bottom up.

The three settings every search exposes

  1. Successful if no search results are found?
    Left on its default, a search that finds nothing stops the Zap there. Switched on, the Zap carries on empty-handed.
  2. Create X if it doesn't exist yet?
    Ticking it turns the search into find-or-create: the setting above disappears and the fields needed to create the item show up.
  3. If multiple search results are found?
    Three ways out: keep the first match, which is the default, stop the Zap, or pass every match on at once.
When it breaks

When a Google Sheets Zap breaks

Zapier's help centre lists several Google Sheets errors by name. Below, each title with what this page can tell you about the field or setting involved; the full fix is in the matching help article.

Beyond these errors, two general rules apply: a Zap never catches up on rows that existed before it was published, and Zapier remembers what it has already seen on a polling trigger, so the same row does not start a Zap twice. For a step-by-step method, our Zapier troubleshooting guide goes through the run history.

  • Zap not triggering

    Zapier has a help article under this title. Two facts from this page are worth ruling out: a polling trigger waits up to 15 minutes on Free, and rows added before publishing never count.

  • Required field "Row" is missing

    Row is a required field on Update Spreadsheet Row and Format Spreadsheet Row. The error names it, so the step to open is the one that writes to that row.

  • Required field "Lookup Value" is missing

    Lookup value is required on both lookup searches. To look for blank cells on purpose, the value to type is [:empty:].

  • Nothing could be found for the search

    A search that finds nothing stops the Zap by default. Switch on Successful if no search results are found, or tick the find-or-create box.

  • The caller does not have permission

    Zapier lists this error for Sheets. The connection needs read or write access on any file you do not own, so that access is the first thing to check.

  • Unable to parse range

    Zapier lists this error for writes to Sheets, and its help article gives the fix. Several fields on this page take ranges in A1 notation: A1:C10, A:A, 1:1.
Need help

Need help automating Google Sheets with Zapier?

A person reads every message.

FAQ

Google Sheets Zapier integration: FAQ

01Is the Google Sheets Zapier integration free?
Yes. Google Sheets is not a premium app, so all its operations run on the free Zapier plan. That plan gives 100 tasks a month and unlimited Zaps, but each Zap is limited to two steps: one trigger and one action. Looking up a row before updating it, adding a filter or chaining a second action makes the Zap multi-step, and multi-step Zaps need a paid plan. The trigger itself never costs a task, on any plan.
02How many tasks does a Google Sheets Zap use?
One task for each action that completes, and nothing for the trigger or for Zapier's checks. A Zap that creates one row per form answer costs one task per answer. Add Sort Range after it and each run costs two. An action that fails is not counted against your plan. Searches like Lookup Spreadsheet Row make the Zap multi-step, so they matter for the plan you need, and a test run shows exactly what a full pass consumes.
03Does Google Sheets trigger Zaps in real time?
Three of the seven triggers do. New Spreadsheet Row, New or Updated Spreadsheet Row and Updated Spreadsheet Row are instant: Google tells Zapier the moment the row changes, whatever your plan. The other four poll, so Zapier checks at an interval set by your plan: 15 minutes on Free, 2 on Professional, 1 on Team and Enterprise. That covers New Spreadsheet, New Worksheet and both Team Drive row triggers, so prefer the instant versions when the file is not in a Team Drive.
04What do you need to connect Google Sheets to Zapier?
A Google account that can open the spreadsheets you want to automate. Add it from the Apps page with + Add connection, sign in on the Google tab that opens and grant Zapier access. For files owned by a colleague, that account needs read or write access first, shared by the owner before you build the Zap. One connection then serves every Google Sheets step, in every Zap you build with that account.
05Why does the Zap keep updating the same row?
Because a row was picked from the list instead of mapped. On Update Spreadsheet Row and Format Spreadsheet Row, choosing a row from the dropdown fixes it: the Zap rewrites that line every run. To hit a different row each time, put a Lookup Spreadsheet Row step before it and map the row number it returns. Note that this adds a search, which makes the Zap multi-step and moves it onto a paid plan.
06What if the Google Sheets action you need isn't listed?
Then API Request (Beta) is the fallback. It sends a raw request to Google Sheets through the connection you already have, reaching operations none of the 21 actions cover. It is a technical step, still in beta, and it can only call domains tied to the app. If no one on the team writes API calls, that is the point to bring in someone who does, rather than forcing the workflow into operations that do not fit.
07Zapier, Make or n8n for Google Sheets?
It comes down to criteria, not a winner. On Zapier, Google Sheets has three instant row triggers and runs two-step Zaps on its free plan, with 36 operations to pick from. What decides is which operations your workflow needs, how each tool counts the bill and who will maintain the automation. List your steps first, then check the Google Sheets page of each tool against that list before choosing, so the comparison rests on your own workflow.
Same platform

Other docs you might need on this stack.

Browse all integrations