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

How it works

1. Schedule Trigger runs every 6 hours (customizable)
2. Apify Scraper fetches Upwork jobs matching your criteria
3. Deduplication filters out jobs you've already seen
4. AI Scoring (GPT-4) evaluates fit, client quality, budget (0-100 score)
5. Filter keeps only jobs scoring 60+
6. Proposal Generator creates personalized proposals
7. Google Sheets logs all results
8. Telegram sends summary notification

Setup steps

Time: ~15 minutes

1. Create Google Sheet with "Job ID" column
2. Get Apify account + Upwork scraper actor
3. Get OpenAI API key
4. Set environment variables:
   • GOOGLE_SHEETS_DOC_ID
   • APIFY_ACTOR_ID
   • TELEGRAM_CHAT_ID
5. Create credentials: Google Sheets, Apify (Header Auth), OpenAI, Telegram
6. 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