Update cell in spreadsheet

This action will update a single cell in 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.

Developer info

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

Action fields

Path Text input > Path to a folder

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

Filename Text input > File name

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

Spreadsheet url Text input > Other

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.updateCellInSpreadsheet.setSpreadsheetUrl(string: spreadsheet_url)

Worksheet Text input > Other

Label: Worksheet name
Helper text: Leave blank for the first worksheet, or the tab in a pasted URL. A sheet named in the cell, like Sheet2!B5, wins. When set, the spreadsheet must already exist
Slug: worksheet
Required: false
Can have default value: true
Filter method: GoogleSheets.updateCellInSpreadsheet.setWorksheet(string: worksheet)

Cell Text input > Other

Label: Which cell?
Helper text: Use A1 notation for a single cell e.g. A2 or B10
Slug: cell
Required: true
Can have default value: true
Filter method: GoogleSheets.updateCellInSpreadsheet.setCell(string: cell)

Value Text input

Label: Value
Helper text: Value to be filled in the cell
Slug: value
Required: true
Can have default value: true
Filter method: GoogleSheets.updateCellInSpreadsheet.setValue(string: value)