Google Sheets
Google Sheets is a cloud-based spreadsheet software that allows users to create, edit, and collaborate on spreadsheets in real-time.
Categories: productivity-and-collaboration
Type: googleSheets/v1
Connections
Version: 1
OAuth2 Authorization Code
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
clientId | Client Id | STRING | TEXT | true | |
clientSecret | Client Secret | STRING | TEXT | true |
Actions
Clear Sheet
Name: clearSheet
Clear a sheet of all values while preserving formats.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetId | Sheet ID | INTEGER | SELECT | The ID of the sheet. | true |
isTheFirstRowHeader | Is the First Row Headers? | BOOLEAN | SELECT | If the first row is header. | true |
Create Column
Name: createColumn
Append a new column to the end of the sheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetName | Sheet Name | STRING | SELECT | The name of the sheet. | true |
columnName | Column Name | STRING | TEXT | Name of the new column. | true |
Output
Type: OBJECT
Properties
Name | Type | Control Type |
---|---|---|
spreadsheetId | STRING | TEXT |
sheetName | STRING | TEXT |
headers | [STRING] | ARRAY_BUILDER |
Create Sheet
Name: createSheet
Create a blank sheet with title. Optionally, provide headers.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetName | Sheet Name | STRING | TEXT | The name of the new sheet. | true |
headers | Headers | [STRING] | ARRAY_BUILDER | The headers of the new sheet. | false |
Output
Type: OBJECT
Properties
Name | Type | Control Type |
---|---|---|
spreadsheetId | STRING | TEXT |
sheetName | STRING | TEXT |
headers | [STRING] | ARRAY_BUILDER |
Delete Column
Name: deleteColumn
Delete column on an existing sheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetId | Sheet ID | INTEGER | SELECT | The ID of the sheet. | true |
label | Column Label | STRING | TEXT | The label of the column to be deleted. | true |
Create Spreadsheet
Name: createSpreadsheet
Create a new spreadsheet in a specified folder.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
title | Title | STRING | TEXT | Title of the new spreadsheet to be created. | true |
folderId | Folder ID | STRING | SELECT | ID of the folder where the new spreadsheet will be stored. If no folder is selected, the folder will be created in the root folder. | false |
Delete Row
Name: deleteRow
Delete row on an existing sheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetId | Sheet ID | INTEGER | SELECT | The ID of the sheet. | true |
rowNumber | Row Number | INTEGER | INTEGER | The row number to delete. | true |
Delete Sheet
Name: deleteSheet
Delete a specified sheet from a spreadsheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetId | Sheet ID | INTEGER | SELECT | The ID of the sheet. | true |
Find Row by Number
Name: findRowByNum
Get a row in a Google Sheet by row number.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetName | Sheet Name | STRING | SELECT | The name of the sheet. | true |
isTheFirstRowHeader | Is the First Row Headers? | BOOLEAN | SELECT | If the first row is header. | true |
rowNumber | Row Number | INTEGER | INTEGER | The row number to get from the sheet. | true |
Insert Multiple Rows
Name: insertMultipleRows
Append rows to the end of the spreadsheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetName | Sheet Name | STRING | SELECT | The name of the sheet. | true |
valueInputOption | Value Input Option | STRING | SELECT | How the input data should be interpreted. | true |
isTheFirstRowHeader | Is the First Row Headers? | BOOLEAN | SELECT | If the first row is header. | true |
rows | DYNAMIC_PROPERTIES | null |
Insert Row
Name: insertRow
Append a row of values to an existing sheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetName | Sheet Name | STRING | SELECT | The name of the sheet. | true |
valueInputOption | Value Input Option | STRING | SELECT | How the input data should be interpreted. | true |
isTheFirstRowHeader | Is the First Row Headers? | BOOLEAN | SELECT | If the first row is header. | true |
row | DYNAMIC_PROPERTIES | null |
List Sheets
Name: listSheets
Get all sheets from the spreadsheet.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
Output
Type: OBJECT
Properties
Name | Type | Control Type |
---|---|---|
spreadsheetId | STRING | TEXT |
sheetId | INTEGER | INTEGER |
sheetName | STRING | TEXT |
Update Row
Name: updateRow
Overwrite values in an existing row.
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet ID | STRING | SELECT | The ID of the spreadsheet to apply the updates to. | true |
sheetName | Sheet Name | STRING | SELECT | The name of the sheet. | true |
rowNumber | Row Number | INTEGER | INTEGER | The row number to update. | true |
isTheFirstRowHeader | Is the First Row Headers? | BOOLEAN | SELECT | If the first row is header. | true |
updateWholeRow | Update Whole Row | BOOLEAN | SELECT | Whether to update the whole row or just specific columns. | true |
row | DYNAMIC_PROPERTIES | null |
Triggers
New Row
Triggers when a new row is added.
Type: DYNAMIC_WEBHOOK
Properties
Name | Label | Type | Control Type | Description | Required |
---|---|---|---|---|---|
spreadsheetId | Spreadsheet | STRING | SELECT | The spreadsheet to apply the updates to. | true |
isTheFirstRowHeader | Is the First Row Headers? | BOOLEAN | SELECT | If the first row is header. | true |
sheetName | Sheet | STRING | SELECT | The name of the sheet | true |
Additional instructions
CONNECTION
Turning on Sheets API