I want to download the Complete List of Folders and the Sub Folders and the Names of the Files in my Google Drive
This doesn't have anything to do with Appsheet. I would google that if I were you.
Shouldn't be difficult to achieve with Apps Script
Do you have that app script as there are around 5000 folders and 80000 files which I need the structure along with URLs in the following format
Level 1 - Level 2 - ---------Level 10 - Folder Name - File Name
Folder Name - Sub Folder - File Name - Folder URL - Subfolder URL - File Name URL
No unfortunately, I'll have to write it, sorry. But again, it shouldn't be difficult if you know Apps Script. If you have some basic scripting knowledge but do not know Apps Script, it won't be difficult for your to learn it.
In any case, as @Marc_Dillon said, this has nothing to do with AppSheet.
You can do this with the free, open source, command-line, indispensable GAM tool. Check out https://github.com/jay0lee/GAM/wiki, https://github.com/taers232c/GAMADV-XTD3/wiki, and https://groups.google.com/forum/#!forum/google-apps-manager for more details.
Hope that helps,
Ian