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)