Google Sheets modules
After connecting to the Google Sheets app, you can use the following modules to build your scenarios.
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 | |
Search Method | Select a method to choose the spreadsheet whose rows you want to watch.
|
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. |
Adds a new row at the bottom of the table.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet in which you want to add a row.
|
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. |
Updates a row.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet in which you want to update a row.
|
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. |
Appends multiple rows to the bottom of the table.
Field | Description |
|---|---|
Connection | |
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. |
Updates multiple rows.
Field | Description |
|---|---|
Connection | |
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. |
Returns results matching the given criteria.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet in which you want to search rows.
|
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:
|
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. |
Returns results matching the given criteria. This module doesn't return a row number.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet in which you want to search rows.
|
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. An example: select * when B contains "[email protected]" |
Limit | The maximum number of results Make should return during one scenario execution cycle. |
Clears values from a specific row.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet in which you want to clear a row.
|
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. |
Deletes a specific row.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet in which you want to delete a row.
|
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
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.
To use this module, follow the steps in the Set up a Google Sheets webhook section.
Updates a specific cell.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet and sheet whose value you want to update.
|
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. |
Gets a specific cell.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet and sheet whose value you want to get.
|
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). |
Clears a specific cell.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet and sheet whose value you want to clear.
|
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
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.
To use this module, follow the steps in the Set up a Google Sheets webhook section.
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. |
Adds a new sheet.
Field | Description |
|---|---|
Connection | |
Search method | Select an option to choose the spreadsheet in which you want to create a sheet.
|
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 |
|
Creates a new spreadsheet.
Field | Description |
|---|---|
Connection | |
Spreadsheet name | Enter the name of a new spreadsheet. |
Locale | |
Recalculation interval | The amount of time to wait before volatile functions are recalculated:
|
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. |
Creates a new spreadsheet from a template sheet.
Field | Description |
|---|---|
Connection | |
Search Method | Select or map the Template Spreadsheet ID from which you want to create the spreadsheet.
|
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:
|
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. |
Copies a sheet to another spreadsheet.
Field | Description |
|---|---|
Connection | |
Search Method | Select or map the option to choose the spreadsheet that you want to copy.
|
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 <source sheet name>". |
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Field | Description |
|---|---|
Connection | |
Search Method | Enter the Spreadsheet ID to which you want to create the conditional format rule.
|
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. |
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 | |
Search Method | Select an option to choose the spreadsheet in which you want to create a sheet.
|
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. |
Returns a sheet's content defined by range values.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet whose range value you want to get.
|
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). |
Gets a list of all sheets in a spreadsheet.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet whose range value you want to get.
|
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. |
Deletes a specific sheet.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet where you want to delete the sheet.
|
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. |
Clears a specified range of values from a spreadsheet.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet and sheet name whose value you want to clear.
|
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. |
Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
Field | Description |
|---|---|
Connection | |
Search Method | Select an option to choose the spreadsheet and sheet name from which you want to delete a conditional format rule.
|
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
Performs an arbitrary authorized API call.
Field | Description |
|---|---|
Connection | |
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. |