Automated FX Reporting
FlorAndina S.A.S. · flower exporter
A weekly pipeline that tracks USD/COP volatility and delivers an executive brief, so a flower exporter can protect its margins without anyone building the report by hand.
30+
business news articles read by the AI every week
3
time horizons in every brief: 1 month, 3 months, 1 year
100%
automated, from reading the exchange rate to emailing the PDF brief
The situation
FlorAndina is a medium-sized flower exporter in Bogotá. Over 95% of its revenue arrives in US dollars while most costs are paid in pesos, so every weekly move in the exchange rate lands directly on profit margins and contract pricing.
Key challenges
- Manual reporting was slow and often late.
- Management struggled to react quickly to exchange-rate swings.
- There was no reliable, consistent way to follow the TRM and understand its impact.
How it works
Capture the rate
Every week the workflow pulls the current USD/COP rate from an API and records it in Google Sheets, where a formula compares it with the previous week.
Add real-world context
A second API retrieves the 30 most recent business news articles about the US dollar, because generative AI has no live financial awareness of its own.
Explain the move
Gemini reads the rate change together with the news and drafts the likely causes, following a decision-rules table in Google Sheets that keeps the output accurate and consistent.
Deliver the brief
The result is formatted into a Google Docs template covering 1-month, 3-month and 1-year trends, exported as PDF and emailed to stakeholders.
The outcome
Management now gets a clear weekly view of the exchange rate and what is driving it. They can adjust pricing for future contracts and anticipate revenue shifts with more confidence, without relying on manual analyst work.