Upwork Job Scraper & Daily Email Reports with Apify & Google Sheets

This n8n workflow scrapes job listings from Upwork using Apify's reliable web scraping APIs, fetches keywords from a Google Sheet for targeted searches, processes and deduplicates the data, stores it in Sheets for easy management, and generates structured daily email reports with job summaries and market insights.

Key benefits include hands-free monitoring of relevant freelance opportunities, time savings on manual job hunting, compliance-friendly scraping via Apify (handling proxies and rate limits), flexible keyword management without code changes, and high-quality outputs through built-in cleaning and deduplication. Ideal for freelancers, agencies, or recruiters tracking Upwork trends.

Use cases: Daily job alerts for specific skills (e.g., AI development, graphic design), competitive analysis of job postings, lead generation from client requirements, or portfolio opportunity scouting. Run manually or schedule for automation, with costs mainly from Apify usage.

The workflow features three phases: scraping/initial processing (trigger, keywords fetch, loop, Apify run, waits), data handling (read datasets, clean/store), and reporting (summarize, email). Ensures robust execution with delays and error handling.