{"product_id":"n8n-workflow-log-linkedin-jobs-to-google-sheets-apify","title":"n8n Workflow: Log LinkedIn Jobs to Google Sheets (Apify)","description":"\u003ch3\u003eAutomatically capture fresh LinkedIn jobs in Google Sheets—every morning\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow uses the \u003cstrong\u003eApify LinkedIn Jobs Scraper\u003c\/strong\u003e to search for new LinkedIn job postings each morning and append (or update) them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—while preventing duplicates using the job’s LinkedIn \u003cstrong\u003eid\u003c\/strong\u003e. Perfect for keeping a clean, always-current job pipeline.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e A \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e starts the workflow every morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds LinkedIn search settings:\u003c\/strong\u003e It sets search parameters such as \u003cstrong\u003ekeywords\u003c\/strong\u003e, \u003cstrong\u003elocation\u003c\/strong\u003e, \u003cstrong\u003edate range\u003c\/strong\u003e, \u003cstrong\u003eper-keyword limit\u003c\/strong\u003e, and a cost cap via \u003cstrong\u003emaxTotalChargeUsd\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches job data from Apify:\u003c\/strong\u003e An \u003cstrong\u003eHTTP Request\u003c\/strong\u003e calls the \u003cstrong\u003eApify LinkedIn Jobs Scraper Actor\u003c\/strong\u003e, returning recent postings (including extracted \u003cstrong\u003econtact emails\u003c\/strong\u003e when available).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and formats results:\u003c\/strong\u003e The workflow filters to keep only valid job rows, formats fields (including \u003cstrong\u003esalary\u003c\/strong\u003e and a \u003cstrong\u003efoundAt\u003c\/strong\u003e timestamp), and stops with an error if no jobs are returned.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates in Google Sheets:\u003c\/strong\u003e It appends new jobs to Google Sheets or updates existing rows by matching on the job \u003cstrong\u003eid\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild an “always fresh” LinkedIn job tracker for recruiting or hiring research.\u003c\/li\u003e\n  \u003cli\u003eMonitor specific roles and locations for SaaS operators and growth teams.\u003c\/li\u003e\n  \u003cli\u003eCreate a lightweight lead list of job postings (with emails when available) for outreach workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tech stack:\u003c\/strong\u003e set, code, sticky note, http request, google sheets, schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Uses an n8n HTTP Header Auth credential with \u003ccode\u003eAuthorization: Bearer \u0026lt;token\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets schema:\u003c\/strong\u003e Create columns \u003ccode\u003eid\u003c\/code\u003e, \u003ccode\u003etitle\u003c\/code\u003e, \u003ccode\u003ecompany\u003c\/code\u003e, \u003ccode\u003elocation\u003c\/code\u003e, \u003ccode\u003eseniority\u003c\/code\u003e, \u003ccode\u003eemploymentType\u003c\/code\u003e, \u003ccode\u003esalary\u003c\/code\u003e, \u003ccode\u003eapplicants\u003c\/code\u003e, \u003ccode\u003epostedAt\u003c\/code\u003e, \u003ccode\u003eurl\u003c\/code\u003e, \u003ccode\u003eemails\u003c\/code\u003e, and \u003ccode\u003efoundAt\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eGet fresh LinkedIn job postings into Google Sheets every morning—cleanly, automatically, and without duplicates.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46159504048307,"sku":"N8N-20379","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UfC_6wF66IE7L04tu6eBJ_fG9RCS60.png?v=1791104981","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-log-linkedin-jobs-to-google-sheets-apify","provider":"N8N Commerce","version":"1.0","type":"link"}