{"product_id":"automated-agent-onboarding-gmail-checklists-from-google-sheets-n8n","title":"Automated Agent Onboarding: Gmail Checklists from Google Sheets (n8n)","description":"\u003ch3\u003eAutomatically onboard new agents every morning with Gmail checklists from your Google Sheet\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your agent roster in Google Sheets, finds every row marked \u003cstrong\u003eStatus = New\u003c\/strong\u003e, and emails each new agent a personalized \u003cstrong\u003eHTML onboarding checklist\u003c\/strong\u003e via Gmail. After sending, it updates the same Google Sheet to set their status to \u003cstrong\u003eOnboarding\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e The workflow executes daily at \u003cstrong\u003e09:00\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration:\u003c\/strong\u003e It pulls the Google Sheets URL, your company name, and an HR email address used in the email content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads and indexes the roster:\u003c\/strong\u003e It loads all agent rows from Google Sheets and computes each row’s sheet row number so it can update the correct entry later.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters new agents:\u003c\/strong\u003e Only agents with \u003cstrong\u003eStatus\u003c\/strong\u003e set to \u003cstrong\u003eNew\u003c\/strong\u003e are selected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends onboarding emails:\u003c\/strong\u003e For each new agent, it sends a personalized \u003cstrong\u003eHTML onboarding checklist\u003c\/strong\u003e through the Gmail node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates status in Google Sheets:\u003c\/strong\u003e Once processed, the workflow updates the corresponding row to set \u003cstrong\u003eStatus = Onboarding\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGrowing support teams where new agents must receive the same onboarding checklist without manual emailing.\u003c\/li\u003e\n  \u003cli\u003eSaaS operations that track agent onboarding stages in a single Google Sheet and need daily automated follow-through.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing onboarding comms while keeping roster management in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger:\u003c\/strong\u003e Runs every day at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Reads the agent roster and updates rows to reflect onboarding status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail:\u003c\/strong\u003e Sends onboarding checklist emails (HTML format) to each agent’s \u003cstrong\u003eEmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter:\u003c\/strong\u003e Selects only rows where \u003cstrong\u003eStatus = New\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e set, gmail, filter, sticky note, google sheets, schedule trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cp\u003eConnect \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e and \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e, update the configuration (sheet URL, company name, HR email), and ensure your sheet includes columns: \u003cstrong\u003eAgent_Name\u003c\/strong\u003e, \u003cstrong\u003eEmail\u003c\/strong\u003e, \u003cstrong\u003eStatus\u003c\/strong\u003e, and \u003cstrong\u003eStart_Date\u003c\/strong\u003e—with new agents marked as \u003cstrong\u003eStatus = New\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761012039859,"sku":"N8N-17816","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PxpKmpaR_bPudKrjzD-Tn_PUqb9h2d.png?v=1785921307","url":"https:\/\/buyflowscripts.com\/products\/automated-agent-onboarding-gmail-checklists-from-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}