Google Sheets

With Google Sheets modules in Make, you can manage rows, cells, sheets, spreadsheets, values, and conditional formats in your Google Sheets account.

To use Google Sheets modules, you must have a Google account. You can create one at accounts.google.com. To use instant trigger modules, you must have the Make Google Sheets extension.

Refer to the Google Sheets API documentation for a list of available endpoints.

Note

Make's use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy.

Connect Google Sheets to Make

To establish the connection in Make:

Log in to your Make account, add a Google Sheets module to your scenario, and click Create a connection.
Note: If you add a module with an instant tag, click Create a webhook, then Create a connection.
Optional: In the Connection name field, enter a name for the connection.
Optional: Switch on the Show advanced settings toggle and enter your Google Cloud Console project client credentials. For more information, see the Create and configure a Google Cloud Console project for Google Sheets section below.
Click Sign in with Google.
If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more Google Sheets modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Create and configure a Google Cloud Console project for Google Sheets

To connect to Make using your own client credentials, you can create and configure a project in the Google Cloud Console.

Create a Google Cloud Console project for Google Sheets

To create a Google Cloud Console project:

Log in to the Google Cloud Console using your Google credentials.
In the top menu, click Select a project > New project.
Enter a Project name and select the Location for your project.
Click Create.
In the top menu, check if your new project is selected in the Select a project dropdown. If not, select the project you just created.

Enable APIs for Google Sheets

To enable the required APIs:

Open the left navigation menu and go to APIs & Services > Library.
Search for and enable the following APIs: Google Sheets API and Google Drive API.

Create your Google Sheets client credentials

To create your client credentials:

In the left sidebar, click Credentials.
Click + Create Credentials > OAuth client ID.
In the Application type dropdown, select Web application.
Update the Name of your OAuth client. This will help you identify it in the console.
In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI:
https://www.integromat.com/oauth/cb/google/
Copy your Client ID and Client secret values and store them in a safe place.

You will use these values in the Client ID and Client Secret fields in Make.

Connecting Instant Triggers (Perform a Function, Watch Changes) using the Make Google Sheets Add-onPerform a FunctionTriggers

In order to use instant triggers, you must install the Make add-on in your spreadsheet and establish a connection between the Make module and Google Sheets.

Note

This add-on works only if you open the Google spreadsheet in a browser and make changes there. It will not work when the spreadsheet is filled by Google Forms or other tools.

Make for Google Sheets add-on installation

Open the spreadsheet where you want to install the extension.
Go to Extensions > Add-ons > Get add-ons
Search for the Make for Google Sheets add-on.
Click theMake for Google Sheets add-on.
Click Install.
Click Continue and Allow to grant access rights.
You have now installed theMake for Google Sheets add-on.

Connecting the Instant Trigger module to a Google Sheets spreadsheet

In Make, add a Google Sheets instant module to your scenario and click Create a webhook.
Optional: Enter a name for the webhook in the Webhook name field.
Select the corresponding connection for the webhook in the Connection field.
Click Save > Copy address to clipboard.
Open your spreadsheet.
Open theMake for Google Sheets add-on settings.
Paste the webhook URL you have copied in step 1 to the Webhook URL field in the Watch Updates settings section or Perform a Function section, depending upon which module you are using.
Click Save.
Note
If clicking Save does not work, try the steps again in an Incognito browser window, preferably Chrome (Specifically for Mac users)

Build Google Sheets Scenarios

After connecting the app, you can perform the following actions:

Sheets

Perform a Function

Make allows you to use the custom function MAKE_FUNCTION in Google Sheets similarly to built-in functions like AVERAGE, SUM, etc. It allows you to perform the function in Make and return the result back to the sheet. The function MAKE_FUNCTION accepts as many parameters as you need.

You must have a Sheets Add-On.

See the example of the module usage in the Tips & Tricks section.

Perform a Function - Responder

Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. You must have a Sheets Add-On. This module is to be used together with the Perform a Function module.

Response type	Select whether you insert text or a number into the sheet.
Value	Map the value from the previous module you want to insert into the sheet.

Add a Sheet

Add a new sheet.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to create a sheet. Search by path Select from all Enter manually
Spreadsheet ID	Select, search for, or enter the ID of the spreadsheet that contains the sheet you want to add a sheet to. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Properties	Title Enter the name of the new sheet. Index Enter the sheet position. The default is `0` (places the sheet in the first place).

Create a Spreadsheet

Creates a new spreadsheet.

Connection

Establish a connection to the spreadsheet using your Google account.

Title

Enter the name of a new spreadsheet.

Locale

The locale of the spreadsheet in one of the following formats:

an ISO 639-1 language code such as en,
an ISO 639-2 language code such as haw, if no 639-1 code exists,
a combination of the ISO language code and country code, such as en_US.

Recalculation interval

The amount of time to wait before volatile functions are recalculated:

On change

Volatile functions are updated upon every change.

On change and every minute

Volatile functions are updated upon every change and every minute.

On change and hourly

Volatile functions are updated upon every change and hourly.

Time zone

Select the time zone of the spreadsheet.

Number format

Select the default format of all cells in the spreadsheet.

`TEXT`	Text formatting, e.g `1000. 12`
`NUMBER`	Number formatting, e.g, `1,000.12`
`PERCENT`	Percent formatting, e.g `10. 12%`
`CURRENCY`	Currency formatting, e.g `$1,000.12`
`DATE`	Date formatting, e.g `9/26/2008`
`TIME`	Time formatting, e.g `3:59:00 PM`
`DATE TIME`	Date+Time formatting, e.g `9/26/08 15:59:00`
`SCIENTIFIC`	Scientific number formatting, e.g `1. 01E+03`

Sheets

Add sheets to the new spreadsheet.

Create a Spreadsheet from a Template

Creates a new spreadsheet from a template sheet.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select or map the Template Spreadsheet ID from which you want to create the spreadsheet. Search by path Select from all Enter manually
Drive	Select or map the drive where you want to create the spreadsheet.
Template Spreadsheet ID	Select the template from which you want to create the spreadsheet. If the spreadsheet contains tags like `{{name}}`, they are retrieved below. Your file must contain at least one tag for this module to work.
Title	Enter a name for the spreadsheet.
New Drive Location	Select or map the drive to store the new spreadsheet.
New Document's Location	Select or map the folder, where the new spreadsheet should be placed.

Copy a Sheet

Copies a sheet to another spreadsheet.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select or map the option to choose the spreadsheet that you want to copy. Search by path Select from all Enter manually
Drive	Select or map the drive location where the spreadsheet that you want to copy is located.
Spreadsheet ID	Select or map the Spreadsheet ID you want to copy. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Destination Drive Location	Select or map the drive location where you want to store the copied spreadsheet.
Destination Spreadsheet ID	Select or map the copied Spreadsheet ID.

Add a Conditional Format Rule

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

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Enter the Spreadsheet ID to which you want to create the conditional format rule. Search by path Select from all Enter manually
Spreadsheet ID	Enter the Spreadsheet ID to which you want to create the conditional format rule. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet ID	Enter the Sheet ID to which you want to create the conditional format rule.
Range	Enter the range of rows and columns to which you want to apply the conditional rule format. For example, A1:D25.
Index	The zero-based index where the rule should be inserted.
Format Rule	Select or map the rule for the conditional format rule.
Condition	Select or map the condition and enter the value for the format rule. For more information, see the boolean and gradient conditions.
Cell Format	Select or map the cell background color.
Text Format	Set the text format such as foreground color, bold, italic or strikethrough.

Rename a Sheet

Renames a specific sheet.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to create a sheet. Search by path Select from all Enter manually
Drive	Select or map the drive location where the spreadsheet in which you want to rename a sheet is located.
Spreadsheet ID	Select or map the Spreadsheet ID where a sheet you want to rename is located. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet ID	Enter the Sheet ID you want to rename.
New Sheet Name	Enter a new name of a sheet.

Get Range Values

Returns a sheet's content defined by range values.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet whose range value you want to get. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID for the spreadsheet where you want to retrieve range values. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Select the sheet you want to get the range content from.
Range	Enter the range you want to get, e.g. `A1:D25`.
Table contains headers	Row with headers Enter the range of the table headers, e.g. `A1:F1`. If you leave the field empty, Make will suppose that the header is in the first row of the specified range.
Value render option	Formatted value The values in the reply will be calculated and formatted according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` will return `"$1.23".` Unformatted value The values will be calculated, but not formatted in the reply. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` will return the number `"1.23"`. Formula The values will not be calculated. The reply will include the formulas. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then A2 will return `"=A1"`.
Date and render option	Serial number Instructs date, time, datetime, and duration fields to be output as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (to the left of the decimal) counts the days since December 30th 1899. The fractional portion (to the right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5. 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3 pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which is dependent on the spreadsheet's locale).

List Sheets

Gets a list of all sheets in a spreadsheet.

Connection

Establish a connection to the spreadsheet using your Google account.

Search Method

Select an option to choose the spreadsheet whose range value you want to get.

Select by path
Select from all
Enter manually

Spreadsheet ID

Select or map the Google Spreadsheet ID you want to retrieve sheets from.

You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 where abc1234567 is the Spreadsheet ID.

Delete a Sheet

Deletes a specific sheet.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet whose sheet you want to delete. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID from which you want to delete the row.
Sheet ID	Select or map the Sheet ID you want to delete.

Clear Values from a Range

Clears a specified range of values from a spreadsheet.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet and sheet name whose value you want to clear. Search by path Select from all Enter manually
Spreadsheet ID	Enter the Spreadsheet ID from which you want to clear the values. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter a sheet name from which you want to clear the values.
Range	Enter the range you want to clear. For example, A1:D25.

Delete a Conditional Format Rule

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

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet and sheet name whose value you want to clear. Search by path Select from all Enter manually
Spreadsheet ID	Enter the Spreadsheet ID whose conditional format rule you want to delete. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet ID	Enter the Sheet ID whose conditional format rule you want to delete.
Index	The zero-based index of the rule to be deleted

Rows

Watch New Rows

Triggers when a new row is added. If a sheet contains a blank row, Make doesn't process all subsequent rows.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select a method to choose the spreadsheet whose rows you want to watch. Search by path Select from all Enter manually
Drive	Select Google Drive, where you have the spreadsheet whose rows you want to watch.
Spreadsheet ID	Select the Spreadsheet ID whose rows you want to watch. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter a sheet name in which you want search rows.
Table contains headers	Select whether the spreadsheet contains the header row. If the Yes option is selected, the module doesn't retrieve the header row as output data, and variables in the output are then called by the headers. If the No option is selected, the module retrieves the first table row, and the output variables are called simply A, B, C, D, etc.
Row with headers	Enter the range of the header row, e.g., `A1:F1`.
Value render option	Formatted value The values in the reply will be calculated and formatted according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` will return `"$1.23".` Unformatted value The values will be calculated but not formatted in the reply. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` will return the number `"1.23"`. Formula The values will not be calculated. The reply will include the formulas. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then A2 will return `"=A1"`.
Date and time render option	Serial number Instructs date, time, datetime, and duration fields to be outputted as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (to the left of the decimal) counts the days since December 30th, 1899. The fractional portion (to the right of the decimal) counts the time as a fraction of the day. For example, January 1st, 1900 at noon would be 2.5. 2 because it's 2 days after December 30th, 1899, and .5 because noon is half a day. February 1st, 1900 at 3 pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which depends on the spreadsheet's locale).
Limit	Set the maximum number of results that Make will work with during one execution cycle.

Add a Row

Appends a new row to the bottom of the table.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to add a row. Search by path Select from all Enter manually
Drive	Select Google Drive to choose the spreadsheet in which you want to add a row.
Spreadsheet ID	Enter the Spreadsheet ID in which you want to add a row. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter a sheet name in which you want to add a row.
Column range	Select the column range that you want to work with.
Unformatted	Select or map whether the rows should be formatted or not based upon the spreadsheet's existing formatting.
Value	Enter or mapthe desired cells of the row you want to add.
Value input option	User entered The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Google Sheets UI. Raw The values the user has entered will not be parsed and will be stored as-is.
Insert data option	Insert rows Rows are inserted for the new data. Overwrite The new data overwrites the existing data in the areas where it is written. (Note: adding data to the end of the sheet will still insert new rows or columns so the data can be written.)

Update a Row

Updates a row.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to update a row. Search by path Select from all Enter manually
Drive	Select Google Drive to choose the spreadsheet whose rows you want to update.
Spreadsheet ID	Enter the Spreadsheet ID whose rows you want to update. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Select the sheet you want to update a row in.
Row number	Enter the number of the row you want to update.
Values	Enter or map the values in the desired cells of the row you want to change (update).
Value input option	User entered The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Google Sheets UI. Raw The values the user has entered will not be parsed and will be stored as-is.

Bulk Add Rows (Advanced)

Appends multiple rows to the bottom of the table.

Connection	Establish a connection to the spreadsheet using your Google account.
Spreadsheet ID	Select, search for, or enter the ID of the spreadsheet that contains the sheet where you want to add rows to. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter the name of the sheet where you want to add rows.
Column range	Select the column range that you want to work with.
Unformatted	Select or map whether the rows should be formatted or not based upon the spreadsheet's existing formatting.
Value	Enter or mapthe desired cells of the row you want to add.
Value input option	User entered The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Google Sheets UI. Raw The values the user has entered will not be parsed and will be stored as-is.
Insert data option	Insert rows Rows are inserted for the new data. Overwrite The new data overwrites the existing data in the areas where it is written. (Note: adding data to the end of the sheet will still insert new rows or columns so the data can be written.) Note: adding data to the end of the sheet will still insert new rows or columns.

Bulk Update Rows (Advanced)

Updates multiple rows.

Connection	Establish a connection to the spreadsheet using your Google account.
Spreadsheet ID	Select, search for, or enter the ID of the spreadsheet that contains the sheet where you want to update rows. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter the name of the sheet where you want to update rows.
Column range	Select the column range that you want to work with.
Unformatted	Select or map whether the rows should be formatted or not based upon the spreadsheet's existing formatting.
Values	Enter or map the values in the desired cells of rows you want to change (update).
Value input option	User entered The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Google Sheets UI. Raw The values the user has entered will not be parsed and will be stored as-is.

Search Rows

Returns results matching the given criteria.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to search rows. Search by path Select from all Enter manually
Spreadsheet ID	Enter the Spreadsheet ID in which you want search rows. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter a sheet name in which you want to search rows.
Table contains headers	option is selected, the module also retrieves the first table row, and variables in the output are then called simply A, B, C, D, etc.No option is select
Filter	Set the filter for the row to be searched by. Set filter values. You can also use logical operators, AND/OR in order to specify your selection.
Sort order	Map or select the direction that rows should be sorted by.
Order by	Select or map the option to arrange the search results.
Field Type	Select or map the field type to search the rows that match the specified type: Date Number String
Value reoption	Formatted value The values in the reply will be calculated and formatted according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` will return `"$1.23".` Unformatted value The values will be calculated, but not formatted in the reply. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` will return the number `"1.23"`. Formula The values will not be calculated. The reply will include the formulas. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then A2 will return `"=A1"`.
Date and time render option	Serial number Instructs date, time, datetime, and duration fields to be output as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (to the left of the decimal) counts the days since December 30th 1899. The fractional portion (to the right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5. 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3 pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which is dependent on the spreadsheet's locale).
Maximum number of returned rows	The maximum number of rows Make should return during one scenario execution cycle.

Search Rows (Advanced)

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

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to search rows. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID of the spreadsheet where you want to search rows. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet ID	Enter the Sheet ID whose row you want to search.
Query	Searches rows using Google Charts Query Language. The language is similar to SQL and it is possible to make complex queries. Unfortunately, the response doesn't contain IDs of returned rows. Due to Google Charts, the service is intended for data visualization where the row numbers aren't needed. You can find more information about the query language in the documentation. An example: `select * when B contains "[email protected]"`
Maximum number of returned rows	The maximum number of rows Make should return during one scenario execution cycle.

Clear a Row

Clears values from a specific row.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet in which you want to clear a row. Search by path Select from all Enter manually
Spreadsheet ID	Enter the Spreadsheet ID in which you want to clear a row. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter a sheet name in which you want to clear a row.
Row Number	Enter the number of the row you want to clear, e.g. `23`.

Delete a Row

Deletes a specific row.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet and sheet whose row you want to delete. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID from which you want to delete the row. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet ID	Enter the Sheet ID whose row you want to delete.
Row Number	Enter the number of the row you want to delete, e.g. `23`.

Cells

Watch Changes

Triggers when a cell is updated. You must have a Sheets Add-On.

The module only watches for changes made in the Google Sheets app by the user. Script executions and API requests do not trigger this module. The module does not watch for newly added rows to the sheet.

Webhook

Establish a connection to the spreadsheet using the add-on.

Update a Cell

Updates a specific cell.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet and sheet whose value you want to update. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID for the spreadsheet where you want to update a cell. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter the name of the sheet where you want to update a cell.
Cell	Enter the ID of the cell you want to update, e.g. `A5`.
Value	Enter the new value.
Value input option	User entered The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Google Sheets UI. Raw The values the user has entered will not be parsed and will be stored as-is.

Get a Cell

Updates a specific cell.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet and sheet whose value you want to get. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID from which you want to get a cell. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet ID	Select or map the Sheet ID that contains the cell you want to retrieve data from.
Cell	Enter the ID of the cell you want to get, e.g. `A5`.

Clear a Cell

Clears a specific cell.

Connection	Establish a connection to the spreadsheet using your Google account.
Search Method	Select an option to choose the spreadsheet and sheet whose value you want to clear. Search by path Select from all Enter manually
Spreadsheet ID	Select or map the Spreadsheet ID for the spreadsheet where you want to clear a cell. You can extract the Spreadsheet ID from the spreadsheet URL. For example, the URL is the following: `https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0` where `abc1234567` is the Spreadsheet ID.
Sheet Name	Enter the name of the sheet where you want to clear a cell.
Cell	Enter the ID of the cell you want to clear, e.g. `A5`.

Other

Make an API Call

Performs an arbitrary authorized API call. See the example of usage in the Tips & Tricks section.

Connection	Establish a connection to the spreadsheet using your Google account.
URL	Enter a path relative to `https://sheets.googleapis.com/v4/`. For example: `/spreadsheets/{{spreadsheetID}}`. For the list of available endpoints, refer to the Google Sheets API Documentation.
Method	Select the HTTP method you want to use: GET - to retrieve information for an entry. POST - to create a new entry. PUT - to update/replace an existing entry. PATCH - to make a partial entry update. DELETE - to delete an entry.
Headers	Enter the desired request headers. You don't have to add authorization headers; we already did that for you.
Query String	Enter the request query string.
Body	Enter the body content for your API call.

Tips & Tricks

Deleting Multiple Rows

To delete multiple rows based on filter criteria use the Search Rows module linked to the Delete a Row module as in the following example:

1. Add the Search Rows module and the Delete a Row module to the scenario.
Let's assume that you have a table where you need to delete all rows where column A equals Y.
Open the Search Rows module settings and set the fields as follows:
Filter
A Equal to Y
Sort order
Descending
Order by
Row number
Caution
Make sure that the Sort order and Order by fields are set as above, otherwise values will not be deleted correctly from the table!
Add the Delete a Row module to the scenario and connect it to the Search Row module.
Map the Row number item from the Search Rows module to the Delete a Row module's Row number field.
Run the scenario to delete values that match the filter criteria from the sheet.

How to Get Empty Cells from a Google Sheet

Use the Search Rows (Advanced) module and use this formula to get empty columns.

               select * where E is null

Here "E" is the column and "is null" is the condition. You can create a more advanced query using Google Query Lang

Add a Custom Button in a Sheet to Trigger a Scenario

In Make, insert the Webhook > Custom webhooks module/trigger into the scenario and configure it (see Webhooks).
Note: Once you have configured the custom webhook module, be sure to save the scenario .
Copy the webhook's URL.
Execute the scenario.
In Google Sheets, choose Insert > Drawing from the main menu bar.
Click the Text box icon:
Design a button and click Save and Close in the top-right corner:
The button will be placed in your worksheet. Click the three vertical dots in the button's top-right corner:
Choose Assign script from the menu.
Enter the name of your script (function). For example, runscenarioand click OK:
Choose Extensions > Apps Script from the main menu bar.
Insert the following code:
- The name of the function must correspond to the name you specified in step 9.
- Replace the https://hook.make.com/xxx...xxxURL with the webhook's URL you copied in step 2.
```
                           function runScenario() {
  UrlFetchApp.fetch("https://hook.make.com/xxx...xxx");
}
                        
```
Press Ctrl+S to save the script file, enter a project name, and click OK.
Switch back to Google Sheets and click your new button.
Grant the required authorization to the script:
In Make, verify that the scenario has successfully executed.

Note

This will only trigger a scenarioscenario to run when Scheduling is enabled. The linked webhook URL will not return any data but instead will trigger the scenario to run and allow the connected modules to return data.

Storing Dates in a Spreadsheet

If you store a Date value in a spreadsheet without any formatting,

it will appear as text in ISO 8601 format in the spreadsheet. However, Google Sheets formulas or functions that work with dates do not understand this text. E.g. formula =A1+10 will display the following error:

To help the GS to understand the date, format it with the formatDate(.) function. The correct format passed to the function as the second argument depends on the spreadsheet's locale settings. Choose File ▶ Spreadsheet settings from the main menu to verify/set the locale:

Once you have verified/set the proper locale, determine the corresponding date and time format by choosing Format ▶ Number from the main menu. The format is displayed next to the Date time menu item:

The following example shows the use of M/D/YYYY HH:mm:ss format for the United States locale:

Exploiting Google Sheets Functions

If you miss a built-in function but it is featured by Google Sheets, you may exploit it.

Perform a Function Example

Sample sheet

The Total-EUR amount SUM will be converted, according to the current exchange rate, to the Total - USD amount and will be inserted into the desired field using Make.

Create a scenario. Use the following modules:
- Google Sheets > Perform a Function
- Currency > Convert an Amount Between Currencies
- Google Sheets > Perform a Function - Responder
1. Google Sheets > Perform a Function
  Generate a webhook and paste it into the Make add-on in Google Sheets.
2. Currency > Convert an Amount between Currencies
  Converts the mapped EUR amount to USD.
3. Google Sheets > Perform a Function - Responder
  Inserts the converted amount into the sheet cell.
Run the scenario
Enter the MAKE_FUNCTION into the desired cell to load the converted amount.
When the user changes the amount, the MAKE_FUNCTION re-calculates the Total - USD according to the current exchange rate:

How to perform a custom function?

You can simply use the function like built-in functions in Google Sheet.

Create a new scenario with the following modules:

Perform a Function - the module receives the parameters passed to the function
Perform a Function - Responder - the module returns the result of the function execution back to the sheet

Posting and Getting Images from Google Sheets

When getting an image from Google Sheets, first make sure you enter the image as a formula. For example:=IMAGE("https://i.ytimg.com/vi/MPV2METPeJU/maxresdefault.jpg") making use of the =IMAGE(...)

After you have done so, open the Google Sheets module (e.g. Watch Rows, Search Rows, Get a Cell) and select Show advanced settings. Then select the Formula option in the Value render option field.

The output will be as shown below:

               Then you can extract the URL using the replace function.







The output will be just the URL.

To be able to post an image, make sure to enter the =IMAGE(...) formula that will be used in the cell and then enter the Image URL address.

Make an API Call: Example of Usage

The following API call returns specified spreadsheet details.

URL:

/spreadsheets/{{spreadsheetID}}

Method:

GET

The result can be found in the module's Output under Bundle > Body:

Usage Limits

If the error 429: RESOURCE_EXHAUSTED occurs, you have exceeded the API rate limit.

The Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Limits for reads and writes are tracked separately. There is no daily usage limit.

See more details at developers.google.com/sheets/api/limits.

Note

Did you know?

You can find over 100 predefined Google Sheets sample templates in our template gallery.

In this section:

Google Sheets

Note

Connect Google Sheets to Make

Create and configure a Google Cloud Console project for Google Sheets

Create a Google Cloud Console project for Google Sheets

Enable APIs for Google Sheets

Configure your OAuth consent screen for Google Sheets

Note

Create your Google Sheets client credentials

Connecting Instant Triggers (Perform a Function, Watch Changes) using the Make Google Sheets Add-onPerform a FunctionTriggers

Note

Make for Google Sheets add-on installation

Connecting the Instant Trigger module to a Google Sheets spreadsheet

Note

Build Google Sheets Scenarios

Sheets

Perform a Function

Perform a Function - Responder

Add a Sheet

Create a Spreadsheet

Create a Spreadsheet from a Template

Copy a Sheet

Add a Conditional Format Rule

Rename a Sheet

Get Range Values

List Sheets

Delete a Sheet

Clear Values from a Range

Delete a Conditional Format Rule

Rows

Watch New Rows

Add a Row

Update a Row

Bulk Add Rows (Advanced)

Bulk Update Rows (Advanced)

Search Rows

Search Rows (Advanced)

Clear a Row

Delete a Row

Cells

Watch Changes

Update a Cell

Get a Cell

Clear a Cell

Other

Make an API Call

Tips & Tricks

Deleting Multiple Rows

Caution

How to Get Empty Cells from a Google Sheet

Add a Custom Button in a Sheet to Trigger a Scenario

Note

Storing Dates in a Spreadsheet

Exploiting Google Sheets Functions

Perform a Function Example

How to perform a custom function?

Posting and Getting Images from Google Sheets

Make an API Call: Example of Usage

Usage Limits

Note

Search results