{"product_id":"apify-n8n-auto-add-new-job-postings-to-google-sheets","title":"Apify + n8n: Auto Add New Job Postings to Google Sheets","description":"\u003ch3\u003eAuto-publish newly found job postings into Google Sheets—every morning\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow connects \u003cstrong\u003eApify\u003c\/strong\u003e job scraping with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e so that \u003cstrong\u003enew job postings are automatically added (or updated) in your “Jobs” tab\u003c\/strong\u003e on a daily schedule—using a stable \u003cstrong\u003ejobId\u003c\/strong\u003e key to keep records clean.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSleeps, then runs:\u003c\/strong\u003e Executes every day at \u003cstrong\u003e08:00\u003c\/strong\u003e via a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches new job postings with Apify:\u003c\/strong\u003e Uses the \u003cstrong\u003eApify “careers-jobs” Actor\u003c\/strong\u003e to scrape configured company career pages and filter results (e.g., \u003cem\u003etitleKeywords\u003c\/em\u003e, \u003cem\u003elocations\u003c\/em\u003e, \u003cem\u003eremoteOnly\u003c\/em\u003e, and \u003cem\u003emaxResults\u003c\/em\u003e), returning only newly published postings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes each job into a spreadsheet row:\u003c\/strong\u003e Transforms each job into a consistent format including \u003cstrong\u003ecompany, title, location, workplace type, salary string, posted date, and URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a unique identifier:\u003c\/strong\u003e Creates a \u003cstrong\u003ejobId\u003c\/strong\u003e for each job to serve as the stable matching key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates rows in Google Sheets:\u003c\/strong\u003e Writes to the \u003cstrong\u003e“Jobs”\u003c\/strong\u003e tab, \u003cstrong\u003eappending new rows\u003c\/strong\u003e and \u003cstrong\u003eupdating existing rows\u003c\/strong\u003e when the \u003cstrong\u003ejobId\u003c\/strong\u003e matches.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS recruiting ops:\u003c\/strong\u003e Keep a live spreadsheet of new openings without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e Build a reliable Apify → n8n → Google Sheets pipeline for job monitoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eJob tracking workflows:\u003c\/strong\u003e Filter by keywords and location, then maintain a deduplicated record set using \u003cstrong\u003ejobId\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e (runs daily at 08:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e using \u003cstrong\u003e@apify\/n8n-nodes-apify\u003c\/strong\u003e and an \u003cstrong\u003eApify API token\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode node\u003c\/strong\u003e to format job data and generate \u003cstrong\u003ejobId\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e node with \u003cstrong\u003eOAuth2\u003c\/strong\u003e credentials, writing to the \u003cstrong\u003e“Jobs”\u003c\/strong\u003e tab\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e for workflow documentation (optional, but included in the setup)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003ePerfect if you want an n8n automation workflow that turns Apify job scraping into an always-current Google Sheets job tracker.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223960408243,"sku":"N8N-20884","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JfQsM1AMjybXREJIWa_4R_Jw6M8Wet.png?v=1791969947","url":"https:\/\/buyflowscripts.com\/products\/apify-n8n-auto-add-new-job-postings-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}