n8n HR Onboarding Automation: Google Sheets, Gmail & Slack

Automate HR onboarding end-to-end with n8n: Google Sheets, Gmail & Slack

This n8n HR onboarding automation watches your Google Sheets for new hire submissions, generates an Application ID, emails the right Google Forms via Gmail, and alerts HR in Slack only when every required onboarding step is completed.

What this workflow does

• Detects new hires by triggering every few minutes when a new row is added to the Google Sheets tab that stores New Hire Form responses.
• Creates an Application ID, determines which supplemental forms are required based on the employee’s answers, and adds a tracking row to a Google Sheets progress tracker.
• Updates your roster by appending the new hire’s core details to a Google Sheets employee roster.
• Sends dependent/commute/income forms through Gmail, using pre-filled Google Forms links (only for the forms required for that employee).
• Tracks supplemental completions: when new rows are added to each supplemental form’s response tab, the workflow matches submissions to the correct progress row using the Application ID, marks that form as submitted, and recalculates whether all required submissions are complete.
• Notifies HR in Slack once the progress tracker row indicates “All Complete”—and updates the tracker to ensure Slack is notified only once.

Use cases

• Onboarding teams that collect new hire, dependents, commute, and prior-employer income data via Google Forms.
• HR operations that need accurate progress tracking and conditional form routing (only send what each employee needs).
• SaaS operators using n8n to coordinate onboarding workflows across Google Sheets, Gmail, and Slack.

Technical details

• Triggers: Google Sheets “new row” events for New Hire and supplemental form response tabs.
• Logic & updates: if and set nodes to generate Application IDs, determine required forms, and update progress/roster rows.
• Email delivery: Gmail to send employees required Google Forms links with pre-filled responses.
• HR notifications: Slack message posting when All Complete becomes true.
• Includes documentation helpers such as Sticky Note for workflow clarity.