This n8n workflow automates the process of fetching daily GBP exchange rates, formatting the data into an HTML table, storing it in Google Sheets, and sending it via email. The workflow begins with a manual trigger to initiate the process, followed by an HTTP request to retrieve the latest exchange rates from Fixer.io API. The response data is processed by a code node to generate an HTML table displaying currency rates against GBP.
Next, a Gmail node sends the formatted HTML table as an email to a specified address, providing recipients with up-to-date currency information. Simultaneously, a Google Sheets node appends the exchange rate data with the current date to a Google Spreadsheet for record-keeping or further analysis.
This workflow is particularly useful for financial analysts, business owners, or travelers who need daily updates on currency fluctuations, ensuring timely information dissemination and record automation without manual effort.
Reviews
There are no reviews yet.