About this action
Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.
Developer info
- Description
- 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.
- 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)