Score Upwork jobs and generate proposals with Apify, GPT-4o, Google Sheets and Telegram Workflow Solution

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building.

How it works Schedule Trigger runs every 6 hours (customizable) Apify Scraper fetches Upwork jobs matching your criteria Deduplication filters out jobs you've already seen AI Scoring (GPT-4) evaluates fit, client quality, budget (0-100 score) Filter keeps only jobs scoring 60+ Proposal Generator creates personalized proposals Google Sheets logs all results Telegram sends summary notification Setup steps Time: ~15 minutes Create Google Sheet with "Job ID" column Get Apify account + Upwork scraper actor Get OpenAI API key Set environment variables: GOOGLE_SHEETS_DOC_ID APIFY_ACTOR_ID TELEGRAM_CHAT_ID Create credentials: Google Sheets, Apify (Header Auth), OpenAI, Telegram Connect credentials to workflow nodes Who is this for? Freelancers actively applying to Upwork jobs Agencies monitoring multiple job categories Consultants prioritizing high-quality leads Estimated costs Per run:** $0.50-3.00 (Apify + OpenAI) Monthly (4x/day):** $50-200

Best fit

Need another direction?