Google Forms + Google Drive Integration
Create new Google Drive folder and store attachments into the folder on Google Form Submission
What is Form Director?
Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.
It is available in the Google workspace Marketplace.
Please check installation instructions to install the add-on.
What is Google Drive?
Google Drive is a file storage and synchronization service developed by Google.
Google Drive allows users to store files on their servers, synchronize files across devices, and share files.
Files created and edited through the office suite are saved in Google Drive.
Google Forms to Google Drive: Use Case(s)
> Create Folder in Google Drive and save Attachments on Google Form Submission
Create Folder in Drive on Form Submit
Demo: How to create Google Drive Folder and attach file uploads?
Demo: Advanced Integration with templated folder structure?
Setting up Google Drive App in Form Director
Choosing App and Service
Select Google Drive from the list of applications
Choose Create Folder from the service
Choosing Parent Folder
Click on Choose to Choose the Parent Folder under which you need to create new folder
Clicking on Create will allow you to create new Parent folder
OR use folder from previous service results
Switch on use folder from previous service results if you want to configure folder by choosing previously created folder from service result on Google drive
Use the existing folder by the Name
Instead of creating a new folder, you can also use the existing folder by folder name
If there is no folder found by the configured name, then a new folder is created
Configuring Newly Created Folder Name
Provide a name to the newly created folder
You can create folder with the name deriving from your Google Form input
Click on the three dots on the right side of the box to insert Form input as the Folder Name
Apply Templated Folder Structure
Switch on Apply Templated Folder Structure to copy contents (files & folders) from a Template Folder into newly created folder in Google Drive
Click on Choose to Choose the templated Folder
Adding Attachments to Folder
Choose the Attachments that needs to be stored in the newly created Folder by choosing the Form Fields that has Attachments from the dropdown
Switch on Share Generated Files if the generated files need to be shared.
Add the Recipient Email by clicking the "+" icon.
Add email from Form Fields also by clicking the "+" icon.
Add email from System fields also.
Choose the Attachment that needs to be renamed before inserting it into the folder.
Provide the name to file according to your requirement, you can also pick up fields from the Google Form.
Send your own customized emails on form submission to your audience.
Finish setting up
You are all set to create new Folder and save attachments into it on your Google Form submission
Submit the Form
Submit the Google Form