Sign Up

Import EnergypriceAPI Data to Google Sheets

< Back to Guides

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your EnergypriceAPI API Key

  1. Navigate to energypriceapi.com and click GET FREE API KEY
  2. You will be prompted to create an account and your will receive a verification email. Click on the email to verify your account, and you'll be redirected to the dashboard.
  3. Copy API Key

Part 2: Create Your API Request URL

In this example, we will get the latest energy prices for BRENT, WTI and NATURALGAS in USD.

Full API Request URL:

https://api.energypriceapi.com/v1/latest?base=USD&currencies=BRENT,WTI,NATURALGAS&api_key=[YOUR_API_KEY]

Part 3: Pull EnergypriceAPI Data into Google Sheets

From step 2, we will paste the final URL into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open
  2. In the Create tab, enter the API URL from step 2.
  3. We don't need OAuth Authentication so just leave that set to None. We don't need any headers either so just leave that section blank.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run.

Notes:

  • The timestamp is a UNIX timestamp. You can convert it back to a regular human-readable date with the Sheets function =C2/60/60/24 + DATE(1970,1,1)

Part 4: More Example API URLs

You can experiment with endpoints and query strings as described in the documentation to see other types of data, but if you just want to jump in and get a feel for it, play around with the URLs you enter in the API URL path field. Try the following (one at a time), substituting in your own symbols and dates if you like. List of commodities.

  • Historical price of Brent Crude Oil, WTI Crude Oil, and Natural Gas on 2022-01-30
https://api.energypriceapi.com/v1/2022-01-30?api_key=[API_KEY]&base=USD&currencies=BRENT,WTI,NATURALGAS
  • Conversion rate of USD$25 to Brent Crude Oil on 2022-01-30
https://api.energypriceapi.com/v1/convert?api_key=[API_KEY]&from=USD&to=BRENT&amount=100&date=2022-01-30
  • Conversion rate of USD$25 to WTI Crude Oil on 2022-01-30
https://api.energypriceapi.com/v1/convert?api_key=[API_KEY]&from=USD&to=WTI&amount=100&date=2022-01-30
  • Conversion rate of USD$25 to Natural Gas on 2022-01-30
https://api.energypriceapi.com/v1/convert?api_key=[API_KEY]&from=USD&to=NATURALGAS&amount=100&date=2022-01-30
  • Time-series data for Brent Crude Oil and Natural Gas between 2021-01-01 and 2021-12-01
https://api.energypriceapi.com/v1/timeframe?api_key=[API_KEY]&start_date=2021-01-01&end_date=2021-12-01&base=USD&currencies=BRENT,NATURALGAS
  • Percent change data for Brent Crude Oil and Natural Gas between 2021-01-01 and 2021-12-01
https://api.energypriceapi.com/v1/change?api_key=[API_KEY]&start_date=2021-01-01&end_date=2021-12-01&base=USD&currencies=BRENT,NATURALGAS