{"product_id":"fitness-class-attendance-tracker-n8n-google-sheets-gmail-discord","title":"Fitness Class Attendance Tracker: n8n + Google Sheets, Gmail \u0026 Discord","description":"\u003ch3\u003eTurn fitness check-ins into automated member follow-up—with n8n, Google Sheets, Gmail, and Discord\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures fitness class attendance via a webhook, matches members in Google Sheets, uses OpenAI to classify engagement and draft a short message, logs results back to Google Sheets, and sends automated alerts through Gmail and Discord—plus a weekly retention report.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives check-ins via webhook\u003c\/strong\u003e: Accepts a POST webhook event containing \u003cem\u003emember_id\u003c\/em\u003e, \u003cem\u003eclass_name\u003c\/em\u003e, \u003cem\u003estatus\u003c\/em\u003e, and optional \u003cem\u003enotes\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and handles missing data\u003c\/strong\u003e: Normalizes the payload, rejects missing required fields, and immediately alerts the studio via \u003cstrong\u003eDiscord\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e for invalid entries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches members in Google Sheets\u003c\/strong\u003e: Looks up \u003cstrong\u003eMemberRoster\u003c\/strong\u003e by \u003cem\u003emember_id\u003c\/em\u003e. If the member isn’t found, it alerts on \u003cstrong\u003eDiscord\u003c\/strong\u003e and emails the studio address via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI engagement labeling \u0026amp; message drafting\u003c\/strong\u003e: Sends the matched member plus check-in context to an \u003cstrong\u003eOpenAI-powered agent\u003c\/strong\u003e to label engagement (e.g., \u003cem\u003eat_risk\u003c\/em\u003e, \u003cem\u003enew\u003c\/em\u003e, \u003cem\u003eengaged\u003c\/em\u003e) and generate a short personalized message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs attendance\u003c\/strong\u003e: Appends check-in details, the engagement label, and the generated message to \u003cstrong\u003eAttendanceLog\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomated member communication\u003c\/strong\u003e: Emails the generated message to the member via \u003cstrong\u003eGmail\u003c\/strong\u003e and posts a \u003cstrong\u003eDiscord retention alert\u003c\/strong\u003e when the member is flagged for attention (for example, a no-show).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly retention digest\u003c\/strong\u003e: Every Monday morning, computes weekly attendance and churn-risk stats from Google Sheets, uses OpenAI to write a short digest, then emails it via Gmail and posts it to Discord.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate studio member check-in processing from an app or kiosk.\u003c\/li\u003e\n  \u003cli\u003eTrigger AI-based outreach when members miss classes or show at-risk patterns.\u003c\/li\u003e\n  \u003cli\u003eGenerate a weekly churn-risk report for studio operations without manual reporting.\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\u003ewebhook\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eGmail\u003c\/em\u003e, \u003cem\u003eDiscord\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tabs \u003cem\u003eMemberRoster\u003c\/em\u003e and \u003cem\u003eAttendanceLog\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI component\u003c\/strong\u003e: OpenAI agent for engagement classification and short message\/digest generation\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45917694623923,"sku":"N8N-18763","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cAX3HcTYBRvxyXiMOivKO_zJWB04Lj.png?v=1788080781","url":"https:\/\/buyflowscripts.com\/products\/fitness-class-attendance-tracker-n8n-google-sheets-gmail-discord","provider":"N8N Commerce","version":"1.0","type":"link"}