Automate Company Data Enrichment with ZoomInfo, Serper, & Oxylabs to Google Sheets

This n8n workflow automates the process of enriching company data by leveraging ZoomInfo, Serper (for Google Search), and Oxylabs (for web scraping) to gather information and then consolidate it into a Google Sheet. It's designed to streamline lead generation, market research, or any process requiring comprehensive company profiles.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated manually, allowing you to control when the enrichment process begins.
2. Reads Company Data from Google Sheets: It fetches a list of companies from a specified Google Sheet, providing the initial data points for enrichment.
3. Loops Over Each Company: For each company retrieved from the Google Sheet, the workflow proceeds to enrich its data.
4. Enriches Data with ZoomInfo: It queries ZoomInfo to retrieve detailed company information.
5. Performs Google Search with Serper: If additional information is needed or as a secondary source, it uses Serper to perform a Google search for the company.
6. Scrapes Web Data with Oxylabs: It then uses Oxylabs to scrape relevant data from websites identified through the Google search or other means, extracting specific HTML content.
7. Processes Scraped HTML with Code: A Code node is used to parse and extract structured data from the raw HTML content obtained from Oxylabs, preparing it for storage.
8. Conditionally Processes Data: An If node likely introduces conditional logic, allowing the workflow to branch based on whether certain data was found or specific criteria are met during the enrichment process.
9. Waits for a Specified Duration: A Wait node is included, likely to introduce a delay between API calls or processing steps, which can be useful for respecting rate limits or allowing external systems to process requests.
10. Updates Google Sheets: Finally, all the enriched and processed data is written back to a Google Sheet, providing a centralized and updated repository of company information.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: With a spreadsheet containing initial company data and permissions for n8n to read and write.
• ZoomInfo API Key: For accessing company data from ZoomInfo.
• Serper API Key: For performing Google searches.
• Oxylabs Account/Credentials: For web scraping capabilities.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials (OAuth2 recommended) for the "Google Sheets" node.
   • Configure HTTP Request nodes (not explicitly shown but implied by ZoomInfo, Serper, Oxylabs) with your respective API keys or authentication methods.
3. Adjust Google Sheets Node: Update the "Google Sheets" node to point to your specific spreadsheet and sheet name where company data is located and where results should be written.
4. Customize Data Extraction:
   • Review and adjust the "HTTP Request" nodes for ZoomInfo, Serper, and Oxylabs to ensure they are making the correct API calls and targeting the right data.
   • Modify the "HTML" node to define the specific CSS selectors or XPath expressions needed to extract the desired data from the scraped web pages.
   • Update the "Code" node to refine the parsing logic for the extracted HTML, if necessary.
5. Configure Conditional Logic: Adjust the "If" node's conditions to match your specific business rules for data processing and routing.
6. Set Wait Times: Modify the "Wait" node's duration if you need to adjust the delay between operations.
7. Execute Workflow: Click "Execute Workflow" to run the process manually.