Check if ID exists in a spreadsheet column against a list or array, if exists skip, otherwise add row

[Oozy6645]

I want to scan a google drive folder for files, which returns a list of file ID’s(I have this working) - currently this returns an array of File ID’s

Then search a spreadsheet column for rows that contain file id’s. Then check the results of the spreadsheet search result, if any id’s already exists, skip them, if they don’t exist in the spreadsheet(comparing against the google drive files list search result) add a row containing the file id. So i need to check each bundle result from column A and check if it exists in the array.

Seems simple and I have searched here but can’t quite get it.

[samliew]

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[Oozy6645]

Here are some screenshots, basically the scenario has custom variables for the spreadsheet and folder it is working in

It searches the folder using the folder ID and returns a list of files, which are then filtered for mp3’s only

The spreadsheet is searched in column A which might have file ID’s in it(or not), this column should be compared with the previous step

If there is a file id not in the spreadsheet but in the files list, it should be added as a row in the spreadsheet

[Oozy6645]

I think i found the answer by using a text aggregator