With Document Studio, you can create new empty folders in Google Drive for every new row in a Google Spreadsheet.
For instance, you may have a list of customers in a Google Sheet and you want to create a new folder for each customer, if one doesn't exist already. The company's HR may want to create separate folders for each employee in the organization. In addition to creating folders, you can also share the folder with your customers and employees using Google Drive.
For this example, we have the employee records in a Google Sheet with the employee name, department and the employee's email address. We would like to create a new folder in Drive for each employee, using the path
/Department/Employee Name, and then share the folder with the employee itself so that they can access it as an editor.
Create Folders with Google Drive
Inside the Document Studio app, provide a descriptive name for your workflow and choose the specific worksheet in your Google Spreadsheet that contains the merge data. Click on
Continue to move to the conditions page.
Inside the Conditions section, specify if you want your workflow to run only if the row data satisfies certain conditions. For instance, you may only wish to create folders for employees in the IT and Legal department.
Google Drive from the list of available tasks.
Configure Google Drive Service
Create Folder as the Drive Service and select the parent folder in Drive where you would like to create the new folder. The folder may be in your personal Google Drive or a Shared Drive folder.
Next, specify the name of the new folder with the folder structure. For instance, if you want to create a folder for each employee in the IT department, you would specify
You may also put the email address question in the
Editor section to automatically share the folder with the respondent.
Preview and Save
Preview button and you should see a new folder in your Google Drive created using data from the first row in the Google Sheet. Click
Done to locally apply your changes.
Continue to proceed to the triggers screen. If you want the workflow to be automatically triggered every hour, so that any new rows added in that duration are processed automatically, you can choose the option
Run workflow every hour and then click on the
The workflow will now appear in the workflow dashboard where you can edit, delete or manually run the workflow.
If you would like to create multiple folders in Google Drive for a single row in your Google Sheet, you can add multiple
Google Drive tasks in the same workflow with the
Create folder service.