Add new iOS Contacts to Google Sheets automatically
How this automation works
Record new energy import prices automatically in your Google Sheets for tracking and analysis. This Applet runs whenever new Agile Octopus electricity import prices are published and adds a row of data (including dates and prices) to your chosen spreadsheet. Ideal for monitoring your energy costs and managing tariff performance over time.
If
Trigger ingredients
CreatedAt
DateFrom
DateTo
Price
PublishedAt
Then
Action fields
filename
formatted_row
path
Services used in this Applet
You might also like...
-
272K
-
-
Track time at locations with Google Sheets
157K
-
-
Log work hours in Google Sheets with a Button Widget
124K
-
Related services
Create your own Google Sheets and Agile Octopus workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
24 triggers, queries, and actions
Carbon Intensity Change
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the carbon intensity changes based on user-defined conditions, such as intensity thresholds and specific time ranges. It uses live and forecasted carbon intensity data to evaluate and validate actions.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Energy Consumed By Period
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the energy consumed during a specified period exceeds a user-defined threshold. Users can configure the period type (daily, weekly, or monthly) and set a consumption threshold.
Energy Export Periods
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new export electricity rates are published and match your selected condition — for example, the 5 lowest or highest price periods. Rates are based on data from 11:00 to 11:00 London time.
Energy Export Prices Change
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the electricity export prices change based on user-defined conditions, such as price thresholds and specific time ranges.
Energy Export Prices Published
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new electricity export prices are published. It uses the published price data for a specified period to validate and perform actions.
Energy Exported By Period
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the energy exported during a specified period exceeds a user-defined threshold. Users can configure the period type (daily, weekly, or monthly) and set an export threshold.
Energy Import Periods
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new import electricity rates are published and match your selected condition — for example, the 5 lowest or highest price periods. Rates are based on data from 11:00 to 11:00 London time.
Energy Import Price Change With Carbon Intensity
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
Use this trigger to fire something when your electricity import price falls or rises past your set threshold and between your preferred time settings, also as optional condition you can match carbon intensity level for the periods
Energy Import Prices Index Change With Carbon Intensity
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
Use this trigger to fire something when your electricity import price falls or rises past your set threshold and between your preferred time settings, also as optional condition you can match carbon intensity level for the periods
Energy Import Prices Published
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new electricity import prices are published. It uses published price data for a specified period to validate and perform actions.
New row added to spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Energy export price published
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
Retrieves the electricity price for today based on the applicable export tariffs. The response includes pricing details for the current date, considering variations in export rates throughout the day.
Energy import price published
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
Retrieves the electricity price for today based on the applicable import tariffs. The response includes pricing details for the current date, reflecting any time-based variations in the import rates.
History of rows added to spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.
History of spreadsheets added to folder
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
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.
History of when Cell was updated in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of worksheets in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Update cell in spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Carbon Intensity Change
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the carbon intensity changes based on user-defined conditions, such as intensity thresholds and specific time ranges. It uses live and forecasted carbon intensity data to evaluate and validate actions.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Energy Consumed By Period
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the energy consumed during a specified period exceeds a user-defined threshold. Users can configure the period type (daily, weekly, or monthly) and set a consumption threshold.
Energy Export Periods
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new export electricity rates are published and match your selected condition — for example, the 5 lowest or highest price periods. Rates are based on data from 11:00 to 11:00 London time.
Energy export price published
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
Retrieves the electricity price for today based on the applicable export tariffs. The response includes pricing details for the current date, considering variations in export rates throughout the day.
Energy Export Prices Change
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the electricity export prices change based on user-defined conditions, such as price thresholds and specific time ranges.
Energy Export Prices Published
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new electricity export prices are published. It uses the published price data for a specified period to validate and perform actions.
Energy Exported By Period
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when the energy exported during a specified period exceeds a user-defined threshold. Users can configure the period type (daily, weekly, or monthly) and set an export threshold.
Energy Import Periods
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger activates when new import electricity rates are published and match your selected condition — for example, the 5 lowest or highest price periods. Rates are based on data from 11:00 to 11:00 London time.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
More on Google Sheets and Agile Octopus
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About Agile Octopus
Save money off your energy bill by making things work when energy prices are low.
This is a beta service offered by our R-and-D Labs service without any guarantee of service availability.
Save money off your energy bill by making things work when energy prices are low. This is a beta service offered by our R-and-D Labs service without any guarantee of service availability.