{"product_id":"n8n-attendance-alerts-google-sheets-repeat-absences-gmail-approval","title":"n8n Attendance Alerts: Google Sheets Repeat Absences + Gmail Approval","description":"\u003ch3\u003en8n Attendance Alerts: Google Sheets Repeat Absences + Gmail Approval\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks student attendance every morning, detects repeat absences from Google Sheets, and then sends an administrator-approved alert batch to parents and teachers via Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eScheduled run:\u003c\/b\u003e Triggers at \u003cb\u003e08:00\u003c\/b\u003e (Mon–Sat) using the \u003cb\u003eAsia\/Karachi\u003c\/b\u003e timezone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads attendance data:\u003c\/b\u003e Fetches the latest attendance rows from a Google Sheets spreadsheet (from \u003cb\u003eSheet1\u003c\/b\u003e) using \u003cb\u003eformatted values\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates absence patterns:\u003c\/b\u003e For each student marked absent today, it computes:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cb\u003eConsecutive school-day absence streak\u003c\/b\u003e (skips \u003cb\u003eSundays\u003c\/b\u003e and any \u003cb\u003econfigured holidays\u003c\/b\u003e).\u003c\/li\u003e\n      \u003cli\u003e\u003cb\u003eTotal absences in the \u003cb\u003ecurrent month\u003c\/b\u003e.\u003c\/b\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates alerts with thresholds:\u003c\/b\u003e Creates reminder\/warning items when students reach:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cb\u003e3 consecutive absences\u003c\/b\u003e (reminder)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003e5 absences in the month\u003c\/b\u003e (warning)\u003c\/li\u003e\n    \u003c\/ul\u003e\n    It also suppresses repeats if the sheet’s notification field already contains the corresponding threshold marker.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAdministrator approval via Gmail:\u003c\/b\u003e Builds one batch message and sends a \u003cb\u003eGmail “send and wait” approval\u003c\/b\u003e request to the administrator before any notifications go out.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eApproval outcomes:\u003c\/b\u003e If approved, the workflow emails the approved batch to \u003cb\u003eparents and teachers\u003c\/b\u003e (and the administrator). If not approved, it sends a \u003cb\u003eretry approval request\u003c\/b\u003e; if the retry is also not approved, it \u003cb\u003eescalates to the administrator\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSchools that want automated, rules-based attendance escalation without spamming guardians.\u003c\/li\u003e\n  \u003cli\u003eEducation ops teams that require human confirmation before parent\/teacher notifications.\u003c\/li\u003e\n  \u003cli\u003eOperators running n8n to manage compliance-style approval flows using Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations \/ nodes:\u003c\/b\u003e \u003cb\u003eSchedule Trigger\u003c\/b\u003e, \u003cb\u003eGoogle Sheets\u003c\/b\u003e, \u003cb\u003eCode\u003c\/b\u003e, \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eConfiguration:\u003c\/b\u003e Add Google Sheets \u003cb\u003eOAuth2 credentials\u003c\/b\u003e, set the correct \u003cb\u003eAttendance Google Sheet ID\u003c\/b\u003e, ensure data is on \u003cb\u003eSheet1\u003c\/b\u003e, and include the required sheet headers for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCore logic:\u003c\/b\u003e Streak counting (skipping Sundays + configured holidays) and monthly absence totals with threshold-based suppression.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46105955893427,"sku":"N8N-19978","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/39EDmZfP-J251kRRSIuXv_jyf8tFG7.png?v=1790499733","url":"https:\/\/buyflowscripts.com\/products\/n8n-attendance-alerts-google-sheets-repeat-absences-gmail-approval","provider":"N8N Commerce","version":"1.0","type":"link"}