FM
FlowMarket
AI Agents Advanced ⚡ 31 n8n Nodes

Get Colombian peso to USD exchange rate with Telegram bot and AI

📌 Request TRM (Colombian Peso to US Dollar exchange rate) 🎯 Objective Retrieve the TRM (Colombian Peso to US Dollar exchange rate) for a specific date prov...

🔌 Nodes & Integrations Used (11)

Lm Chat Open Ai Telegram Trigger Telegram HTTP Request Sort Limit Tool Calculator Tool Think Agent Output Parser Structured OpenAI

📖 Implementation & Setup Guide

📌 Request TRM (Colombian Peso to US Dollar exchange rate)

🎯 Objective

Retrieve the TRM (Colombian Peso to US Dollar exchange rate) for a specific date provided by the user via Telegram.

🔄 Summary Flow

  1. 📨 **Telegram Message**
  2. The user sends a text or audio message to the Telegram Bot.

2. 🧠 **Date Extraction** AI (OpenAI) is used to identify the date in `YYYY-MM-DD` format.

3. 📅 **Validation** If the date is in the future, the user is notified that it is not valid.

4. 📡 **TRM Query** The bot queries the open data API from the Colombian government.

5. 📥 **Result** - ✅ If TRM data exists for that date → The bot replies to the user. - ❌ If not → It searches up to 10 previous days for available data.

6. 📤 **Final Response** The most recent available value is sent, or a message indicating no information is available.

🔗 Data Source

**datos.gov.co** – [TRM](https://www.datos.gov.co/)

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Get_Colombian_peso_to_USD_exchange_rate_with_Telegram_bot_and_AI.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related AI Agents Workflows

View All in AI Agents →