This action will overwrite values in up to 5 consecutive rows, starting at the row you specify, on a spreadsheet's first worksheet unless you name another. A missing spreadsheet is created only when you give a name and no URL or worksheet.

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

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.updateMultipleRowsInSpreadsheet.setFilename(string: filename)

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 method: GoogleSheets.updateMultipleRowsInSpreadsheet.setStartRowIndex(string: start_row_index)

Label: Row 1
Helper text: Use "|||" to separate cells
Slug: row_1
Required: true
Can have default value: true
Filter method: GoogleSheets.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.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.updateMultipleRowsInSpreadsheet.setWorksheet(string: worksheet)

Update multiple rows in spreadsheet