This is a step-by-step guide on how to Auto create Folders and Files on Google Drive by using Free Google Sheet add-ons. Please skip steps 1-4 if you have already installed the app.
Auto create folders and Files is a free Google Sheet add-ons. The purpose of this software is to offer Google Drive users a way to auto create a new directory which includes Folders and Files.
This is a very helpful application in terms of removing the duplication of daily tasks. It is a must-have Google Sheet Add-ons if your daily tasks is to create the new folders that have similar structure and to create the new files that follow your company template.
You also can watch the full guide via Youtube as video below:
Let’s get started.
Click here to create new google sheets inside your Google Drive. Set the file name as you want.
From your sheets, go to Add-ons and click to “Get Add-ons”
Search for the keywords: “Auto create folder & file” as screenshot as below:
Then click to install the app as screenshot as below:
If you successfully install, you will see a menu in the picture below.
We now need to download the pre-configuration and the license key.
Click the Download template button to download the template / pre-configuration.
Some new TAB will appear in your google sheet. There’s also a folder which has been created automatically inside your Google Drive.
All your folders and files will be created inside the folder later. We call it the master folder. You can change the name of the master folder as you want. We now just go on as default settings.
Now you need to sign up and get a license key. You will receive the key via email as soon as you fill in the form as pictured below.
You will receive an email with a key as pictured below. Copy the key and paste it into the Setup tab.
Open your sheet and put the key as position below.
We are ready to use the app. Let’s create the first example.
Just go to the app menu and click the Auto create folders & files button.
There some folders and files as shown below will be created automatically inside your master folder.
Inside every child folder, you will see a template file which has been created automatically. You can change the template as you want.
When running the application, you can set and change the name of the folder and template file as your real scenarios.
That’s all for installation and running the first example. You now can use the add-ons to create whatever kind of folders and files structure as you want.
Below are some examples of real scenarios.
You can create a folder to save everything for a new project in the picture below. Remember that you only need to 1-click to create this folder.
There is more. I really love that the app offers a way to manage the information of all folders and files at once.
We can easily access all folders and files inside the master folder as in the picture below. You can see this feature at the Output sheet.