Automate Currency Exchange Rates Update in Google Sheets
Fetches live USD exchange rates from ExchangeRate API, updates a Google Sheet with latest values using upsert logic, and archives historical data for tracking.
This n8n workflow automates the retrieval and management of currency exchange rates, pulling real-time data from the ExchangeRate API based on USD as the base currency. It processes the API response to extract key fields like timestamp and conversion rates, then performs an upsert operation to update a primary Google Sheet tab with the most current rates. Additionally, it appends full rate details to a separate archive tab, ensuring a complete historical record without manual intervention.
The
- Platform
- n8n
- Category
- Utilities
- Price
- $11.99
- Creator
- Fred Garcia
- automation
- finance
- google-sheets
- exchange-rates
- currency
- api
- invoices
- expense-management
- fx-data
- business-ops
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Utilities workflows
- Streamlined Employee Onboarding with Automated Meeting Setup$19.98
- Automate Your LinkedIn Content Creation with RAG Pipeline & Chatbot$24.99
- SEO Keyword Research Automation with Google API Integration$14.99
- Automate Google Sheets and Gmail Integration via Webhook$16.33
- Automated Breaking News Headlines with LLaMA3 and X Posting$19.99
- Automated Webinar Registration and Contact Management$13.09
More from Fred Garcia
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.