Daily FX rate snapshot email for treasury teams

Build me an agent workflow that runs on a cron trigger every weekday (Monday through Friday) at 7am America/New_York and sends my international finance team a treasury-style FX rate snapshot email.

Configurable inputs the workflow should expose: a list of currency pairs (default USD/EUR, USD/GBP, USD/JPY, USD/CAD, USD/INR), a comma-separated recipient list for the finance distribution, a move threshold for the news callout (default 0.5% day-over-day, expressed as a positive percentage that matches either direction), the Gmail sender account, and the Google Sheet ID plus tab name for the running log (default tab name: FX rates log).

On each run, the agent should: (1) For each configured pair, call Real-Time Finance Data Get Currency Exchange Rate to get the current rate. (2) For each pair, call Real-Time Finance Data Get Currency Time Series with period 5D to compute day-over-day and week-over-week percentage changes from the most recent closes (use the latest point as today, the prior trading day for d/d, and 5 trading days back for w/w). (3) For any pair whose absolute day-over-day change exceeds the threshold, call Real-Time Finance Data Get Currency News for that pair and pick the single most relevant headline that explains the move.

Then have the agent draft a short, skimmable briefing email. The body should contain: a one-line date header in ET, a compact rate table with one row per pair showing the pair, current rate (to 4 decimals, or 2 for JPY-style pairs), day-over-day percent change, and week-over-week percent change, and a one-paragraph commentary section that mentions ONLY the pairs that moved past the threshold, each with the driver from the news headline and a short note on what it could mean for invoicing or hedging if relevant. If nothing moved past the threshold, write a single sentence saying rates were quiet. Keep the tone factual and concise. No fluff, no investment advice.

Send the email via Gmail Send a Message to the configured recipient list with subject "FX morning snapshot — <date>". After sending, append one row per pair to the Google Sheet log via Google Sheets Append Values, with columns: date (ISO), pair (e.g. USD/EUR), rate, d/d %, w/w %, headline driver (blank if pair did not trigger a news lookup).

Operational notes: format percentages with a sign and two decimals (for example, +0.42% or -1.18%). Use ISO 4217 codes everywhere (USD, EUR, GBP, JPY, CAD, INR). If Real-Time Finance Data returns no time series or no rate for a pair, still include the pair in the table with a clear placeholder and skip its news lookup rather than failing the whole run. Make the threshold check use absolute value so both rallies and selloffs get explained.