By setting the threshold target price to 36 pence this Applet will populate a row in a Google Sheet titled Octopus_Agile in the folder octopus_agile every time the price changes. The data populated can be constrained to before and after times - e.g. if you just wish to track morning prices. The rows in the Google sheet will have date/time, price, time the Applet was triggered, price used to trigger and the optional before/after time setting.
If
Energy price change
Use this trigger to fire something when your electricity price falls or rises past your set threshold and between your preferred time settings.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
ID sZeuwmYW
Discover more time saving integrations for Agile Octopus and Google Sheets