{"product_id":"n8n-whatsapp-absence-reasons-to-google-sheets-gemini-redis","title":"n8n WhatsApp Absence Reasons to Google Sheets (Gemini + Redis)","description":"\u003ch3\u003eAutomatically message parents on WhatsApp for student absences—then write the reason back to Google Sheets using Gemini + Redis deduplication\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your \u003cstrong\u003eGoogle Sheets attendance tracker\u003c\/strong\u003e daily, sends WhatsApp messages to parents of absent students, and—after interpreting parent replies—updates the \u003cstrong\u003eabsence reasons\u003c\/strong\u003e directly in Google Sheets. It uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for response understanding and \u003cstrong\u003eRedis\u003c\/strong\u003e for buffering, deduplication, and chat memory to keep conversations clean and reliable.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns every day at \u003cstrong\u003e10:30 AM\u003c\/strong\u003e and reads the attendance sheet in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFilters students marked \u003cstrong\u003eabsent\u003c\/strong\u003e who do \u003cstrong\u003enot yet\u003c\/strong\u003e have a recorded reason.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003eWhatsApp\u003c\/strong\u003e message to the student’s parent and stores outbound chat context in \u003cstrong\u003eRedis chat history\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTriggers on incoming WhatsApp messages, extracts details, and replies with a \u003cstrong\u003ewarning if the message is not text\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eRedis\u003c\/strong\u003e to:\n    \u003cul\u003e\n      \u003cli\u003eIgnore duplicate WhatsApp webhooks\u003c\/li\u003e\n      \u003cli\u003eBuffer multiple parent messages for \u003cstrong\u003eup to 5 minutes\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eDebounce rapid replies so only the latest batch is used\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eAcquires a short \u003cstrong\u003eRedis lock per phone number\u003c\/strong\u003e, combines buffered messages, clears the buffer, and then looks up the student record in Google Sheets by \u003cstrong\u003eparent phone number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends the conversation to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (with Redis-based chat memory) to classify whether a \u003cstrong\u003evalid absence reason\u003c\/strong\u003e was provided.\u003c\/li\u003e\n  \u003cli\u003eIf valid, updates the student row in Google Sheets and sends a confirmation WhatsApp reply; otherwise, asks a clarification question.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSchool attendance automation: collect absence reasons from parents via WhatsApp and keep a clean Google Sheets record.\u003c\/li\u003e\n  \u003cli\u003eSaaS ops or automation engineers: reliable WhatsApp webhook handling with Redis deduplication and message buffering.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n\u003c\/strong\u003e workflow with nodes including: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003eRedis\u003c\/strong\u003e, \u003cstrong\u003eWhatsApp\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e read\/update for attendance and absence reasons\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to interpret parent replies\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRedis\u003c\/strong\u003e for deduplication, buffering (up to 5 minutes), debouncing, and chat memory\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46075762901171,"sku":"N8N-19812","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/teCh4Pc6crMoIPoo6uqVu_bGpdsRTt.png?v=1790154651","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-absence-reasons-to-google-sheets-gemini-redis","provider":"N8N Commerce","version":"1.0","type":"link"}