Back to Templates

Match LinkedIn jobs and generate cover letters with OpenAI, Apify and Sheets

Created by

Created by: Jitesh Dugar || jiteshdugar
Jitesh Dugar

Last update

Last update 2 days ago

Categories

Share

This n8n workflow automatically searches LinkedIn jobs using Apify, compares each job with your resume using AI, calculates a match score, generates a personalized cover letter, and stores everything inside Google Sheets.

High-scoring jobs are instantly sent to Telegram so you can apply faster to the most relevant opportunities.

Workflow Structure

Step 1 — Schedule Trigger

Node: Schedule Trigger

This node automatically starts the workflow every day at a specific time.

What it does

  • Runs the workflow automatically
  • Eliminates manual execution
  • Creates a fully automated job-hunting system

Current Configuration

  • Runs daily at 5 PM

Step 2 — Download Resume PDF

Node: Download file

This node downloads the resume PDF from Google Drive.

What it does

  • Connects to Google Drive
  • Downloads the selected resume file
  • Sends the file to the next processing step

Why it matters

Your resume becomes dynamic input for the AI matching system.

Step 3 — Extract Resume Text

Node: Extract from File

This node extracts readable text from the PDF resume.

What it does

  • Reads the PDF file
  • Extracts plain text content
  • Makes the resume understandable for AI

Output

  • Resume text
  • PDF metadata
  • Structured readable content

Step 4 — Read Job Search Filters

Node: Get row(s) in sheet

This node reads job search preferences from Google Sheets.

What it reads

  • Job keyword
  • Preferred location
  • Easy Apply option

Example

Keyword Location Easy Apply
Software Developer Bangalore true

Step 5 — LinkedIn Job Scraper

Node: Run an Actor and get dataset

This node uses Apify to scrape LinkedIn job listings.

What it does

  • Searches LinkedIn jobs
  • Uses keyword + location filters
  • Fetches latest job postings
  • Supports Easy Apply filtering

Example Search

  • Software Developer
  • Bangalore
  • Easy Apply enabled

Output Includes

  • Job title
  • Company name
  • Job description
  • LinkedIn apply link
  • Applicant count
  • Workplace type

Step 6 — Process Jobs One-by-One

Node: Loop Over Items

This node processes each scraped job individually.

What it does

  • Loops through all job listings
  • Processes one job at a time
  • Prevents AI overload
  • Maintains stable execution

Step 7 — AI Resume Matcher

Node: Job Matcher

This is the core AI engine of the workflow.

AI Model Used

  • GPT-4.1 Mini

What it does

  • Reads your resume
  • Reads the job description
  • Compares both intelligently
  • Calculates a job match score
  • Generates a personalized cover letter

AI Output

{
  "score": 80,
  "coverLetter": "Generated personalized cover letter"
}

Step 8 — Parse AI Output

Node: Edit Fields

This node formats the AI response into reusable structured data.

What it does

  • Converts raw AI response into JSON
  • Cleans output formatting
  • Makes fields reusable in later nodes

Output Fields

  • Match score
  • Cover letter

Step 9 — Save Results to Google Sheets

Node: Append or update row in sheet

This node stores processed jobs inside Google Sheets.

What gets saved

  • Job title
  • Company
  • Location
  • Job description
  • Apply link
  • Match score
  • AI-generated cover letter

Step 10 — High Match Score Filter

Node: Score Filter

This node filters only high-quality job matches.

Current Logic

Continue only if:

Score ≥ 50

Step 11 — Telegram Job Alerts

Node: Send a text message

This node sends instant Telegram notifications for top job matches.

What it sends

  • Job title
  • Company
  • Location
  • Match score
  • Apply link