How to Auto Create Folder and File on Google Drive

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 add-ons

Auto create folders and Files is a free Google Sheet add-ons.

With just one click from Google Sheets, you can automate the 07 steps below:

1. Auto-create new parent folders that contain multiple child folders in Google Drive.
2. Auto-create new files and organize them into the appropriate folders.
3. Auto-fill text into the newly created files.
4. Auto-save information about the newly created files and folders into your current Google Sheet.
5. Automatically add files to the list of existing folders.
6. Seamlessly add new folders to the existing list of folders.
7. Generate QR codes for each folder, enabling quick access through the Google Drive App by scanning to open the folder.

When using this automated document creation in Google Drive, you will no longer need to manually perform the following steps:

1. Copy or duplicate your template files or folder structure.
2. Paste your templates or folders into the appropriate location.
3. Rename the new files.

With this add-on, you can effortlessly create multiple folders and files on Google Drive simultaneously. You can manage your Google Drive and its document directly from Google Sheeets.

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.

Step 01 - Create new Google Sheets

Click here to create new google sheets inside your Google Drive. Set the file name as you want.

Step 02 - Go to Add-ons and Get Add-ons

From your sheets, go to Add-ons and click to “Get Add-ons”

Step 03 - Search with keyword: Auto create folders

Search for the keywords: “Auto create folder & file” as screenshot as below:

Then click to install the app as screenshot as below:

Step 04 - Install successfully

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.

Step 05 - Download template and get 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.

Step 06 - Create 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.

Step 07 - Auto create folders and files on Google Drive as your need

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.