Score Upwork jobs and generate proposals with Apify, GPT-4o, Google Sheets and Telegram
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every 6 hours) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI and Telegram.
How it runs
Trigger: On a schedule (every 6 hours) (plus 1 other trigger).
- Run Apify Scraper (HTTP Request): calls an HTTP API (POST)
- Send Error Alert (Telegram): uses Telegram
- Get Dataset Items (HTTP Request): calls an HTTP API
- Read Existing Job IDs (Google Sheets): uses Google Sheets
- Filter Duplicates (Code): runs custom JavaScript code
- Has New Jobs? (If): checks a condition and branches into true / false
- Normalize Fields (Code): runs custom JavaScript code
- AI Scoring (OpenAI): uses OpenAI
- Parse AI Score (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Telegram
n8n-nodes-base.telegram - Error Trigger
n8n-nodes-base.errorTrigger
From the author
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.…