n8n Onboarding Automation: Daily Google Drive Checks, Gmail Alerts & Slack Rollup

Daily Google Drive onboarding checks + Gmail reminders + Slack overdue rollups

This n8n workflow automates your new-hire onboarding document chase: every day at 08:00 it checks each person’s Google Drive intake folder against a role-based requirements matrix, emails missing documents via Gmail with blank form templates attached, and posts an overdue rollup to Slack.

What this workflow does

• Runs on a schedule: executes daily at 08:00.
• Loads configuration: 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.
• Pulls the onboarding roster: reads a paperwork requirement matrix and the onboarding roster (people whose documents are not marked complete) from n8n Data Tables.
• Detects missing documents: 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.
• Manages chase stages: calculates a chase stage (gentle, firm, overdue, complete) and suppresses repeat chases using each person’s last chased date.
• Sends tailored Gmail reminders: when a chase is due, it downloads matching blank form templates from Google Drive, bundles them, and sends a reminder email via Gmail.
• Updates tracking + Slack summary: updates each roster record with chase stage, last chased date, missing list, and completion flag, then posts a single Slack message summarizing only overdue people.

Use cases

• SaaS HR ops teams needing consistent, role-based document collection across locations.
• Automation engineers deploying onboarding workflows that reduce manual follow-ups.
• Operators who want audit-friendly tracking of document status, due dates, and chase stages.

Technical details

• Schedule (runs daily at 08:00)
• n8n Data Tables (requirements matrix + onboarding roster tracking)
• Google Drive (intake folder checks, template downloads)
• Gmail (sends reminders with blank form templates attached)
• Slack (posts overdue rollup to an escalation channel)
• Nodes used: if, set, code, gmail, slack, data table

Setup note: add credentials for Google Drive OAuth2, Gmail OAuth2, and Slack, then replace the placeholders in the configuration step.