Back

Add multiple rows to spreadsheet

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.

Developer info

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

Action fields

Filename Text input > Document title

Label: Spreadsheet name
Helper text: A new spreadsheet will be created if one doesn't exist.
Slug: filename
Required: true
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setFilename(string: filename)

Row 1 Text input > Title

Label: Row 1
Helper text: Use "|||" to separate cells
Slug: row_1
Required: true
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setRow1(string: row_1)

Row 2 Text input > Title

Label: Row 2
Helper text: Use "|||" to separate cells (leave blank to skip)
Slug: row_2
Required: false
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setRow2(string: row_2)

Row 3 Text input > Title

Label: Row 3
Helper text: Use "|||" to separate cells (leave blank to skip)
Slug: row_3
Required: false
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setRow3(string: row_3)

Row 4 Text input > Title

Label: Row 4
Helper text: Use "|||" to separate cells (leave blank to skip)
Slug: row_4
Required: false
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setRow4(string: row_4)

Row 5 Text input > Title

Label: Row 5
Helper text: Use "|||" to separate cells (leave blank to skip)
Slug: row_5
Required: false
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setRow5(string: row_5)

Path Text input > Path to a folder

Label: Drive folder path
Helper text: Use '/' to separate folders, e.g., 'Documents/Photos/Receipts'. Detailed guide <a href="https://ift.tt/drivefolderpath" target="_blank">here</a>
Slug: path
Required: false
Can have default value: true
Filter code method: GoogleSheets.addMultipleRowsToSpreadsheet.setPath(string: path)