Enrich seller data with email domain lookup using Bright Data
π Email Lookup with Google Search from Postgres Database This N8N workflow is designed to enrich seller data stored in a Postgres database by performing aut...
π Nodes & Integrations Used (3)
π Implementation & Setup Guide
π Email Lookup with Google Search from Postgres Database
This N8N workflow is designed to **enrich seller data** stored in a Postgres database by performing automated **Google search lookups**. It uses **Bright Data's Web Unlocker** to bypass search result restrictions and the **HTML Extract node** to parse and extract relevant information from webpages.
The main purpose of this workflow is to discover **missing contact details, company domains, and secondary emails** for businesses or sellers based on existing database entries.
---
π― Problem This Workflow Solves
Manually searching for missing seller or business detailsβlike secondary emails, websites, or domain namesβcan be time-consuming and inefficient, especially for large datasets. This workflow automates the search and data enrichment process, significantly reducing manual effort while improving the quality and completeness of your seller database.
---
β Prerequisites
Before using this template, make sure the following requirements are met:
* βοΈ A Bright Data account with access to the **Web Unlocker** or **Amazon Scraper API** * βοΈ A valid Bright Data API key * βοΈ An active **PostgreSQL** database with seller data * βοΈ **N8N self-hosted** instance (recommended for using community nodes like `n8n-nodes-brightdata`) * βοΈ Installed `n8n-nodes-brightdata` package (custom node for Bright Data integration)
---
βοΈ Setup Instructions
Step 1: Prepare Your Postgres Table
Create a table in Postgres with the following structure (you can adjust field names if needed):
```sql CREATE TABLE sellers ( seller_id SERIAL PRIMARY KEY, seller_name TEXT, primary_email TEXT, company_info TEXT, trade_name TEXT, business_address TEXT, coc_number TEXT, vat_number TEXT, commercial_register TEXT, secondary_email TEXT, domain TEXT, seller_slug TEXT, source TEXT ); ```
Step 2: Setup Web Unlocker on Bright Data
- Go to your Bright Data dashboard.
- Navigate to **Proxies & Scraping β Web Unlocker**.
- Create a new zone, selecting **Web Unlocker API** under **Scraping Solutions**.
- Whitelist your server IP if required.
Step 3: Generate API Key
- In the Bright Data dashboard, go to the **API** section.
- Generate a new API key.
- In N8N, create **HTTP Request Credentials** using Bearer Authentication with the API key.
Step 4: Install the Bright Data Node in N8N
- In your N8N self-hosted instance, go to **Settings β Community Nodes**.
- Search and install `n8n-nodes-brightdata`.
---
π Workflow Functionality
* π **Trigger**: Can be set to run on a schedule (e.g., daily) or manually. * π₯ **Read**: Fetches seller records from the Postgres table. * π **Search**: Uses Bright Data to perform a Google search based on `seller_name`, `company_info`, or `trade_name`. * π§Ύ **Extract**: Parses the HTML content using the **HTML Extract node** to identify potential websites and email addresses. * π **Update**: Writes enriched data (like `domain` or `secondary_email`) back to the Postgres table.
---
π‘ Use Cases
* Lead enrichment for e-commerce sellers * Domain and contact info discovery for B2B databases * Email and web domain verification for CRM systems * Market research automation
---
π οΈ Customization Tips
* You can enhance the parsing logic in the **HTML Extract** node to look for phone numbers, LinkedIn profiles, or social media links. * Modify the search query logic to include additional parameters like `location` or `industry` for more refined results. * Integrate additional APIs (e.g., Hunter.io, Clearbit) for email validation or social profile enrichment. * Add filtering to skip entries that already have `domain` or `secondary_email`.
β‘ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Enrich_seller_data_with_email_domain_lookup_using_Bright_Data.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Social Media & Content Workflows
View All in Social Media & Content βAI Auto-Tagging for WordPress Posts
Production-ready n8n automation template for AI Auto-Tagging for WordPress Posts built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Output Parser Autofixing, Output Parser Structured with 32 configured nodes.
AI Auto-Tagging for WordPress Posts
Production-ready n8n automation template for AI Auto-Tagging for WordPress Posts built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Output Parser Autofixing, Output Parser Structured with 32 configured nodes.
AI Image Caption Generator Overlay
Production-ready n8n automation template for AI Image Caption Generator Overlay built by AhiXLight. Seamlessly connects Lm Chat Google Gemini, Output Parser Structured, Edit Image with 16 configured nodes.
AI Image Caption Generator with Overlay
Production-ready n8n automation template for AI Image Caption Generator with Overlay built by AhiXLight. Seamlessly connects Lm Chat Google Gemini, Output Parser Structured, Edit Image with 16 configured nodes.