This action will add up to 5 rows 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.add_multiple_rows_to_spreadsheet
Filter method
GoogleSheets.addMultipleRowsToSpreadsheet.skip(string?: reason)
Runtime method
runAction("google_sheets.add_multiple_rows_to_spreadsheet", {})
Action fields
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.addMultipleRowsToSpreadsheet.setFilename(string: filename)
Label
Row 1
Helper text
Use "|||" to separate cells
Slug
row_1
Required
true
Can have default value
true
Filter method
GoogleSheets.addMultipleRowsToSpreadsheet.setRow1(string: row_1)
Label
Row 2
Helper text
Use "|||" to separate cells (leave blank to skip)
Slug
row_2
Required
false
Can have default value
true
Filter method
GoogleSheets.addMultipleRowsToSpreadsheet.setRow2(string: row_2)
Label
Row 3
Helper text
Use "|||" to separate cells (leave blank to skip)
Slug
row_3
Required
false
Can have default value
true
Filter method
GoogleSheets.addMultipleRowsToSpreadsheet.setRow3(string: row_3)
Label
Row 4
Helper text
Use "|||" to separate cells (leave blank to skip)
Slug
row_4
Required
false
Can have default value
true
Filter method
GoogleSheets.addMultipleRowsToSpreadsheet.setRow4(string: row_4)
Label
Row 5
Helper text
Use "|||" to separate cells (leave blank to skip)
Slug
row_5
Required
false
Can have default value
true
Filter method
GoogleSheets.addMultipleRowsToSpreadsheet.setRow5(string: row_5)
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.addMultipleRowsToSpreadsheet.setPath(string: path)
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.addMultipleRowsToSpreadsheet.setSpreadsheetUrl(string: spreadsheet_url)
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.addMultipleRowsToSpreadsheet.setWorksheet(string: worksheet)