AutomationFlowsAI & RAG › Match Linkedin Jobs and Generate Cover Letters with Openai, Apify and Sheets

Match Linkedin Jobs and Generate Cover Letters with Openai, Apify and Sheets

ByJitesh Dugar @jiteshdugar on n8n.io

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.

Cron / scheduled trigger★★★★☆ complexityAI-powered24 nodesOpenAI ChatGoogle SheetsTelegram@Apify/N8N Nodes ApifyGoogle DriveAgent
AI & RAG Trigger: Cron / scheduled Nodes: 24 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #15623 — we link there as the canonical source.

This workflow follows the Agent → Google Drive recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "SU5LhyxPl6zwArgS",
  "name": "LinkedIn job search with apify - Cover Letter Generator v2",
  "tags": [],
  "nodes": [
    {
      "id": "e8dc3fe0-9c0c-488f-9138-14b3ceac21c6",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        512,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "4c11917a-eeca-4151-9aeb-99f76695d136",
      "name": "Score Filter",
      "type": "n8n-nodes-base.if",
      "position": [
        1824,
        16
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "1499f1ac-a7ae-4983-85c7-aa7b8445b2e2",
              "operator": {
                "type": "number",
                "operation": "gte"
              },
              "leftValue": "={{ $json.score }}",
              "rightValue": 50
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "e3ece56d-4791-4e90-8f63-a236b49fddb2",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        736,
        224
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "b8b8e982-3a48-4aa6-a9eb-c9a1141245a5",
      "name": "Extract from File",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -480,
        112
      ],
      "parameters": {
        "options": {},
        "operation": "pdf"
      },
      "typeVersion": 1
    },
    {
      "id": "9054e1f3-5cff-4bc2-b169-d06e770285ff",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1472,
        16
      ],
      "parameters": {
        "columns": {
          "value": {
            "link": "={{ $('Loop Over Items').item.json.linkedinUrl }}",
            "Title": "={{ $('Loop Over Items').item.json.title }}",
            "score": "={{ $json.score }}",
            "Company": "={{ $('Loop Over Items').item.json.company.name }}",
            "Location": "={{ $('Loop Over Items').item.json.location.linkedinText }}",
            "description": "={{ $('Loop Over Items').item.json.descriptionText }}",
            "Cover Letter": "={{ $json.coverLetter }}"
          },
          "schema": [
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Location",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "score",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Cover Letter",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Cover Letter",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "link"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1a8SyquhYln8RA5i9F_hcoQxZq-Rkh7WQfNFqlULdnOk/edit#gid=0",
          "cachedResultName": "Result"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1a8SyquhYln8RA5i9F_hcoQxZq-Rkh7WQfNFqlULdnOk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1a8SyquhYln8RA5i9F_hcoQxZq-Rkh7WQfNFqlULdnOk/edit?usp=drivesdk",
          "cachedResultName": "n8n - Job Search"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "01b93613-baca-454c-a342-d837ac9124ab",
      "name": "Send a text message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2192,
        192
      ],
      "parameters": {
        "text": "=Title: {{ $json.Title }}\nCompany: {{ $json.Company }}\nLocation: {{ $json.Location }}\nJob Score: {{ $json.score }}\nApply: {{ $json.link }}",
        "chatId": "123456789",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "d3b41a4e-0a97-4b7d-8d1f-567adc59138d",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -224,
        112
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1038962310,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1a8SyquhYln8RA5i9F_hcoQxZq-Rkh7WQfNFqlULdnOk/edit#gid=1038962310",
          "cachedResultName": "Filter"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1a8SyquhYln8RA5i9F_hcoQxZq-Rkh7WQfNFqlULdnOk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1a8SyquhYln8RA5i9F_hcoQxZq-Rkh7WQfNFqlULdnOk/edit?usp=drivesdk",
          "cachedResultName": "n8n - Job Search"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "1e7f6fa0-374f-4557-a9f2-bf629a1af4d6",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1136,
        112
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 17
            }
          ]
        }
      },
      "notesInFlow": false,
      "typeVersion": 1.2
    },
    {
      "id": "b7c8d135-a58c-4cfd-aa7a-fd78a63abd97",
      "name": "Run an Actor and get dataset",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        160,
        0
      ],
      "parameters": {
        "actorId": {
          "__rl": true,
          "mode": "list",
          "value": "zn01OAlzP853oqn4Z",
          "cachedResultUrl": "https://console.apify.com/actors/zn01OAlzP853oqn4Z/input",
          "cachedResultName": "Advanced Linkedin Job Scraper (No Cookies) (harvestapi/linkedin-job-search)"
        },
        "timeout": {},
        "operation": "Run actor and get dataset",
        "customBody": "={\n  \"easyApply\": {{ $json['Easy Apply'] }},\n  \"jobTitles\": [\n    \"{{ $json.Keyword }}\"\n  ],\n  \"locations\": [\n    \"{{ $json.Location }}\"\n  ],\n  \"maxItems\": 2,\n  \"sortBy\": \"date\",\n  \"under10Applicants\": false\n}"
      },
      "credentials": {
        "apifyApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "acc9c317-9169-45f9-98bb-975b290712b7",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        1168,
        16
      ],
      "parameters": {
        "mode": "raw",
        "options": {},
        "jsonOutput": "={{ $json.output }}"
      },
      "typeVersion": 3.4
    },
    {
      "id": "4e4d1dcc-2cb8-4b7a-a531-8947b6e66770",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1248,
        -320
      ],
      "parameters": {
        "color": "#E9C4C4",
        "width": 304,
        "height": 576,
        "content": "# Step 1: Schedule Trigger\n\nThis node starts the workflow automatically on a fixed schedule.\n\n## What it does\n- Runs the workflow without manual execution\n- Starts the full job search process every day\n- Keeps the job matching system active in the background\n\n## Current setup\n- Trigger type: Schedule Trigger\n- Runs daily at the configured hour"
      },
      "typeVersion": 1
    },
    {
      "id": "7a1d54b0-e4b1-4237-af36-df8cad646184",
      "name": "Download file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -800,
        112
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "list",
          "value": "1ms4kSz9GjPYsNQZLs6kTGGJB7zESC9Qy",
          "cachedResultUrl": "https://drive.google.com/file/d/1ms4kSz9GjPYsNQZLs6kTGGJB7zESC9Qy/view?usp=drivesdk",
          "cachedResultName": "jos_butler_resume.pdf"
        },
        "options": {},
        "operation": "download"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "ec8d3278-305a-4acd-a8c4-4b0e90fe71f1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        -208
      ],
      "parameters": {
        "color": "#D4CCE6",
        "width": 272,
        "height": 464,
        "content": "# Step 3: Extract Resume Text\n\nThis node converts the resume PDF into plain text so the AI can understand it.\n\n## What it does\n- Reads the downloaded PDF\n- Extracts all available text from the resume\n- Makes the resume content available for AI matching"
      },
      "typeVersion": 1
    },
    {
      "id": "78132108-e7e8-40aa-8673-e6ef74a8b4da",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        -272
      ],
      "parameters": {
        "color": "#BDD5DB",
        "width": 304,
        "height": 528,
        "content": "# Step 4: Read Job Search Filters\n\nThis node reads the search criteria from a Google Sheet.\n\n## What it reads\n- Job keyword\n- Location\n- Easy Apply preference\n\n## Example input\n- Keyword: Software Developer\n- Location: Bangalore\n- Easy Apply: true\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e1e7071b-c64f-4496-8787-52772e349870",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        16,
        -448
      ],
      "parameters": {
        "color": "#C4DEC6",
        "width": 352,
        "height": 704,
        "content": "# Step 5: LinkedIn Job Scraper (Apify)\n\nThis node runs an Apify LinkedIn job scraper using the filters from Google Sheets.\n\n## What it does\n- Searches LinkedIn jobs by keyword\n- Searches jobs by location\n- Applies the Easy Apply filter\n- Sorts results by latest jobs\n- Returns job descriptions, company details, locations, and apply links\n\n## Current configuration\n- Source: LinkedIn job search through Apify\n- Search input: Google Sheets filter row\n- Result limit: Configured inside the Apify request body\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "1f708d84-3088-4772-b9f6-32d3e8035922",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -416
      ],
      "parameters": {
        "color": "#EDF4B8",
        "width": 304,
        "height": 560,
        "content": "# Step 6: Process Jobs One-by-One\n\nThis node loops through every scraped LinkedIn job result individually.\n\n## What it does\n- Takes the full list of job posts from Apify\n- Sends one job at a time to the AI matcher\n- Prevents multiple job descriptions from being mixed together\n- Keeps scoring and cover letter generation clean and accurate\n"
      },
      "typeVersion": 1
    },
    {
      "id": "d81129f4-e14a-4d0d-94c2-9f57ff338419",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        736,
        -400
      ],
      "parameters": {
        "color": "#E2D0B1",
        "width": 320,
        "height": 528,
        "content": "# Step 7: AI Resume Matcher\n\nThis AI Agent compares the extracted resume text with the current LinkedIn job description.\n\n## What it does\n- Reads the job description from the current loop item\n- Reads the extracted resume text from the PDF\n- Calculates a job match score\n- Generates a personalized cover letter\n- Returns the result in structured JSON format\n"
      },
      "typeVersion": 1
    },
    {
      "id": "43986510-38b6-46f1-9f1c-cce0edb7d670",
      "name": "Job Matcher",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        768,
        16
      ],
      "parameters": {
        "text": "=You are a helpful job matcher, you read my resume then analyze the given resume and job description and provide a job matching score. also write a cover letter based on my resume and the job description. cover letter must be at least 2 paragraph and ignore the name, address and signature part from start and end.\nif you are using special character like \" use \\ to escape it. output must be parse in json without error. \n\nfor example your response should be like:\n{\"score\": 80, \"coverLetter\": \"sample cover letter\" }\n\njob_description: {{ $json.descriptionText }}\nmy_resume: {{ $('Extract from File').item.json.text }}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2
    },
    {
      "id": "b66ddcf7-05e7-455a-990f-ea974959b3b4",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        -416
      ],
      "parameters": {
        "color": "#E8BFDB",
        "width": 288,
        "height": 560,
        "content": "# Step 8: Parse AI Output\n\nThis node converts the AI Agent response into structured workflow data.\n\n## What it does\n- Reads the AI output\n- Converts the response into JSON fields\n- Makes `score` and `coverLetter` available for later nodes\n\n## Why this is needed\nThe next nodes need clean fields to save data into Google Sheets and filter high-quality job matches.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "ca9ba663-62ab-4ce1-8e87-897b9fa39d8d",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1376,
        -512
      ],
      "parameters": {
        "color": "#D1C4DE",
        "width": 336,
        "height": 656,
        "content": "# Step 9: Save Results to Google Sheets\n\nThis node stores each processed job result in Google Sheets.\n\n## What it saves\n- Job title\n- Company name\n- Location\n- Job description\n- LinkedIn apply link\n- AI match score\n- Generated cover letter\n\n## Matching logic\nThe workflow uses the job link as the matching column, so duplicate jobs can be updated instead of creating repeated rows.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b26edeec-ea67-438d-8921-dac10d225ebf",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1728,
        -208
      ],
      "parameters": {
        "color": "#CED6B3",
        "width": 352,
        "height": 352,
        "content": "# Step 10: High Match Score Filter\n\nThis node checks whether the AI match score is high enough to send a Telegram alert.\n\n### Current Logic\nOnly continue if:\nScore \u2265 50"
      },
      "typeVersion": 1
    },
    {
      "id": "aa2415d9-1877-43d3-95ca-7828df6434a0",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2096,
        -128
      ],
      "parameters": {
        "color": "#F0E3B2",
        "width": 320,
        "height": 464,
        "content": "# Step 11: Telegram Job Alerts\n\nThis node sends a Telegram message when a job passes the score filter.\n\n## What it sends\n- Job title\n- Company name\n- Location\n- AI match score\n- LinkedIn apply link\n"
      },
      "typeVersion": 1
    },
    {
      "id": "1b0afac6-85c7-4fa6-8f0a-5f1c46e26d22",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        -736
      ],
      "parameters": {
        "color": "#D0C3DA",
        "width": 1072,
        "height": 384,
        "content": "# Overview\n\n# LinkedIn AI Job Matcher & Cover Letter Generator\n\nThis workflow automatically searches LinkedIn job posts, compares each job description with a resume, generates an AI match score, and writes a personalized cover letter.\n\n## How it works\n1. Runs on a schedule.\n2. Downloads and extracts text from a resume PDF.\n3. Reads job search filters from Google Sheets.\n4. Searches LinkedIn jobs using Apify.\n5. Uses AI to score each job against the resume.\n6. Saves every result to Google Sheets.\n7. Sends Telegram alerts only for high-match jobs."
      },
      "typeVersion": 1
    },
    {
      "id": "cfd3992a-605d-4ae3-93a6-d7961ae2f305",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -928,
        -192
      ],
      "parameters": {
        "color": "#DEC1E6",
        "width": 320,
        "height": 448,
        "content": "# Step 2: Download Resume PDF\n\nThis node downloads the selected resume file from Google Drive.\n\n## What it does\n- Connects to Google Drive\n- Downloads the resume PDF as binary data\n- Passes the file to the PDF extraction node\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "binaryMode": "separate",
    "executionOrder": "v1"
  },
  "versionId": "28a2f8c6-1086-41e3-bae1-46d078f7c6b8",
  "connections": {
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Job Matcher": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Score Filter": {
      "main": [
        [
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Job Matcher",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Job Matcher",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Run an Actor and get dataset",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a text message": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run an Actor and get dataset": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        [
          {
            "node": "Score Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

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.

Source: https://n8n.io/workflows/15623/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

This n8n workflow is designed for content creators, digital marketers, and social media managers who want to automate their entire content creation and publishing process across multiple platforms. It

Google Sheets, WordPress, Edit Image +13
AI & RAG

This n8n templates helps you to authomatically search Linkeding jobs. It uses AI (Gemini or OpenAPI) to match your resume with each job description and write a sample cover letter for each job and upd

Agent, OpenAI Chat, Google Drive +3
AI & RAG

Job seekers, career coaches, and developers looking to automate job market research and identify the exact technical skills required to land their target roles.

Google Drive, Google Sheets, HTTP Request +4
AI & RAG

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Mailgun, OpenAI, OpenAI Chat +8
AI & RAG

Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.

@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9