This n8n workflow automates the process of fetching and updating currency exchange rates in Google Sheets. Designed for businesses or individuals needing real-time currency conversions, this workflow runs daily at 8:00 AM, pulling the latest USD exchange rates via an API. It then processes the data, updates a dedicated sheet with current rates, and archives historical data for record-keeping. The workflow includes steps to set up API credentials, trigger the workflow on a schedule, make HTTP requests to fetch exchange rates, format and filter the data, and update Google Sheets seamlessly. This task automation reduces manual effort, ensures accuracy, and provides up-to-date financial data ready for reporting or invoicing.
Automated Currency Exchange Rate Update in Google Sheets
| Node Count | 6 – 10 Nodes |
|---|---|
| Nodes Used | code, googleSheets, httpRequest, merge, scheduleTrigger, set, stickyNote |
