Telegram Daily Work Reports → Google Sheets via OpenAI GPT-4o

Turn Telegram daily updates into structured Google Sheets reports—automatically

This n8n workflow listens for Telegram Daily Plan (#DailyPlan) and Daily Progress (#DailyProgress) messages, uses OpenAI (GPT-4o) to convert them into strict JSON, validates the results, and appends each verified work report into Google Sheets.

What this workflow does

• Triggers on new Telegram messages from a private chat or group.
• Normalizes the input by capturing sender/chat details, the raw text, message IDs, a Jakarta-based report date, and an optional forced report type from #DailyPlan or #DailyProgress.
• Uses OpenAI (GPT-4o) to extract only the relevant report content into strict JSON (report type, projects, tasks with statuses, blockers, and an attention flag).
• Parses and validates the AI output: it only accepts reports where the type is Morning Plan or Afternoon Report and where at least one task is present. Task statuses are normalized to the allowed set.
• Silently drops non-reports or malformed outputs.
• Appends a new row to a Google Sheets tab, including a task summary, task count, blockers, and the original Telegram message.

Use cases

• Collect daily status from a team in Telegram and maintain a clean Google Sheets daily log.
• Track Morning Plan and Afternoon Report tasks, including blockers, without manual copy/paste.
• Automation engineers and SaaS operators who want reliable, validated AI extraction from chat messages.

Technical details

• Telegram Trigger to detect incoming messages (private or group; disable bot privacy mode via @BotFather for broader group capture).
• if, code, and validation steps to enforce correct report structure.
• n8nn8n-nodes-langchainagent + OpenAI (GPT-4o) to convert reports into strict JSON.
• Google Sheets to append each validated report as a new row.
• Optional Sticky Note for workflow documentation.