Productivity

Google Sheets

Google Sheets modules

16min

After connecting to the Google Sheets app, you can use the following modules to build your . 
Sheets
﻿ 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 Google Sheets tips and examples﻿ article.
Returns processed data as a result of the MAKE_FUNCTION or INTEGROMAT function. This module is to be used together with the Perform a Function module.
Field
Description
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.
Adds a new sheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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).
﻿
Creates a new spreadsheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Creates a new spreadsheet from a template sheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Copies a sheet to another spreadsheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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
Select or map the copied Spreadsheet ID.
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.
Renames a specific sheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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 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.
Returns a sheet's content defined by range values.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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).
Gets a list of all sheets in a spreadsheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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 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.
Deletes a specific sheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets account﻿.
Search Method
Select an option to choose the spreadsheet whose range value 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.
Clears a specified range of values from a spreadsheet.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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 
Enter a sheet name from which you want to clear the values.
Range
Enter the range you want to clear. For example, A1:D25.
Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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 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
Triggers when a new row is added. If a sheet contains a blank row, Make doesn't process all subsequent rows.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Appends a new row to the bottom of the table.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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 map the 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.)
Updates a row.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Appends multiple rows to the bottom of the table.
Field
Description
Connection
﻿Create a connection to your Google Sheets account﻿.
Spreadsheet ID
Enter the Spreadsheet ID in which you want to add 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 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 map the desired cells of the rows 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.)
Updates mulitple rows.
Field
Description
Connection
﻿Create a connection to your Google Sheets account﻿.
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 rows in.
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 the 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.
Returns results matching the given criteria.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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
If the 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.
Returns results matching the given criteria. This module doesn't return a row number.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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 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.
Clears values from a specific row.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Clears values from a specific row.
Field
Description
Connection
﻿Create a connection to your Google Sheets account﻿.
Search Method
Select an option to choose the spreadsheet in which you want to delete.
Search by path
Select from all
Enter manually
Spreadsheet ID
Enter the Spreadsheet ID in which you want to delete 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 ID
Enter a Sheet ID whose row you want to delete.
Row Number
Enter the number of the row you want to delete, e.g. 23.
Cells
Triggers when a cell is updated.
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.
Updates a specific cell.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Gets a cell.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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.
Clears a specific cell.
Field
Description
Connection
﻿Create a connection to your Google Sheets 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
Performs an arbitrary authorized API call. 
Field
Description
Connection
﻿Create a connection to your Google Sheets 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:
DELETE - to delete an entry.
PATCH - to make a partial entry update.
PUT - to update/replace an existing entry.
POST - to create a new entry.
GET - to retrieve information for 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.
﻿
﻿

Field	Description
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.

Field	Description
Connection	Create a connection to your Google Sheets 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).

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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	Select or map the copied Spreadsheet ID. 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.

Field	Description
Connection	Create a connection to your Google Sheets 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 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.

Field	Description
Connection	Create a connection to your Google Sheets 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).

Field	Description
Connection	Create a connection to your Google Sheets 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 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.

Field	Description
Connection	Create a connection to your Google Sheets account.
Search Method	Select an option to choose the spreadsheet whose range value 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.

Field	Description
Connection	Create a connection to your Google Sheets 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	Enter a sheet name from which you want to clear the values.
Range	Enter the range you want to clear. For example, A1:D25.

Field	Description
Connection	Create a connection to your Google Sheets 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 ID	Enter the Sheet ID whose conditional format rule you want to delete.
Index	The zero-based index of the rule to be deleted

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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 map the 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.)

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets account.
Spreadsheet ID	Enter the Spreadsheet ID in which you want to add 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 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 map the desired cells of the rows 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.)

Field	Description
Connection	Create a connection to your Google Sheets account.
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 rows in.
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 the 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.

Field	Description
Connection	Create a connection to your Google Sheets 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	If the 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.

Field	Description
Connection	Create a connection to your Google Sheets 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 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.

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets account.
Search Method	Select an option to choose the spreadsheet in which you want to delete. Search by path Select from all Enter manually
Spreadsheet ID	Enter the Spreadsheet ID in which you want to delete 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 ID	Enter a Sheet ID whose row you want to delete.
Row Number	Enter the number of the row you want to delete, e.g. 23.

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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.

Field	Description
Connection	Create a connection to your Google Sheets 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: DELETE - to delete an entry. PATCH - to make a partial entry update. PUT - to update/replace an existing entry. POST - to create a new entry. GET - to retrieve information for 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.

Updated 31 Mar 2025

Google Sheets

Google Sheets tips and examples

Google Sheets modules

Sheets

Perform a Function

Perform a Fuction - 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