Automate LinkedIn Job Leads to Google Sheets via n8n & Apify

Automatically collect LinkedIn job leads and upsert them into Google Sheets with n8n + Apify

This n8n workflow runs daily to search LinkedIn jobs via an Apify actor, normalizes and deduplicates the results, and then updates (upserts) your job records in Google Sheets using a stable job ID—so your spreadsheet stays clean and current.

What this workflow does

• Schedules and triggers: Executes every day at 08:00 UTC (or you can start it manually for testing).
• Loads & validates configuration: Reads job-search settings such as keyword, location, posted-within window, and item limits, and verifies required values are set.
• Fetches results from Apify: Calls the Apify API to run the actor nomad-agent/linkedin-enrich-translate-normalize-scraper and retrieves dataset items as JSON.
• Validates, normalizes, and deduplicates: Confirms the returned job schema, flattens nested fields into a single record shape, and removes duplicates using a derived jobKey.
• Upserts into Google Sheets: Appends or updates rows by matching on jobKey, preventing duplicates across runs.

Use cases

• Recruiters and job seekers who want an always-updated Google Sheet of LinkedIn job leads.
• SaaS operators tracking specific roles by keyword/location with consistent deduplication.
• Automation engineers who want a reliable pattern for scheduled data sync: Apify → n8n → Google Sheets.

Technical details

• n8n nodes / building blocks: set, code, sticky note, HTTP Request, Google Sheets, Manual Trigger.
• Apify integration: Uses an n8n Header Auth credential that sends Authorization: Bearer <YOUR_APIFY_TOKEN> to the Apify HTTP request.
• Google Sheets integration: Requires OAuth credentials and a target worksheet (e.g., Jobs) with expected columns (referenced via google-sheets-columns.csv).

Configure your Google Spreadsheet ID, select the target sheet name, and adjust search parameters (keyword, location, postedWithin, maxItems, and maxTot) to match your LinkedIn job lead strategy.