Blog

Blog

Blog

Automate Product Design Job Filtering on Upwork

Automate Product Design Job Filtering on Upwork

Use Make.com and OpenAI to save time, streamline your freelance workflow and focus on high-quality opportunities.

Use Make.com and OpenAI to save time, streamline your freelance workflow and focus on high-quality opportunities.

30 June 2024

As a freelancer, sifting through countless job postings on platforms like Upwork can be overwhelming and time-consuming. To streamline this process, I've developed an automation using Make.com that filters job listings tailored to my specific criteria, significantly reducing the time spent on job hunting.

The Challenge

One of the biggest challenges on Upwork is dealing with the sheer volume of job postings, many of which are unsuitable. For example, some clients may want to recreate complex platforms like Facebook with an unrealistic budget of just five dollars. To avoid wasting time on these low-quality jobs, I needed an efficient solution.

The Solution

Here's how I set up the automation:

  1. RSS Feed Integration: The automation grabs the RSS feed from Upwork, ensuring it captures the latest job postings as they come in.

  2. OpenAI API: The RSS feed data is then sent to the OpenAI API. Using ChatGPT, the automation evaluates each job posting based on specific rules I’ve set:

    • Desired hourly rate.

    • Preferred types of work.

    • Types of work to avoid.

  3. Filtering Process: ChatGPT processes the job postings and filters them according to my criteria. While it’s not perfect, it performs significantly better than manually reviewing each job myself.

  4. Notification and Tracking: Depending on the outcome, the automation takes the following actions:

    • If a job meets my criteria, it sends a notification to my Telegram bot, alerting me of the new opportunity. It also adds the job to my Airtable for tracking.

    • If a job doesn’t meet my criteria, it’s automatically rejected but still added to Airtable for record-keeping.

The Results

The automation has already processed its first job and rejected it due to an hourly rate issue, as shown in my Airtable. This setup promises to save me a substantial amount of time, allowing me to focus on high-quality job opportunities without the hassle of manual filtering.

Now automation tools spend the majority of effort filtering out low quality jobs on Upwork.

… and the result of being able to apply to a job in record time.

Interested in the Make.com Template?

If you find this automation useful and would like a copy of the template, leave a comment on this LinkedIn post or this Twitter thread, and I'll send it over to you. Let's see how much time we can save together!

New articles, freshly delivered to your inbox!

The ins and outs of product design. Unsubscribe anytime.

New articles, freshly delivered to your inbox!

The ins and outs of product design. Unsubscribe anytime.

New articles, freshly delivered to your inbox!

The ins and outs of product design. Unsubscribe anytime.