Track and qualify new business filings with Apify, OpenAI, Sheets, Slack and Gmail

## New business filing tracker Pulls newly registered companies from state business registries through Apify, keeps only filings you have not seen, and scores them by trade keywords in the name, entity type, state, freshness and a usable street address. ### How it works 1. A schedule or manual run reads everything from Config. 2. The Apify actor runs asynchronously; the flow waits and polls until it ends. 3. Results are validated and deduped against earlier runs. 4. A rule score plus an AI chain (structured output) rate each record. 5. Rows are saved to Google Sheets; hot ones go to Slack for approve or dismiss, warm ones to an email digest. 6. A weekly report and an error alert branch run separately. ### Setup 1. Create an HTTP Header Auth credential (Authorization: Bearer ) and pick it on the Apify nodes. 2. Add a Google Sheet tab matching the sheet columns and paste its ID into Config. 3. Connect OpenAI (or any chat model), Slack and Gmail; set the Slack channel and digest email in Config. 4. Fill the actor input and the scoring keywords in Config, run once manually, then activate. ### Customization tips - Change the rule weights in the scoring Code node and the aiCriteria text. - Swap Slack or Gmail for Teams, Discord, HubSpot or Airtable; delivery nodes only read $json. Disclosure: I maintain these Apify actors (account transparent_meteorite). The actor is a paid pay-per-event Apify tool; check its Store page for current pricing before scheduling.