- Zapier
- Youform
- Apollo
- Webhooks
- Google Sheets
- Slack
- Gmail
- AI by Zapier
// THE BRIEF
A consulting firm that helps sales teams automate lead qualification needed a workflow that captures leads in real time, enriches them with company data from an external API, scores and prioritizes them, stores the results, alerts the sales team to high-priority leads, and drafts personalized outreach with an LLM.
// WHAT I BUILT
One Zap with 11 steps. A form submission starts it, the Apollo API enriches the company data, and Paths split each lead into High or Low priority.
Zap overview: 11 steps, 2 paths
| Stage | What the Zap does |
|---|---|
| Lead intake | A Youform submission starts the Zap and captures the lead's details. |
| Cleanup | Formatter extracts the company URL so the lead can be matched for enrichment. |
| Enrichment | A webhook calls the Apollo API and retrieves additional company information. |
| Scoring and routing | Paths split leads into High priority (company size of 10,000 or more) and Low priority (everything else). |
| High priority | Saves the lead to Google Sheets, alerts the sales team in Slack, has AI write a personalized email, and sends it through Gmail. |
| Low priority | Sends the sales team a notification by Gmail. |
Pipeline Stages & Zap Actions
A Youform submission starts the Zap and captures the lead's details.
Formatter extracts the company URL so the lead can be matched for enrichment.
A webhook calls the Apollo API and retrieves additional company information.
Paths split leads into High priority (company size of 10,000 or more) and Low priority (everything else).
Saves the lead to Google Sheets, alerts the sales team in Slack, has AI write a personalized email, and sends it through Gmail.
Sends the sales team a notification by Gmail.
// KEY DECISIONS
- Calling Apollo through a webhook step instead of a built-in app step gives control over the request and shows the workflow isn't limited to Zapier's native integrations.
- Separate High and Low paths put the sales team's attention on the leads that matter first, while low-priority leads still reach them.
- The AI email draws on the enriched company data, so outreach is specific to each lead and not a generic template.
// TESTING
I tested the workflow with a test lead from Shopee. Apollo returned the company data, the lead was routed to High Priority, and a notification appeared in a Slack channel I created for a mock sales team.
Slack alert for a High Priority test lead
// WHAT I'D CHANGE FOR PRODUCTION
- Log low-priority leads too, with their priority label, so no lead is lost
- Send the AI email to a sales rep for approval as a draft, instead of sending it automatically
// OUTCOME
What this workflow delivers
- New leads are enriched automatically with company and contact details from Apollo, so nobody researches them by hand.
- Each lead is scored and sent down the right path (qualified, needs review, or not a fit), so the sales team looks at the best leads first.
- Qualified leads are saved to a sheet and posted to Slack right away, with an AI-drafted follow-up email ready to review.
Tested end to end with sample leads. In a live setup I’d track time-to-first-contact and the share of qualified leads.
Practice project based on a real-world brief.