Workflow to grab conversion rates from an API

Another member was asking how to automatically grab GBP to EUR conversion rates to use in an account spreadsheet to automate things a bit. First thins first I thought a POC would grab the daily rates or any date you wanted from an API and write it to a GDrive spread sheet - Easy-Peasy

Phase 2 would be making an automation that on row update it would read the date and amount the grab the conversion from the other sheet and Bada-bing bada-boom - its not a problem any more!

🚀 START HERE – PROJECT WALKTHROUGH

📖 Guide

🔹 OVERVIEW

This n8n workflow retrieves daily GBP to EUR exchange rates from an API and applies them to a Google Sheets spreadsheet.

Since conversion rates change daily, we fetch the latest rate and update the sales data accordingly.

🔹 API SETUP (FIXER.IO) create a free account

https://fixer.io/quickstart

🆓 Free Plan: 100 API calls/month good for testing

💰 Basic Plan: 10,000 calls for $13.99/month

✅ Alternative: Free sources may be available, but this is a POC.

🔹 GOOGLE DRIVE INTEGRATION

📂 You'll need a Google Drive account to access the spreadsheets.

📺 Setup Tutorial: YouTube – NateH

Set up Google Credentials in n8n in 5 minutes (2025)

https://www.youtube.com/watch?v=3Ai1EPznlAc

✅ Once set up, this workflow will dynamically update sales transactions with the latest exchange rates! 🚀

But for now it just pulls them down and writes them to a spreadsheet for later use -

Technically you could just write a google formula taking date and transaction value from the transaction sheet; then using a google function vlookup to find the matching date and conversion rate on the conversion conversion sheet and write the result of multiplying the GBP amount and the EUR conversion to get the result.

But that is not fun so I am going to try and automate it when a transaction is added to the Transaction sheet the conversion happens automatically :-)

2 comments