{"product_id":"n8n-workflow-daily-telegram-market-briefing-w-openai","title":"n8n Workflow: Daily Telegram Market Briefing w\/ OpenAI","description":"\u003ch3\u003eGet a weekday market briefing to your Telegram—generated with OpenAI from real-time data\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e automatically collects market prices, crypto quotes, US 10Y yields, macro calendar events, and top market news—then uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a structured market briefing and posts it to \u003cstrong\u003eTelegram\u003c\/strong\u003e every weekday morning.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes every weekday at \u003cstrong\u003e07:45 (Europe\/Berlin)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls data from multiple providers:\u003c\/strong\u003e market ETF\/FX time series from \u003cstrong\u003eTwelve Data\u003c\/strong\u003e, crypto prices from \u003cstrong\u003eCoinGecko\u003c\/strong\u003e, the US 10-year yield series from \u003cstrong\u003eFRED\u003c\/strong\u003e, near-term macro events from \u003cstrong\u003eQuantGist\u003c\/strong\u003e, and recent market news from \u003cstrong\u003eMarketaux\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes inputs + captures issues:\u003c\/strong\u003e standardizes each provider’s response into a consistent structure and records errors or missing\/invalid payloads \u003cem\u003ewithout guessing\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a briefing with OpenAI:\u003c\/strong\u003e sends the normalized dataset and source health to OpenAI to produce a \u003cstrong\u003estrictly JSON-formatted\u003c\/strong\u003e market briefing in \u003cstrong\u003eBosnian\/Serbian\u003c\/strong\u003e with a single \u003cstrong\u003emarket_regime\u003c\/strong\u003e label.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and formats output:\u003c\/strong\u003e enforces allowed \u003cstrong\u003emarket_regime\u003c\/strong\u003e values and reshapes array fields, then builds an \u003cstrong\u003eHTML Telegram message\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts and archives:\u003c\/strong\u003e sends the briefing to the configured Telegram chat and inserts the full result (headline, summary, assets, events, news, drivers, opportunities, plus raw sources) into \u003cstrong\u003ePostgres\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomated daily market updates for traders or investment teams via \u003cstrong\u003eTelegram\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building a “market brief” feature without manual research\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want a reliable, traceable workflow using Postgres storage and source health reporting\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e \u003cem\u003eschedule trigger\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003etelegram\u003c\/em\u003e, \u003cem\u003epostgres\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal APIs:\u003c\/strong\u003e Twelve Data, CoinGecko, FRED, QuantGist, Marketaux\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration:\u003c\/strong\u003e generates strictly JSON output, then the workflow validates and converts it to an HTML Telegram message\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e configure credentials for each provider and ensure API authentication is passed via the configured HTTP header\/query method\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001867784371,"sku":"N8N-19457","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RuCT2-mREUW6eEPsroLje_HL7cao8Y.png?v=1789117971","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-daily-telegram-market-briefing-w-openai","provider":"N8N Commerce","version":"1.0","type":"link"}