... However for completeness I will list the scripts i used to generate the spreadsheet. The script that gets the path will list all the folders back to the root ...
... a script project which is bound to the spreadsheet (see link at the bottom of the page for more details). This uses code specifically for bound scripts ...