5.5 β Building the lead machine (Make + Airtable + ChatGPT) π₯οΈ
Letβs bring the whole course together into one concrete case, end to end, no code. The goal: turn incoming prospects into qualified opportunities, automatically.
π’ In plain words β ββno-codeββ means without writing a program: you assemble existing tools like Lego bricks. Three bricks are enough β a memory (where to store the info), an orchestration (which triggers the steps), a brain (the AI that decides).
The three building blocks (Level 3):
- π¦ Airtable = the memory (ββLeadsββ table: name, company, message, score, status).
- π§ Make (or n8n) = the orchestration (the workflow that chains the steps).
- π’ ChatGPT (or Claude) = the brain (qualify + write), driven by your Level 2 prompt.
The workflow:
- Trigger β a prospect fills in a form β a row is created in Airtable.
- Qualification β ChatGPT reads the message and rates the lead hot / warm / cold (structured prompt, 4 ingredients from Level 2).
- Memory β the score is written back to Airtable.
- Action β if hot β personalized email; if warm β follow-up sequence; if cold β archiving.
- Guardrails (Level 4):
- filter on the incoming message (against indirect injection: a booby-trapped message slipped into data the agent reads β recall from Level 4) ;
- HITL before sending emails ;
- minimal Airtable read/write permissions ;
- execution history for traces.
π The whole course in one image: concept (L1) β prompt (L2) β agent that acts (L3) β secured agent (L4) β machine that makes money (L5). The same idea, raised a notch at each level.
π° Why itβs worth money: a salesperson who only handles hot leads (pre-qualified by the agent) converts more in less time. Calculating the gain is the subject of the next demo (5.6) and your workshop (5.10).
β³ Freshness note: the AI building blocks in Make, n8n and Airtable evolve fast. The assembly β orchestration + memory + brain + guardrails β remains valid.
β οΈ Common mistake β wanting to automate everything at once, without HITL, from day one. An agent that sends emails to real customers without review can ship an awkward or off-topic message at scale. You start with a human who validates before sending, then loosen the reins once trust is established.
β Check your understanding β In the lead machine, which brick plays the role of the brain, and which Level of the course tells it how to think?
See the answer
The brain is the AI (ChatGPT or Claude): it reads the message and qualifies the lead. What tells it how to think is the structured prompt from Level 2 (the 4 ingredients: role, context, task, format). Without a good prompt, even a good brain answers poorly.
β In short
- The lead machine = 3 bricks: memory (Airtable) + orchestration (Make) + brain (AI).
- The workflow: trigger β qualification β memory β action, with guardrails (L4).
- Itβs the whole course brought together: concept β prompt β agent β secured agent β business value.
π Going further
Why separate ββorchestrationββ and ββbrainββ instead of handing everything to the AI? Because orchestration (Make/n8n) is deterministic and reliable: it always triggers the same steps in the same order, and keeps a trace of each run (useful for Level 4 observability). The AI, on the other hand, is creative but unpredictable: you confine it to the one step where you need judgment (qualify, write). This split β deterministic around an AI core β is a recurring pattern of reliable agentic systems.
π My note
A training byBaxIA