Automate Currency Exchange Rates Update in Google Sheets - n8n Workflow | Neura Market
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.