Add row to spreadsheet

This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

About this action

Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.

Developer info

Description
API endpoint slug: google_sheets.append_to_google_spreadsheet
Filter code method: GoogleSheets.appendToGoogleSpreadsheet.skip(string?: reason)
Runtime method: runAction("google_sheets.append_to_google_spreadsheet", {})

Action fields

Filename Text input > Document title

Label: Spreadsheet name
Helper text
Slug: filename
Required: true
Can have default value: true
Filter code method: GoogleSheets.appendToGoogleSpreadsheet.setFilename(string: filename)

Formatted row Text input

Label: Formatted row
Helper text
Slug: formatted_row
Required: true
Can have default value: true
Filter code method: GoogleSheets.appendToGoogleSpreadsheet.setFormattedRow(string: formattedRow)

Path Text input > Path to a folder

Label: Drive folder path
Helper text
Slug: path
Required: false
Can have default value: true
Filter code method: GoogleSheets.appendToGoogleSpreadsheet.setPath(string: path)