n8n Lead Generation Sales Data Extraction
Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.
Scrape Glassdoor with Bright Data
Designed for sales teams, recruiters, and marketers aiming to automate job discovery and prospecting. This workflow scrapes Glassdoor job listings using Bright Data and automatically generates targeted pitches using AI, streamlining lead identification and outreach.
How It Works
This automation leverages n8n, Bright Data, Google Sheets, and OpenAI:
1. Trigger
Starts with a custom form input (Location, Keyword, Country).
2. Bright Data Job Scrape
Triggers a Bright Data dataset snapshot via HTTP Request.
Polls snapshot progress using a Wait node, ensuring data readiness.
Retrieves full job listings dataset once ready.
3. Google Sheets Integration
Writes detailed job data (company, role, location, overview, metrics) into a Google Sheet.
Uses a pre-built template for organized data storage.
4. Automated Pitch Generation (AI)
Splits listings into actionable parts: company name, title, and description.
Sends data to OpenAI (via LangChain) to generate relevant pitches or icebreakers.
Saves generated content back into the same sheet for easy access.
Requirements
Ensure you have the following:
- Google Sheets
- Google account
- Template Sheet with columns for job details and AI-generated pitches
- Bright Data
- Active account with Dataset API access
- API key and dataset ID
- OpenAI
- Valid OpenAI API key for GPT models
- n8n Environment
- Nodes: HTTP Request, Wait, If, Google Sheets, Split Out, LangChain (OpenAI)
- Credentials:
- Google Sheets OAuth2
- Bright Data API credentials
- OpenAI API key
Setup InstructionsStep 1: Prepare Google Sheets
Copy the provided Google Sheets template.
Do not change headers.
Step 2: Import & Configure Workflow in n8n
Import the workflow JSON file.
Set Google Sheets node:
Link to your copied sheet.
Confirm correct tab name.
Step 3: Configure Bright Data
Replace <YOUR_BRIGHT_DATA_API_KEY> with your real key.
Set your dataset ID in all HTTP Request nodes.
Step 4: Configure OpenAI (LangChain)
Connect OpenAI API key to the LangChain node.
Customize prompt to match tone and outreach style.
Step 5: Testing & Scheduling
Test via manual form trigger.
Schedule runs or leave form enabled for on-demand use.
Tips & Best Practices
- Use specific keywords and locations for better results.
- Adjust polling intervals based on dataset size.
- Refine AI prompts regularly to improve pitch quality.
- Clean unused columns from your sheet to boost performance.
Support & Feedback
For help or customization:
Email: [email protected]
YouTube: @YaronBeen
LinkedIn: linkedin.com/in/yaronbeen
Bright Data Docs: docs.brightdata.com/introduction
Tools used: Bright Data, Google Sheets, OpenAI
Download the workflow template (JSON)
Want this running in your business? KOBA42 builds and operates automations like this one.