Explore Plans
Google 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.

Developer info

API endpoint slug
google_sheets.append_to_google_spreadsheet
Filter 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
A new spreadsheet will be created if one doesn't exist, unless you name a worksheet. Leave blank if you paste a URL
Slug
filename
Required
false
Can have default value
true
Filter 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 method
GoogleSheets.appendToGoogleSpreadsheet.setFormattedRow(string: formatted_row)

Path Text input > Path to a folder

Label
Drive folder path
Helper text
Use '/' to separate folders, e.g., 'Documents/Photos/Receipts'. Detailed guide here
Slug
path
Required
false
Can have default value
true
Filter method
GoogleSheets.appendToGoogleSpreadsheet.setPath(string: path)

Spreadsheet url Text input > Other

Label
Or copy and paste the spreadsheet URL
Helper text
Used instead of the folder path and name when set. The spreadsheet must already exist. A URL with #gid= writes to that tab
Slug
spreadsheet_url
Required
false
Can have default value
true
Filter method
GoogleSheets.appendToGoogleSpreadsheet.setSpreadsheetUrl(string: spreadsheet_url)

Worksheet Text input > Other

Label
Worksheet name
Helper text
Leave blank for the first worksheet, or the tab in a pasted URL. When set, the spreadsheet must already exist
Slug
worksheet
Required
false
Can have default value
true
Filter method
GoogleSheets.appendToGoogleSpreadsheet.setWorksheet(string: worksheet)