Back

Update row in spreadsheet

This action will overwrite all values in a specific row of the first worksheet of a spreadsheet you specify.

Developer info

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

Row index Text input > Other

Label: Which row?
Helper text: Row number (e.g. 2 for the first data row after a header)
Slug: row_index
Required: true
Can have default value: true
Filter code method: GoogleSheets.updateRowInSpreadsheet.setRowIndex(string: row_index)

Formatted row Text input > Title

Label: Formatted row
Helper text: Use "|||" to separate cells
Slug: formatted_row
Required: true
Can have default value: true
Filter code method: GoogleSheets.updateRowInSpreadsheet.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 <a href="https://ift.tt/drivefolderpath" target="_blank">here</a>
Slug: path
Required: false
Can have default value: true
Filter code method: GoogleSheets.updateRowInSpreadsheet.setPath(string: path)