Recent
Recommendations
Webhooks
Service
X (Twitter)
Service
YouTube
Service
Discord
Service
Google Sheets
Service
MyQ
Service
Gmail
Service
Instagram
Service
See all results
Explore
Plans
Log in
Get started
Mobile menu
Close menu
Back
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)
Applets using this Action
Send data from MESH to Google SpreadSheet
by
MESH
515