{"product_id":"n8n-workflow-apify-career-page-jobs-to-google-sheets","title":"n8n Workflow: Apify Career Page Jobs to Google Sheets","description":"\u003ch3\u003eAutomatically scrape an Apify company career page and keep your job listings in Google Sheets up to date\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs the \u003cstrong\u003eApify Company Career Page Scraper\u003c\/strong\u003e for a single company URL, then imports the scraped job listings into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including a \u003cem\u003ecurrent jobs\u003c\/em\u003e view, a per-run \u003cem\u003ehistory\u003c\/em\u003e log, and a safe \u003cem\u003erun ledger\u003c\/em\u003e with locking and resume support.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e and takes the target company career\/ATS URL, job limit, charge cap, and the destination Google Sheets spreadsheet ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates configuration\u003c\/strong\u003e, reads the existing spreadsheet, and creates required tabs if missing (Career Current, Career History, Career Runs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds a temporary lock sheet\u003c\/strong\u003e to prevent overlapping writes and protect data integrity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates existing schema \u0026amp; uniqueness\u003c\/strong\u003e in the current and history tables before importing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts the Apify Actor run\u003c\/strong\u003e (FalconScrape Company Career Page Scraper Actor ID: \u003cstrong\u003eHiJYKx437rQqU6YMb\u003c\/strong\u003e) with a charge cap, or \u003cstrong\u003eresumes\u003c\/strong\u003e a provided Apify run ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls until completion\u003c\/strong\u003e, fetches the full scraped dataset, then \u003cstrong\u003enormalizes and deduplicates\u003c\/strong\u003e job records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates\/creates rows\u003c\/strong\u003e in \u003cem\u003eCareer Current\u003c\/em\u003e, appends per-run observations to \u003cem\u003eCareer History\u003c\/em\u003e, and writes an import status entry to \u003cem\u003eCareer Runs\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRemoves the lock\u003c\/strong\u003e and returns a summary (baseline, new, refreshed, rejected, replayed) plus a link to the spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain an always-current hiring page mirror for recruiters using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTrack job posting changes over time with a built-in \u003cstrong\u003eCareer History\u003c\/strong\u003e ledger.\u003c\/li\u003e\n  \u003cli\u003eResume long-running imports by Apify run ID for reliable operations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (FalconScrape Company Career Page Scraper Actor), Google Sheets via \u003cstrong\u003eOAuth2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ components:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e, \u003ccode\u003emanual trigger\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperational safety:\u003c\/strong\u003e lock sheet for concurrent write protection and checkpointing via the \u003cem\u003eCareer Runs\u003c\/em\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154083926195,"sku":"N8N-20051","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bj4nY7HF9ojqzvqsk4Nql_SQnblwq2.png?v=1790933521","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-apify-career-page-jobs-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}