News Summary

Automation for Power Automate and Build AI (ChatGPT, Copilot, etc.).

I have a list of RSS feed URLs from different websites (about 20).

Extraction:

I would like the news to be saved in an Excel file.
For each piece of news, I want to save:
Date, Title, and URL.
The content needs to be accessed by going to the URL and obtaining the content from there.

Processing:

Group in a new Excel file the news that are about the same topic but from different sources.
Columns:
- Date: First appearance
- Title: Summary of the news
- URLs: List of URLs of the news
Grouping by days and by weeks.

Generation:

I would like to choose the 2, 3, or 4 most interesting news and have a summary generated with all the information from the news by ChatGPT or similar.
I would like to have control over how the summary is generated, whether it is longer, shorter, with a certain tone, or another. I want the freedom to do prompt engineering with all the texts of the grouped news.