Excel rows Topic Groupings with AI

So I got this automation where scrape AI Topic from certain news letters and place the information in a excel sheet. Lets say I have this running with multiple rows of articles from different sources. How would I go about creating an automation that on a different sheet with the same excel workbook creates a sheet where these stories are grouped together based on their similarity in topics or cover the same company? Similar to the original sheet however instead of an long list of all topics within different newsletter they are grouped based on similarity or connectedness of news topics. the group gotta be nicely separated in excel with like a empty row or maybe separated with a group name. Anybody got an idea or some tips?



AI Newsletter.json (70.2 KB)

Hello @Sam_Van_Leeuwen; why not when processing the individual entries, you have company and topics information extracted as well? Then place those as additional columns of information.

Then you could run AI on that sheet of data to create the grouping in a new sheet the way you want.

In the prompt instructions, provide examples of how to output the results with a topical header to create the structure you want.