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. - 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.