SOP 0: CRM Overview — How Leads Flow Through Our System
SOP 0: CRM Overview — How Leads Flow Through Our System
The Complete Lead Lifecycle:
- CAPTURE — A prospect fills out the interest form on the Regenesis website (WordPress). They provide their name, email, company, budget range, and what they are interested in.
- GOOGLE SHEET — The form submission automatically lands in the Google Sheet "Website Interest forms - May 2024 onwards". This sheet is the single source of truth for all inbound leads. DO NOT modify, rename, or restructure this sheet — all CRM automations depend on it.
- n8n AUTOMATION — One of 16 active CRM workflows in n8n detects the new row and creates a task in the ClickUp Sales Pipeline. The lead's details are mapped to ClickUp custom fields.
- BUDGET FILTER — The system checks the stated budget. Leads with 150k+ budget are auto-qualified. Below-threshold leads receive a comment noting "Below budget threshold" and are routed differently (they still exist in the pipeline but don't trigger the full qualification sequence).
- AI RESEARCH — For qualified leads (150k+), an AI-powered research workflow auto-triggers. It profiles the lead's company, industry, recent news, key people, and potential fit. The research output is posted as a detailed comment on the ClickUp task.
- WELCOME EMAIL — A personalised welcome email is automatically sent to qualified leads, acknowledging their interest and setting expectations for next steps. The lead is marked "warm" in ClickUp.
- MAILCHIMP NURTURE — Qualified leads sync from ClickUp > Google Sheets > Mailchimp for ongoing email campaigns. They are added to the appropriate regional mailing list and nurture sequence. Unsubscribes auto-sync back to ClickUp.
- BOOKING — When a lead books a demo or consultation via Calendly, the booking syncs back to ClickUp via Google Calendar integration and updates the lead's status automatically.
- VIDEO TESTIMONIALS — The system matches video testimonials to lead records, so sales can reference relevant social proof during outreach.
- CLOSE — Justin and the sales team work the lead through discovery, proposal, negotiation, and close using ClickUp as the single dashboard for all pipeline activity.
Key Tools in the Stack:
- Website (WordPress): Lead capture forms — the front door
- Google Sheets: Source of truth for form submissions — never touch the structure
- n8n: 16 active CRM workflows handling all automation between tools
- ClickUp: Sales pipeline management, task tracking, lead status, comments, custom fields
- Mailchimp: Email campaigns, nurture sequences, regional mailing lists
- Calendly / Google Calendar: Demo and consultation scheduling with auto-sync
- AI Research: Automated lead profiling triggered on qualified leads
Steps:
- When onboarding a new team member to sales, walk them through this document
- Show them the ClickUp Sales Pipeline board view — this is where they will live
- Explain the difference between automated steps (system handles) and manual steps (human action needed)
- Point them to SOPs 1-5 for detailed procedures on each stage
- Have them shadow Justin on 2-3 lead reviews before working independently
What the System Does Automatically:
- Captures website form submissions into Google Sheets
- Creates ClickUp tasks from new form entries
- Filters leads by budget (150k+ threshold)
- Runs AI research on qualified leads
- Sends welcome emails to qualified leads
- Syncs leads to Mailchimp nurture lists
- Updates ClickUp when Calendly bookings are made
- Matches video testimonials to lead records
- Handles unsubscribe sync between Mailchimp and ClickUp
What Humans Do:
- Review AI research and add personal insights
- Make qualification judgment calls on edge cases
- Conduct discovery calls and demos
- Send personalised follow-ups after demos
- Negotiate and close deals
- Update deal stage in ClickUp as conversations progress
- New team member can trace a lead from website form to close without asking questions
- All tools in the stack are understood at a high level
- The distinction between automated and manual steps is clear
- Team member knows which SOP to reference for each stage
- Lead not appearing in ClickUp after form submission: Check the Google Sheet first — if the row is there, the n8n workflow may have failed. Check n8n execution logs for the CRM capture workflow.
- Leads not appearing in Mailchimp: Check the sync workflow in n8n. Verify the Google Sheet intermediate step has the correct data.
- Calendly bookings not updating ClickUp: Check the Calendly-ClickUp sync workflow in n8n. Verify the Google Calendar integration is active.
- AI research not running: Check the AI research trigger workflow in n8n. It only fires for 150k+ budget leads.
- Escalation: Contact Barrie for system/automation errors, Justin for sales process decisions.
v2 — April 2026 | Pending review by: Justin, Florian