No-Code Enrichment with
Use APILayer APIs To Generate Exchange Rates from Currency Codes
Sign Up Free

Use APILayer To Look Up Exchange Rates

With over 15 exchange rate data sources, the APILayer Exchangerates API is delivering exchanging rates data for more than 170 world currencies. Simply provide the APILayer API a currency code, and it will return the exchange rates. This frictionless access to accurate geographic data allows you to bring more understanding to your data in Gigasheet. 

APILayer API for Exchange Rates

Provider Website:
Provider Enrichment Docs:
Endpoint: curl --request GET \--url '' \--header 'apikey: 123examplekey456'
Token / Registration Required: Yes

How To Enrich A Spreadsheet With APILayer:

For this example, our sheet contains a list of base currencies, conversion currencies and amounts to convert.

sample file for apilayer exchangerate API

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from APILayer.

apilayer exchangerate API cURL request

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the “to”, “from”, and “amount” in the input, and then select our Location column and click +Insert Column Reference. We also need to highlight the “123examplekey” and paste our real key from APILayer. Then click Next.

customizing the apilayer exchangerate API request

apilayer exchangerate API request ready to execute

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Ziptastic response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

Preview of response from apilayer exchangerate API

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Confirm execution of the apilayer exchangerate API

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the APILayer Exchange Rate API.

APILayer has added the Base Currency Date, Base Currency Info/Rate (exchange rate) and Base Currency - Result (converted amount). 

Results of the custom enrichment in Gigasheet using apilayer exchangerate API

Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever