n8n Workflow: Send Childcare Daily Reports via Telegram & Gmail

Auto-send daily childcare reports from Telegram to parents—plus director alerts

This n8n workflow turns a teacher’s daily childcare notes into parent-ready summaries automatically. It collects messages via Telegram, matches each child to a Google Sheets roster, uses OpenAI (LangChain) to generate a short JSON-based parent summary with concern/follow-up flags, logs everything to Google Sheets, and emails parents via Gmail—with Telegram/Gmail alerts for unknown children, processing issues, and reports needing director attention.

What this workflow does

• Receives teacher notes in Telegram through a Telegram bot and checks the message has enough content.
• Handles incomplete/invalid submissions by replying on Telegram and logging invalid entries to Google Sheets.
• Matches the child to the roster by loading the child list from Google Sheets and extracting the child name from the message text.
• Detects unknown children: if no roster match is found, it alerts the director via Telegram and Gmail, and logs the unknown report to Google Sheets.
• Generates parent-friendly summaries using an OpenAI (LangChain) agent that returns a short JSON summary including concern and follow-up flags.
• Escalates AI parsing issues: if the AI output can’t be parsed, the director is alerted via Telegram (and Gmail), and the issue is surfaced.
• Emails parents daily via Gmail with the generated summary, and confirms receipt back to the teacher on Telegram.
• Escalates flagged reports to the director via Telegram and Gmail when concern/follow-up flags are set.
• Runs a daily scheduled sweep to find children missing today’s report by comparing the roster to today’s Google Sheets logs, then sends reminders.

Use cases

• Childcare centers that collect daily notes from staff via Telegram and need instant parent updates.
• Operators who want automated director oversight for unknown children or flagged concerns.
• Teams using Google Sheets rosters that need reliable matching, logging, and exception handling.

Technical details

• n8n nodes/tools: if, set, code, gmail, telegram, and sticky note.
• Data/logging: Google Sheets for roster lookup, invalid submissions, unknown-child reports, and final summaries.
• AI: OpenAI via LangChain agent to produce a short JSON summary with concern/follow-up flags.