Automated Upwork Job Alerts with Airtable & Slack

Overview
This automated workflow fetches Upwork job postings using Apify, removes duplicate job listings via Airtable, and sends new job opportunities to Slack.

Key Features:
Automated job retrieval** from Upwork via Apify API
Duplicate filtering** using Airtable to store only unique jobs
Slack notifications** for new job postings
Runs every 30 minutes** during working hours (9 AM - 5 PM)

This workflow requires an active Apify subscription to function, as it uses the Apify Upwork API to fetch job listings.

Who is This For?
This workflow is ideal for:
Freelancers looking to track Upwork jobs in real time
Recruiters automating job collection for analytics
Developers who want to integrate Upwork job data into their applications

What Problem Does This Solve?
Manually checking Upwork for jobs is time-consuming and inefficient. This workflow:
Automates job discovery based on your keywords
Filters out duplicate listings, ensuring only new jobs are stored
Notifies you on Slack when new jobs appear

How the Workflow Works

1. Schedule Trigger (Every 20 Minutes)
   Triggers the workflow at 20-minute intervals
   Ensures job searches are only executed during working hours (9 AM - 5 PM)

2. Query Upwork for Jobs
   Uses Apify API to scrape Upwork job posts for specific keywords (e.g., "n8n", "Python")

3. Find Existing Jobs in Airtable
   Searches Airtable to check if a job (based on title and link) already exists

4. Filter Out Duplicate Jobs
   The Merge Node compares Upwork jobs with Airtable data
   The IF Node filters out jobs that are already stored in the database

5. Save Only New Jobs in Airtable
   The Insert Node adds only new job listings to the Airtable collection

6. Send a Slack Notification
   If a new job is found, a Slack message is sent with job details

Setup Guide

Required API Keys
Upwork Scraper (Apify Token) – Get your token from Apify Airtable Credentials Slack API Token – Connect Slack to n8n and set the channel ID (default: #general)

Configuration Steps
Modify search keywords in the 'Assign Parameters' node (startUrls)
Adjust the Working Hours in the 'If Working Hours' node
Set your Slack channel in the Slack node
Ensure Airtable is connected properly - you'll need to create a table with 'title' and 'link' columns. Adjust the 'If Working Hours' node to match your timezone and hours, or remove it altogether to receive notifications and updates constantly.

How to Customize the Workflow
Change keywords: update the startUrls in the 'Assign Parameters' node to track different job categories
Change 'If Working Hours': Modify conditions in the IF Node to filter times based on your needs
Modify Slack Notifications: Adjust the Slack message format to include additional job details

Why Use This Workflow?
Automated job tracking without manual searches
Prevents duplicate entries in Airtable
Instant Slack notifications for new job opportunities
Customizable – adapt the workflow to different job categories

Next Steps
Run the workflow and test with a small set of keywords
Expand job categories for better coverage
Enhance notifications by integrating Telegram, Email, or a dashboard

This workflow ensures real-time job tracking, prevents duplicates, and keeps you updated effortlessly.