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