{"product_id":"n8n-hr-onboarding-automation-google-sheets-gmail-slack","title":"n8n HR Onboarding Automation: Google Sheets, Gmail \u0026 Slack","description":"\u003ch3\u003eAutomate HR onboarding end-to-end with n8n: Google Sheets, Gmail \u0026amp; Slack\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eDetects new hires\u003c\/b\u003e by triggering every few minutes when a new row is added to the \u003cb\u003eGoogle Sheets\u003c\/b\u003e tab that stores \u003cb\u003eNew Hire Form\u003c\/b\u003e responses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreates an Application ID\u003c\/b\u003e, determines which supplemental forms are required based on the employee’s answers, and adds a tracking row to a \u003cb\u003eGoogle Sheets progress tracker\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates your roster\u003c\/b\u003e by appending the new hire’s core details to a \u003cb\u003eGoogle Sheets employee roster\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends dependent\/commute\/income forms\u003c\/b\u003e through \u003cb\u003eGmail\u003c\/b\u003e, using pre-filled \u003cb\u003eGoogle Forms links\u003c\/b\u003e (only for the forms required for that employee).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTracks supplemental completions\u003c\/b\u003e: when new rows are added to each supplemental form’s response tab, the workflow matches submissions to the correct progress row using the \u003cb\u003eApplication ID\u003c\/b\u003e, marks that form as submitted, and recalculates whether all required submissions are complete.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNotifies HR in Slack\u003c\/b\u003e once the progress tracker row indicates \u003cb\u003e“All Complete”\u003c\/b\u003e—and updates the tracker to ensure Slack is notified only once.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOnboarding teams that collect new hire, dependents, commute, and prior-employer income data via Google Forms.\u003c\/li\u003e\n  \u003cli\u003eHR operations that need accurate progress tracking and conditional form routing (only send what each employee needs).\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to coordinate onboarding workflows across Google Sheets, Gmail, and Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTriggers: \u003cb\u003eGoogle Sheets\u003c\/b\u003e “new row” events for New Hire and supplemental form response tabs.\u003c\/li\u003e\n  \u003cli\u003eLogic \u0026amp; updates: \u003cb\u003eif\u003c\/b\u003e and \u003cb\u003eset\u003c\/b\u003e nodes to generate Application IDs, determine required forms, and update progress\/roster rows.\u003c\/li\u003e\n  \u003cli\u003eEmail delivery: \u003cb\u003eGmail\u003c\/b\u003e to send employees required Google Forms links with pre-filled responses.\u003c\/li\u003e\n  \u003cli\u003eHR notifications: \u003cb\u003eSlack\u003c\/b\u003e message posting when \u003cb\u003eAll Complete\u003c\/b\u003e becomes true.\u003c\/li\u003e\n  \u003cli\u003eIncludes documentation helpers such as \u003cb\u003eSticky Note\u003c\/b\u003e for workflow clarity.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837428228275,"sku":"N8N-18280","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0IxQqkv5IRw4a_6DPHAgq_WaEYmytQ.png?v=1786794109","url":"https:\/\/buyflowscripts.com\/products\/n8n-hr-onboarding-automation-google-sheets-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}