Merging RSS Feeds into JSON for AI-Driven News Summaries

Hey! I'm currently working with a project where I have multiple RSS feed sources. I have sent all of these feeds into a master table, and now I want to "merge" the rows into a JSON list and then send this list into a new table in the workbook, as a single row entry. So I basically want to compile multiple news from the RSS feed from the same date, and then with the help of AI write a summary of the news. I'm having trouble with how to send the rows and merge it into one. I'm familiar with the write to table and lookup functions, but they don't seem to do the job. What could be the right approach here?

8 comments

Channeled
APP
·
·
To handle multiple RSS feeds and create summaries in Clay, here's the recommended approach: 1. First, import your RSS feeds into your master table. The feeds will automatically update every hour to keep your data current. 2. Once you have your master table with all the RSS feed data, use the Write to Table feature to send the data to a new table. This will help you organize the datapoints into their own columns. 3. In the new table, you can leverage Clay's AI capabilities to: • Generate summaries of news articles • Filter content by relevant topics or trends • Consolidate information from multiple sources Clay's AI summarization features are particularly effective for condensing news articles and third-party content into actionable insights, making it ideal for your use case.
Sources: New RSS Feed reader source We Made 24 Prompts So You Don’t Have To [Automated Outbound] - Clay University Claybooks: Extract data from paginated databases in seconds | Clay.com
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Bharat D.
·
·
Hey Dante, There is a function called extract data from object. You can give that a try.
Dante E.
·
·
Thanks Bharat, I'll check it out
Dante E.
·
·
Unfortunately didn't work, does anyone know another solution?
Bo (.
·
·
Hey Dante! To merge multiple RSS feed entries by date and then summarize them with AI, here's what you can do: First, you'll need to group your RSS entries by date. You can create a formula column that extracts just the date part from your timestamp. Then use a lookup that targets this date column to group related entries together. For example: 1. Add a formula column that formats your timestamp as YYYY-MM-DD 2. Create a new Lookup that replicate this to number the rows. This is the formula if you want to copy it {{Unique ID}}?({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())> -1?{{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())+1:2):2 3. Add a filter, remove all the variations over 1 4. Add a lookup that works on the date, you'll now have unique date and the results for all those dates inside of the lookup. That'll also be able to be fed inside of the AI
The AI prompt could begin with: "Here are several news items from /date. Please provide a summary of these stories:"/lookup "
Let me know how it goes
Channeled
APP
·
·
Hi Dante E.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Merging RSS Feeds into JSON for AI-Driven News Summaries | Clay