This applet populates your Google Sheet with the Agile prices for the next day. Agile prices are published between 4.00pm and 5.00pm for the period 11.00pm to 11.00pm ahead.
If
Energy prices published
Use this trigger to fire something when your electricity prices for the day ahead are published.
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 DFxPSfDu
Explore more great ways to automate Google Sheets and Agile Octopus