Automated Job Hunter: Upwork Opportunity Aggregator & AI-Powered Notifier

This n8n workflow automates the process of finding relevant job opportunities on Upwork, extracting key information, and notifying you via email. It leverages AI to intelligently parse job descriptions and determine their suitability.

Description

This workflow acts as a smart job hunter, periodically scanning for new Upwork job postings. It then uses an AI agent to analyze each job, extracting crucial details and assessing if the opportunity aligns with predefined criteria. Finally, it compiles a summary of suitable jobs and sends a notification email, saving you time and ensuring you don't miss out on potential opportunities.

What it does

1. Triggers on Schedule: The workflow starts on a predefined schedule (e.g., daily, hourly) to check for new job postings.
2. Fetches Upwork Jobs (HTTP Request): It makes an HTTP request to an Upwork RSS feed or API endpoint to retrieve the latest job postings.
3. Extracts Job Data (Edit Fields): Transforms the raw data from the HTTP request into a structured format, preparing it for AI processing.
4. Analyzes Job with AI Agent (AI Agent): Each job description is fed into an AI agent (powered by an OpenAI Chat Model) configured with a structured output parser. The AI agent extracts specific fields like job title, description, skills required, budget, and a suitability score or assessment.
5. Stores Data in Google Sheets: The extracted and analyzed job data is then appended to a Google Sheet, creating a persistent record of all processed opportunities.
6. Sends Email Notification (Gmail): For jobs deemed suitable by the AI, the workflow compiles a summary and sends an email notification to a specified recipient, highlighting the most relevant opportunities.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Upwork RSS Feed/API Endpoint: Access to an Upwork RSS feed or API endpoint for job postings. (The HTTP Request node will need to be configured with the correct URL).
• OpenAI API Key: For the OpenAI Chat Model node to function, you will need an OpenAI API key configured as a credential in n8n.
• Google Account: A Google account with access to Google Sheets. You will need to set up a Google Sheets credential in n8n and specify the spreadsheet and sheet name.
• Gmail Account: A Gmail account configured as a credential in n8n for sending email notifications.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • OpenAI Chat Model: Configure your OpenAI API key credential.
   • Google Sheets: Set up your Google Sheets credential.
   • Gmail: Set up your Gmail credential.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule to your preferred frequency (e.g., every 1 hour, once a day).
   • HTTP Request: Update the URL to the Upwork RSS feed or API endpoint you wish to monitor. You may need to adjust headers or authentication depending on the source.
   • Edit Fields: Review and adjust the data transformation logic if the structure of the incoming job data changes.
   • AI Agent:
     • Prompt: Customize the AI agent's prompt to define what information you want it to extract and how it should assess job suitability.
     • Tools: Ensure the AI agent is correctly configured with the OpenAI Chat Model and Structured Output Parser.
   • Structured Output Parser: Define the JSON schema for the output you expect from the AI agent (e.g., {"title": "string", "description_summary": "string", "skills": "array", "budget": "string", "suitability_score": "number"}).
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where you want to store the job data. Ensure the column headers in your sheet match the output from the AI agent.
   • Gmail: Configure the recipient email address, subject, and body of the notification email. You can use expressions to dynamically include job details from the AI agent's output.
4. Activate the Workflow: Once configured, activate the workflow to start the automated job hunting process.