{"product_id":"n8n-onboarding-compliance-checker-openai-google-sheets-telegram","title":"n8n Onboarding Compliance Checker: OpenAI + Google Sheets + Telegram","description":"\u003ch3\u003eAutomatically verify new-hire onboarding documents—then alert HR in Telegram\u003c\/h3\u003e\n\u003cp\u003eIntroducing \u003cstrong\u003en8n Onboarding Compliance Checker: OpenAI + Google Sheets + Telegram\u003c\/strong\u003e—an automation workflow that watches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “NewHires” tab, downloads onboarding PDFs from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to validate each required document, and keeps HR updated via \u003cstrong\u003eTelegram\u003c\/strong\u003e with daily follow-ups for anything missing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new hires\u003c\/strong\u003e when a new row is added to the \u003cstrong\u003eNewHires\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetermines required documents\u003c\/strong\u003e by looking up the role-based checklist in the \u003cstrong\u003eChecklist\u003c\/strong\u003e tab and identifying which document links are missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads documents from Google Drive\u003c\/strong\u003e (e.g., \u003cstrong\u003eID Proof\u003c\/strong\u003e, \u003cstrong\u003eTax Form\u003c\/strong\u003e, \u003cstrong\u003eSigned Policy\u003c\/strong\u003e, \u003cstrong\u003eNDA\u003c\/strong\u003e), extracts text from the PDFs, and sends the content to \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e for per-document classification and validation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a structured compliance report\u003c\/strong\u003e by merging the four document review results and running a final OpenAI compliance pass to detect gaps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies HR via Telegram\u003c\/strong\u003e if gaps are found, then updates the employee row in Google Sheets to \u003cstrong\u003ePending\u003c\/strong\u003e with a gap summary and reminder metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirms compliance\u003c\/strong\u003e with a Telegram message and marks the row as \u003cstrong\u003eCompliant\u003c\/strong\u003e when no gaps are detected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily for reminders\u003c\/strong\u003e to find \u003cstrong\u003ePending\u003c\/strong\u003e hires due for follow-up, sends Telegram reminders, and increments a reminder count in Google Sheets—setting an escalation flag after three reminders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors workflow health\u003c\/strong\u003e by triggering on errors and posting an execution alert to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel for operational monitoring.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate onboarding checks for every employee added to your Google Sheet, with HR visibility in Telegram.\u003c\/li\u003e\n  \u003cli\u003eReduce document-review workload by validating PDFs using OpenAI and tracking gaps in-place in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eEnsure follow-ups happen reliably with a scheduled daily reminder loop and escalation after repeated prompts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: triggers on new rows; updates compliance status to \u003cem\u003ePending\u003c\/em\u003e\/\u003cem\u003eCompliant\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e: downloads the onboarding document files referenced in the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e: per-document classification\/validation and final compliance pass.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e: HR alerts for gaps and confirmations for compliant cases; daily reminder notifications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: alerts on workflow errors for monitoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, set, code, merge, slack, telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eIdeal for\u003c\/strong\u003e n8n users, automation engineers, and SaaS operators who need an auditable, document-level compliance workflow with reliable HR follow-up.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741415432371,"sku":"N8N-17605","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/A4CH7orivRgSHcLe-j1p8_ryda9YTe.png?v=1785316068","url":"https:\/\/buyflowscripts.com\/products\/n8n-onboarding-compliance-checker-openai-google-sheets-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}