Need an excel script to find which folder a specific file is

Hey, I Need an excel script to find which folder a specific file is and once found print the name of the folder to a field in the google sheets. The name of the file to be searched will be always int he next column for example: sample.pdf

So the script has to find "sample.pdf" in the the google drive and if its found in root/work/january/basic/sample.pdf would have to catch the folder name "basic"