Populate my Google Sheet when Octopus Agile prices are published
Start today
Other popular Agile Octopus workflows and automations
-
151 - Email me when Octopus Agile electricity consumption for the week is high 18
- When energy prices fall, change set temperature of Nethome Plus AC
- If Octopus Agile electricity price is low increase my Honeywell thermostat
- Update my Google Sheet with Octopus Agile price with pre-populated fields
- When energy prices fall, change set temperature of Midea AC.
- Control my Ecobee using Octopus Agile rates
- When carbon intensity of electricity exceeds the intensity limit set a variable to false in Apilio
- When energy prices fall, change set temperature of Midea AC.
Useful Agile Octopus and ThermoSmart 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.
Temperature rises aboveThis Trigger fires every time the temperature rises above a threshold you specify.- 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.
- Temperature drops belowThis Trigger fires every time the temperature drops below a threshold you specify.
- 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.
- ThermoSmart gets pausedThis Trigger fires every time the ThermoSmart is paused.
- 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.
- ThermoSmart gets unpausedThis Trigger fires every time the ThermoSmart gets unpaused.
- Energy consumptionUse this trigger to fire something when you have consumed a set amount of electricity (measured in kWh) in a period.
- ThermoSmart changes programThis Trigger fires every time the ThermoSmart changes a scheduled program.
- Energy exportUse this trigger to fire something when you have exported a set amount of electricity (measured in kWh) in a period.
- Carbon intensity lowestUse this Trigger to do something when the carbon intensity is at its lowest and between your preferred time settings.
- Carbon intensity highestUse this Trigger to do something when the carbon intensity is at its highest and between your preferred time settings.
- Carbon intensity changeUse this trigger to fire something when carbon intensity falls or rises past your set threshold and between your preferred time settings.
- 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.
- Energy prices publishedUse this trigger to fire something when your electricity prices for the day ahead are published.
- 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.
- Energy half hour price publishedUse this trigger to fire something when electricity price for each half hour period for the day ahead is published.
- 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 published Energy pricesThis query returns a list of daily published energy prices/
- History of temperature rises above thresholdThis query returns a list of when the temperature rises above a threshold you specify. Note: this query will only return future events after this Applet is created.
- 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.
IFTTT helps all your apps and devices work better together