{"product_id":"weekly-parent-progress-reports-google-sheets-gpt-4o-mini","title":"Weekly Parent Progress Reports: Google Sheets + GPT-4o mini","description":"\u003ch3\u003eSend weekly, personalized parent progress reports automatically—generated with GPT-4o mini and delivered as PDF via Gmail + Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads student performance data from Google Sheets every Friday, generates a warm parent-ready narrative using OpenAI (gpt-4o-mini), converts it to a PDF with PDFShift, and sends both PDF and performance updates to parents through Gmail and Telegram. It also logs sends back to Google Sheets, alerts teachers about urgent cases, and notifies your Slack channel if anything fails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly:\u003c\/strong\u003e scheduled for \u003cstrong\u003eFriday at 18:00 UTC\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls student metrics:\u003c\/strong\u003e fetches all rows from a Google Sheets \u003cstrong\u003e“Students”\u003c\/strong\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates progress:\u003c\/strong\u003e computes \u003cstrong\u003eattendance\u003c\/strong\u003e, \u003cstrong\u003eaverage test score\u003c\/strong\u003e, and \u003cstrong\u003ehomework completion\u003c\/strong\u003e percentages, then flags students below configured thresholds (including urgent criteria).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a parent narrative:\u003c\/strong\u003e uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to produce a personalized, parent-friendly report using each student’s metrics and any red flags.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a PDF report:\u003c\/strong\u003e injects the narrative into an \u003cstrong\u003eHTML template\u003c\/strong\u003e and converts it to PDF via the \u003cstrong\u003ePDFShift API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends updates:\u003c\/strong\u003e emails the PDF to each parent via \u003cstrong\u003eGmail\u003c\/strong\u003e, and posts a brief performance summary to parents via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates urgent concerns:\u003c\/strong\u003e if urgent criteria are met, sends an additional high-priority Telegram alert with the specific concerns and posts a consolidated urgent summary to the teacher via Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudits delivery:\u003c\/strong\u003e appends a row to Google Sheets \u003cstrong\u003e“Send Logs”\u003c\/strong\u003e for each student.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e on workflow errors, posts an alert to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel via the workflow error trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly parent updates for tutoring centers, academies, and schools using Google Sheets as the source of truth.\u003c\/li\u003e\n  \u003cli\u003eAutomated progress reporting with GPT-written narrative and measurable metric flagging.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility: Slack alerts for failures and Google Sheets send audit logs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e Google Sheets, OpenAI (gpt-4o-mini), PDFShift, Gmail, Telegram, Slack, plus logic nodes such as \u003cstrong\u003eif\u003c\/strong\u003e and \u003cstrong\u003ecode\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e connect Google Sheets OAuth, set your spreadsheet ID and worksheet names for \u003cstrong\u003e“Students”\u003c\/strong\u003e (read) and \u003cstrong\u003e“Send Logs”\u003c\/strong\u003e (append), and provide credentials for Gmail, Telegram, PDFShift, and OpenAI.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872820060339,"sku":"N8N-18477","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/v3e1PHMg54C6_eHd9AoAn_yT9a4cRk.png?v=1787216979","url":"https:\/\/buyflowscripts.com\/products\/weekly-parent-progress-reports-google-sheets-gpt-4o-mini","provider":"N8N Commerce","version":"1.0","type":"link"}