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

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