Turn newly incorporated UK companies into HubSpot leads

Every weekday at 7am, find newly incorporated UK companies in my target sectors, turn the best-fit ones into fresh HubSpot prospects, and post a summary to my sales channel in Slack.

Start with the Companies House Advanced Company Search. Filter by my target SIC codes, set the incorporation date to the previous day, and optionally narrow by a location such as a region or postcode area. This returns the companies that were registered yesterday and fall inside the sectors I care about.

For each promising result, pull Get Company Profile to capture the registered office address and confirm the SIC codes and company status, and List Company Officers to capture the director names. Keep the list focused on genuine best-fit prospects rather than every new registration.

Score each company against a simple ideal-customer profile: the right sector (SIC code), an in-scope location, and any other signals I define such as company type. Only keep the good-fit matches and drop the rest.

Before creating anything, run HubSpot Search Companies to check whether the company already exists, matching on name and on domain when one is available. Skip any company that is already in the CRM. For each new good-fit match, use HubSpot Create Company to add the prospect with its name, registered office address, and industry. Then use Create Note attached to that company to record the director names and the incorporation context, including the company number, incorporation date, and SIC codes.

When the day's results are processed, post a summary to my sales channel with the Slack bot Send a Message. List the new prospects added today with their name, location, sector, and directors, and note how many new registrations were reviewed and how many were skipped as existing companies. If there were no good-fit new companies, post a short note saying so.