Complete System Architecture: RevOps Intelligence Hub

Overview: How Data Flows Through Your Automation Ecosystem

ENTRY POINT: Lead Capture (Project 1)

Trigger Method: Webhook (Real-time)

What triggers it: Form submission, API call, manual webhook trigger

Data Flow:

`External Form/Source ↓ (webhook POST) Make.com Scenario: "Lead Capture & Scoring Engine" ↓

1. Webhook receives data (name, email, company, etc.)
2. Search Companies table for existing company
3. Router splits:
   • Path 1: Company exists → Link to existing
   • Path 2: Company not found → Create new company first
4. Calculate lead score (job title + company size + revenue + source)
5. Assign sales rep (based on industry/company size)
6. Create Contact record in Airtable
7. Link Contact to Company`

What gets created in Airtable:

• New Contact record (or finds existing)
• New Company record (if doesn't exist)
• Linked relationship between Contact and Company
• Populated fields: Lead Score, Assigned Sales Rep, Lead Status = "New"

When this triggers: Immediately when webhook receives data (real-time)

Airtable tables affected:

• Contacts (create/update)
• Companies (create if new)

PROJECT 2: Lead Nurture & Follow-up Engine

Trigger Method: Schedule (Daily at 9 AM)