{"product_id":"automate-linkedin-job-leads-to-google-sheets-via-n8n-apify","title":"Automate LinkedIn Job Leads to Google Sheets via n8n \u0026 Apify","description":"\u003ch3\u003eAutomatically collect LinkedIn job leads and upsert them into Google Sheets with n8n + Apify\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs daily to search LinkedIn jobs via an Apify actor, normalizes and deduplicates the results, and then \u003cstrong\u003eupdates (upserts)\u003c\/strong\u003e your job records in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e using a stable job ID—so your spreadsheet stays clean and current.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules and triggers:\u003c\/strong\u003e Executes every day at \u003cstrong\u003e08:00 UTC\u003c\/strong\u003e (or you can start it manually for testing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads \u0026amp; validates configuration:\u003c\/strong\u003e Reads job-search settings such as \u003cstrong\u003ekeyword\u003c\/strong\u003e, \u003cstrong\u003elocation\u003c\/strong\u003e, \u003cstrong\u003eposted-within window\u003c\/strong\u003e, and \u003cstrong\u003eitem limits\u003c\/strong\u003e, and verifies required values are set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches results from Apify:\u003c\/strong\u003e Calls the Apify API to run the actor \u003cstrong\u003enomad-agent\/linkedin-enrich-translate-normalize-scraper\u003c\/strong\u003e and retrieves dataset items as JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates, normalizes, and deduplicates:\u003c\/strong\u003e Confirms the returned job schema, flattens nested fields into a single record shape, and removes duplicates using a derived \u003cstrong\u003ejobKey\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets:\u003c\/strong\u003e Appends or updates rows by matching on \u003cstrong\u003ejobKey\u003c\/strong\u003e, preventing duplicates across runs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiters and job seekers who want an always-updated Google Sheet of LinkedIn job leads.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking specific roles by keyword\/location with consistent deduplication.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want a reliable pattern for scheduled data sync: \u003cstrong\u003eApify → n8n → Google Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ building blocks:\u003c\/strong\u003e set, code, sticky note, HTTP Request, Google Sheets, Manual Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Uses an n8n Header Auth credential that sends \u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e to the Apify HTTP request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e Requires OAuth credentials and a target worksheet (e.g., \u003cem\u003eJobs\u003c\/em\u003e) with expected columns (referenced via \u003ccode\u003egoogle-sheets-columns.csv\u003c\/code\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eConfigure your \u003cstrong\u003eGoogle Spreadsheet ID\u003c\/strong\u003e, select the target sheet name, and adjust search parameters (keyword, location, postedWithin, maxItems, and maxTot) to match your LinkedIn job lead strategy.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812011204787,"sku":"N8N-17963","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/zAt0WVVt89TNVIIZa3Ow5_XEFIT08v.png?v=1786352994","url":"https:\/\/buyflowscripts.com\/products\/automate-linkedin-job-leads-to-google-sheets-via-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}