When the Octopus Agile price passes a set price, add a row to your Google Sheet. The default is set to trigger whenever the price is below 50pence so will log every price. Adjust your preferred price, whether to track above/below and even set preferred after/before times.
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.
Explore more great ways to automate Google Sheets and Agile Octopus