This is a guideline of using Mode 06 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
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 06.
Your input in Google Sheets is describe as below:
With above input, after click to Mode 06, we will have an output in Google Drive as below:
Below is the output in Google Sheets after clicking to Mode 06.
All the folders which are added to a new folder must be located within a Parent folder.
The maximum number of new children folders are 50.
The name of a new folder that is added to the children folder is defined by the user’s preference.
The location of the parent folder is defined by the user’s preference.
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.
From your Google Sheets, navigate to Mode 06 as guide below:
Extension => Auto Create folder and Files => Free => Mode 06
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 06 works.
Required having free license with lifetime access
[Mode 01]: Mode 01
[Mode 02]: Mode 02
[Mode 03]: Mode 03
[Mode 04]: Mode 04
[Mode 05]: Mode 05
[Mode 07]: Mode 07
[Mode 08]: Mode 08
[Mode 09]: Mode 09