Quick overview
Quick overview Turn new clients into structured onboarding records, project handoffs, checklists, welcome emails, and internal team alerts using Google Sheets and Gmail. Includes duplicate detection, risk escalation, and a daily onboarding digest for small agencies. How it works Receives new client details via a webhook endpoint. Validates required fields, normalizes key values, and generates a client ID and project ID. Reads the Clients and Onboarding Config tabs in Google Sheets to detect active duplicates and load default owners and kickoff/SLA rules. Builds an onboarding plan that sets priority and kickoff target date, compiles a checklist, and flags risks like missing info, rush start dates, VIP services, or high budgets. If an active duplicate is found, sends a duplicate-review email via Gmail and returns a JSON response indicating manual review is required. If no duplicate is found, appends new rows to the Clients, Projects, and Onboarding Checklist tabs in Google Sheets, then emails the client a welcome message and the owner an internal handoff summary via Gmail. If the onboarding is flagged as needing attention, logs the issue to the Onboarding Risk Log tab and sends a risk alert email to the project owner, while also returning a JSON response with the created status. Every morning, reads active projects from Google Sheets, compiles a risk digest for overdue kickoff targets, long-running onboardings, or high-risk records, and emails the digest via Gmail when issues are found. Setup Create a Google Sheets spreadsheet with the tabs Clients, Projects, Onboarding Checklist, Onboarding Config, and Onboarding Risk Log using the column headers expected by the workflow. Add Google Sheets OAuth2 credentials in n8n and replace every REPLACE_WITH_GOOGLE_SHEET_ID value with your spreadsheet ID. Add Gmail credentials in n8n and update the placeholder internal email addresses (for example, project-manager@example.com) to your real recipients. Populate the Onboarding Config tab with keys like defaultProjectManager, defaultKickoffDays, rushKickoffDays, vipServices, and optionally highValueBudget. Copy the webhook URL from n8n and configure your form/CRM/checkout tool to POST client intake fields to it. An n8n automation workflow template by Faraz Shoaib.
Faraz Shoaib
web
free
Others in the same category, ranked by how often they are opened.
