What it is.
The template reads company names from a Google Sheet, calls Apollo's organization search and enrichment, then people search and bulk enrichment to find the titles you asked for. Results land in a Contacts tab, and a separate Contacts (Verified) tab holds only what a human approved.
Apollo's match rate on titles and addresses varies by company size and region, so a template that writes straight into your sequencer inherits every bad match. Nothing reaches your sequencer until a rep approves it. Slack gets a weekly summary of what passed.
What you get.
- A three-tab Google Sheet: companies in, contacts out, verified contacts as the approved set.
- Apollo organization search, organization enrichment, people search, and bulk people enrichment wired in order.
- A conditional branch that skips companies with no Apollo match.
- A Slack node that posts a weekly summary of verified leads.
How to set it up.
Copy the linked Google Sheet so the Companies, Contacts, and Contacts (Verified) tabs keep their exact column names.
Add credentials for Google Sheets, Apollo, Slack, and whichever model you use for title matching.
Point every Sheets node at your copy; the template arrives with the author's sheet IDs and will write nowhere useful until you change them.
Set the job titles and seniority you want in the Apollo people-search node, since the default is broader than most ICPs.
Choose your Slack channel in the notification node and confirm the schedule matches how often you want the summary.
Add one company row and watch it move through all three tabs before you paste in a full list.
Use cases
Build a verified contact set
Feed the company tab and work from the approved tab once a person has checked it.
Keep a human in the loop
Review the enriched contacts before anything reaches a sending tool.
Refresh a stale list
Re-run the search on accounts you last touched a quarter ago.
Best for
Filling in an account list
You have the target companies from a CRM export or an event attendee list, and no names against them.
Keeping a human in the loop
The verified tab means a rep signs off on every contact before it reaches a sequence.
Teams living in Sheets
Nothing here needs a CRM, so it works before you have one.