Automatically create new folders in Google Drive, generate templates in new folders, fill out text automatically in new files, and save info in Google Sheets. Just 01-click!
Listing updated:October 20, 2024
Works with:
76K+
Overview
Let's automate the following 07 steps with just one-click from Google Sheets:

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

Watch the “How It Works video” OR Read more to understand how to automate your Google Drive using your Google Sheets.

WHEN AUTOMATE CREATE new folders, you can: 
- Contain multiple subfolders within them. 
- Customize the name and structure of the new folders and its subfolders according to your preference.
- Utilize sequential numbering on Google Sheets to define the structure of the subfolders.
- Set up the folder structure once and enjoy its repeated usage in the future.
- Option to automatically add a new folder to multiple existing folders.
- Centralize the storage of all folder information within a single Google Sheets document. This information includes created date, name, link to folder, creator, and more.

WHEN AUTO GENERATE new files from templates, you can: 
- Change the templates as your preference. The new files are generated from commonly used template files that you and your company utilize.
- Automatically place them in the newly created folder.
- Option to automatically add a new file to multiple existing folders.
- Option to create multiple new files within each folder and subfolder.

WHEN AUTO CREATE new files, you can: 
- Automatically replace text segments in newly generated files.
- Customize and set up replacement fields in the new file. Maximum of 5 replacement fields.
- Utilize Google Sheets to configure the desired replacement fields.

Manage your Google Drive directly from your Google Sheet by using this add-on.

Organize the new folders and files inside your Google Drive as what you are typing in your Google Sheet.
 
USE THIS ADD-ONS IF:

1) You want to auto create a bulk of new folders and files in your Google Drive within one click. 

2) You hate to create a Google Drive folder and its child folders manually. You hate to execute the duplicated work manually. You hate copy-paste-rename of folders and files manually.

3) You love automation. You love to manage your Google Drive and its structure from your Google Sheets. 

4) You love to centralize the storage of all folder information within a single Google Sheets document. This information includes created date, name, link to folder, creator, and more.

Join over 32,000 people using this add-ons to remove the duplicated task when working with the Google Drive folder and files. 

The add-on has been chosen by people from corporate environments including leaders like Stanford University, Nature [.]com, Hawaii University, Boston Public Schools, CodeChef[.]com, Blockchaincenter[.]io, explore-data science[.]net, and more.

Common use cases include field services, sales department, human resource, education, accounting and tax, digital agency, video production, construction, furniture and a whole lot more!

GETTING STARTED
(1) Install the AC2F add-ons.
(2) Click the download template button from the AC2F's menu. Sign up.
(3) Check your email to get your free license key.
(4) Define the Google Drive folder and file structure as you want from your Google Sheet.
(5) Enjoy Auto-create bulk of new Google Drive folders and files. 

FOR MORE INFORMATION:  

(1) SET UP: https://www.timkhachhang.net/blog/auto-create-folder-and-file-on-google-drive-set-up/ 

(2) FQA: https://www.timkhachhang.net/blog/auto-create-folder-and-file-google-sheets-add-on-fqa-p616779/ 

(3) USER GUIDE: 
https://timkhachhang.net/blog/category/auto-create-folder-and-file/ 

(4) VIDEO TUTORIAL:
https://www.youtube.com/playlist?list=PLWaIL_RL14zvRJ_gpBCTiU7FazwgKAvQy 
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
Auto create folder and files will ask for the permissions shown below. Learn more
Auto create folder and files will need access to your Google account
This will allow Auto create folder and files to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete only the specific Google Drive files you use with this app
View and manage metadata of files in your Google Drive
See, edit, create, and delete all your Google Slides presentations
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Admin Newway
November 11, 2023
Google ecosystem in general and G-Drive in particular have become crucial to my works and myself. And organising Google Drive is always a headache to me ever since. I used to make a mindmap before manually creating each folder and its contents (sub-folders and files), it really took time to finish. And along the usage, I usually need to make the "inventory" of my Drive. With this add-on, I can easily manage from the beginning and along the usage. This is very usefull and super easy to work on, even for a someone with basic knowledge of IT like me.
Is this review helpful?
Yes
No
Profile Picture
Dhivyabharathi. A - Product - Engineer
January 23, 2024
It is cool one, very useful for my team to save lot of time. we can organise the team folder in wonderful manner. I thank to customer service support when were i sent mail they are continuously supporting without any hesitation.
Is this review helpful?
Yes
No
Profile Picture
Adrien NoDataNoBusiness
June 3, 2022
Really cool add-on, easy-to-use and very useful for people who count on a perfect Drive set up for an efficient work ! I could create 10 folders and subfolders with just 1 click :), what else ? ;)
Is this review helpful?
Yes
No
Profile Picture
Thứ Hai Đại Lý
June 21, 2022
I really like the Mode 01 as It helps me to auto create a parent folder and up-to 10 sub-folders on Google Drive with 1-click only. Five star for the add-ons.
Is this review helpful?
Yes
No
Profile Picture
Mobile ERP
August 17, 2022
This add-on saves a lot of time for my team. We are a media production company. My team have 10 members. Everyday, As a manager, I need a tool to auto create a workspace for my team to collaborate with each others. Using this add-on, It takes only one click, then all of my team member have their own workspace for their daily project. If you are middle manager and you love to use Google Drive as the workspace for your team, It recommends that you should use this add-on as soon as possible.
Is this review helpful?
Yes
No
Profile Picture
Đại lý Thứ Nhất
March 26, 2022
Brilliant! Save a ton of time for me.
Is this review helpful?
Yes
No
Profile Picture
Khoe Van Huynh
December 10, 2020
this is horrible add on, it not working and missing folder and very hard to using.
Is this review helpful?
Yes
No
Profile Picture
kham Nguyen
July 13, 2021
yeah, it save me a lot of time.
Is this review helpful?
Yes
No
Profile Picture
Vo Tu Duc
July 13, 2021
Save a ton of time for me!
Is this review helpful?
Yes
No
1-9 of 9
Search
Clear search
Close search
Google apps
Main menu