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 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) 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) 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) 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)
Google Sheets