{"product_id":"telegram-daily-work-reports-google-sheets-via-openai-gpt-4o","title":"Telegram Daily Work Reports → Google Sheets via OpenAI GPT-4o","description":"\u003ch3\u003eTurn Telegram daily updates into structured Google Sheets reports—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow listens for \u003cstrong\u003eTelegram Daily Plan (#DailyPlan)\u003c\/strong\u003e and \u003cstrong\u003eDaily Progress (#DailyProgress)\u003c\/strong\u003e messages, uses \u003cstrong\u003eOpenAI (GPT-4o)\u003c\/strong\u003e to convert them into strict JSON, validates the results, and appends each verified work report into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new Telegram messages\u003c\/strong\u003e from a private chat or group.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the input\u003c\/strong\u003e by capturing sender\/chat details, the raw text, message IDs, a Jakarta-based report date, and an optional forced report type from \u003ccode\u003e#DailyPlan\u003c\/code\u003e or \u003ccode\u003e#DailyProgress\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI (GPT-4o)\u003c\/strong\u003e to extract only the relevant report content into \u003cstrong\u003estrict JSON\u003c\/strong\u003e (report type, projects, tasks with statuses, blockers, and an attention flag).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and validates\u003c\/strong\u003e the AI output: it only accepts reports where the type is \u003cstrong\u003eMorning Plan\u003c\/strong\u003e or \u003cstrong\u003eAfternoon Report\u003c\/strong\u003e and where \u003cstrong\u003eat least one task\u003c\/strong\u003e is present. Task statuses are normalized to the allowed set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSilently drops\u003c\/strong\u003e non-reports or malformed outputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to a Google Sheets tab, including a task summary, task count, blockers, and the original Telegram message.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCollect daily status from a team in Telegram and maintain a clean \u003cstrong\u003eGoogle Sheets daily log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTrack \u003cstrong\u003eMorning Plan\u003c\/strong\u003e and \u003cstrong\u003eAfternoon Report\u003c\/strong\u003e tasks, including blockers, without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers and SaaS operators who want reliable, validated AI extraction from chat messages.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram Trigger\u003c\/strong\u003e to detect incoming messages (private or group; disable bot privacy mode via \u003cstrong\u003e@BotFather\u003c\/strong\u003e for broader group capture).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and validation steps to enforce correct report structure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8nn8n-nodes-langchainagent\u003c\/strong\u003e + \u003cstrong\u003eOpenAI (GPT-4o)\u003c\/strong\u003e to convert reports into strict JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to append each validated report as a new row.\u003c\/li\u003e\n  \u003cli\u003eOptional \u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow documentation.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072076566707,"sku":"N8N-19799","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/apu-pNIrMEVP0yVCPIlYS_YZ4jzKjE.png?v=1790068030","url":"https:\/\/buyflowscripts.com\/products\/telegram-daily-work-reports-google-sheets-via-openai-gpt-4o","provider":"N8N Commerce","version":"1.0","type":"link"}