Skip to content

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

NameLabelTypeControl TypeDescriptionRequired
clientIdClient IdSTRINGTEXTtrue
clientSecretClient SecretSTRINGTEXTtrue

Actions

Clear Sheet

Name: clearSheet

Clear a sheet of all values while preserving formats.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetIdSheet IDINTEGERSELECTThe ID of the sheet.true
isTheFirstRowHeaderIs the First Row Headers?BOOLEANSELECTIf the first row is header.true

Create Column

Name: createColumn

Append a new column to the end of the sheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetNameSheet NameSTRINGSELECTThe name of the sheet.true
columnNameColumn NameSTRINGTEXTName of the new column.true

Output

Type: OBJECT

Properties

NameTypeControl Type
spreadsheetIdSTRINGTEXT
sheetNameSTRINGTEXT
headers[STRING]ARRAY_BUILDER

Create Sheet

Name: createSheet

Create a blank sheet with title. Optionally, provide headers.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetNameSheet NameSTRINGTEXTThe name of the new sheet.true
headersHeaders[STRING]ARRAY_BUILDERThe headers of the new sheet.false

Output

Type: OBJECT

Properties

NameTypeControl Type
spreadsheetIdSTRINGTEXT
sheetNameSTRINGTEXT
headers[STRING]ARRAY_BUILDER

Delete Column

Name: deleteColumn

Delete column on an existing sheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetIdSheet IDINTEGERSELECTThe ID of the sheet.true
labelColumn LabelSTRINGTEXTThe label of the column to be deleted.true

Create Spreadsheet

Name: createSpreadsheet

Create a new spreadsheet in a specified folder.

Properties

NameLabelTypeControl TypeDescriptionRequired
titleTitleSTRINGTEXTTitle of the new spreadsheet to be created.true
folderIdFolder IDSTRINGSELECTID 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

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetIdSheet IDINTEGERSELECTThe ID of the sheet.true
rowNumberRow NumberINTEGERINTEGERThe row number to delete.true

Delete Sheet

Name: deleteSheet

Delete a specified sheet from a spreadsheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetIdSheet IDINTEGERSELECTThe ID of the sheet.true

Find Row by Number

Name: findRowByNum

Get a row in a Google Sheet by row number.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetNameSheet NameSTRINGSELECTThe name of the sheet.true
isTheFirstRowHeaderIs the First Row Headers?BOOLEANSELECTIf the first row is header.true
rowNumberRow NumberINTEGERINTEGERThe row number to get from the sheet.true

Insert Multiple Rows

Name: insertMultipleRows

Append rows to the end of the spreadsheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetNameSheet NameSTRINGSELECTThe name of the sheet.true
valueInputOptionValue Input OptionSTRINGSELECTHow the input data should be interpreted.true
isTheFirstRowHeaderIs the First Row Headers?BOOLEANSELECTIf the first row is header.true
rowsDYNAMIC_PROPERTIESnull

Insert Row

Name: insertRow

Append a row of values to an existing sheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetNameSheet NameSTRINGSELECTThe name of the sheet.true
valueInputOptionValue Input OptionSTRINGSELECTHow the input data should be interpreted.true
isTheFirstRowHeaderIs the First Row Headers?BOOLEANSELECTIf the first row is header.true
rowDYNAMIC_PROPERTIESnull

List Sheets

Name: listSheets

Get all sheets from the spreadsheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true

Output

Type: OBJECT

Properties

NameTypeControl Type
spreadsheetIdSTRINGTEXT
sheetIdINTEGERINTEGER
sheetNameSTRINGTEXT

Update Row

Name: updateRow

Overwrite values in an existing row.

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheet IDSTRINGSELECTThe ID of the spreadsheet to apply the updates to.true
sheetNameSheet NameSTRINGSELECTThe name of the sheet.true
rowNumberRow NumberINTEGERINTEGERThe row number to update.true
isTheFirstRowHeaderIs the First Row Headers?BOOLEANSELECTIf the first row is header.true
updateWholeRowUpdate Whole RowBOOLEANSELECTWhether to update the whole row or just specific columns.true
rowDYNAMIC_PROPERTIESnull

Triggers

New Row

Triggers when a new row is added.

Type: DYNAMIC_WEBHOOK

Properties

NameLabelTypeControl TypeDescriptionRequired
spreadsheetIdSpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.true
isTheFirstRowHeaderIs the First Row Headers?BOOLEANSELECTIf the first row is header.true
sheetNameSheetSTRINGSELECTThe name of the sheettrue


Additional instructions


anl-c-google-sheet-md

CONNECTION

Setting up OAuth2

Turning on Sheets API