Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Google Sheets Trigger
  2. Apollo Organization Enrichment
  3. Create Apollo People Search URL
  4. Loop Over Items (1000 per Batch)
  5. Apollo Find Decision Makers
  6. Add Contacts
  7. Apollo Enrich Decision Makers
  8. Create Apollo People Enrichment Payload
  9. Enrich Contacts
  10. Loop Over Items For Bulk Enrichment (10 per batch)
  11. Determine Contact's Department
  12. Apollo Organization Search
  13. Add Company Website
  14. Approve Company Website

56 steps in total.

Similar automations