Populate my Google Sheet when Octopus Agile prices are published
Start today
Popular Agile Octopus and Google Sheets workflows and automations
- Update my Google Sheet with Octopus Agile price with pre-populated fields
- Populate my Google Sheet every time Octopus Agile price changes
- Update my Google Sheet with Octopus Agile price
Useful Agile Octopus and Google Sheets integrations
Triggers (If this)
- Energy price changeUse this trigger to fire something when your electricity price falls or rises past your set threshold and between your preferred time settings.
- New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- Energy export price changeUse this trigger to fire something when your electricity export price falls or rises past your set threshold and between your preferred time settings.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Energy price threshold change for durationUse this trigger to fire something when your electricity price stays above (or below) your set threshold for a minimum length of time in 30-minute blocks.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Energy price lowest for durationUse this trigger to fire something when your electricity price is at the lowest and for a set duration (such as an hour) and between your preferred time settings.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Energy consumptionUse this trigger to fire something when you have consumed a set amount of electricity (measured in kWh) in a period.
- Energy exportUse this trigger to fire something when you have exported a set amount of electricity (measured in kWh) in a period.
- Carbon intensity lowestUse this Trigger to do something when the carbon intensity is at its lowest and between your preferred time settings.
- Carbon intensity highestUse this Trigger to do something when the carbon intensity is at its highest and between your preferred time settings.
- Carbon intensity changeUse this trigger to fire something when carbon intensity falls or rises past your set threshold and between your preferred time settings.
- Carbon intensity threshold change for durationUse this trigger to fire something when carbon intensity stays above (or below) your set threshold for a minimum length of time in 30-minute blocks.
- Energy prices publishedUse this trigger to fire something when your electricity prices for the day ahead are published.
- Energy prices published thresholdUse this trigger to fire something when your electricity prices for the day ahead are published and are below your set threshold.
- Energy half hour price publishedUse this trigger to fire something when electricity price for each half hour period for the day ahead is published.
- Energy export price highest for durationUse this trigger to fire something when your electricity export price is at the highest and for a set duration (such as an hour) and between your preferred time settings.
- Energy export prices publishedUse this trigger to fire something when your electricity export prices for the day ahead are published.
- Energy export half hour price publishedUse this trigger to fire something when electricity export price for each half hour period for the day ahead is published.
Queries (With)
- History of published Energy pricesThis query returns a list of daily published energy prices/
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of Energy price threshold alertsThis query returns a list of alerts when your electricity price crossed your set threshold between your preferred time settings. Note: this query will only return future events after this Applet is created.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of Energy export price changesUse this query to fire something when your electricity export price fell or rose past your set threshold and between your preferred time settings. Note: this query will only return future events after this Applet is created.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of energy exportThis query returns a list of when you have exported a set amount of electricity (measured in kWh) in a period.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of energy price lowest for durationThis query returns a list of when energy price was at the lowest and for a set duration (such as an hour) and between your preferred time settings.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- History of energy price threshold change for durationThis query returns a list of when energy price threshold changes for set duration. Note: this query will only return future events after this Applet is created.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of energy half hour pricing publishedThis query returns a list of when electricity price for each half hour period for the day was published.
- History of carbon intensity changesThis query returns a list of when carbon intensity fell or rose past your set threshold and between your preferred time settings. Note: this query will only return future events after this Applet is created.
Actions (Then that)
- Add row to spreadsheetThis 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.
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
IFTTT helps all your apps and devices work better together