Populate my Google Sheet when Octopus Agile prices are published
Start today
Other popular Agile Octopus workflows and automations
- Email me when Octopus Agile electricity consumption for the week is high
- When energy prices fall, change set speed of Midea Humidifier.
- If Octopus Agile electricity price is high turn my Hue lights red
- When energy prices fall, change set temperature of AC.
- Agile and Wemo Insight
- If Octopus Agile electricity price is high turn off my Smart Life devices
- Move my Octopus Energy saving to a Monzo Pot
- When Octopus Energy prices change set my TP Link Kasa
Useful Agile Octopus and Smart Life integrations
Triggers (If this)
- 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.
- Device or group is turned onThis trigger fires when the specified device/group is turned on.
- 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.
- Device or group is turned offThis trigger fires when the specified device/group is turned off.
- 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.
- Unlock the lockThis trigger fires when user unlocking the lock, his password or fingerprint identification or card is confirmed.
- 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.
- Camera detects motionThis trigger fires when the specified camera detects motion. To use this trigger, camera’s motion detection should be turned on.
- Energy consumptionUse this trigger to fire something when you have consumed a set amount of electricity (measured in kWh) in a period.
- Camera detects soundThis trigger fires when the specified camera detects sound. To use this trigger, camera’s sound detection should be turned on.
- Energy exportUse this trigger to fire something when you have exported a set amount of electricity (measured in kWh) in a period.
- Input incorrect password repetitiouslyThis trigger fires when someone input incorrect password repetitiously.
- Carbon intensity lowestUse this Trigger to do something when the carbon intensity is at its lowest and between your preferred time settings.
- Battery lowThis trigger fires when residual electricity in the lock under threshold.
- Carbon intensity highestUse this Trigger to do something when the carbon intensity is at its highest and between your preferred time settings.
- Door sensor is openThis trigger fires when the door sensor is open.
- Carbon intensity changeUse this trigger to fire something when carbon intensity falls or rises past your set threshold and between your preferred time settings.
- Door sensor is closedThis trigger fires when the door sensor is closed.
- 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.
- Person is detectedThis trigger fires when PIR detects person.
- Energy prices publishedUse this trigger to fire something when your electricity prices for the day ahead are published.
- Leak detectedThis trigger fires when water leak detected.
- 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.
- Sound and light detectedThis trigger fires when water sound and light detected.
- Energy half hour price publishedUse this trigger to fire something when electricity price for each half hour period for the day ahead is published.
- Shake detectedThis trigger fires when sensor shake detected
- 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.
- Energy export prices publishedUse this trigger to fire something when your electricity export prices for the day ahead are published.
- 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 Leak detectedThis query returns a list of times when the sensor detected a water leak.
- History of published Energy pricesThis query returns a list of daily published energy prices/
- History of when Door sensor was closedThis query returns a list of times when the door sensor was closed.
- 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 when Door sensor was openThis query returns a list of times when the door sensor was open.
- 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 when a Person was detectedThis query returns a list of when PIR detected person.
- 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 Device turned offThis query returns a list of times when the specified device/group was turned off.
- 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 Device was turned onThis query returns a list of when the specified device/group was turned on.
- 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 repetitious incorrect password alertsThis query returns a list of times when someone input an incorrect password repetitiously.
- 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 motion detections by CameraThis query returns a list of when a Camera detected motion. To use this query, Camera motion detected should be turned on.
- 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.
- History of Camera detected soundThis query returns a list of times when the specified camera detected sound. To use this query, camera’s sound detection must have been turned on.
- History of Shake detectedThis query returns a list of when sensor detected a shake
- History of when lock unlockedThis query returns a list of when a user unloocked the lock and his password, fingerprint identification, or card was confirmed.
- History of Sound or Light DetectedThis query returns a list of when water sound or light were detected.
- History of low Battery alertsThis query returns a list of when residual electricity in the lock dropped below the threshold. Note: this query will only return future events after this Applet is created.
Actions (Then that)
- Turn onThis action will turn on the device/group of your choosing.
- Turn offThis action will turn off the device/group of your choosing.
- Activate SceneThis action will activate the specified scene.
- Set light brightnessThis action will set your light to a specified brightness.
- Set light colorThis action will set the light to specified color.
- Start Cool ModeThis action will set your AC to Cool Mode.
- Start Heat ModeThis action will set your AC to Heat Mode.
- Set AC temperatureThis action will set your AC to a specified temperature by remote controller.
- Turn on oscillation function of fanThis action will turn on the oscillation function of your fan by IR remote controller.
- Turn off oscillation function of fanThis action will turn off the oscillation function of your fan by IR remote controller.
Agile Octopus and Smart Life resources
IFTTT helps all your apps and devices work better together