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.
Use this trigger to fire something when your electricity prices for the day ahead are published.
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