n8n Workflow: Track Pracuj.pl Jobs in Google Sheets

Automatically track Pracuj.pl job listings and keep Google Sheets up to date

This 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.

What this workflow does

• Runs manually and reads your configured Pracuj.pl search parameters (keyword, location, max items, charge cap, and the target Google Sheets spreadsheet ID).
• Validates the setup, checks the destination Google Sheets file, creates required tabs if missing, and applies a temporary lock sheet to prevent concurrent writes.
• Verifies existing data consistency by validating headers, limits, and search scope across the Pracuj Jobs, Pracuj Companies, and Pracuj Runs tabs.
• Starts an Apify run for FalconScrape’s “Pracuj.pl Job Offers Scraper” (or loads an existing run when a resume run ID is provided) and writes a PROCESSING checkpoint to the Pracuj Runs tab.
• Polls Apify until success, then downloads the full dataset of scraped listings.
• Normalizes and deduplicates 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.
• Releases the lock and outputs a run summary with counts and a link to your spreadsheet.

Use cases

• Maintain an always-current Google Sheets tracker for specific Pracuj.pl roles by keyword and location.
• Recruiting teams consolidating job leads into “Pracuj Jobs” and “Pracuj Companies” views.
• SaaS operators monitoring scraping runs via a run ledger for transparency and repeatability.

Technical details

• Integrations: Apify (FalconScrape Pracuj.pl Job Offers Scraper) and Google Sheets.
• n8n workflow nodes: manual trigger, if, set, code, sticky note, http request.
• Data handling: configuration validation, locking (temporary lock sheet), batching, deduplication, and run checkpointing in Pracuj Runs.