Answer Telegram data questions with DeepSeek, Open-Meteo, Frankfurter, CoinGecko, and StudioAPI

Your Telegram bot, now with live data. Ask it about weather, exchange rates, crypto, gold, earthquakes, Bank Indonesia rates, holidays, or Jakarta power supply, and it answers with real numbers while logging every query to Google Sheets.

Last updated: September 2026.

Quick Overview This workflow turns a Telegram bot into an AI data assistant. Users ask questions in plain language and the agent answers with live data: weather (Open-Meteo), foreign exchange rates (Frankfurter), crypto prices (CoinGecko), gold price, Indonesian earthquakes, Bank Indonesia rates, Indonesian holidays, and Jakarta power supply (StudioAPI). Every query is logged to Google Sheets, and a weekly market briefing is sent to the owner every Monday.

How it works Triggers when a new message arrives at your Telegram bot. Normalizes the incoming message (text, chat ID, user name, and timestamp). A DeepSeek agent (deepseek-v4-flash) keeps a short conversation memory and picks the right data tool for the question. Weather tool: current conditions from Open-Meteo (temperature, humidity, wind, and weather code) by latitude and longitude. FX Rates tool: reference exchange rates from Frankfurter. Gold Price tool: the current international gold price in USD per troy ounce. Crypto Prices tool: USD prices and 24-hour change for ten major coins from CoinGecko. Indonesian data from StudioAPI: latest earthquakes (BMKG), Bank Indonesia reference rates, national holidays, and Jakarta power supply status. /help and /start return a short menu of supported topics without calling a tool. The question and answer are logged to Google Sheets and the answer is sent back to the user in Telegram as a short, mobile-friendly reply. Every Monday at 07:00 a scheduled branch fetches crypto prices and writes a short market briefing (crypto highlights, gold price, and FX note) for the owner. If a node fails, the Error Trigger path replies in Telegram that the data service is temporarily unavailable, so failed lookups are not silently dropped.

Setup Create a Telegram bot with BotFather and add your Telegram credentials in n8n for the trigger and reply nodes. Connect your OpenAI-compatible API credentials on the model nodes (deepseek-v4-flash by default). Create a StudioAPI key and add an HTTP Header Auth credential (x-api-key). The earthquakes, BI rates, holidays, and power tools require it. Connect your Google Sheets credentials and set the spreadsheet and sheet used to log queries. Send a message to your bot to test, then adjust the system prompt if you want to change what the assistant can answer.

Quick Answers Which data sources does it use? Open-Meteo for weather, Frankfurter for FX rates, and CoinGecko for crypto, plus StudioAPI for the international gold price, BMKG earthquakes, Bank Indonesia rates, Indonesian holidays, and Jakarta power supply status.

Where are my questions stored? Every question and answer is logged to Google Sheets, so you keep a history of what was asked.

Is there a weekly update? Yes. Every Monday at 07:00 the workflow writes a short market briefing covering crypto highlights, the gold price, and an FX note for the owner.

What happens if a data service is down? An Error Trigger path replies in Telegram that the service is temporarily unavailable, so failed lookups are never silently dropped.

Additional info Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/