RSS Feed Duplicating Data in Google Sheets - Need Help with Filters

Getting Started
1

Hi everyone, I’m really new to this and its taken me days to set this up. I ran into a problem with my automation sequence.

The automation is suppose to start with Google Sheets to get a range value, then Google Sheets again to search for rows.

After that I have the RSS feed items that then populates Google Sheets add a row with the values from the RSS feed.

So I’m creating an RSS feed from multiple websites at the same time using that automation, pulling data from the site RSS feed into Google Sheets.

Heres the problem:
When I hit the run button the first time, the RSS feed populates Google Sheets with all the data I want.

When I hit the button a second time, whether its the same day or next day, all the exact same URLs and data from the RSS feed gets duplicated over and over again in an endless loop.

I can’t figure out how to set up the proper filter to only populate or add a row when there is a new article or unique URL and data set.

image
image1336×807 66.3 KB

The screenshot below has duplicate values highlighted.
So you can see, all the yellow highlighted URLs have been duplicated some where in the sheet.

image
image1427×1220 126 KB

image
image1431×1227 123 KB

2

Hello @seoautomation,
Welcome to the community.

Quick Solution

I think you need to use the Route module with filters.
Router ⇒ https://www.make.com/en/help/modules/router
Filters ⇒ https://www.make.com/en/help/scenarios/filtering

How it works - Long details

See these long detailed videos and course materials which give you more clarity.

https://academy.make.com/courses/FoundationC02
After checking these things you get an idea about how to implement those filters and prevent duplication.

:bulb:P.S.: Always search first in community, Check Make Academy.
If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down:

3

How would I write out the logic in the filter? I’ve spent a few days on this and cant figure out what is the right formula and where to add the filter either before or after RSS feed?

4

Can you provide support on how to write out the formula and what to do exactly?

5

Please share these things.

  1. Your scenario blueprint.
  2. Sheet structure screenshot
  3. Multiple Sample data(2-3) of rss feeds.

That’s helps me to use it on my side and send back to you.

6

Thanks for getting back to me. Sorry for the late response I will share the blueprint and the Google sheet with you.