Sign Up

Import ForexRateAPI 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 ForexRateAPI API Key

  1. Navigate to forexrateapi.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 forex rates for EUR, JPY and CAD in USD.

Full API Request URL:

https://api.forexrateapi.com/v1/latest?base=USD&currencies=EUR,JPY,CAD&api_key=[YOUR_API_KEY]

Part 3: Pull ForexRateAPI 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 currencies.

  • Historical price of European Euro, Japan Yen, and Canadian Dollar on 2022-01-30
https://api.forexrateapi.com/v1/2022-01-30?api_key=[API_KEY]&base=USD&currencies=EUR,JPY,CAD
  • Conversion rate of USD$25 to European Euro on 2022-01-30
https://api.forexrateapi.com/v1/convert?api_key=[API_KEY]&from=USD&to=EUR&amount=100&date=2022-01-30
  • Conversion rate of USD$25 to Japanese Yen on 2022-01-30
https://api.forexrateapi.com/v1/convert?api_key=[API_KEY]&from=USD&to=JPY&amount=100&date=2022-01-30
  • Conversion rate of USD$25 to European Euro on 2022-01-30
https://api.forexrateapi.com/v1/convert?api_key=[API_KEY]&from=USD&to=EUR&amount=100&date=2022-01-30
  • Time-series data for European Euro and Canadian Dollar between 2021-01-01 and 2021-12-01
https://api.forexrateapi.com/v1/timeframe?api_key=[API_KEY]&start_date=2021-01-01&end_date=2021-12-01&base=USD&currencies=EUR,CAD
  • Percent change data for European Euro and Canadian Dollar between 2021-01-01 and 2021-12-01
https://api.forexrateapi.com/v1/change?api_key=[API_KEY]&start_date=2021-01-01&end_date=2021-12-01&base=USD&currencies=EUR,CAD