FormTrigger Automate

Target Audience

• Small Business Owners: Streamline file management by uploading multiple files to specific Google Drive folders.
• Freelancers: Easily organize client files without manual sorting.
• Teams: Collaborate efficiently by managing shared files in designated folders.
• Educators: Collect and organize student submissions in an organized manner.
• Event Planners: Gather and categorize event-related documents quickly.

Problem Solved

This workflow addresses the challenge of managing multiple file uploads to Google Drive. It simplifies the process by:

• Allowing users to upload multiple files at once.
• Automatically creating a specified folder if it does not exist, ensuring that files are organized without additional manual effort.
• Maintaining the original file names and structure, which helps in easy retrieval and organization.

Workflow Steps

1. On Form Submission: Triggered when a user submits the form with files and a folder name.
2. Get Folder Name: Extracts the folder name provided in the form submission.
3. Search Specific Folder: Checks if the specified folder already exists in Google Drive.
4. Folder Found?: Evaluates if the folder exists:
   • If yes, proceeds to prepare files for upload.
   • If no, creates a new folder in Google Drive.
5. Create Folder: Generates a new folder in Google Drive if it does not exist.
6. Prepare Files for Upload: Prepares the files for upload to the existing folder.
7. Upload Files: Uploads the files to the existing folder while maintaining their original structure.
8. Prepare Files for New Folder: Prepares the files for upload to the newly created folder.
9. Upload to New Folder: Uploads the files to the newly created folder.