Connect Agile Octopus to Google Sheets and unlock powerful automations

Use this trigger to fire something when your electricity price falls or rises past your set threshold and between your preferred time settings.

This 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.

Use this trigger to fire something when your electricity export price falls or rises past your set threshold and between your preferred time settings.

This trigger fires when a new worksheet is added to a spreadsheet you specify.

Use 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.

This trigger fires when a new row is added to a spreadsheet you specify.

Use 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.

This trigger fires when a particular cell is updated within the spreadsheet you specify.

Use this trigger to fire something when you have consumed a set amount of electricity (measured in kWh) in a period.

Use this trigger to fire something when you have exported a set amount of electricity (measured in kWh) in a period.

Use this Trigger to do something when the carbon intensity is at its lowest and between your preferred time settings.

Use this Trigger to do something when the carbon intensity is at its highest and between your preferred time settings.

Use this trigger to fire something when carbon intensity falls or rises past your set threshold and between your preferred time settings.

Use 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.

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

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

Use this trigger to fire something when electricity price for each half hour period for the day ahead is published.

Use 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.

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

Use this trigger to fire something when electricity export price for each half hour period for the day ahead is published.

This query returns a list of daily published energy prices/

This query returns the current values in a given row. Values from columns A-Z are available as ingredients.

This 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.

This query returns the current value of a single cell in your spreadsheet.

Use 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.

This query returns a list of when a new row is added to a spreadsheet you specify.

This query returns a list of when you have exported a set amount of electricity (measured in kWh) in a period.

This query returns a list of when a particular cell was updated within the spreadsheet you specify.

This 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.

This 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.

This 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.

This query returns a list of when a new worksheet is added to a spreadsheet you specify.

This query returns a list of when electricity price for each half hour period for the day was published.

This 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.

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.

This 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.