I have 3 RSS feeds, I merge them together and want to keep 1 article off which the title contains a keyword, I have stored in google sheets . If he doesn’t find matching keyword he has to go back and take other article. I can’t figure out how to do it. Do I need AI Agent or what nodes ? Thanks for your help
What is the error message (if any)?
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
First, you’ll want to read your RSS feeds. You can do this in two ways: either create three separate RSS Read nodes, one for each feed, or make a small script that generates the URLs and loops through them to read each feed one by one.
Next, you’ll want to combine all those articles into one list. For that, just add a Merge node in append mode, and connect all your RSS nodes or loop outputs to it. That way, you’ll have all the articles together.
Then, you’ll need to get your keywords from Google Sheets. Use the Google Sheets node to fetch your keywords whether they’re listed one per row or in a column and load them into n8n.
Finally, you’ll want to filter those articles based on your keywords. Here’s the trick: use a Code node with two inputs one coming from your merged articles, and the other from your keywords. Inside that code, you’ll turn your keywords into lowercase, trim spaces, and then check each article’s title to see if it contains any of the keywords. As soon as you find a match, you keep that article and stop searching. If none match, you can decide whether to send nothing or a message saying “no match.”
This way, you keep everything simple, fast, and totally under control no need for AI agents or complicated setups. Let me know if this helps!