I would like to create an index for all the files in a google drive folder on my Mac, using excel 2011. Preferably where one can insert the folder directory to index in a sheet, press "run", and then get all the files and folders there get listed in a new sheet.

I have tried a few scripts online but couldn't get them to work. There seems to be a problem with the DIR function using excel 2011 on Mac.

Does anyone know how to do this?

Thanks for the help!

André