Comparing Arrays

Questions
,
1

Hi everyone,

I have 2 sheets in google sheets:

One called Main, which imports an RSS feed.

One called Archive, where I store RSS items I have already processed.

Whats I have in Make & what I’m trying to achive:

In make, I use 2 search rows module from google sheets (each pulling from the respective sheets).

My aim is to create an array from the values that Main has and Archive doesn’t (basically making sure I haven’t processed them before and then adding that array to the Archive sheet so I don’t process them again)
I can’t figure out how to do it…

3

Hi @juan_burstein

Add a Search rows module to search for all Rows in Main.

Next, add another search rows module on Archive, that will run for each row found on the first one.

On the second module, add a filter on some unique value of both (url?) where the value being returned by the first module is equal to the value on the second one.

Then add a filter after the second module where the total number of bundles returned = 0, meaning no result was found.

@damato

4

Hey @damato

Thanks for the reply

I didn’t understand why add the last filter?

5

Because the flow would continue if it found the result or not on the second sheet. That would be equivalent to all records of the main sheet.

6

Welcome to the Make community!

To do this, you can try using the RSS “Watch new items” polling trigger module —

Triggers when a new RSS feed item is posted.

For more information about the module and app, see the corresponding Integrations page and the Help Centre documentation.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew