Discover enrich decision makers with Apollo and human verifica
🧩 What This Workflow Does This workflow automates the process of identifying and enriching decision-maker contacts from a list of companies. By integrating ...
🔌 Nodes & Integrations Used (5)
📖 Implementation & Setup Guide
🧩 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.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Discover_enrich_decision_makers_with_Apollo_and_human_verifica.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Web Scraping & Data Workflows
View All in Web Scraping & Data →Amazon Data Scraper with Bright Data API
Production-ready n8n automation template for Amazon Data Scraper with Bright Data API built by AhiXLight. Seamlessly connects HTTP Request, Read Write File with 16 configured nodes.
Amazon product search scraper with BrightData GPT 4 and Google
This workflow automates web scraping of Amazon search result pages by retrieving raw HTML, cleaning it to retain only the relevant product elements, and then...
Apify Scrape - Transcribe - Add to Sheet
Production-ready n8n automation template for Apify Scrape - Transcribe - Add to Sheet built by AhiXLight. Seamlessly connects HTTP Request, Limit, OpenAI with 12 configured nodes.
Apollo Scraping
Production-ready n8n automation template for Apollo Scraping built by AhiXLight. Seamlessly connects Execute Workflow Trigger, HTTP Request, Google Sheets with 6 configured nodes.