Daily new business leads (state registries + SEC funding filings) → Google Sheets + Slack, no scraping

Built with n8n
,
1

What it does

Every morning this workflow pulls the businesses that registered yesterday — new LLCs and corporations from state registries, newly licensed local businesses from 9 city license feeds, and companies that just filed a funding notice with the SEC (Form D / C / 1-A) — and appends them to a Google Sheet, then posts a short digest to Slack.

No scraping of protected sites and no browser: the data comes from official open-data portals and SEC EDGAR through an Apify Actor (New Business Leads Monitor), so it runs on plain HTTP and costs cents per thousand records.

Why I built it

Sales teams want to reach a business the week it registers — before it has a bank, an accountant, insurance or a website — and SaaS vendors want the companies that just closed a round. Subscription list services sell this same public data in weekly batches; I wanted a daily feed that lands in a spreadsheet by itself.

How it works (5 nodes)

  1. Schedule Trigger — every day at 8:00.
  2. HTTP Request → POST https://api.apify.com/v2/acts/lergassy~us-business-filings/run-sync-get-dataset-items with a small JSON input. The Actor runs in monitor mode: it remembers what it already delivered (a named key-value store), so each run returns only businesses you have not seen. The preset field picks the feed: local_leads_with_phones, connecticut_email_leads (≈200 new companies a day, almost all with a business email) or funded_startups.
  3. Filter — drops the Actor’s error items if a source is down.
  4. Edit Fields (Set) — flattens the record into spreadsheet columns: lead score, company, industry, address, contact name and contact type (owner vs. registered agent), phone in E.164, email, website, amount raised, and a one-line plain-English summary.
  5. Google Sheets (append) + Aggregate → Slack for the digest.

Setup

  • Apify account (free plan is enough to try) → API token → Header Auth credential in n8n (Authorization: Bearer <token>).
  • Google Sheets credential + an empty sheet.
  • Optional Slack channel.

Actor page with field reference and FAQ: 🏢 New Business Leads & Funded Startups Feed (US) · Apify

Workflow (copy the JSON below and paste it onto your n8n canvas):

Happy to answer questions — and if you need another state or city feed, tell me which one.