Populate my Google Sheet every time Octopus Agile price changes
Start today
Other popular Agile Octopus workflows and automations
- Populate my Google Sheet when Octopus Agile prices are published
- Octopus Energy Agile Prices Lowest for Duration - Send Email
- If Octopus Agile electricity price is low run my Honeywell hot water between certain times
- If Octopus Agile electricity is below a value turn on my Wemo Smartplug
- Move my Octopus Energy saving to a Monzo Pot
- Agile and Wemo Insight
- Control my Ecobee using Octopus Agile rates
- PLUNGE PRICING ALERT: Octopus Agile electricity just went below zero pence per kWh
Useful Agile Octopus and SmartThings integrations
Triggers (If this)
- Switched onThis Trigger fires every time your SmartThings device is switched on.
- Energy price changeUse this trigger to fire something when your electricity price falls or rises past your set threshold and between your preferred time settings.
- Switched offThis Trigger fires every time your SmartThings device is switched off.
- Energy export price changeUse this trigger to fire something when your electricity export price falls or rises past your set threshold and between your preferred time settings.
- OpenedThis Trigger fires every time your SmartThings device is opened.
- Energy price threshold change for durationUse this trigger to fire something when your electricity price stays above (or below) your set threshold for a minimum length of time in 30-minute blocks.
- ClosedThis Trigger fires every time your SmartThings device is closed.
- Energy price lowest for durationUse this trigger to fire something when your electricity price is at the lowest and for a set duration (such as an hour) and between your preferred time settings.
- LockedThis Trigger fires every time your SmartThings device is locked.
- Energy consumptionUse this trigger to fire something when you have consumed a set amount of electricity (measured in kWh) in a period.
- UnlockedThis Trigger fire every time your SmartThings device is unlocked.
- Energy exportUse this trigger to fire something when you have exported a set amount of electricity (measured in kWh) in a period.
- Any new motionThis Trigger fires every time your SmartThings device senses motion.
- Carbon intensity lowestUse this Trigger to do something when the carbon intensity is at its lowest and between your preferred time settings.
- Presence detectedThis Trigger fires every time your SmartThings device's presence is detected.
- Carbon intensity highestUse this Trigger to do something when the carbon intensity is at its highest and between your preferred time settings.
- Presence no longer detectedThis Trigger fires every time your SmartThings device's presence is no longer detected.
- Carbon intensity changeUse this trigger to fire something when carbon intensity falls or rises past your set threshold and between your preferred time settings.
- Temperature rises aboveThis Trigger fires every time your SmartThings device detects temperatures above a value you specify.
- Carbon intensity threshold change for durationUse this trigger to fire something when carbon intensity stays above (or below) your set threshold for a minimum length of time in 30-minute blocks.
- Temperature drops belowThis Trigger fires every time your SmartThings device detects temperatures below a value you specify.
- Energy prices publishedUse this trigger to fire something when your electricity prices for the day ahead are published.
- Humidity rises aboveThis Trigger fires every time your SmartThings device detects humidity above a value you specify.
- Energy prices published thresholdUse this trigger to fire something when your electricity prices for the day ahead are published and are below your set threshold.
- Humidity drops belowThis Trigger fires every time your SmartThings device detects humidity below a value you specify.
- Energy half hour price publishedUse this trigger to fire something when electricity price for each half hour period for the day ahead is published.
- Moisture detectedThis Trigger fires every time your SmartThings device detects moisture.
- Energy export price highest for durationUse this trigger to fire something when your electricity export price is at the highest and for a set duration (such as an hour) and between your preferred time settings.
- Brightness rises aboveThis Trigger fires every time the your SmartThings device detects brightness above a value you specify.
- Energy export prices publishedUse this trigger to fire something when your electricity export prices for the day ahead are published.
- Brightness drops belowThis Trigger fires every time the your SmartThings device detects brightness below a value you specify.
- Energy export half hour price publishedUse this trigger to fire something when electricity export price for each half hour period for the day ahead is published.
Queries (With)
- History of published Energy pricesThis query returns a list of daily published energy prices/
- History of Energy price threshold alertsThis query returns a list of alerts when your electricity price crossed your set threshold between your preferred time settings. Note: this query will only return future events after this Applet is created.
- History of Energy export price changesUse this query to fire something when your electricity export price fell or rose past your set threshold and between your preferred time settings. Note: this query will only return future events after this Applet is created.
- History of energy exportThis query returns a list of when you have exported a set amount of electricity (measured in kWh) in a period.
- History of energy price lowest for durationThis query returns a list of when energy price was at the lowest and for a set duration (such as an hour) and between your preferred time settings.
- History of energy price threshold change for durationThis query returns a list of when energy price threshold changes for set duration. Note: this query will only return future events after this Applet is created.
- History of energy half hour pricing publishedThis query returns a list of when electricity price for each half hour period for the day was published.
- History of carbon intensity changesThis query returns a list of when carbon intensity fell or rose past your set threshold and between your preferred time settings. Note: this query will only return future events after this Applet is created.
Actions (Then that)
- Switch onThis Action will turn on your SmartThings devices that support switching on.
- Switch offThis Action will turn off your SmartThings devices that support switching off.
- LockThis Action will lock your SmartThings devices that support locking.
- UnlockThis Action will unlock your SmartThings devices that support unlocking.
- Activate siren/strobeThis Action will activate your SmartThings alerting device's siren and/or strobe.
- Deactivate siren/strobeThis Action will deactivate your SmartThings alerting device's siren and/or strobe.
IFTTT helps all your apps and devices work better together