Stripe Connect Referral Commissions in Google Sheets (n8n)

Automate Stripe Connect referral commissions from Google Sheets (with n8n)

This 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.

What this workflow does

Built around scheduled runs and Google Sheets as the source of truth, the workflow performs these steps:

• Detect new referrers (parrains): On a schedule, it reads recent purchases from the Clients actifs sheet, parses the “parrain” fields, and groups results by parrain name.
• Deduplicate and retrieve emails: It compares detected parrains against an intermediate sheet to keep only new ones, appends them, then looks up the parrain email in Clients actifs.
• Create Stripe Connect accounts: 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.
• Send onboarding via Gmail: A daily run reads Parrains à contacter Stripe, sends the Stripe onboarding email through Gmail when it hasn’t been sent yet, and marks the row as emailed.
• Calculate monthly commission eligibility and totals: On a cron schedule (28th at 08:00), it merges Clients actifs with Clients partis, 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 Commissions1 with anti-duplication.
• Pay eligible commissions: 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.

Use cases

• Referral programs where referrers must be onboarded to Stripe Connect automatically.
• SaaS operators calculating monthly commissions in Google Sheets and paying out via Stripe transfers.
• Teams who want automated Gmail onboarding/reminder emails tied to Google Sheets tracking.

Technical details

• Google Sheets (multiple sheets: “Clients actifs”, “Clients partis”, intermediate, “Parrains à contacter Stripe”, “Commissions1”).
• Stripe API for Stripe Connect account creation and commission payout via transfers.
• Gmail for onboarding email delivery and status updates.
• n8n nodes used include: if, set, code, gmail, merge, switch—executed via scheduled and cron runs.