How to use Mode 09 of Auto create folders and Files add-ons

This is a guideline of using Mode 09 of Auto Create folder and files Google Sheets add-ons. The add-ons provide a way to Automate Folder Creation, File Generation, and Text Replacement in Google Drive from Google Sheets. Free to download it from Google Workspace Marketplace or get started with a guide on How to Auto Create Folder and File on Google Drive

What Mode 09 can do with a single click:

1. Automatically creates a new parent folder in Google Drive.
2. Automatically creates up to 10 new child folders and sub-child folders to the new parent folder.
3. Automatically generate multiple new files to each new child folder or sub-child folder. The new files are generated based on a commonly used template file.
4. Automatically substitute the TEXT within all the newly generated files.
5. Store All information about the new parent folder, new child folders, new sub-child folders and new files in a single tab. This information includes name, creation date, links and creators.

User-defined options

• Template file.
• Location of Parent Folder
• Name of parent folder, child folder and sub-child folder.
• Utilize sequential numbering on Google Sheets to define the structure of the child folder and sub-child folders.
• The number of new child folders and sub-children folders to be added to the Parent folder is one or more, but it must be less than 10 in total.
• The newly created child folder and sub-child folder could be blank or include newly generated files.
• Set up specific text values for substitution in your template files and Google Sheets.

Define these options by inputting them into Google Sheets. Define the parent folder structure once, then repeat to create it with a single click.

The template file is identified by its unique file ID. If you are unfamiliar with File ID and Folder ID in Google Drive, click here to learn more what is meaning of File ID and Folder ID in Google Drive

See the image below to have an overview of Mode 09.

Input in Google Sheets

Your input in Google Sheets is describe as below:

Output in Google Drive

With above input, after click to Mode 09, we will have an output in Google Drive as below:

Output in Google Sheets

Below is the output in Google Sheets after clicking to Mode 09.

Limitations

• The maximum number of new children folders and sub-children folders are 10.

• All information about the new parent folder, new children folders and new files are - stored in a single Tab. These information include folder name, file name, created date, link to folder, link to file, file or folder creator.

• [x ] Auto replace text in the new-created files

How to navigate to Mode 09

From your Google Sheets, navigate to Mode 09 as guide below:

Extension => Auto Create folder and Files => Premiums=> Mode 09

It is recommended that you should download the add-ons and watch the video tutorial for more detail. The above instructions are just an example that help you have a first look of how Mode 09 works.

Common scenarios to use Mode 09

License Issue

• Required having free license with lifetime access

• Lifetime access

Video tutorial

Other Modes guideline

[Mode 01]: Mode 01

[Mode 02]: Mode 02

[Mode 03]: Mode 03

[Mode 04]: Mode 04

[Mode 05]: Mode 05

[Mode 06]: Mode 06

[Mode 07]: Mode 07

[Mode 08]: Mode 08