We want to send a news digest to users automatically. The mail should contain new/unread news posts from sites the user is following. Ideally this would happen on a fixed day in the week.
I found the auto-news digest feature, but this article says, it only sends news that are posted by someone in the direct management chain of the user or someone they are closely working with.
Is it possible to send a news digest for the followed sites instead? If this isn't a feature, can it be created as a logic app, azure function, etc.? Or are there third party products?
So far my only idea is, to create a program that loops through all users, and for each user querys Graph API for their followed sites, gets news from this site via Search API, creates and sends an email and then continues with the next user.