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

Setting up OAuth2

Turning on Sheets API