How to Build Daily Newsletters Using SharePoint & Power Automate
At a Glance
- Target Audience
- SharePoint Admins, Power Platform Developers, M365 Community Managers
- Problem Solved
- Overwhelmed by content updates; manual newsletter curation and distribution
- Use Case
- Automating curated newsletters for Microsoft 365 communities or internal teams
Most companies try to solve information overload by buying more reading apps. It never works. You do not need another tool to hoard links. You need a ruthless curation system.
Back in 2006, the SharePoint ecosystem exploded. We were drowning in updates at Collab365. We craved a system to keep us informed without consuming our entire day. That survival tactic forced us to fix our newsletter problem by building an internal RSS feed. Over time, that simple feed evolved into our Daily Digest Newsletter.
Today, we serve the Microsoft 365 Community. We act as a filter for IT professionals, citizen developers, and founders.
Stop manually copying and pasting content. Here is the exact workflow we use to curate, summarize, and deliver daily news.
The 6-Step Curation Engine
You do not need a massive editorial team to run a daily publication. You need to do the boring work of setting up a flawless pipeline.
1. The Filter
We monitor over 300 blogs. Feedly is our lens. It filters the noise and presents a daily list of potential articles. We manually select the best pieces and drop them into a specific Daily Digest board. Human curation is non-negotiable.
2. The Brain
This is where automation takes over. Saving an article to our board triggers a scenario in Make.com. We choose Make.com because it perfectly bridges Feedly and SharePoint while keeping costs low. It hands the article to OpenAI. The AI strips out the fluff and writes a crisp summary.
3. The Staging Ground
Those AI summaries land in a SharePoint list. They sit there awaiting human approval. We run rigorous quality checks. If a piece does not meet our standard, we cut it.
4. The Publishing Engine
We push approved items straight to WordPress. We orchestrate this seamless transition using Power Automate. Our custom WordPress theme guarantees 100% uniformity. Every single article looks perfect before it goes live.
5. The Assembly Line
WordPress generates a custom RSS feed. This feed acts as the spine of our entire operation. It compiles all the approved and formatted summaries into a single package.
6. The Delivery
We rely on BigMailer backed by AWS SES to handle the distribution. We need a system that handles 14,000 emails reliably every single morning. BigMailer’s infrastructure ensures our content actually hits the inbox instead of the spam folder.
Listen to Your Audience
Hitting send is just the beginning. We use BigMailer to manage our growing list of 14,000 subscribers. We track the data, handle automated unsubscriptions, and listen to direct feedback. Your readers will tell you exactly what they want to read. You just have to pay attention.
We are always looking ahead. We plan to launch a mobile application and continue refining our delivery process.
If you want to see this system in action, I invite you to subscribe. You can also explore our content at today.collab365.com or join the Collab365 Academy.
Want to build something similar? Reach out. Simple hellos are always welcome at hello@collab365.com.

