Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Find Company Decision Makers with Apollo and Notify Slack
When a company is added in Google Sheets or on a schedule, it enriches it with Apollo, finds decision makers with OpenAI help and alerts Slack.
What it does
# 🏢 Company Decision Maker Discovery This workflow processes a list of companies (optionally with their websites to improve search accuracy) and outputs a curated list of decision-makers (e.g., CEO, COO, CTO, VP, Director) along with their contact information (LinkedIn, email, phone) into a structured leads database. It also sends out a weekly report to a Slack channel, specifying the number of verified leads generated over the past week. Here's the [Google Sheet]({{ $env.WEBHOOK_URL }} template for this workflow. You can explore the Apps Script code in the sheet via Extensions > App Script
The steps
- Google Sheets Trigger
- Apollo Organization Enrichment
- Create Apollo People Search URL
- Loop Over Items (1000 per Batch)
- Apollo Find Decision Makers
- Add Contacts
- Apollo Enrich Decision Makers
- Create Apollo People Enrichment Payload
- Enrich Contacts
- Loop Over Items For Bulk Enrichment (10 per batch)
- Determine Contact's Department
- Apollo Organization Search
- Add Company Website
- Approve Company Website
56 steps in total.
Similar automations
Lead Generation & EnrichmentFind Decision-Makers with Apollo, OpenAI and Slack Review25 stepsEmail AutomationFind decision makers and published emails from company pages with Apify and OpenAI35 stepsLead Generation & EnrichmentFind Job Posts and Decision Makers with Apify18 stepsLead Generation & EnrichmentFind Emails from Company Domains with Apollo and Sheets9 steps