{"product_id":"n8n-hr-attrition-risk-workflow-sheets-openai-gmail-alerts","title":"n8n HR Attrition Risk Workflow: Sheets + OpenAI + Gmail Alerts","description":"\u003ch3\u003eWeekly HR attrition risk intelligence—powered by Sheets, OpenAI, and real-time alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls your HR datasets from Google Sheets, calculates rule-based attrition risk, enriches results with an OpenAI (GPT-4o-mini) risk assessment, logs everything back to Google Sheets, and sends high-risk Telegram alerts plus a weekly HTML digest email via Gmail.\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 on a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads and merges HR data\u003c\/strong\u003e from Google Sheets tabs: \u003cem\u003eEmployees_Master\u003c\/em\u003e, \u003cem\u003eAttendance\u003c\/em\u003e, \u003cem\u003eEngagement_Survey\u003c\/em\u003e, \u003cem\u003ePerformance_Reviews\u003c\/em\u003e, and \u003cem\u003eOneOnO\u003c\/em\u003e into a single employee profile.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes a rule-based flight\/attrition risk score\u003c\/strong\u003e using rule logic and factors.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds an anonymized payload\u003c\/strong\u003e and sends it to \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e for a structured JSON risk assessment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the JSON response\u003c\/strong\u003e; if parsing fails, it \u003cem\u003efalls back to rule-only scoring\u003c\/em\u003e and notifies an admin via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a composite risk score and risk level\u003c\/strong\u003e by combining rule-based and LLM results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eActs on outcomes\u003c\/strong\u003e by sending a \u003cstrong\u003eTelegram alert\u003c\/strong\u003e and appending flagged employees to \u003cem\u003eGoogle Sheets Risk_Dashboard\u003c\/em\u003e (standard outcomes are also logged).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a weekly HTML digest\u003c\/strong\u003e by reading today’s \u003cem\u003eRisk_Dashboard\u003c\/em\u003e entries and emailing the HR team through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFails safely\u003c\/strong\u003e: if any node errors, an execution alert is posted to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDetect at-risk employees weekly using attendance, engagement, performance reviews, and 1:1 notes from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eProvide HR leadership with an auditable risk dashboard and a consistent weekly email summary.\u003c\/li\u003e\n  \u003cli\u003eCatch malformed AI outputs automatically and revert to rule-based scoring while alerting admins.\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 (OAuth), \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eTelegram\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequires setup:\u003c\/strong\u003e connect Google Sheets OAuth credentials, provide your Sheet ID, and ensure the required tabs exist.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741418414259,"sku":"N8N-17601","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/e4Sl93tz7-bLc8tmJtWlM_HajF65aI.png?v=1785316164","url":"https:\/\/buyflowscripts.com\/products\/n8n-hr-attrition-risk-workflow-sheets-openai-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}