{"product_id":"apify-to-google-sheets-hiring-leads-w-gpt-4o-slack-alerts","title":"Apify to Google Sheets Hiring Leads w\/ GPT-4o \u0026 Slack Alerts","description":"\u003ch3\u003eTurn Apify hiring leads into Google Sheets rows—then notify your team in Slack with GPT-4o\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls the last 24 hours of job postings from \u003cb\u003eApify\u003c\/b\u003e, groups them by company, generates a \u003cb\u003etwo-line cold outreach opener\u003c\/b\u003e using \u003cb\u003eGPT-4o\u003c\/b\u003e, logs deduplicated leads into \u003cb\u003eGoogle Sheets\u003c\/b\u003e, and sends \u003cb\u003ehot-lead alerts\u003c\/b\u003e plus a \u003cb\u003edaily digest\u003c\/b\u003e to \u003cb\u003eSlack\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns every morning at 8 AM\u003c\/b\u003e to fetch recent hiring activity.\u003c\/li\u003e\n  \u003cli\u003eBuilds a search payload from your \u003cb\u003eniche settings\u003c\/b\u003e (job titles\/keywords and optional filters like industries, company sizes, and locations) and queries the \u003cb\u003eApify Hirebase jobs feed\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf the job feed fails, immediately sends a \u003cb\u003eSlack message\u003c\/b\u003e with \u003cb\u003eerror details\u003c\/b\u003e and stops lead logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGroups postings by company\u003c\/b\u003e, summarizing role count, titles, locations, and job links into one lead per company.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDeduplicates across runs\u003c\/b\u003e by skipping companies that already appeared in previous executions, and filters out companies below your \u003cb\u003eminimum open-role threshold\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cb\u003eOpenAI\u003c\/b\u003e to draft a \u003cb\u003etwo-line outreach opener\u003c\/b\u003e for each remaining company.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends leads to Google Sheets\u003c\/b\u003e (company details, roles, links, and the AI opener).\u003c\/li\u003e\n  \u003cli\u003ePosts to Slack as either an \u003cb\u003eimmediate alert for hot leads\u003c\/b\u003e or a \u003cb\u003edigest for standard leads\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS and agency teams automating \u003cb\u003ehiring outreach\u003c\/b\u003e based on newly posted roles.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up a \u003cb\u003edaily lead pipeline\u003c\/b\u003e with deduplication and error visibility.\u003c\/li\u003e\n  \u003cli\u003eOperators who want \u003cb\u003eGoogle Sheets lead tracking\u003c\/b\u003e backed by targeted Apify job search results and AI-generated openers.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eApify integration\u003c\/b\u003e via \u003ccode\u003e@apify\/n8n-nodes-apify\u003c\/code\u003e (ensure node is installed).\u003c\/li\u003e\n  \u003cli\u003eOpenAI (generate outreach with \u003cb\u003eGPT-4o\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003eSlack notifications (alerts + daily digest).\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic using nodes such as \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, plus lead logging to \u003cb\u003eGoogle Sheets\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978929103027,"sku":"N8N-19322","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/e2sAXfPzkS0henHf6VvEZ_8qcG9zpa.png?v=1788859618","url":"https:\/\/buyflowscripts.com\/products\/apify-to-google-sheets-hiring-leads-w-gpt-4o-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}