This automation workflow extracts potential clients from new Upwork job listings. It identifies company names or individual freelancers, determines entity type, finds LinkedIn profiles via Phantombuster, retrieves emails using Hunter.io, and stores enriched lead data in Google Sheets — fully automated for scalable outreach.
## Who it´s for
- Freelancers looking for clients on Upwork and wanting to automate contact collection
- SaaS startups needing to find niche customers based on job postings
- Agencies scaling personalized outreach with tailored service offers
- Recruiters building databases of companies and professionals from Upwork
- Salespeople using enriched leads for cold email and LinkedIn engagement
## What the automation does
- Periodically fetches new Upwork job listings via Apify API
- Uses AI (GPT) to extract company or person names from job descriptions
- Classifies the entity as a company or individual
- Searches LinkedIn profiles using Phantombuster and scrapes key details
- Finds email addresses via Hunter.io
- Stores all enriched data in Google Sheets for follow-up
## What´s included
- Ready-to-use n8n workflow with LangChain agent logic
- Cron-based trigger for scheduled execution
- Integrations with Apify, Phantombuster, Hunter.io, Google Sheets, and OpenAI
- Basic text guide for setup and adaptation
## Requirements for setup
- Active accounts: Apify, Phantombuster, Hunter.io, Google Sheets
- Valid API keys for all listed services
- Access to an n8n instance (cloud or self-hosted)
- OpenAI account with API access
## Benefits and outcomes
- Saves up to 10 hours per week on manual lead research
- Builds targeted lead lists with verified contacts in minutes
- Enables high-volume personalized outreach campaigns
- Increases outreach conversion through accurate, enriched data
- Auto-updates lead database every 6 hours (customizable)
- Scales lead generation without added manual effort
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.
lead extraction from Upwork
automated contact collection
scrape Upwork job listings
find email with Hunter io
LinkedIn profile scraping
lead enrichment automation
Google Sheets integration
n8n workflow automation
AI name extraction
freelance lead generation
automated outreach pipeline
company or person classification
Apify API for Upwork
Phantombuster LinkedIn search
AI-powered job parsing
No feedback yet