{"product_id":"n8n-onboarding-automation-daily-google-drive-checks-gmail-alerts-slack-rollup","title":"n8n Onboarding Automation: Daily Google Drive Checks, Gmail Alerts \u0026 Slack Rollup","description":"\u003ch3\u003eDaily Google Drive onboarding checks + Gmail reminders + Slack overdue rollups\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automates your new-hire onboarding document chase: every day at \u003cstrong\u003e08:00\u003c\/strong\u003e it checks each person’s \u003cstrong\u003eGoogle Drive intake folder\u003c\/strong\u003e against a role-based requirements matrix, emails missing documents via \u003cstrong\u003eGmail\u003c\/strong\u003e with blank form templates attached, and posts an \u003cstrong\u003eoverdue rollup to Slack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e: executes daily at \u003cstrong\u003e08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration\u003c\/strong\u003e: uses values for the Google Drive templates folder ID, the Slack escalation channel ID, and the Gmail reply-to address. It also lists blank form templates from the configured Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls the onboarding roster\u003c\/strong\u003e: reads a \u003cem\u003epaperwork requirement matrix\u003c\/em\u003e and the onboarding roster (people whose documents are not marked complete) from \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects missing documents\u003c\/strong\u003e: for each person, it lists files in their Drive intake folder and compares filenames to the required document slugs to determine what’s missing and what’s due.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManages chase stages\u003c\/strong\u003e: calculates a chase stage (\u003cem\u003egentle, firm, overdue, complete\u003c\/em\u003e) and suppresses repeat chases using each person’s last chased date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends tailored Gmail reminders\u003c\/strong\u003e: when a chase is due, it downloads matching blank form templates from Google Drive, bundles them, and sends a reminder email via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates tracking + Slack summary\u003c\/strong\u003e: updates each roster record with chase stage, last chased date, missing list, and completion flag, then posts \u003cstrong\u003ea single Slack message\u003c\/strong\u003e summarizing only \u003cstrong\u003eoverdue\u003c\/strong\u003e people.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS HR ops teams needing consistent, role-based document collection across locations.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying onboarding workflows that reduce manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eOperators who want audit-friendly tracking of document status, due dates, and chase stages.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule\u003c\/strong\u003e (runs daily at 08:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Data Tables\u003c\/strong\u003e (requirements matrix + onboarding roster tracking)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e (intake folder checks, template downloads)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (sends reminders with blank form templates attached)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e (posts overdue rollup to an escalation channel)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: \u003cem\u003eif, set, code, gmail, slack, data table\u003c\/em\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e add credentials for \u003cstrong\u003eGoogle Drive OAuth2\u003c\/strong\u003e, \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e, and \u003cstrong\u003eSlack\u003c\/strong\u003e, then replace the placeholders in the configuration step.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814429974707,"sku":"N8N-17984","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qpvUUfJItgJDte9FZhJzu_vkz8FwOh.png?v=1786439919","url":"https:\/\/buyflowscripts.com\/products\/n8n-onboarding-automation-daily-google-drive-checks-gmail-alerts-slack-rollup","provider":"N8N Commerce","version":"1.0","type":"link"}