{"product_id":"automate-shab-b2b-leads-with-apify-n8n-sheets-gmail","title":"Automate SHAB B2B Leads with Apify, n8n, Sheets \u0026 Gmail","description":"\u003ch3\u003eAutomatically find new SHAB (HR01) B2B companies, deduplicate them in Google Sheets, and email a daily HTML summary\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls newly published Swiss commercial register notices (SHAB HR01) via \u003cstrong\u003eApify\u003c\/strong\u003e, filters them into qualified leads, stores only \u003cem\u003eunseen\u003c\/em\u003e entries in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a \u003cstrong\u003edaily Gmail\u003c\/strong\u003e email with an HTML table—running every weekday morning at \u003cstrong\u003e07:00\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule\u003c\/strong\u003e: executes every weekday at \u003cstrong\u003e07:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches SHAB HR01 “new companies”\u003c\/strong\u003e: sends a request to an \u003cstrong\u003eApify actor\u003c\/strong\u003e to retrieve recent “new companies” notices for your configured \u003cstrong\u003ecantons\u003c\/strong\u003e and \u003cstrong\u003elookback window\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies leads\u003c\/strong\u003e: filters results by allowed \u003cstrong\u003elegal forms\u003c\/strong\u003e and applies \u003cstrong\u003einclude\/exclude keyword matching\u003c\/strong\u003e against company name and purpose.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates in Google Sheets\u003c\/strong\u003e: reads existing leads from the Sheets \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab and removes any company whose \u003cstrong\u003eUID\u003c\/strong\u003e already exists.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends only new leads\u003c\/strong\u003e: writes the remaining new companies to the sheet (including fields such as \u003cstrong\u003euid\u003c\/strong\u003e, \u003cstrong\u003ename\u003c\/strong\u003e, \u003cstrong\u003elegal_form\u003c\/strong\u003e, \u003cstrong\u003ecanton\u003c\/strong\u003e, \u003cstrong\u003epurpose\u003c\/strong\u003e, \u003cstrong\u003epublished\u003c\/strong\u003e, and \u003cstrong\u003eshab_url\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a daily HTML email\u003c\/strong\u003e: builds an HTML summary table of new companies and sends it via \u003cstrong\u003eGmail\u003c\/strong\u003e to your configured recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFails loudly\u003c\/strong\u003e: if the Apify request fails, it sends a \u003cstrong\u003efailure alert email\u003c\/strong\u003e instead of producing silent empty output.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a continuously updated pipeline of \u003cstrong\u003eSwiss B2B leads\u003c\/strong\u003e from SHAB HR01 without manual research.\u003c\/li\u003e\n  \u003cli\u003eReduce duplicate outreach by ensuring each UID appears only once in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e lead list.\u003c\/li\u003e\n  \u003cli\u003eSend stakeholders a daily, structured overview of newly matched companies via \u003cstrong\u003eGmail\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\u003en8n schedule trigger\u003c\/strong\u003e (weekdays at 07:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to \u003cstrong\u003eApify\u003c\/strong\u003e using \u003cstrong\u003eHTTP Header Auth\u003c\/strong\u003e: \u003cem\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth for reading\/writing the \u003cstrong\u003eLeads\u003c\/strong\u003e tab\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to send the HTML daily summary and failure alerts\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\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":46359771873459,"sku":"N8N-22156","price":77.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ebxHTWQqBzoXAhm8MbXJy_39t98TM1.png?v=1793697514","url":"https:\/\/buyflowscripts.com\/products\/automate-shab-b2b-leads-with-apify-n8n-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}