My filter on Google Sheet is not working and I get duplicated tasks in make

How To
, ,
1

Hi everyone.

Probably for most of you this is very simple.

I am trying to get some data from a youtube channel so I can embed some videos on my website.

This is my module:

image
image1549Ă—429 46.1 KB

Basically I get a video from Youtube channel, set a variable where I put the ID of the video to the URL and post it with API POST on a Wordpress website.

It works perfectly, but I need to add a filter or a condition where I can avoid having duplicates.

So for this I have created a Google Sheet where I add a row with all the data, included the youtube video ID that runs everytime the automation publish something.

image
image1022Ă—451 13.7 KB

As you can see I have several duplicates.

I added aswell the filter here:

image
image987Ă—487 38.5 KB

With these settings inside:

image
image581Ă—527 26.3 KB

But now that I’m testing it, it runs multiple times, even if I set the filter where “ID Video” in Google sheet DOESN’T CONTAIN “ID Video” from Youtube result.

What am I missing?

2

What does your Google Sheets Search Rows configuration look like?

1 Like
3

image
image560Ă—840 45.8 KB

image
image560Ă—843 40.3 KB

Now that i’m looking at it, I think that it can be something wrong in the filter. Probably it should be " Contain". Am i right?

4

Yeah. Seems that the problem was in Google Sheet Search Row. I had to put in “Contain” on the filter

1 Like