Update cell in spreadsheet

This action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.

Developer info

API endpoint slug: google_sheets.update_cell_in_spreadsheet
Filter code 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: Format: some/folder/path (defaults to “IFTTT”)
Slug: path
Required: false
Can have default value: true
Filter code 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.
Slug: filename
Required: true
Can have default value: true
Filter code method: GoogleSheets.updateCellInSpreadsheet.setFilename(string: filename)

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 code 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 code method: GoogleSheets.updateCellInSpreadsheet.setValue(string: value)