n8n Onboarding Workflow: Google Sheets, Gmail & Slack

Automatically onboard new employees with Google Forms, Google Sheets, Gmail, and Slack

This n8n onboarding workflow automatically creates an Application ID for every new hire, updates your Google Sheets progress tracker and employee roster, sends the required Google Forms links via Gmail, and notifies HR in Slack when all required forms are completed.

What this workflow does

• Starts from Google Sheets intake: Triggers when a new row is added to your new-hire intake Google Sheets response sheet.
• Creates tracking and determines requirements: Generates a unique Application ID, reads the intake answers, and determines whether dependents, commute, and prior-employer forms are required. It then appends a tracking row to the progress tracker.
• Updates the employee roster: Appends the new hire’s core details to your employee roster Google Sheets tab.
• Sends required supplemental forms: Uses Gmail to email one or more messages containing pre-filled Google Forms links (including the Application ID) for every supplemental form marked as required.
• Marks submissions automatically: Triggers when new rows are added to each supplemental form’s Google Sheets response sheet, looks up the matching progress-tracker row by Application ID, and marks each form as submitted.
• Notifies HR only when complete: When the progress tracker updates—and Slack hasn’t been notified yet—it posts a message in Slack and updates the tracker to confirm Slack notification.

Use cases

• HR teams managing onboarding checklists across multiple Google Forms.
• Automation engineers standardizing onboarding workflows for every new employee.
• SaaS operators reducing manual follow-ups by emailing form links and tracking completion.

Technical details

• Triggers and actions using Google Sheets (intake responses, supplemental form responses, progress tracker, and employee roster tabs).
• Gmail emails with pre-filled Google Forms links that include the Application ID.
• Slack notification posted once all required forms are complete.
• Logic and workflow flow implemented with nodes including if, set, and sticky note.
• Setup requires Google OAuth for both Google Sheets access and the Google Sheets Trigger nodes, plus configuration of the relevant document IDs and sheet tabs.