Automate SHAB B2B Leads with Apify, n8n, Sheets & Gmail

Automatically find new SHAB (HR01) B2B companies, deduplicate them in Google Sheets, and email a daily HTML summary

This n8n workflow pulls newly published Swiss commercial register notices (SHAB HR01) via Apify, filters them into qualified leads, stores only unseen entries in Google Sheets, and sends a daily Gmail email with an HTML table—running every weekday morning at 07:00.

What this workflow does

• Runs on schedule: executes every weekday at 07:00.
• Fetches SHAB HR01 “new companies”: sends a request to an Apify actor to retrieve recent “new companies” notices for your configured cantons and lookback window.
• Qualifies leads: filters results by allowed legal forms and applies include/exclude keyword matching against company name and purpose.
• Deduplicates in Google Sheets: reads existing leads from the Sheets “Leads” tab and removes any company whose UID already exists.
• Appends only new leads: writes the remaining new companies to the sheet (including fields such as uid, name, legal_form, canton, purpose, published, and shab_url).
• Sends a daily HTML email: builds an HTML summary table of new companies and sends it via Gmail to your configured recipient.
• Fails loudly: if the Apify request fails, it sends a failure alert email instead of producing silent empty output.

Use cases

• Maintain a continuously updated pipeline of Swiss B2B leads from SHAB HR01 without manual research.
• Reduce duplicate outreach by ensuring each UID appears only once in your Google Sheets lead list.
• Send stakeholders a daily, structured overview of newly matched companies via Gmail.

Technical details

• n8n schedule trigger (weekdays at 07:00)
• HTTP Request to Apify using HTTP Header Auth: Authorization: Bearer <YOUR_APIFY_TOKEN>
• Google Sheets OAuth for reading/writing the Leads tab
• Gmail to send the HTML daily summary and failure alerts
• Workflow nodes: set, code, gmail, http request, google sheets, plus a sticky note