AI Job Relevancy Scorer: Search LinkedIn Jobs with GPT-4o-mini & Google Sheets

🧠 Workflow Overview — AI-Powered Jobs Scraper & Relevancy Evaluator

This workflow automates the process of finding highly relevant job listings based on a user’s resume, career preferences, and custom filters. It scrapes fresh job data, evaluates relevance using OpenAI GPT models, and automatically appends the results to your Google Sheet tracker — while skipping any jobs already in your sheet, so you don’t have to worry about duplicates.

Perfect for recruiters, job seekers, or virtual assistants who want to automate job research and filtering.

⚙️ What the Workflow Does

1. Takes user input through a form — including resume, preferences, target score, and Google Sheet link.
2. Fetches job listings via an Apify LinkedIn Jobs API actor.
3. Filters and deduplicates results (removes duplicates and blacklisted companies).
4. Evaluates job relevancy using GPT-4o-mini, scoring each job (0–100) against the user’s resume & preferences.
5. Applies a relevancy threshold to keep only top-matching jobs.
6. Checks your Google Sheet for existing jobs and prevents duplicates.
7. Appends new, relevant jobs directly into your provided Google Sheet.

📋 What You’ll Get

• A personal Job Scraper Form (public URL you can share or embed).

• Automatic job collection & filtering based on your inputs.

• Relevance scoring (0–100) for each job using your resume and preferences.

• Real-time job tracking Google Sheet that includes:

  • Job Title
  • Company Name & Profile
  • Job URLs
  • Location, Salary, HR Contact (if available)
  • Relevancy Score

🪄 Setup Instructions

1. Required Accounts

You’ll need:

• ✅ n8n account (self-hosted or Cloud)
• ✅ Google account (for Sheets integration)
• ✅ OpenAI account (for GPT API access)
• ✅ Apify account (to fetch job data)

2. Connect Credentials

In your n8n instance:

1. Go to Credentials → Add New:

   • Google Sheets OAuth2 API

     • Connect your Google account.

   • OpenAI API

     • Add your OpenAI API key.

   • Apify API

     • Replace <your_apify_api> with your apify api key.

2. Set Up Apify API

   Get your Apify API key

   • Visit: https://console.apify.com/settings/integrations

   • Copy your API key.

   Rent the required Apify actor before running this workflow

   • Go to: https://console.apify.com/actors/BHzefUZlZRKWxkTck/input

   • Click “Rent Actor”.

Once rented, it can be used by your Apify account to fetch job listings.

3. Set Up Your Google Sheet

1. Make a copy of this template:
   📄 Google Sheet Template
2. Enable Edit Access for anyone with the link.
3. Copy your sheet’s URL — you’ll provide this when submitting the workflow form.

4. Deploy & Run

1. Import this workflow (jobs_scraper.json) into your n8n workspace.

2. Activate the workflow.

3. Visit your form trigger endpoint (e.g. https://your-n8n-domain/webhook/jobs-scraper).

4. Fill out the form with:

   • Job title(s)
   • Location
   • Contract type, Experience level, Working mode, Date posted
   • Target relevancy score
   • Google Sheet link
   • Resume text
   • Job preferences or ranking criteria

5. Submit — within minutes, new high-relevance job listings will appear in your Google Sheet automatically.

🧩 Example Use Cases

• Automate daily job scraping for clients or yourself.
• Filter jobs by AI-based relevance instead of keywords.
• Build a smart job board or job alert system.
• Support a career agency offering done-for-you job search services.

💡 Tips

• Adjust the “Target Relevancy Score” (e.g., 70–85) to control how strict the filtering is.
• You can add your own blacklisted companies in the Filter & Dedup Jobs node.