Discover & enrich decision-makers with Apollo and human verification
## 🧩 What This Workflow Does
This workflow automates the process of identifying and enriching decision-maker contacts from a list of companies. By integrating with Apollo's APIs and Google Sheets, it streamlines lead generation, ensures data accuracy through human verification, and maintains an organized leads database.
## 📚 Use Case
Ideal for sales and marketing teams aiming to:
- Automate the discovery of key decision-makers (e.g., CEOs, CTOs).
- Enrich contact information with LinkedIn profiles, emails, and phone numbers.
- Maintain an up-to-date leads database with minimal manual intervention.
- Receive weekly summaries of newly verified leads.
## 🧪 Setup
**1.** Google Sheets Preparation:
- Use the following pre-configured Google Sheet: [Company Decision Maker Discovery Sheet](https://docs.google.com/spreadsheets/d/1KqKFZ7Uxrt1MivBjLklGdPRMgNBhEc0slpthoSjt2wI/edit?gid=0#gid=0).
- This spreadsheet includes the necessary tabs and columns: `Companies`, `Contacts`, and `Contacts (Verified)`.
- It also contains a custom `onEdit` Apps Script function that automatically updates the Status column to `Pending` whenever the Domain field is modified.
- To review or modify the script, navigate to __Extensions > Apps Script__ within the Google Sheet.
**2.** Credentials Setup:
- Configure the following credentials in your n8n instance:
- Google Sheets: To read from and write to the spreadsheet.
- Slack: To send verification prompts and weekly reports.
- Apollo: To access the Organization Search, Organization Enrichment, People Search, and Bulk People Enrichment APIs.
- LLM Service (e.g., OpenAI): To generate company summaries and determine departments based on job titles.
**3.** Workflow Configuration:
- Import the workflow into your n8n instance.
- Update the nodes to reference the correct Google Sheet and Slack channel.
- Ensure that the Apollo and LLM nodes have the appropriate API keys and configurations.
**4.** Testing the Workflow:
- Add a new company entry in the Companies tab of the Google Sheet.
- Verify that the workflow triggers automatically, processes the data, and updates the Contacts and Contacts (Verified) tabs accordingly.
- Check Slack for any verification prompts and confirm that weekly reports are sent as scheduled.
