{"product_id":"stripe-connect-referral-commissions-in-google-sheets-n8n","title":"Stripe Connect Referral Commissions in Google Sheets (n8n)","description":"\u003ch3\u003eAutomate Stripe Connect referral commissions from Google Sheets (with n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow detects new Stripe Connect referrers (parrains) from your Google Sheets, creates their Stripe Connect accounts, generates onboarding links, calculates monthly commissions, and pays eligible commissions via Stripe transfers—while sending Gmail onboarding and reminder emails and updating multiple tracking sheets automatically.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt around scheduled runs and Google Sheets as the source of truth, the workflow performs these steps:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetect new referrers (parrains)\u003c\/strong\u003e: On a schedule, it reads recent purchases from the \u003cem\u003eClients actifs\u003c\/em\u003e sheet, parses the “parrain” fields, and groups results by parrain name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicate and retrieve emails\u003c\/strong\u003e: It compares detected parrains against an intermediate sheet to keep only new ones, appends them, then looks up the parrain email in \u003cem\u003eClients actifs\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreate Stripe Connect accounts\u003c\/strong\u003e: If an email is found, it creates a Stripe Connect account via the Stripe API, stores the Stripe account ID and status back in Google Sheets, and generates an onboarding link and email content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend onboarding via Gmail\u003c\/strong\u003e: A daily run reads \u003cem\u003eParrains à contacter Stripe\u003c\/em\u003e, sends the Stripe onboarding email through Gmail when it hasn’t been sent yet, and marks the row as emailed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculate monthly commission eligibility and totals\u003c\/strong\u003e: On a cron schedule (28th at 08:00), it merges \u003cem\u003eClients actifs\u003c\/em\u003e with \u003cem\u003eClients partis\u003c\/em\u003e, marks each filleul as commission-eligible based on purchase age and refund status, aggregates eligible mentions per parrain, and appends new monthly commission rows to \u003cem\u003eCommissions1\u003c\/em\u003e with anti-duplication.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePay eligible commissions\u003c\/strong\u003e: A further scheduled run selects unpaid commissions that have a valid Stripe account, checks Stripe account status, and proceeds with payment via Stripe transfers when eligible.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReferral programs where referrers must be onboarded to \u003cstrong\u003eStripe Connect\u003c\/strong\u003e automatically.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators calculating \u003cstrong\u003emonthly commissions\u003c\/strong\u003e in Google Sheets and paying out via Stripe transfers.\u003c\/li\u003e\n  \u003cli\u003eTeams who want automated \u003cstrong\u003eGmail onboarding\/reminder emails\u003c\/strong\u003e tied to Google Sheets tracking.\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 (multiple sheets: “Clients actifs”, “Clients partis”, intermediate, “Parrains à contacter Stripe”, “Commissions1”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStripe API\u003c\/strong\u003e for Stripe Connect account creation and commission payout via transfers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for onboarding email delivery and status updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e used include: if, set, code, gmail, merge, switch—executed via scheduled and cron runs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45917699211443,"sku":"N8N-18760","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/M4Mnt6d6Nrp4_Ls41x4py_YPIqEJbN.png?v=1788080847","url":"https:\/\/buyflowscripts.com\/products\/stripe-connect-referral-commissions-in-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}