{"product_id":"n8n-referral-webhook-google-sheets-ledger-thank-you-email","title":"n8n Referral Webhook → Google Sheets Ledger + Thank-You Email","description":"\u003ch3\u003eTurn referral form submissions into a tracked ledger, compliant thank-yous, and monthly reminders—fully automated\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives referral submissions via a \u003cstrong\u003ewebhook\u003c\/strong\u003e, appends them to a \u003cstrong\u003eGoogle Sheets “Referrals” ledger\u003c\/strong\u003e, sends \u003cstrong\u003eplain-text thank-you emails\u003c\/strong\u003e through a compliance\/opt-out guardrail sub-workflow (when a referrer email exists), notifies your firm, and then runs monthly to generate a \u003cstrong\u003ereciprocal-referral reminder digest\u003c\/strong\u003e based on the last 90 days.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives referral submissions\u003c\/strong\u003e via a webhook endpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates payload data\u003c\/strong\u003e, ensuring required referrer details exist before recording anything.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends valid referrals to Google Sheets\u003c\/strong\u003e (the “Referrals” tab) including date, lead details, and referrer metadata (name, email, type, matter type, and status).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends compliant thank-you emails to referrers\u003c\/strong\u003e only when a referrer email is present:\n    \u003cul\u003e\n      \u003cli\u003eGenerates a plain-text thank-you message.\u003c\/li\u003e\n      \u003cli\u003eRoutes it through a \u003cstrong\u003eguardrail sub-workflow\u003c\/strong\u003e (for compliance\/opt-out handling) before delivery via \u003cstrong\u003eSMTP\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails your firm a referral summary\u003c\/strong\u003e via SMTP regardless of whether the thank-you was sent, skipped, or suppressed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on the 1st of every month\u003c\/strong\u003e: reads the full ledger, calculates per-referrer referral counts for the last 90 days, filters referrers that meet the repeat threshold, and sends your firm a \u003cstrong\u003edigest reminder email\u003c\/strong\u003e (also logged via the guardrail workflow).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA law firm capturing partner referrals through a web form and keeping a referral ledger in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing referral tracking while maintaining email compliance and opt-out guardrails.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators needing monthly “reciprocal referral” outreach based on repeat activity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ logic:\u003c\/strong\u003e webhook, code, if, filter, aggregate, no op.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth2) and SMTP (email delivery).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance:\u003c\/strong\u003e guardrail sub-workflow used before sending thank-you\/reminder communications.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931000463539,"sku":"N8N-18995","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rVfEz3GU0sYrNhmKIq2Ra_zvuJsy7v.png?v=1788253235","url":"https:\/\/buyflowscripts.com\/products\/n8n-referral-webhook-google-sheets-ledger-thank-you-email","provider":"N8N Commerce","version":"1.0","type":"link"}