Upwork Job Aggregator & Notifier
detail.loadingPreview
Automatically fetch, log, summarize, and email Upwork job listings.
About This Workflow
This workflow automates the process of finding Upwork job opportunities. It fetches new job listings daily, logs them into a Google Sheet for historical tracking, uses AI (OpenAI) to generate concise summaries, and sends these summaries via email for easy review. It's designed to keep users informed about relevant freelance opportunities without manual searching.
Key Features
- Scheduled Trigger: Runs automatically at a predefined interval (e.g., daily at 9 AM).
- Job Fetching: Utilizes Apify's Upwork scraper to get up-to-date job listings.
- Data Formatting: Extracts and standardizes key job details like title, URL, description, budget, and post date.
- Google Sheets Logging: Appends all fetched job data to a Google Sheet for record-keeping.
- AI Summarization: Employs OpenAI (GPT-4o-mini) to create short, email-friendly summaries of the job listings.
- Structured Output: Uses a LangChain output parser to ensure the AI summary has a defined structure (subject and summary).
- Email Notification: Sends a daily digest of job summaries to a specified email address via Gmail.
How To Use
- Configure Trigger: Set the
Daily Upwork Job Triggerto your desired schedule (e.g.,triggerAtHour: 9). - Apify Credentials: Replace
<YOUR_TASK_ID>and<YOUR_API_TOKEN>in theFetch Upwork Jobs (Apify)node with your actual Apify task ID and API token. - Google Sheets Setup: Ensure your Google Sheet (
Upwork Scraper) has a sheet namedSheet1with columns:url,title,description,budget,datePosted. Authenticate theLog Jobs to Google Sheetnode with your Google account. - OpenAI Credentials: Authenticate the
OpenAI Job Summarizernode with your OpenAI API key. - Email Configuration: Set the
Send Job Summary Emailnode'ssendToaddress and authenticate with your Gmail account. - Review Prompts: Adjust the prompt in the
Summarize Job Listingsnode and thejsonSchemaExampleinParse Summary Outputto fine-tune the AI's summarization and output structure. - Enable Workflow: Activate the workflow to start receiving daily job updates.
Apps Used
Workflow JSON
{
"id": "6b8e22f9-cacb-4e85-8bd0-b6c5a5103452",
"name": "Upwork Job Aggregator & Notifier",
"nodes": 17,
"category": "Lead Generation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 6b8e22f9-cacb...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Automated Job Lead Generation and Qualification
Automatically process incoming job listings from a webhook, filter for relevant roles using AI, check against existing data, and update a Google Sheet with qualified leads. Includes decision-maker identification.