💰 Automate currency rates update in invoices with Google Sheet, ExchangeRate API

Tags: Automation, Finance, Google Sheets, API

Note: This workflow uses the Exchange rate API and requires a valid API key.

Context I’m [Samir Saci](https://samirsaci.com), a Supply Chain Data Scientist who builds automations to streamline operations, reduce manual tasks, and boost decision-making through real-time data.

In this workflow, I automated the task of fetching live currency exchange rates, updating a Google Sheet with the latest values, and archiving historical records — all without writing any code.

> Improve your productivity by automating admin tasks with n8n!

📬 For business inquiries, you can add me on [LinkedIn](https://www.linkedin.com/in/samir-saci)

Who is this template for? This template is perfect for: - Finance teams tracking multi-currency cashflows - Analysts building dashboards or models requiring updated FX data - Anyone working with spreadsheets who needs up-to-date exchange rates

It updates: - A live sheet with the latest USD-based exchange rates - An archive tab to track historical changes over time