What is IFTTT?
Explore Plans Developers
Mobile menu Close menu
Google SheetsGoogle Sheets

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
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.
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
Will create a new spreadsheet if one with this title doesn’t exist
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
Use “|||” to separate cells
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
Format: some/folder/path (defaults to “IFTTT”)
Slug
path
Required
false
Can have default value
true
Filter code method
GoogleSheets.appendToGoogleSpreadsheet.setPath(string: path)