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 1. Modify search keywords in the Assign Parameters node (startUrls) 2. Adjust the Working Hours in the If Working Hours node 3. Set your Slack channel in the Slack node 4. Ensure Airtable is connected properly - you'll need to create a table with title and link columns. 5. 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 1. Run the workflow and test with a small set of keywords 2. Expand job categories for better coverage 3. Enhance notifications by integrating Telegram, Email, or a dashboard This workflow ensures real-time job tracking, prevents duplicates, and keeps you updated effortlessly.

Platform

n8n

Category

Communication

Price

Free

Creator

Artur

• general
• if
• set
• code
• merge
• slack
• airtable
• stickyNote
• httpRequest
• scheduleTrigger