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