Client Onboarding Saga Automation with Webhooks & Gmail Alerts

Turn client onboarding into an automated “saga” with Webhooks, Data Tables, and Gmail alerts

This n8n workflow coordinates a full client onboarding saga—starting from a webhook intake, persisting onboarding + step state in n8n Data Tables, reconciling external child outcomes (offer, invoice, booking, and documents), and sending “stranded onboarding” reminders via Gmail every 30 minutes.

What this workflow does

• Receives onboarding requests via a Webhook endpoint and validates an intake token from request headers.
• Normalizes and validates payload data (identity, email, service code, quantity, kickoff slot, and optional document metadata). Invalid requests return 422.
• Persists onboarding state in an n8n Data Table: inserts a new “claimed” onboarding row only when there’s no matching onboarding_id and smoke_tag.
• Ensures step intent records exist by reading existing step rows and inserting only missing intents for: offer, invoice, kickoff booking, signed document, welcome email, and internal checklist.
• Reconciles evidence by fetching matching result rows from the offer, invoice, booking, and document result Data Tables, then updating step states to safe terminal/review/blocked/unknown outcomes.
• Updates the parent onboarding projection back into the Onboardings Data Table when needed, then returns a 202 “saga receipt” with current decisions.
• Runs on a 30-minute schedule to re-read onboarding, step, alert, and child-result tables and adopt late evidence.

Use cases

• Automate onboarding intake for SaaS onboarding workflows using webhook-driven requests.
• Guarantee step-level tracking (offer → invoice → kickoff booking → signed document → welcome email) using Data Tables.
• Detect and resolve “stranded onboarding” cases by sending scheduled Gmail alerts.

Technical details

• Nodes/blocks: if, code, gmail, webhook, data table, sticky note.
• Core storage: n8n Data Tables for Onboardings, step rows, and child-result evidence (offer, invoice, booking, documents).
• Scheduling: every 30 minutes for continuous reconciliation and alerting.