{"product_id":"n8n-workflow-send-childcare-daily-reports-via-telegram-gmail","title":"n8n Workflow: Send Childcare Daily Reports via Telegram \u0026 Gmail","description":"\u003ch3\u003eAuto-send daily childcare reports from Telegram to parents—plus director alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns a teacher’s daily childcare notes into parent-ready summaries automatically. It collects messages via \u003cstrong\u003eTelegram\u003c\/strong\u003e, matches each child to a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e roster, uses \u003cstrong\u003eOpenAI (LangChain)\u003c\/strong\u003e to generate a short JSON-based parent summary with concern\/follow-up flags, logs everything to Google Sheets, and emails parents via \u003cstrong\u003eGmail\u003c\/strong\u003e—with Telegram\/Gmail alerts for unknown children, processing issues, and reports needing director attention.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives teacher notes in Telegram\u003c\/strong\u003e through a Telegram bot and checks the message has enough content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles incomplete\/invalid submissions\u003c\/strong\u003e by replying on Telegram and logging invalid entries to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches the child to the roster\u003c\/strong\u003e by loading the child list from Google Sheets and extracting the child name from the message text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects unknown children\u003c\/strong\u003e: if no roster match is found, it alerts the director via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e, and logs the unknown report to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates parent-friendly summaries\u003c\/strong\u003e using an \u003cstrong\u003eOpenAI (LangChain) agent\u003c\/strong\u003e that returns a short JSON summary including concern and follow-up flags.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates AI parsing issues\u003c\/strong\u003e: if the AI output can’t be parsed, the director is alerted via Telegram (and Gmail), and the issue is surfaced.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails parents daily via Gmail\u003c\/strong\u003e with the generated summary, and confirms receipt back to the teacher on Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates flagged reports\u003c\/strong\u003e to the director via Telegram and Gmail when concern\/follow-up flags are set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns a daily scheduled sweep\u003c\/strong\u003e to find children missing today’s report by comparing the roster to today’s Google Sheets logs, then sends reminders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eChildcare centers that collect daily notes from staff via Telegram and need instant parent updates.\u003c\/li\u003e\n  \u003cli\u003eOperators who want automated director oversight for unknown children or flagged concerns.\u003c\/li\u003e\n  \u003cli\u003eTeams using Google Sheets rosters that need reliable matching, logging, and exception handling.\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\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData\/logging:\u003c\/strong\u003e Google Sheets for roster lookup, invalid submissions, unknown-child reports, and final summaries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e OpenAI via \u003cstrong\u003eLangChain\u003c\/strong\u003e agent to produce a short JSON summary with concern\/follow-up flags.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45917696098483,"sku":"N8N-18762","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/iFd3DM-FuZRdveHUo-dFl_CrOMmpym.png?v=1788080804","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-send-childcare-daily-reports-via-telegram-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}