Instagram Linkedin-in Envelope

Automating Upwork Job Search

Entire process: job post filtering, data processing, and generating custom application messages for Upwork jobs.

Role: Automation Engineer

Project Description:

Designed and implemented a system to automate Upwork job search and application processes. The workflow filters job posts, stores relevant data in a Google Sheet, and uses OpenAI GPT-4 to generate custom introduction messages for applications. This system saves time and ensures that job applications are tailored and efficient, significantly improving the chances of securing projects.

Skills and Deliverables:

  • Automation
  • Upwork RSS Feeds
  • Google Sheets Integration
  • OpenAI GPT-4
  • API Integration

Outcome:

This project improved the efficiency of job searches on Upwork, ensuring relevant matches and personalized applications, thus increasing the chances of securing projects.

  • Reduced job search and application time by 70%.
  • Increased the rate of successful applications by 30%.
  • Positive feedback from clients for tailored and well-crafted application messages.

Project Workflow

Automates filtering of Upwork job posts and processes data using Google Sheets and OpenAI. Then uses OpenAI GPT-4 to generate personalized introductions for job applications based on filtered job data.

Detailed Workflow Breakdown:


Job Post Filtering

  • RSS Feed Watch: Monitors Upwork RSS feed for new job posts.
  • Parse Description: Extracts and converts job descriptions from HTML to text.
  • Filter Jobs: Uses OpenAI GPT-4 to filter job posts based on relevance and criteria.

Data Processing

  • Get Budget: Extracts budget information from job posts.
  • Google Sheets Integration: Stores filtered job data in separate sheets within a Google Sheets document for organization and tracking.

Introduction Generation

  • OpenAI (ChatGPT): Generates custom introduction messages tailored to each job post.
  • HTTP Request: Saves the generated introduction with the Upwork job application.

Error Handling

  • Error Logging: Log errors in a dedicated Google Sheet for monitoring and troubleshooting.
  • Retry Mechanism: Implements auto retries for failed tasks to ensure reliability.
  • Notifications: Sends alerts to the team via email when Google Sheets gets updated.