1. What It Is
A Google AppScript that reads a list of folder and subfolder names from a Google Sheet and creates that folder structure in Google Drive automatically. Useful for setting up a consistent directory layout without clicking through Drive one folder at a time.
2. How It Was Built
- Created a Google Sheet with the folder names laid out in columns (folder → subfolder)
- Opened the AppScript editor from the Extensions menu
- Wrote the script to loop through the sheet rows and create the corresponding folders in Drive — used GPT to help write the code since AppScript was new
- Ran it and confirmed the folders appeared in Drive as expected
3. Observations
AppScript syntax was unfamiliar going in; leaned on GPT to get the code right. The script works for the basic use case. A potential next step would be packaging this as a no-code tool or a simple Chrome extension so others can use it without needing to open the script editor at all.