A beginner's guide
Explore
Plans
Mobile menu Close menu
Agile Octopus Energy prices published. Google Sheets Add row to spreadsheet.

Populate my Google Sheet when Octopus Agile prices are published

by Agile Octopus
110
Connect

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

Agile Octopus icon
Energy prices published

Use this trigger to fire something when your electricity prices for the day ahead are published.

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
More details