This n8n workflow automates the process of retrieving the Colombian Peso to US Dollar exchange rate (TRM) for a specific date received via Telegram. When a user sends a text or audio message, the workflow extracts the date mentioned using OpenAI’s language model, validates whether the date is in the past or future, and if valid, queries the Colombian government’s open data API for the TRM of that date. If data is not available for the exact date, the workflow searches up to 10 previous days to find the most recent available TRM and sends this information back to the user through Telegram. This automation is particularly useful for businesses, financial analysts, or individuals needing quick access to historical exchange rates communicated via Telegram messages, incorporating natural language understanding and date validation.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.openAi, @n8n/n8n-nodes-langchain.outputParserStructured, @n8n/n8n-nodes-langchain.toolCalculator, @n8n/n8n-nodes-langchain.toolThink, code, filter, httpRequest, if, limit, set, sort, splitInBatches, splitOut, stickyNote, switch, telegram, telegramTrigger