About this trigger
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 trigger fires when a particular cell is updated within the spreadsheet you specify.
- API endpoint slug
- google_sheets.cell_updated_in_spreadsheet
Trigger fields
Path Text input > Other
- Label
- Enter the folder path...
- Helper text
- Format: folders separated by "/" like "Recipes/Vegetables"
- Slug
- path
- Required
- true
- Can have default value
- true
Filename Text input > Other
- Label
- and enter the filename
- Helper text
- E.g. Vegetable Recipes
- Slug
- filename
- Required
- true
- Can have default value
- true
Spreadsheet URL Text input > Other
- Label
- Or copy and paste the spreadsheet URL
- Helper text
- Must be a valid spreadsheet URL
- Slug
- spreadsheet_url
- Required
- true
- Can have default value
- true
Cell Text input > Other
- Label
- Which cell to monitor?
- Helper text
- E.g. "A17" (must be a valid single cell)
- Slug
- cell
- Required
- true
- Can have default value
- true
Ingredients
ValueThe new value of the cell.
- Slug
- value
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.Value
- Type
- String
- Example
- Red
PathPath of the Spreadsheet
- Slug
- path
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.Path
- Type
- String
- Example
- /IFTTT/FoodTracking
Spreadsheet nameName of the spreadsheet.
- Slug
- spreadsheet_name
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.SpreadsheetName
- Type
- String
- Example
- Vegetables
Spreadsheet URLThe URL to the spreadsheet.
- Slug
- spreadsheet_url
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.SpreadsheetUrl
- Type
- Web URL
- Example
- https://docs.google.com/spreadsheets/d/1cHROp05l1AvtsvKmfKhiyIl09FoxeZR2GGFtzI9fYcc/edit?usp=sharing
Updated atDate and time event the cell was updated.
- Slug
- updated_at
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.UpdatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00