{"product_id":"n8n-workflow-track-pracuj-pl-jobs-in-google-sheets","title":"n8n Workflow: Track Pracuj.pl Jobs in Google Sheets","description":"\u003ch3\u003eAutomatically track Pracuj.pl job listings and keep Google Sheets up to date\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls Pracuj.pl job offers using an Apify charge-capped scraper, then inserts or refreshes job data and company-level observations in Google Sheets—complete with run logging and a lock mechanism to prevent overlapping imports.\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 reads your configured Pracuj.pl search parameters (keyword, location, max items, charge cap, and the target Google Sheets spreadsheet ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the setup\u003c\/strong\u003e, checks the destination Google Sheets file, creates required tabs if missing, and applies a \u003cstrong\u003etemporary lock sheet\u003c\/strong\u003e to prevent concurrent writes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies existing data consistency\u003c\/strong\u003e by validating headers, limits, and search scope across the \u003cem\u003ePracuj Jobs\u003c\/em\u003e, \u003cem\u003ePracuj Companies\u003c\/em\u003e, and \u003cem\u003ePracuj Runs\u003c\/em\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts an Apify run\u003c\/strong\u003e for FalconScrape’s “Pracuj.pl Job Offers Scraper” (or loads an existing run when a resume run ID is provided) and writes a \u003cem\u003ePROCESSING\u003c\/em\u003e checkpoint to the \u003cem\u003ePracuj Runs\u003c\/em\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Apify until success\u003c\/strong\u003e, then downloads the full dataset of scraped listings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e job data and batch-updates Google Sheets: adds new jobs, refreshes existing ones, appends per-company observation rows, and logs run status and summary counts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReleases the lock\u003c\/strong\u003e and outputs a run summary with counts and a link to your 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 \u003cstrong\u003eGoogle Sheets tracker\u003c\/strong\u003e for specific Pracuj.pl roles by keyword and location.\u003c\/li\u003e\n  \u003cli\u003eRecruiting teams consolidating job leads into “Pracuj Jobs” and “Pracuj Companies” views.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators monitoring scraping runs via a run ledger for transparency and repeatability.\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 Pracuj.pl Job Offers Scraper) and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes:\u003c\/strong\u003e manual trigger, if, set, code, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData handling:\u003c\/strong\u003e configuration validation, locking (temporary lock sheet), batching, deduplication, and run checkpointing in \u003cem\u003ePracuj Runs\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081414955187,"sku":"N8N-19877","price":40.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vzpk_VT89Nawj5wi6TZ3i_y9DEGXVH.png?v=1790240925","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-pracuj-pl-jobs-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}