Skip to content

Google Sheets

Reference


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]

Version: 1


Connections

Version: 1

OAuth2 Authorization Code

Properties

NameTypeControl TypeDescription
Client IdSTRINGTEXT
Client SecretSTRINGTEXT

Triggers

New Row

Triggers when a new row is added.

Type: DYNAMIC_WEBHOOK

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Is the first row headers?BOOLEANSELECTIf the first row is header
SheetSTRINGSELECTThe name of the sheet

Output

Type: ARRAY

Properties

TypeControl Type
{}OBJECT_BUILDER

Actions

Clear sheet

Clear a sheet of all values while preserving formats.

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetINTEGERSELECTThe name of the sheet
Is the first row headers?BOOLEANSELECTIf the first row is header

Create column

Append a new column to the end of the sheet.

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetSTRINGSELECTThe name of the sheet
Column nameSTRINGTEXTName of the new column.

Output

Type: OBJECT

Properties

TypeControl Type
STRINGTEXT
STRINGTEXT
[BOOLEAN, NUMBER, STRING]ARRAY_BUILDER

Create sheet

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

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Sheet nameSTRINGTEXTThe name of the new sheet.
Headers[BOOLEAN, NUMBER, STRING]ARRAY_BUILDERThe headers of the new sheet.

Output

Type: OBJECT

Delete row

Delete row on an existing sheet

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetINTEGERSELECTThe name of the sheet
Row numberINTEGERINTEGERThe row number to delete

Find row by number

Get a row in a Google Sheet by row number

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetSTRINGSELECTThe name of the sheet
Is the first row headers?BOOLEANSELECTIf the first row is header
Row numberINTEGERINTEGERThe row number to get from the sheet.

Output

Type: OBJECT

Insert multiple rows

Append rows to the end of the spreadsheet.

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetSTRINGSELECTThe name of the sheet
Value input optionSTRINGSELECTHow the input data should be interpreted.
Is the first row headers?BOOLEANSELECTIf the first row is header
DYNAMIC_PROPERTIESnull

Output

Type: ARRAY

Properties

TypeControl Type
{}OBJECT_BUILDER

Insert row

Append a row of values to an existing sheet

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetSTRINGSELECTThe name of the sheet
Value input optionSTRINGSELECTHow the input data should be interpreted.
Is the first row headers?BOOLEANSELECTIf the first row is header
DYNAMIC_PROPERTIESnull

Output

Type: OBJECT

Update row

Overwrite values in an existing row

Properties

NameTypeControl TypeDescription
SpreadsheetSTRINGSELECTThe spreadsheet to apply the updates to.
Include sheets from all drivesBOOLEANSELECTWhether both My Drive and shared drive sheets should be included in results.
SheetSTRINGSELECTThe name of the sheet
Row numberINTEGERINTEGERThe row number to update
Is the first row headers?BOOLEANSELECTIf the first row is header
DYNAMIC_PROPERTIESnull

Output

Type: OBJECT


Additional instructions


anl-c-google-sheet-md

CONNECTION

Setting up OAuth2

Turning on Sheets API