Match Philips Hue light color to updated Google Sheets cell
by
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Developer info
- API endpoint slug
- google_sheets.cell_updated_in_spreadsheet
Trigger fields
Path Text input > Other
- Label
- Enter the folder path...
- Helper text
- Use '/' to separate folders, e.g., 'Documents/Photos/Receipts'. Detailed guide here
- 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
Worksheet Text input > Other
- Label
- Which worksheet
- Helper text
- Leave blank to use the spreadsheet's default sheet, or enter the worksheet (tab) name exactly as it appears at the bottom of the Google Sheet (e.g. "Invoices").
- Slug
- worksheet
- Required
- true
- Can have default value
- true
Cell Text input > Other
- Label
- Which cell to monitor?
- Helper text
- E.g. "A17", "Sheet2!B12" or "'Adrian''s List'!C42" (must be a valid single cell)
- Slug
- cell
- Required
- true
- Can have default value
- true
Ingredients
Value The new value of the cell.
- Slug
- value
- Filter
- GoogleSheets.cellUpdatedInSpreadsheet.Value
- Type
- String
- Example
- Red
Path Path of the Spreadsheet
- Slug
- path
- Filter
- GoogleSheets.cellUpdatedInSpreadsheet.Path
- Type
- String
- Example
- /IFTTT/FoodTracking
Worksheet name The worksheet (tab) the monitored cell lives on.
- Slug
- worksheet_name
- Filter
- GoogleSheets.cellUpdatedInSpreadsheet.WorksheetName
- Type
- String
- Example
- Invoices
Spreadsheet name Name of the spreadsheet.
- Slug
- spreadsheet_name
- Filter
- GoogleSheets.cellUpdatedInSpreadsheet.SpreadsheetName
- Type
- String
- Example
- Vegetables
Spreadsheet url The URL to the spreadsheet.
- Slug
- spreadsheet_url
- Filter
- GoogleSheets.cellUpdatedInSpreadsheet.SpreadsheetUrl
- Type
- Web URL
- Example
- https://docs.google.com/spreadsheets/d/1cHROp05l1AvtsvKmfKhiyIl09FoxeZR2GGFtzI9fYcc/edit?usp=sharing
Updated at Date and time event the cell was updated.
- Slug
- updated_at
- Filter
- GoogleSheets.cellUpdatedInSpreadsheet.UpdatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
