{"product_id":"vendor-onboarding-compliance-automation-with-n8n-google-sheets-gmail","title":"Vendor Onboarding \u0026 Compliance Automation with n8n, Google Sheets, Gmail","description":"\u003ch3\u003eAutomate Vendor Onboarding \u0026amp; Compliance Decisions with n8n, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically processes vendor onboarding applications submitted via an n8n form, checks for duplicate registrations in Google Sheets, validates required compliance fields, calculates a compliance risk score, then approves or rejects vendors—while logging results and emailing applicants through Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives vendor applications\u003c\/strong\u003e from an n8n form submission.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates inputs\u003c\/strong\u003e: stamps an application ID and timestamps, then ensures all required vendor data is present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects duplicates\u003c\/strong\u003e: looks up the vendor in the \u003cem\u003eVendor_Master\u003c\/em\u003e Google Sheets sheet using \u003cstrong\u003eTax ID\u003c\/strong\u003e and \u003cstrong\u003eRegistration No\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects duplicate registrations\u003c\/strong\u003e: if a duplicate is found, the workflow logs the rejection in \u003cem\u003eVendor_Onboarding_Log\u003c\/em\u003e and sends an email notification to the applicant via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates mandatory compliance fields\u003c\/strong\u003e when no duplicate exists, including:\n    \u003cul\u003e\n      \u003cli\u003eTax Registration Valid\u003c\/li\u003e\n      \u003cli\u003eBusiness Registration Valid\u003c\/li\u003e\n      \u003cli\u003eBank Details Verified\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes compliance risk\u003c\/strong\u003e: calculates a compliance-based \u003cstrong\u003erisk score\u003c\/strong\u003e and \u003cstrong\u003erisk level\u003c\/strong\u003e, then approves vendors only within a configured threshold.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs decisions and notifies applicants\u003c\/strong\u003e: adds approved vendors to \u003cem\u003eVendor_Master\u003c\/em\u003e and records outcomes in the onboarding log, then sends the final approval\/rejection email via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce manual review time for SaaS vendor onboarding while maintaining consistent compliance checks.\u003c\/li\u003e\n  \u003cli\u003ePrevent duplicate vendor records by enforcing Tax ID + Registration No uniqueness in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eProvide immediate applicant feedback by automatically emailing approved or rejected decisions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: configure your spreadsheet ID in all Google Sheets steps; use \u003cstrong\u003eVendor_Master\u003c\/strong\u003e and \u003cstrong\u003eVendor_Onboarding_Log\u003c\/strong\u003e with the mapped columns.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008723144883,"sku":"N8N-19507","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EmKaZ7rYDR9FMi_7-gUNf_cKDHE88E.png?v=1789203938","url":"https:\/\/buyflowscripts.com\/products\/vendor-onboarding-compliance-automation-with-n8n-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}