Weekly intelligence brief on public companies in your pipeline

Every Monday at 7:00am, build a weekly intelligence brief on the publicly traded companies sitting in my HubSpot pipeline.

Start with HubSpot Search Companies to pull the accounts that have a stock ticker stored on the company record. The ticker normally lives in a custom property, something like ticker or stock_symbol, so let me configure which property holds it. Scope the search to accounts I actually care about, for example companies tied to an open deal or an active lifecycle stage. Any company without a ticker should be skipped silently rather than treated as an error. Only a minority of a typical pipeline is publicly traded, so a small result set here is expected, not a bug.

For each ticker, query Finnhub three ways: Company News for the past seven days, Basic Financials for the headline metrics, and Recommendation Trends for analyst sentiment and how it has shifted recently.

Then read each account's news and judge what actually matters to a seller rather than summarizing everything. Things that matter: a guidance cut or an earnings miss, which signals budget scrutiny and longer approval cycles; an acquisition or merger, which signals new buying centers and integration spend; an executive change in the function I sell into, which means the champion may be gone; layoffs or restructuring, which put headcount-based deals at risk; expansion, a major product launch, or new funding, which signal fresh budget. Use the financial metrics and the analyst trend as supporting context for the judgement, not as the headline. If nothing material happened for an account this week, skip it entirely and write nothing for it.

For every account that clears that bar, write the summary back into the CRM with HubSpot Create Note associated to that company, so the rep sees it on the record. Keep the note short and useful: what happened, why it matters for this deal, and a suggested next move. Include a link to the source article so the rep can read further.

Finally, rank the accounts that had material news by how urgent and actionable they are, take the top five, and post a single digest to the sales channel with Slack Bot Send a Message so the team knows who to call first. Each entry should name the company and ticker, give the one-line trigger, and say why to call now. Open the digest by making it explicit that this brief covers only the public companies in the pipeline, so nobody reads it as a full account review. If no account had material news, post a short note saying it was a quiet week rather than posting nothing.

A couple of practical notes. Finnhub's free tier allows 60 calls per minute, so pace the requests when the account list is long. If a ticker returns no data or a plan-restricted response, skip that account quietly and carry on with the rest.