{"product_id":"track-new-linkedin-jobs-daily-in-google-sheets-n8n-meka","title":"Track New LinkedIn Jobs Daily in Google Sheets (n8n + MEKA)","description":"\u003ch3\u003eTrack new public LinkedIn jobs every day—automatically append only what’s new to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors LinkedIn job listings via MEKA (through Apify), then writes new, deduplicated roles into your Google Sheets—so you always see fresh opportunities without duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or on a schedule\u003c\/strong\u003e: Use the \u003cem\u003eManual Trigger\u003c\/em\u003e for setup\/testing, then enable the included \u003cem\u003edaily Schedule Trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates your settings before searching\u003c\/strong\u003e: It reads and validates the search, spreadsheet, result, and budget settings prior to starting a MEKA Actor run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors the actor run safely\u003c\/strong\u003e: Handles \u003cstrong\u003eREADY\u003c\/strong\u003e and \u003cstrong\u003eRUNNING\u003c\/strong\u003e responses with a bounded poll loop, without retrying the billable start request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads actor output before importing\u003c\/strong\u003e: It checks the Actor OUTPUT summary, stops on failed searches, and marks enrichment failures or budget stops as partial coverage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls one bounded dataset batch\u003c\/strong\u003e: Fetches a bounded Dataset batch, then normalizes valid public LinkedIn job records into a documented \u003cstrong\u003eten-column\u003c\/strong\u003e format.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates by job ID\u003c\/strong\u003e: Reads existing IDs from the target Google Sheet and removes jobs already present (including duplicates inside the fetched batch).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends only unseen rows\u003c\/strong\u003e: Inserts new rows while preserving \u003cstrong\u003efirstSeenAt\u003c\/strong\u003e, and reports counts for fetched, new, appended, skipped, and coverage.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiting teams building a \u003cstrong\u003edaily LinkedIn job pipeline\u003c\/strong\u003e inside Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking target roles while controlling \u003cstrong\u003esearch results and budget coverage\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers running a reliable \u003cstrong\u003en8n + Google Sheets\u003c\/strong\u003e workflow for ongoing enrichment visibility.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/tools\u003c\/strong\u003e: MEKA (via Apify Actor + Dataset), Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuth\u003c\/strong\u003e: HTTP Header Auth with \u003cstrong\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/strong\u003e used on Start Actor, Poll Actor Run, Get Run Output, and Get Dataset Items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNode building blocks\u003c\/strong\u003e: \u003cem\u003eif, set, code, wait, split out, sticky note\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet headers\u003c\/strong\u003e (row 1): id, title, company, location, postedAt, url, salary, employmentType, seniority, firstSeenAt.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288990404787,"sku":"N8N-21679","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8MHSbFBiFQTgM2i_wNzYL_Oo4nVJrs.png?v=1793005747","url":"https:\/\/buyflowscripts.com\/products\/track-new-linkedin-jobs-daily-in-google-sheets-n8n-meka","provider":"N8N Commerce","version":"1.0","type":"link"}