Daily Exchange Rate Tracker for Google Sheets and Slack

PromptCreate

Every weekday at 6am, log the exchange rates I care about to a Google Sheet and ping me in Slack when one of them jumps. This should be a plain deterministic job with no commentary and no AI-written summary, so the sheet stays clean enough to chart and pivot over time.

Let me configure my watchlist of currency pairs as an input, each written as BASE/QUOTE (for example EUR/USD, GBP/USD, USD/JPY), along with the spreadsheet ID and tab name of my tracking sheet, the Slack channel to alert, and the move threshold, which should default to 1 percent.

Use the Open Exchange Rates Get Latest Rates operation to fetch today's rates. Free Open Exchange Rates plans are USD base only and return 400 invalid_base if you ask for anything else, so always request rates against USD and pass the set of currency codes from my watchlist as the symbols filter. Derive each cross rate by dividing USD quotes: the rate for BASE/QUOTE is the USD rate for QUOTE divided by the USD rate for BASE.

Then work out the previous business day and use Get Historical Rates for that date to fetch the same currencies the same way. Previous business day means weekends are skipped: on a Monday go back to the Friday, otherwise use yesterday. Derive the baseline from this historical call rather than by reading old rows back out of the spreadsheet, so the job stays stateless and still produces correct numbers after a missed run. Do not use Convert Amount or Get Time-Series, which require higher Open Exchange Rates plans. Fetching the previous day as its own Get Historical Rates call is exactly why the workflow is built this way. Note that historical values are the last rate published up to 23:59:59 UTC on the requested day, and that two requests per run keeps this well inside the monthly request quota.

For each pair in my watchlist, append one dated row to my tracking sheet using the Google Sheets Append Values operation, with columns in this order: date, pair, rate, previous rate, percent change. Percent change is (rate minus previous rate) divided by previous rate, multiplied by 100. Write the date as YYYY-MM-DD, and write rate, previous rate, and percent change as real numbers rather than preformatted strings, so the columns stay chartable and pivotable. Round rates to six decimal places and percent change to two. Append all of the day's rows in a single call so each run adds one clean block.

After the sheet is updated, check whether any pair moved more than the threshold in either direction. If any did, send one Slack message using Send a Message to my alert channel, listing just those pairs with their percent change and whether the move was up or down. Keep it to a plain list with no analysis or commentary. If nothing crossed the threshold, do not send a message at all, so the channel stays quiet on normal days.

If either rates lookup fails, or the historical date returns no data for a currency in my watchlist, stop without writing partial rows to the sheet so I never end up with a half-written day.

What does this prompt do?

Runs automatically every weekday morning and records today's rate for each currency pair you follow.
Adds one dated row per pair to your tracking spreadsheet with the current rate, the previous business day's rate, and the percent change.
Sends a Slack message only when a pair moves more than your threshold, listing which pairs moved and in which direction.
Keeps the spreadsheet clean and consistent so you can chart trends or build pivot tables straight from it.

What do I need to use this?

An Open Exchange Rates account. The free plan is enough.
A Google account and a spreadsheet to use as your tracking sheet.
A Slack workspace and the channel where you want alerts to land.
Your list of currency pairs to watch, written like EUR/USD or USD/JPY.

How can I customize it?

Change the schedule: run it later in the morning, or every day including weekends.
Adjust the alert threshold: raise it above one percent for calmer currencies, or lower it to catch smaller moves.
Send alerts to a different Slack channel, or as a direct message to yourself instead.
Add or remove currency pairs at any time. New pairs start logging on the next run.

FAQs

Do I need a paid Open Exchange Rates plan?

No, the free plan covers everything this workflow needs. Free accounts quote every currency against the US dollar, so the workflow works out pairs like EUR/GBP from the dollar rates behind the scenes. It also makes only two lookups per run, which keeps you comfortably inside the free monthly allowance.

What happens if a run gets missed, like on a public holiday?

The next run still produces correct numbers. It always looks up the previous business day's rate directly from Open Exchange Rates rather than relying on what is already in your spreadsheet, so a skipped day does not throw off the comparison.

Will it message me every single day?

No. The spreadsheet is updated every weekday, but Slack only gets a message when a pair actually moves more than your threshold. On quiet days the channel stays silent.

Can I track cryptocurrency or less common currencies?

Yes, as long as Open Exchange Rates covers them. It supports over 200 world and digital currencies, and you just add the pair to your watchlist.

Will this overwrite anything in my existing spreadsheet?

No. It only adds new rows underneath what is already there, so your history, charts, and pivot tables stay intact.

Related templates

Auto-fix your calendar when a flight slips, and flag what's at risk

When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.

Agentic Task

Trace phishing emails to the sending IP and report abuse

Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.

Agentic Task

Weekly Amazon S3 bucket security audit posted to Slack

Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.

Agentic Task

Turn procurement portal tenders into CRM deals each morning

Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.