Back

Update multiple rows in spreadsheet

This action will overwrite values in up to 5 consecutive rows starting at the row you specify in the first worksheet of a spreadsheet.

Developer info

API endpoint slug: google_sheets.update_multiple_rows_in_spreadsheet
Filter code method: GoogleSheets.updateMultipleRowsInSpreadsheet.skip(string?: reason)
Runtime method: runAction("google_sheets.update_multiple_rows_in_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.updateMultipleRowsInSpreadsheet.setFilename(string: filename)

Start row index Text input > Other

Label: Starting row
Helper text: Row number to start updating from (e.g. 2 for the first data row after a header)
Slug: start_row_index
Required: true
Can have default value: true
Filter code method: GoogleSheets.updateMultipleRowsInSpreadsheet.setStartRowIndex(string: start_row_index)

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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.setPath(string: path)