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
- Label
- Enter the folder path...
- Helper text
- Format: folders separated by "/" like "Recipes/Vegetables"
- Slug
- path
- Required
- true
- Can have default value
- true
- Label
- and enter the filename
- Helper text
- E.g. Vegetable Recipes
- Slug
- filename
- Required
- true
- Can have default value
- true
- 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
- 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
- Slug
- value
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.Value
- Type
- String
- Example
- Red
- Slug
- path
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.Path
- Type
- String
- Example
- /IFTTT/FoodTracking
- Slug
- spreadsheet_name
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.SpreadsheetName
- Type
- String
- Example
- Vegetables
- Slug
- spreadsheet_url
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.SpreadsheetUrl
- Type
- Web URL
- Example
- https://docs.google.com/spreadsheets/d/1cHROp05l1AvtsvKmfKhiyIl09FoxeZR2GGFtzI9fYcc/edit?usp=sharing
- Slug
- updated_at
- Filter code
- GoogleSheets.cellUpdatedInSpreadsheet.UpdatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00