Send Hourly Exchange Rate Emails
Fetches live exchange rates for 20 major currencies against the USD every hour and delivers a formatted HTML summary to your Gmail inbox.
Overview
This workflow automatically fetches the latest exchange rates for 20 major world currencies against the US dollar every hour. It then formats the data into a clean HTML email and sends it directly to your Gmail inbox β keeping you updated with fresh currency insights on a regular basis.
It does three things:
- Runs every hour on the hour (UTC) using a scheduled trigger.
- Uses an AI agent to fetch live exchange rates from a free public API, structure the data with currency details and trend indicators, and create a formatted HTML email body.
- Sends the formatted HTML email via Gmail to a specified recipient with a clear subject line.
What You Need
- A Needle platform account with access to workflow automation.
- A Gmail account connected via the Pipedream Gmail connector with proper authentication.
- No API key is needed β the exchange rates API used is free and public.
How the Flow Works
| Node | Description |
|---|---|
| Scheduled Trigger | Runs the workflow automatically every hour (at minute 0, UTC) to initiate data fetching. |
| AI Currency Agent | Fetches current exchange rates from a public API, processes data for 20 major currencies, and returns a neatly formatted HTML email body including flags, currency codes, names, regions, rates, and trend icons. |
| Send Gmail | Takes the HTML output from the AI agent and sends it as an email to the specified Gmail recipient with the subject "π Hourly Currency Exchange Rates (per 1 USD)". |
Currencies Covered
The workflow tracks the following 20 currencies against the USD:
- EUR, GBP, INR, JPY, CAD, AUD, CHF, CNY, SGD, AED
- SAR, HKD, NZD, SEK, NOK, MXN, ZAR, BRL, KRW, THB
Output
At the end of each workflow run, you'll receive an email in your Gmail inbox containing a beautifully formatted table of the latest exchange rates. The email includes:
- Flag emojis for each currency
- Currency codes and full names
- Country or region labels
- Exchange rates rounded to 4 decimal places
- Visual trend indicators showing whether each currency's rate is above or below 1 USD
Notes
- The scheduled trigger uses UTC time by default. Adjust the cron expression if you want emails at a different local time.
- The currency data and flag emojis are embedded directly in the HTML email for clear readability across most email clients.
- Since the exchange rates API requires no authentication, this workflow is simple and maintenance-free.
- Ensure your Gmail connector remains authenticated to avoid send failures.
- You can customize the recipient email or add multiple addresses by editing the Gmail node settings.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
