Selected work / Energy policy consultancy
Energy policy consultancy · AI workflow automation
An executive newsfeed that curates itself.
The problem
The consultancy’s analyst spent a full day each week building an executive news briefing: triaging 60 to 80 forwarded links, clicking through tracking wrappers to find real articles, writing summaries, sorting by geography and topic, then hand-building a Word document with live hyperlinks. The formatting step alone took two hours.
What we built
Four decoupled Power Automate flows that separate ingestion, triage, approval, and rendering. Emails become structured rows automatically; a resolver chain unwraps tracking links to canonical articles; Azure OpenAI writes the summary, takeaways, and a why-it-matters line; the analyst approves what counts; and an Azure Function renders the branded Word briefing with live hyperlinks on a single button click. Editorial judgment stays human. Everything else runs itself.
How it flows
- Email trigger
- URL extraction
- Redirect resolver chain
- AI summary + takeaways
- Why-it-matters line
- Junk filtered, not deleted
- Structured list
- Approve or reject
- Flag top issues
- One-click generation
- Branded Word briefing
- Live hyperlinks
How it was built
The work, step by step.
- Power Automate
- Azure OpenAI
- Azure Functions
- SharePoint
- 01
Mapped the real intake
Two distinct input types (single-link forwards and dense newsletters), each with its own extraction path.
- 02
Built the URL resolver
Unwraps tracking links, decodes redirects, and pulls canonical URLs and metadata from the destination page.
- 03
Filtered the junk
Rules catch social links, newsletter furniture, and bare homepages. Ambiguous items get tagged for the reviewer, never silently deleted.
- 04
Triaged with AI
Azure OpenAI returns a structured summary, takeaways, and a why-it-matters line for every article, tuned to the client’s editorial voice.
- 05
Survived the hostile web
Major news sites block automated requests; every step has failure handling so rows are still created with whatever was recoverable.
- 06
Rendered the report
An Azure Function turns approved articles into the client’s existing briefing format: heading hierarchy, top-issues section, clickable links.
Have a workflow like this? Let's look at it.
A free, 20-minute readiness call. We'll tell you honestly whether it's a two-week build or a bigger one.