--- title: Google Sheets modules slug: google-sheets-modules createdAt: 2025-03-12T12:24:05.341Z --- After connecting to the Google Sheets app, you can use the following modules to build your scenarios. # Rows :::ExpandableHeading ## Watch New 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](https://apps.make.com/google-sheets#qzpra). | | **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 to watch rows. | | **Table contains headers** | Select whether the spreadsheet contains the header row.
If set to **Yes**, the module doesn't retrieve the header row as output data, and variables in the output are then called by the headers.
If set to **No**, 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 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 output 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. | ::: :::ExpandableHeading ## Add a Row Adds a new row at the bottom of the table. | **Field** | **Description** | | ------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to add a row. | | **Sheet Name** | Enter a sheet name in which you want to add a row. | | **Column range **(for Enter manually Search method) | Select the column range that you want to work with. | | **Table contains headers** | Select whether the spreadsheet contains the header row.
If set to **Yes** , 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. | | **Use column headers as IDs of the columns** | If **Table contains headers** is enabled, select whether to use column headers as IDs of the columns.
If set to **Yes**, column header names are used as stable IDs. As long as you don't rename your columns in the sheet, existing mappings will continue to work even if other columns are added, removed, or reordered in the table.
If set to **No**, column position will be used as the ID. The module will continue working when columns are renamed, but not if other columns are added, removed, or reordered in the table. | | **Values in columns** | Enter or map the desired cells of the row you want to add. | | **Unformatted** | Select or map whether the rows should be formatted or not based on the spreadsheet's existing formatting. | | **Value input option** | Select** User entered **if you want the values to be parsed as if typed into the Google Sheets 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 in Google Sheets.
Select **Raw **if you want the values to be stored exactly as provided, without any parsing or conversion. | | **Insert data option** | Select **Insert rows** if the new data should create new rows.
Select **Overwrite **if the new data should replace existing cells in the range. | ::: :::ExpandableHeading ## Update a Row Updates a row. | **Field** | **Description** | | ------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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 in which you want to update a row. | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet you want to update a row in. | | **Sheet Name** | Select the sheet you want to update a row in. | | **Row number** | Enter the number of the row you want to update. | | **Column range **(for Enter manually Search method) | Select the column range that you want to work with. | | **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. | | **Use column headers as IDs of the columns** | If **Table contains headers** is enabled, select whether to use column headers as IDs of the columns.
If set to **Yes**, column header names are used as stable IDs. As long as you don't rename your columns in the sheet, existing mappings will continue to work even if other columns are added, removed, or reordered in the table.
If set to **No**, column position will be used as the ID. The module will continue working when columns are renamed, but not if other columns are added, removed, or reordered in the table. | | **Values in column** | Enter or map the values in the desired cells of the row you want to change (update). | | **Value input option** | Select** User entered **if you want the values to be parsed as if typed into the Google Sheets 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 in Google Sheets.
Select **Raw **if you want the values to be stored exactly as provided, without any parsing or conversion. | ::: :::ExpandableHeading ## Bulk Add Rows (advanced) Appends multiple rows to the bottom of the table. | **Field** | **Description** | | ---------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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 to which you want to add rows. | | **Column range** | Select the column range that you want to work with. | | **Rows** | Add rows and values. | | **Unformatted** | Select or map whether the rows should be formatted or not based on the spreadsheet's existing formatting. | | **Value input option** | Select** User entered **if you want the values to be parsed as if typed into the Google Sheets 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 in Google Sheets.
Select **Raw **if you want the values to be stored exactly as provided, without any parsing or conversion. | | **Insert data option** | Select **Insert rows** if the new data should create new rows. Select **Overwrite **if the new data should replace existing cells in the range. | ::: :::ExpandableHeading ## Bulk Update Rows (advanced) Updates multiple rows. | **Field** | **Description** | | ---------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Range** | Enter the range that you want to change. Example: A1\:B5 | | **Value input option** | Select** User entered **if you want the values to be parsed as if typed into the Google Sheets 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 in Google Sheets.
Select **Raw **if you want the values to be stored exactly as provided, without any parsing or conversion. | ::: :::ExpandableHeading ## Search Rows Returns results matching the given criteria. | **Field** | **Description** | | ----------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **Search Method** | Select an option to choose the spreadsheet in which you want to search rows.
- Select from My Drive
- Select from all | | **Spreadsheet ID**
for Select from all Search method) | Enter the Spreadsheet ID in which 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. | | **Spreadsheet** **Name **(for Select from My Drive Search method) | Select the spreadsheet in which you want to search rows. | | **Sheet Name** | Enter a sheet name in which you want to search rows. | | **Table contains headers** | Select whether the spreadsheet contains the header row.
If set to **Yes**, the module doesn't retrieve the header row as output data, and variables in the output are then called by the headers.
If set to **No** option, the module retrieves the first table row, and the output variables are called simply A, B, C, D, etc. | | **Column range** | Select the column range you want to work with. | | **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** | If **Table contains headers** is enabled, select or map the field type to search the rows that match the specified type:
- Date
- Number
- String | | **Value render option** | Defines how cell values are returned in the output.
**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** | Specifies whether dates are shown as formatted text or numeric serials.
**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 output as strings in their given number format (which is dependent on the spreadsheet's locale). | | **Limit** | The maximum number of results Make should return during one scenario execution cycle. | ::: :::ExpandableHeading ## Search Rows (advanced) 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](https://apps.make.com/google-sheets#qzpra). | | **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 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 rows you want to search. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to search rows. | | **Sheet Name **(for Select from My Drive Search method) | Select the sheet in which you want to search rows. | | **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 the 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](https://developers.google.com/chart/interactive/docs/querylanguage).
An example: `select * when B contains "example@email.com"` | | **Limit** | The maximum number of results Make should return during one scenario execution cycle. | ::: :::ExpandableHeading ## Clear a Row Clears values from a specific row. | **Field** | **Description** | | ------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to clear a row. | | **Sheet Name** | Select the sheet in which you want to clear a row. | | **Row number** | Enter the number of the row you want to clear, e.g. `23`. | ::: :::ExpandableHeading ## Delete a Row Deletes a specific row. | **Field** | **Description** | | ------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **Search Method** | Select an option to choose the spreadsheet in which you want to delete a row.
- 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. | | **Spreadsheet Name**
(for Search by path Search method) | eleteSelect the spreadsheet in which you want to d a row. | | **Sheet Name** | Select the sheet in which you want to delete a row. | | **Row number** | Enter the number of the row you want to delete, e.g. `23`. | ::: # Cells ::::ExpandableHeading ## Watch Changes 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. :::hint{type="success"} To use this module, follow the steps in the [Set up a Google Sheets webhook](docId\:Bfky9RO9lWvqnMVDj1TCL) section. ::: :::: :::ExpandableHeading ## Update a Cell Updates a specific cell. | **Field** | **Description** | | ------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to update a cell. | | **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** | Select** User entered **if you want the values to be parsed as if typed into the Google Sheets 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 in Google Sheets.
Select **Raw **if you want the values to be stored exactly as provided, without any parsing or conversion. | ::: :::ExpandableHeading ## Get a Cell Gets a specific cell. | **Field** | **Description** | | ------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to get a cell. | | **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`. | | **Value render option** | Defines how cell values are returned in the output.
**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** | Specifies whether dates are shown as formatted text or numeric serials.
**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 output as strings in their given number format (which is dependent on the spreadsheet's locale). | ::: :::ExpandableHeading ## Clear a Cell Clears a specific cell. | **Field** | **Description** | | ------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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 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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to clear a cell. | | **Sheet Name ** | Select the sheet in which you want to clear a cell. | | **Sheet ID** | Select or map the Sheet ID that contains the cell you want to clear data from. | | **Cell** | Enter the ID of the cell you want to get, e.g., `A5`. | ::: # Sheets ::::ExpandableHeading ## 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. :::hint{type="success"} To use this module, follow the steps in the [Set up a Google Sheets webhook](docId\:Bfky9RO9lWvqnMVDj1TCL) section. ::: :::: :::ExpandableHeading ## Perform a Function - Responder Returns processed data as a result of the `MAKE_FUNCTION` or `INTEGROMAT` function. This module should 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. | ::: :::ExpandableHeading ## Add a Sheet Adds a new sheet. | **Field** | **Description** | | ------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to add a sheet. | | **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). | ::: :::ExpandableHeading ## Create a Spreadsheet Creates a new spreadsheet. | **Field** | **Description** | | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **Spreadsheet name** | Enter the name of a new spreadsheet. | | **Locale** | The locale of the spreadsheet in one of the following formats:
- an ISO [639-1](https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes) language code such as `en`,
- an [ISO 639-2](https://en.wikipedia.org/wiki/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. | | **Default format > 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. | ::: :::ExpandableHeading ## Create a Spreadsheet from a Template Creates a new spreadsheet from a template sheet. | **Field** | **Description** | | ---------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Values** (for Enter manually search method) | Add:
- Sheet ID
- Tags
- Replaced values | | **Spreadsheet name** | 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. | ::: :::ExpandableHeading ## Copy a Sheet Copies a sheet to another spreadsheet. | **Field** | **Description** | | ------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Source Spreadsheet Name **(for Search by path search method) | Select the spreadsheet you want to copy. | | **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. | | **Destination Spreadsheet Name ** (for Search by path search method) | Select the Spreadsheet name where you want to add a copy of a sheet. | | **New Sheet Name **(for Search by path search method) | Enter a name for a new sheet. It must be unique within the destination spreadsheet. If left empty, the new sheet name will be "Copy of \". | ::: :::ExpandableHeading ## Add a Conditional Format Rule 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](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to create the conditional format rule. | | **Sheet Name **(for Search by path Search method) | Select the sheet in 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](https://developers.google.com/apps-script/reference/spreadsheet/conditional-format-rule-builder). | | **Cell Format** | Select or map the cell background color. | | **Text Format** | Set the text format, such as foreground color, bold, italic, or strikethrough. | ::: :::ExpandableHeading ## Rename a Sheet Renames a specific sheet. | **Field** | **Description** | | ------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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 the 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 ID of the sheet you want to rename. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet in which you want to rename a sheet. | | **Sheet Name **(for Search by path Search method) | Select the sheet you want to rename. | | **New Sheet Name** | Enter a new name for a sheet. | ::: :::ExpandableHeading ## Get Range Values Returns a sheet's content defined by range values. | **Field** | **Description** | | ------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet where you want to retrieve range values. | | **Sheet Name** | Select the sheet you want to get the range values 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). | ::: :::ExpandableHeading ## List Sheets Gets a list of all sheets in a spreadsheet. | **Field** | **Description** | | ------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet you want to retrieve sheets from. | ::: :::ExpandableHeading ## Delete a Sheet Deletes a specific sheet. | **Field** | **Description** | | ------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **Search Method** | Select an option to choose the spreadsheet where you want to delete the sheet.
- Search by path
- Select from all
- Enter manually | | **Spreadsheet ID** | Select or map the Spreadsheet ID from which you want to delete a sheet. | | **Sheet ID** | Select or map the Sheet ID you want to delete. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet from which you want to delete the sheet. | | **Sheet Name **(for Search by path Search method) | Select the sheet you want to delete. | ::: :::ExpandableHeading ## Clear Values from a Range Clears a specified range of values from a spreadsheet. | **Field** | **Description** | | ------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet from which you want to clear the values. | | **Sheet Name** | Select the sheet from which you want to clear the values. | | **Range** | Enter the range you want to clear. For example, **A1\:D25**. | ::: :::ExpandableHeading ## Delete a Conditional Format Rule 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](https://apps.make.com/google-sheets#qzpra). | | **Search Method** | Select an option to choose the spreadsheet and sheet name from which you want to delete a conditional format rule.
- Search by path
- Select from all
- Enter manually | | **Spreadsheet ID** | Enter the Spreadsheet ID from which you want to delete a 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 whose conditional format rule you want to delete. | | **Spreadsheet Name**
(for Search by path Search method) | Select the spreadsheet from which you want to delete a conditional format rule. | | **Sheet Name **(for Search by path Search method) | Select the sheet from which you want to delete a conditional format rule. | | **Index** | The zero-based index of the rule to be deleted | ::: # Other :::ExpandableHeading ## Make an API Call Performs an arbitrary authorized API call. | **Field** | **Description** | | ---------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | **Connection** | [Create a connection to your Google Sheets account](https://apps.make.com/google-sheets#qzpra). | | **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. | :::