Contact Enrichment Automation using Apollo and Google Sheets - n8n Workflow

• Sales Operations Teams: Who need to systematically enrich company data with specific contact roles (e.g., procurement).
• B2B Researchers: Needing scalable, automated methods for data sourcing and validation.
• n8n Users: Looking for proven n8n templates utilizing complex flow control, HTTP requests, and Google Sheets operations.
• Data Engineers: Requiring a scheduled n8n workflow to maintain and update contact databases automatically.

Maintaining a clean and comprehensive database of relevant contacts is crucial for B2B outreach. This specialized n8n workflow solves the problem of manual contact searching and data entry. It operates entirely automatically, using an n8n trigger to initiate the enrichment process at scheduled intervals. By leveraging the power of Apollo.io, the workflow efficiently searches for individuals based on predefined criteria (like job title or department, implicitly Procurement) using Company IDs retrieved from Google Sheets. The use of the n8n platform ensures reliable data transfer and processing, providing a high-value n8n template for any organization focused on lead generation and data quality. Error handling is built-in, utilizing an error n8n node to send instant notifications via Telegram if any part of the n8n workflow fails.

This automation initiates with a scheduled n8n trigger, configured to run every X minutes or hours to maintain a continuous enrichment pipeline.

1. Trigger and Data Retrieval: The Run Every X Minutes n8n trigger starts the process. The first action is using the Google Sheets n8n node (Get Apollo Company ID) to retrieve the next batch of company IDs requiring enrichment from a dedicated spreadsheet.


2. Filter Generation: A Set n8n node (Define Search Settings) prepares baseline parameters, which are then passed to a Code n8n node (Build Search Filters). This node dynamically constructs the complex JSON payload needed to search the Apollo API, ensuring accurate targeting of contacts (e.g., Procurement).


3. Apollo Search: The Search People in Apollo HTTP Request n8n node queries Apollo.io for people associated with the company ID, matching the dynamically built filters.


4. Flow Decision: An If n8n node (Check if Any People Found) determines the next step. If contacts are found, the flow proceeds to step 5. If no contacts are found, the company ID is marked as processed via the Mark Company as Processed (No Person Found) Google Sheets n8n node, and the n8n workflow pauses briefly before looping back to fetch the next ID.


5. Detail Extraction and Saving: If contacts are found, the SplitOut n8n node (Process Each Person One by One) iterates through each contact record. The Get Person Contact Details HTTP Request n8n node fetches the full profile, including sensitive contact information. This enriched data is then saved using the Save Person to Google Sheet n8n node.


6. Completion and Loop: After saving all contacts for a company, the original company ID is marked as 'Processed' in the source sheet using the Mark Company as Processed n8n node. A Wait n8n node (Pause Before Next Run) is used for rate limiting or sequencing before the entire n8n workflow loops back to the Get Apollo Company ID n8n node to fetch the next item, ensuring the batch is processed efficiently.

1. Importing the n8n Template: Copy the provided n8n workflow JSON data and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credential Setup: This n8n workflow requires credentials for:

1. Configuration: Update the Schedule Trigger n8n node to set your desired execution frequency. Review the Code n8n nodes to ensure search filters and error messages match your specific data requirements. Once configured, activate the n8n workflow.

Run Every X Minutes (Schedule Trigger): The primary n8n trigger that initiates the periodic execution of this data enrichment n8n workflow.
Get Apollo Company ID (Google Sheets): This n8n node connects to the data source, pulling unprocessed Company IDs that need contact enrichment.
Build Search Filters (Code): A custom n8n node responsible for executing JavaScript logic to dynamically build the complex search criteria required by the Apollo API, ensuring accurate results.
Search People in Apollo (HTTP Request): This is the core enrichment n8n node, sending the filtered request to the Apollo API to find potential contacts.
Check if Any People Found (If): A critical flow control n8n node that branches the n8n workflow based on whether contact data was returned by Apollo.
Process Each Person One by One (Split Out): A foundational n8n node for iteration, ensuring that subsequent steps are executed individually for every contact found.
Save Person to Google Sheet (Google Sheets): The sink n8n node where the complete, enriched contact data (including contact details retrieved) is securely written back to your database sheet.
Catch Workflow Error (Error Trigger): A specialized n8n trigger used for reliable error monitoring across the n8n workflow. It intercepts failures and reroutes the flow to the Telegram notification path.

• Send Alert to Telegram (Telegram): An outreach n8n node used to instantly notify administrators of any critical failures or issues encountered during the execution of this n8n template.