Automate company data enrichment with ZoomInfo, Serper & Oxylabs to Google Sheets

by Naveen Choudhary ✓ · 883 views · created 2025-08-06 · Lead Generation

What this workflow does

This workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls google.serper.dev and realtime.oxylabs.io over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Load Unprocessed Domains (Google Sheets): uses Google Sheets
2. Process Each Domain (Loop Over Items (Split in Batches)): loops over the items in batches
3. Search ZoomInfo via Serper (HTTP Request): calls google.serper.dev (POST)
4. Check Search Results Found (If): checks a condition and branches into true / false
5. Extract Domain and ZoomInfo URL (Code): runs custom JavaScript code
6. Processing Delay (Wait): pauses before continuing
7. Validate if Domain Matches (If): checks a condition and branches into true / false
8. Mark Domain as Processed (Google Sheets): update
9. Scrape ZoomInfo Page (HTTP Request): calls realtime.oxylabs.io (POST)
10. Extract Company Data (HTML): parses or builds HTML

…plus 3 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: google.serper.dev, realtime.oxylabs.io

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nodes used (8)

• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• HTMLn8n-nodes-base.html
• Waitn8n-nodes-base.wait

From the author

This workflow automatically enriches company domain lists with comprehensive business information scraped from ZoomInfo, organizing the data in Google Sheets for sales teams and researchers. Who's it for - Sales teams building prospect databases with accurate…

View the original on n8n.io → Check your own copy