This action will overwrite all values in a specific row of a spreadsheet you specify, on the 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_row_in_spreadsheet
Filter method
GoogleSheets.updateRowInSpreadsheet.skip(string?: reason)
Runtime method
runAction("google_sheets.update_row_in_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.updateRowInSpreadsheet.setFilename(string: filename)
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 method
GoogleSheets.updateRowInSpreadsheet.setRowIndex(string: row_index)
Label
Formatted row
Helper text
Use "|||" to separate cells
Slug
formatted_row
Required
true
Can have default value
true
Filter method
GoogleSheets.updateRowInSpreadsheet.setFormattedRow(string: formatted_row)
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.updateRowInSpreadsheet.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.updateRowInSpreadsheet.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.updateRowInSpreadsheet.setWorksheet(string: worksheet)
