Telegram Bot: Colombian Peso to USD Rate with AI Date Recognition

This n8n workflow powers a Telegram bot that retrieves the official TRM (Representative Market Exchange Rate) from Colombian Peso (COP) to US Dollar (USD) for user-specified dates. Users send text or audio messages via Telegram, and OpenAI extracts the date in YYYY-MM-DD format. The workflow validates the date (rejecting future dates), queries the Colombian government's open data API (datos.gov.co), and if no exact match, searches up to 10 prior days for the nearest available rate.

Key benefits include hands-free date recognition via AI (handling natural language or voice), reliable data from official sources, automated fallback logic to ensure useful responses, and seamless Telegram integration for instant replies. It saves time for frequent users like traders, businesses, or expats tracking historical rates without manual API calls or website scraping.

Ideal use cases: Financial analysts monitoring COP/USD fluctuations, Colombian businesses handling international payments, personal finance apps needing quick historical TRM lookups, or automated reporting bots. Deploy it to streamline currency queries in chats, reducing errors from manual date entry and providing always-available access to verified government data.