Resources · Make integration

Google Sheets Make integrationAutomate Google Sheets with Make.

Can Make keep your spreadsheets current while you work on something else? Yes. The Google Sheets Make integration gives you 27 modules, 3 of them triggers. This guide links your Google account, builds a first scenario with you and explains every module in plain words.

Try the Google Sheets integration on MakeSee the 27 modules

Verified Trustpilot reviews · AI, automation & growth agency

What you can automate

What can the Google Sheets Make integration do for you?

The Google Sheets Make integration connects your spreadsheets to the rest of your tools. Make is where you chain apps together without code: it can pick up new rows, write or update values, search a sheet and even create whole spreadsheets. You choose the steps once, and Make repeats them each time the situation comes up.

A lead sheet that updates itself. A form drops contacts into a sheet. Watch New Rows picks up each one, passes it to your CRM, then Update a Row writes "sent" in the status column so nobody handles it twice.

A client report built from a template. When a deal closes, Create a Spreadsheet from a Template produces a fresh file for that client, and Add a Row fills in the first figures. No more duplicating the file by hand and forgetting to rename it.

A formula that asks Make for an answer. With the Make add-on, Perform a Function lets a cell call your scenario, and Perform a Function - Responder sends the result straight back into that cell.

What Make won't do here: Watch Changes only reacts to edits typed in the Google Sheets app, and both instant triggers need the Make add-on (or the script described in the doc) inside the spreadsheet. Still deciding on the tool? The Make review gives the full picture, and n8n vs Make covers the other common route for spreadsheet automation.

Connect

How do you connect your Google account to Make?

  1. 01

    Open the connection window

    Add any Google Sheets module to your scenario and click Create a connection. A connection is your Google account linked to Make once, then reused by every Google Sheets module. For an instant module, click Create a webhook first.

  2. 02

    Name it and skip the advanced part

    Type a clear label in Connection name, such as the address of the account, so you can tell connections apart later. The Show advanced settings toggle is optional: it takes client credentials from your own Google Cloud Platform project. You can leave it off.

  3. 03

    Sign in with Google

    Click Sign in with Google, pick the account that owns your spreadsheets, grant all requested permissions and confirm. Back in Make, the module now lists your spreadsheets and sheets in a menu, so you choose them instead of typing them.

First scenario

Your first scenario: copy each new order into a shared spreadsheet

GoalWhen a new row appears in your Google Sheets order log, Make adds the same order to a second spreadsheet shared with the warehouse.

  1. 01

    Create the scenario

    On the Scenarios page, create a new scenario and click the +. A scenario is the automation you build: a chain of modules, each module being one brick that triggers, acts or searches.

  2. 02

    Add Watch New Rows

    Search for Google Sheets, pick Watch New Rows and click Create a connection to link your Google account. This module will open the scenario.

  3. 03

    Point it at your order log

    Choose the spreadsheet and the sheet from the lists Make shows once the connection exists. No need to remember file names: Make reads them from your account.

  4. 04

    Add the Add a Row module

    Click the + on the right of the trigger, pick Google Sheets again, then Add a Row. Select the warehouse spreadsheet and map each column to a value coming from Watch New Rows.

  5. 05

    Test with Run once

    Type a test order in the log, then click Run once. Each module shows the bundles it received; a bundle is one item passed along, here one row. Check that the order landed in the second file.

  6. 06

    Schedule it and switch it on

    Open the clock on the first module. A new scenario checks every 15 minutes by default, and the Free plan can't go below that. Then switch the scenario on.

Triggers

What can start a Google Sheets scenario?

3 modules start a scenario when something happens in Google Sheets. A scheduled trigger is checked by Make on the scenario's schedule; an instant one is called by Google Sheets as soon as it happens.

Google Sheets1Watch New Rows

Watch New Rows

Scheduled trigger

In Make“Triggers when a new row is added.”

Watch New Rows looks at one sheet and hands every row added since its last check to the next module, one bundle per row. It fits a sheet that a form fills, or one where a teammate logs incoming requests.

How it fires
scheduled. Make checks the app on the scenario's schedule, every 15 minutes by default, and never more often than that on the Free plan (paid plans go down to 1 minute).
When to use it
a support log where every new ticket line should reach your help desk without anyone copying it over.
Watch out
it looks for added rows only. Editing an older row won't start the scenario; that's the job of Watch Changes.
Google Sheets2Watch Changes

Watch Changes

Instant trigger

In Make“Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.”

Watch Changes starts your scenario when someone edits a cell in the spreadsheet. You decide which Sheet and which Range it keeps an eye on, in the settings of the Make add-on.

How it fires
instant. The app calls Make through a webhook as soon as it happens: the add-on (or the Apps Script from the doc, set on the On edit event) sends the change to the webhook URL copied from the module.
When to use it
a project tracker where switching a status cell to "Approved" should alert the client.
Watch out
only edits made in the Google Sheets app count. Values written by another scenario or an import go unnoticed, and Scheduling has to be switched on for the scenario.
Google Sheets3Perform a Function

Perform a Function

Instant trigger

In Make“Receives data from the MAKE_FUNCTION or INTEGROMAT functions used in a sheet. Please note, the Sheets Add-On is required.”

Perform a Function turns a formula into a doorbell for your scenario. Type the MAKE_FUNCTION function (or INTEGROMAT) in a cell, and whatever you pass to it lands in Make as data to work on.

How it fires
instant. The app calls Make through a webhook as soon as it happens, provided the Sheets add-on is installed in that spreadsheet.
When to use it
a pricing sheet where a cell should fetch a value that lives in another tool, like the current stock of a product.
Watch out
the webhook URL returns no data on its own. It only starts the scenario; to write an answer back into the cell, end with Perform a Function - Responder.
Modules

Every Google Sheets module, and when to pick it

Google Sheets gives you 24 modules in 4 groups. For each one: what it does for you, when to reach for it, and what to watch out for.

Rows

8 modules
Google Sheets1

Add a Row

Action

In Make“Appends a new row to the bottom of the table.”

Add a Row writes one new line at the bottom of your table, with each column filled from data earlier in the scenario.

When to use it
logging every paid invoice from your billing tool so finance has one list to check.
Watch out
it always appends at the end, so keep empty rows or notes out of the bottom of the table.
Google Sheets2

Update a Row

Action

In Make“Updates a row.”

This module rewrites the values of a row that already exists. You tell it which row, then which columns get new content.

When to use it
flipping a lead's status to "contacted" once the email has gone out.
Watch out
it needs the row number. Get it from Search Rows, not from Search Rows (Advanced), which doesn't return one.
Google Sheets3

Bulk Add Rows (Advanced)

Action

In Make“Appends multiple rows to the bottom of the table.”

Where Add a Row writes one line, Bulk Add Rows (Advanced) appends a whole batch at the bottom of the table in a single step.

When to use it
dropping every line of an order export into the sheet at once instead of looping row by row.
Watch out
it expects a list, so you'll usually group your bundles first with an aggregator, a module that gathers several items into one.
Google Sheets4

Bulk Update Rows (Advanced)

Action

In Make“Updates multiple rows.”

Several rows change in one pass with Bulk Update Rows (Advanced), instead of one Update a Row per line.

When to use it
refreshing the price column of a product catalog after your supplier sends new rates.
Watch out
as with the bulk add, prepare the rows as a list beforehand; a mistake in that list changes many lines at the same time.
Google Sheets5

Search Rows

Search

In Make“Returns results matching the given criteria.”

Search Rows finds the lines that match your criteria, like every row where the email column equals a given address. Each match comes out as its own bundle.

When to use it
checking whether a customer is already in the sheet before adding them again.
Watch out
a search can return zero, one or many rows. Plan what happens next in each case.
Google Sheets6

Search Rows (Advanced)

Search

In Make“Returns results matching the given criteria. This module doesn't return a row number.”

The advanced version of the search also filters your table on the criteria you set, for people comfortable writing a more precise query.

When to use it
pulling the rows you only want to read, such as open deals above a threshold for a summary email.
Watch out
it doesn't return a row number, so you can't feed its results to Update a Row or Delete a Row. Use Search Rows for that.
Google Sheets7

Clear a Row

Action

In Make“Clears values from a specific row.”

Clear a Row empties the values of one row but leaves the line itself in place, so the rows below don't move up.

When to use it
wiping a booking slot when the customer cancels, so the next booking can reuse it.
Watch out
the content is gone for good; if you might need it later, copy it elsewhere first.
Google Sheets8

Delete a Row

Action

In Make“Deletes a specific row.”

Unlike clearing, Delete a Row removes the whole line and shifts the rows underneath up by one.

When to use it
removing a subscriber from your list once they've unsubscribed.
Watch out
there is no undo from Make. And since every row below moves, a row number you fetched earlier in the scenario may no longer point where you think.

Cells

3 modules

To use this module, follow the steps in the Set up a Google Sheets webhook section.

Google Sheets9

Update a Cell

Action

In Make“Updates a specific cell.”

Pinpoint editing: Update a Cell writes a value into one single cell, like B2, without touching the rest of the row.

When to use it
a dashboard where one cell shows the last sync time or a running total.
Watch out
if someone inserts a column, your cell address points somewhere else. Keep that dashboard layout stable.
Google Sheets10

Get a Cell

Action

In Make“Gets a specific cell.”

Get a Cell reads the value of one cell and makes it available to the modules that follow.

When to use it
a settings tab where a manager types the discount rate, and the scenario reads it before building a quote.
Watch out
it reads one cell only. For a block of cells, Get Range Values saves you a string of lookups.
Google Sheets11

Clear a Cell

Action

In Make“Clears a specific cell.”

With Clear a Cell, one cell goes blank and everything around it stays as it was.

When to use it
resetting an "action needed" flag once the scenario has handled the request.
Watch out
Make doesn't keep the old value. Read it with Get a Cell first if a later step needs it.

Sheets

12 modules

To use this module, follow the steps in the Set up a Google Sheets webhook section.

Google Sheets12

Perform a Function - Responder

Action

In Make“Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. Sheets Add-On required.”

This is the other half of Perform a Function: it returns the processed result to the cell that called MAKE_FUNCTION, so the answer appears right where the formula sits.

When to use it
a lookup formula that should display the shipping status fetched from another app.
Watch out
without the Sheets add-on and the Perform a Function trigger at the start, it has nothing to answer.
Google Sheets13

Add a Sheet

Action

In Make“Adds a new sheet.”

Add a Sheet creates a new tab inside a spreadsheet you already have.

When to use it
opening a dedicated tab for each new event, so registrations for one event never mix with another.
Watch out
give each tab a name that won't collide with an existing one, for instance by including the event name.
Google Sheets14

Create a Spreadsheet

Action

In Make“Creates a new spreadsheet.”

A brand-new, empty spreadsheet appears in your Google account when this module runs.

When to use it
starting a separate tracking file whenever a new supplier signs on.
Watch out
the file starts blank. If every file should share the same columns and formatting, Create a Spreadsheet from a Template does that work for you.
Google Sheets15

Create a Spreadsheet from a Template

Action

In Make“Creates a new spreadsheet from a template sheet.”

You prepare a model sheet once, with its headers, formulas and colors. This module then produces a new spreadsheet from it each time the scenario runs.

When to use it
a client onboarding pack that should look the same for every new account.
Watch out
any mistake in the template gets copied into every new file, so test the model before you connect it.
Google Sheets16

Copy a Sheet

Action

In Make“Copies a sheet to another spreadsheet.”

Copy a Sheet sends a copy of one tab to another spreadsheet, with its content.

When to use it
handing a partner their own copy of a price list without giving them access to your master file.
Watch out
the copy is a snapshot. Changes made to the original afterward won't follow it.
Google Sheets17

Add a Conditional Format Rule

Action

In Make“Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.”

This module adds a formatting rule, such as turning a cell red when a value drops below a threshold, at the position you choose in the rule list.

When to use it
setting up the same color alerts on every new tab your scenario creates.
Watch out
every rule after the one you insert moves one position further down the list, which matters if another step refers to them by index.
Google Sheets18

Rename a Sheet

Action

In Make“Renames a specific sheet.”

Rename a Sheet changes the name of a tab, nothing else.

When to use it
marking a tab as "Closed" once a project wraps up, so the team sees at a glance what's still active.
Watch out
formulas and other modules that point at the old tab name may stop finding it after the change.
Google Sheets19

Get Range Values

Search

In Make“Returns a sheet’s content defined by range values.”

Get Range Values reads a whole block of cells, for example A1:D50, and returns its contents for the next steps.

When to use it
loading a price grid or a list of reps into the scenario before matching them with incoming requests.
Watch out
it's a search module, so it can return several bundles. Check what the next module expects before mapping.
Google Sheets20

List Sheets

Search

In Make“Gets a list of all sheets in a spreadsheet.”

List Sheets gives you the names of all the tabs in a spreadsheet.

When to use it
a scenario that should loop through every regional tab without you updating it each time a region is added.
Watch out
each tab comes out as its own bundle, so the next module runs once per tab and uses one operation each time. An operation is one run of one module, the unit Make counts on your plan.
Google Sheets21

Delete a Sheet

Action

In Make“Deletes a specific sheet.”

Delete a Sheet removes a tab and everything on it from the spreadsheet.

When to use it
cleaning out temporary tabs that another step of the scenario created for a calculation.
Watch out
nothing brings the tab back from Make. Double-check which sheet you selected, especially if names look alike.
Google Sheets22

Clear Values from a Range

Action

In Make“Clears a specified range of values from a spreadsheet.”

This one empties a range you define, say C2:C200, in one step, while the headers and the layout stay put.

When to use it
resetting the input area of a template before the scenario fills it again with fresh data.
Watch out
a range that's slightly too wide erases the row totals or notes sitting next to it.
Google Sheets23

Delete a Conditional Format Rule

Action

In Make“Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.”

Delete a Conditional Format Rule removes one formatting rule, picked by its position in the rule list.

When to use it
dropping an old alert color once a project phase is over.
Watch out
every rule after it moves up one position, so running the same deletion twice removes a different rule the second time.

Other

1 module
Google Sheets24

Make an API Call

Action

In Make“Performs an arbitrary authorized API call.”

Make an API Call is the escape hatch: it sends a request to any endpoint of the Google API, using the connection you already set up.

When to use it
you need something none of the other modules offers, such as a setting the ready-made modules don't expose.
Watch out
here you write the request yourself, so keep the Google documentation open next to the module.
Need help

Need help automating Google Sheets with Make?

A person reads every message.

FAQ

Google Sheets and Make: common questions

01Is the Google Sheets Make integration free?
Yes, Google Sheets is a standard app, so it works on the Make Free plan. That plan has limits worth knowing: 2 active scenarios, at least 15 minutes between two scheduled runs, 5 minutes of execution per run, and files up to 5 MB. Paid plans (Core, Pro, Teams, Enterprise) lift the interval to 1 minute and remove the cap on active scenarios. Usage is counted in operations, meaning one module run on one item, so a scenario that touches many rows uses more of your monthly allowance.
02What do you need to connect Google Sheets to Make?
A Google account and a Make account are enough for most modules. You add a Google Sheets module, click Create a connection, sign in with Google and grant the permissions it asks for. The instant triggers ask for more: Watch Changes and Perform a Function also need the Make add-on installed in the spreadsheet, or the Apps Script given in the doc. Using your own Google Cloud Platform project with client credentials is optional and only matters if your company requires it.
03Does the Google Sheets trigger react in real time?
It depends on the trigger. Watch New Rows is scheduled: Make checks the sheet on the scenario's schedule, every 15 minutes by default, and 1 minute is the shortest option on paid plans. Watch Changes and Perform a Function are instant: the add-on calls Make through a webhook as soon as the edit or the formula happens. The catch is that Watch Changes only sees edits typed in the Google Sheets app, and the scenario still needs Scheduling switched on.
04What if the Google Sheets module you need doesn't exist in Make?
Use Make an API Call. It reaches any endpoint of the Google API through the connection you already have, so you're not limited to the 27 ready-made modules. Before you go there, check the Rows, Cells and Sheets groups: many needs are covered by Search Rows, Get Range Values or the bulk modules. Also keep in mind that Search Rows (Advanced) returns no row number, which is often why an update step seems impossible. Switch to Search Rows in that case.
05Make or n8n: which one fits Google Sheets better?
It depends on your team, since Google Sheets often has an n8n node too. On the Make side, you get 27 ready-made modules, one connection reused by all of them, and menus that list your spreadsheets so you pick instead of typing. Instant triggers go through the Make add-on in the spreadsheet. The fairest test is to build the same small flow in the tool your team already knows, then check who will maintain it and which other apps you connect. Neither tool wins by default.
Same platform

Other docs you might need on this stack.

Browse all integrations