Compare Arrays - find entries in one Array that don't exist in other Array

How To
1

I may be overcomplicating things.

I have an array of URLs (extracted from a website’s sitemap) and a second array of URLs (extracted from a Google Search Console export in Google Sheets).

I want to find a list (array?) of URLs that exist in the Google Sheet but don’t exist in the sitemap.

My idea at the moment would be to iterate through the URLs from the Google Sheet and each time ask “does with URL exist in the sitemap URLs?” - but I don’t know how to do that.

Any ideas?

Screenshot 2024-12-17 at 17.09.59
Screenshot 2024-12-17 at 17.09.592208×448 77.5 KB

1 Like
2

Hey @Magganpice

  1. List the URLs from sitemap.
  2. Aggregate the URLs from sitemap.
  3. List URLs from google sheet
  4. Put an aggregator if you want the URLs altogether as a text or put a module from where you want to the filtered URLs.
  5. Before module in step 4, set a filter like below:

{{map(Array_From_Step2);url}}
Does Not CONTAIN (from array operator)
url from google sheet

Hope this helps.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation