Populate my Google Sheet every time Octopus Agile price changes

28
Connect

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

Agile Octopus icon
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

Google Sheets icon
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.

Fewer details

Discover more time saving integrations for Google Sheets and Agile Octopus