HomeOur TeamContact

How to use mode 01 of Auto create folders and Files add-ons

By Vo Tu Duc
July 04, 2023
2 min read
How to use mode 01 of Auto create folders and Files add-ons

This is a guideline of using Mode 01 of Auto Create folder and files Google Sheets add-ons

What Mode 01 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 located within the parent folder.

  3. Automatically creates a new file within the newly created child folder.

  4. The new file is generated based on a commonly used template file.

  5. Store All information about the new parent folder, child folders, and files in a single tab. This information includes name, creation date, links and creators.

User-defined options:

  • Template file.
  • Name of children folders
  • Location of new Parent Folder
  • The number of new child folders to create. one or more. But it must be less than 10.

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 01.

Mode 01 - Auto create folder and files add-ons - overview
Mode 01 - Auto create folder and files add-ons - overview

Input in Google Sheets

Your input in Google Sheets is describe as below:

Mode 01 - Auto create folder and files add-ons - input in Google Sheets
Mode 01 - Auto create folder and files add-ons - input in Google Sheets

Output in Google Drive

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

Mode 01 - Auto create folder and files add-ons - Output in Google Drive
Mode 01 - Auto create folder and files add-ons - Output in Google Drive

Output in Google Sheets

Below is the output in Google Sheets.

Mode 01 - Auto create folder and files add-ons - Output in Google Sheets
Mode 01 - Auto create folder and files add-ons - Output in Google Sheets

Limitations

  • You are allowed to add only one template file into each new children folder.

  • The maximum number of new children folders are 10.

  • Auto creates a new file that is located in the new child folder.

  • The new file is created based on the template file which is defined by the user’s preference.

  • The location of the new 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.

How to navigate to Mode 01

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

Extension => Auto Create folder and Files => Free => Mode01

Common scenarios to use Mode 01

License Issue

  • Required having free license with lifetime access

  • Lifetime access

Video tutorial

Other Modes

[Mode 02]: https://timkhachhang.net

[Mode 03]: https://timkhachhang.net

[Mode 04]: https://timkhachhang.net


Tags

Google SheetsAdd-onsAuto create folder and filesMode1AutomatedGoogle Drive

Share

Previous Article
Website and Application Terms and Conditions of Use
Vo Tu Duc

Vo Tu Duc

A Google Developer Expert, Google Cloud Innovator

Table Of Contents

1
What Mode 01 can do with a single click:
2
Input in Google Sheets
3
Output in Google Drive
4
Output in Google Sheets
5
Limitations
6
How to navigate to Mode 01
7
Common scenarios to use Mode 01
8
License Issue
9
Video tutorial
10
Other Modes

Related Posts

How to add a folder in google drive
August 10, 2023
5 min
© 2024, All Rights Reserved.
Powered By

Quick Links

About UsContact Us

Social Media