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

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows. Supports knowledge capture and document intelligence use cases.

This AlekSystem 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

Best fit

Need another direction?