This workflow retrieves the latest GBP exchange rates and sends them via email in a formatted HTML table. It also logs the data in a Google Sheets document for record-keeping.
The workflow is triggered manually and begins by fetching the latest exchange rates for GBP against USD, AUD, and CAD using the Fixer API. The data is then formatted into an HTML table using a code node. This table is emailed to a specified address using Gmail. Additionally, the exchange rate data is appended to a Google Sheets document for tracking and analysis.
Platform
n8n
Category
Communication
Price
Free
Creator
Theo van der Berg
code
gmail
stickyNote
httpRequest
googleSheets
manualTrigger
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.