{"product_id":"n8n-onboarding-buddy-pairing-google-sheets-gmail-slack","title":"n8n Onboarding Buddy Pairing: Google Sheets + Gmail \u0026 Slack","description":"\u003ch3\u003eInstant onboarding buddy pairing—automated with Google Sheets, Gmail, and Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n onboarding workflow automatically matches new hires to available onboarding buddies using Google Sheets, records every pairing (or waitlist), and sends the right Gmail + Slack notifications—saving your team hours of manual coordination.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a new buddy request\u003c\/strong\u003e from an n8n form submission with the joiner’s name, work email, and team\/cohort.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your buddy program roster\u003c\/strong\u003e by pulling data from the \u003cem\u003eMentors\u003c\/em\u003e and \u003cem\u003ePairings\u003c\/em\u003e tabs in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates mentor availability\u003c\/strong\u003e by counting active mentees for each mentor, filtering out mentors who are on leave or at capacity, and prioritizing mentors in the joiner’s cohort.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssigns or waitlists\u003c\/strong\u003e: appends a new row to the Google Sheets \u003cem\u003ePairings\u003c\/em\u003e tab marking the request as active with the selected mentor, or as waitlisted when no mentor is available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates mentor status\u003c\/strong\u003e by setting the mentor’s \u003cem\u003elast_assigned\u003c\/em\u003e value in the Google Sheets \u003cem\u003eMentors\u003c\/em\u003e tab when a match is made.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies people automatically\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf matched: sends a dual-intro email via \u003cstrong\u003eGmail\u003c\/strong\u003e to both mentor and joiner (CC’ing the coordinator) and sends the mentor a direct \u003cstrong\u003eSlack\u003c\/strong\u003e message.\u003c\/li\u003e\n      \u003cli\u003eIf waitlisted: posts an alert in the coordinator’s \u003cstrong\u003eSlack\u003c\/strong\u003e channel and shows the joiner a waitlist completion page.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate buddy matching for recurring onboarding cohorts without spreadsheet juggling.\u003c\/li\u003e\n  \u003cli\u003eKeep onboarding introductions timely by sending Gmail + Slack messages immediately after pairing.\u003c\/li\u003e\n  \u003cli\u003eHandle capacity limits and leave status reliably, with waitlisting when needed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2): Mentors + Pairings tabs (tracks active assignments, mentor capacity, and \u003cem\u003elast_assigned\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2): dual-intro email with coordinator CC.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e (credentials): direct mentor message and coordinator waitlist alert.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eform\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837455851699,"sku":"N8N-18262","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/clKZJnanZ-CmSir1-uMoY_RsbyANGv.png?v=1786794520","url":"https:\/\/buyflowscripts.com\/products\/n8n-onboarding-buddy-pairing-google-sheets-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}