How do I create a Zap that individually copies files from Monday.com to Google Drive?

I am trying to:

• Copy files added to a column in Monday.com called Attached Files to a specific folder in my GDrive

I created this zap to do the following:

1. When an update is made to an item in Monday (NOTE: It would not surface my files column when I tried to use “Specific Column Value Changed in Board)
2. Get the column values for the Files column
3. Extract the URLs separately
4. Loop them so that each URL is sent to GDrive on it’s own rather than as a zip file
5. (NOTE: this is the step I’m having problems with) Figure out whether the file already exists in the GDrive, if it doesn’t, then
6. Upload the file to Gdrive with the Public URL from the Loop

I have two problems:

• this would be way easier if my Files column would surface for discovery in Step 1 

  

  • I’ve tried renaming the column
  • Using developer mode to see the name of the column
  • refreshing the data in Zapier
• In Step 5, I have files that I know have been uploaded, but they aren’t being found. I think this is because the file name is actually different than the Public URL link, but I can’t find data that displays only the file name. I’ve tried the results name from step 2, the public url from step 2 and step 3 and the result of the loop. I don’t think I want this step before the loop because the loop is what pulls all of the results into separate items, but moving it up didn’t seem to make a difference either.

  

   

Any help would be appreciated.