{"product_id":"hiring-intent-lead-finder-n8n-apify-to-google-sheets","title":"Hiring-Intent Lead Finder: n8n + Apify to Google Sheets","description":"\u003ch3\u003eAutomatically find hiring-intent companies and enrich contacts in your Google Sheet (n8n + Apify)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday to identify companies currently hiring (based on your criteria) using Apify, logs only new domains to Google Sheets to prevent duplicates, and optionally enriches contact names with verified work email addresses—then posts a weekly summary to Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e automatically executes every Monday at \u003cstrong\u003e8:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your criteria + deduplication ledger:\u003c\/strong\u003e reads search inputs and pulls existing \u003cem\u003ecompany domains\u003c\/em\u003e from Google Sheets to avoid re-adding the same companies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail enrichment (optional, sheet-driven):\u003c\/strong\u003e collects rows where you entered \u003cstrong\u003econtact first\/last name\u003c\/strong\u003e and \u003cstrong\u003edomain\u003c\/strong\u003e but \u003cstrong\u003eno work email\u003c\/strong\u003e, then sends them to \u003cstrong\u003eApify Work Email Finder\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets:\u003c\/strong\u003e matches on company domain and records any found work emails, or saves a \u003cstrong\u003e“not found”\u003c\/strong\u003e status with the \u003cstrong\u003elast-checked date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHiring-intent company discovery:\u003c\/strong\u003e calls the \u003cstrong\u003eApify Hiring Intent Contacts\u003c\/strong\u003e actor to fetch companies hiring in your selected locations and time window, including public-site emails and sample job details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and appends:\u003c\/strong\u003e excludes companies already present in Google Sheets, flags whether only \u003cem\u003egeneric inbox emails\u003c\/em\u003e were found, and appends new companies as new rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly visibility:\u003c\/strong\u003e builds a run summary and (if enabled) posts it to \u003cstrong\u003eSlack\u003c\/strong\u003e. It also sends a Slack alert and \u003cstrong\u003efails the run\u003c\/strong\u003e if the Apify company search fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly lead sourcing for B2B outbound using \u003cstrong\u003ehiring intent\u003c\/strong\u003e signals.\u003c\/li\u003e\n  \u003cli\u003eMaintaining an up-to-date Google Sheets CRM with verified work emails.\u003c\/li\u003e\n  \u003cli\u003eSaaS teams monitoring target companies and job-related hiring changes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n + tools used)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e HTTP requests using an API token via \u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets for storing domains, contacts, enriched emails, statuses, and “last-checked” timestamps\u003c\/li\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289204215987,"sku":"N8N-21616","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6OlWk4d13Dm3T0i8HeaM6_jFIEBIaR.png?v=1793006557","url":"https:\/\/buyflowscripts.com\/products\/hiring-intent-lead-finder-n8n-apify-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}