Importing Exchange Rate-API Data
This guide will walk through how to convert currency with Exchange Rate-API directly in Google Sheets.
To start pulling data all you need to do is make a request using Phlorin in Google Sheets.
Getting Started
Install the API solution add-on from Google Marketplace.
Pull Exchange Rate-API data into Sheets
To get the most out of the Exchange Rate-API, use Phlorin to pull up-to-date data seamlessly into Google Sheets.
1. In your desired Sheets document, open Phlorin and create a new request:
Extensions > Phlorin > Open > Create a request
2. In the Application dropdown select or search for Exchange Rate-API
3. Select the desired endpoint. No API key necessary.
In this example we will use /latest/{currency_code}, this will provide the current exchange rate for the selected currency.
4. Next select the desired currency from the dropdown menu. Click here for a complete list of currency codes.
This example uses USD, the United States Dollar.
5. Make sure your desired sheet is selected and then click Run.
Creating Custom Request
With Phlorin and Exchange Rate-API documentation you can find URLs to run custom requests. However, this will require you to first acquire an Exchange Rate-API Key.
Though it is recommended to use Phlorin’s built in integration, buying a pro plan with Exchange Rate-API can allow access to a key for custom integration.
This example shows how to use Phlorin to fetch conversion rates for USD.
- Application: Custom
- Method: GET
- Request URL: https://v6.exchangerate-api.com/v6/YOUR-API-KEY/latest/USD
Adapting the URL to your needs:
The request URL must be formatted to fit your demands. Once acquired from ExchangeRate-API, your key should be placed in the link.
Documentation
Exchange Rate-API official documentation: https://www.exchangerate-api.com/docs/overview