Bulk File Upload to Google Drive with Folder Management

This n8n workflow provides a streamlined solution for uploading multiple files to Google Drive, with intelligent folder creation and management based on user input. It simplifies the process of organizing uploaded content by automatically creating a new folder for each submission if one doesn't already exist.

What it does

This workflow automates the following steps:

1. Triggers on Form Submission: It starts when a user submits a form, likely containing file uploads and a desired folder name.
2. Checks for Existing Folder: It uses an "If" node to determine if a Google Drive folder with the specified name already exists.
3. Creates New Folder (if needed):
   • If no folder exists, it creates a new folder in Google Drive using the provided name.
   • It then sets the folderId to the ID of the newly created folder.
4. Uses Existing Folder (if found):
   • If a folder with the specified name already exists, it retrieves its ID.
   • It then sets the folderId to the ID of the existing folder.
5. Uploads Files: It iterates through the uploaded files from the form submission and uploads each one to the identified (or newly created) Google Drive folder.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Drive Account: A Google account with access to Google Drive.
• Google Drive Credentials: Configured Google Drive OAuth2 or API Key credentials within n8n.
• n8n Form Trigger: The form that triggers this workflow needs to be set up to collect files and a folder name.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New Workflow" or open an existing one.
   • Go to "Workflows" > "Import from JSON" and paste the code.
2. Configure Credentials:
   • Locate the "Google Drive" node.
   • Click on the "Credential" field and select your existing Google Drive credentials or create new ones if you haven't already. Ensure the credentials have sufficient permissions to create folders and upload files.
3. Configure the n8n Form Trigger:
   • Select the "On form submission" node.
   • Customize the form fields to collect the necessary data, including:
     • A field for the desired Google Drive folder name (e.g., a "Text" field).
     • A "File" field to allow users to upload files.
   • Note the names of these fields as you will need them for expressions in subsequent nodes.
4. Configure the "If" Node:
   • The "If" node will likely check for the existence of a folder based on the input from the form. Ensure the condition correctly references the folder name provided in the form trigger.
5. Configure "Edit Fields" (Set) Nodes:
   • There will be two "Edit Fields" nodes, one for the "True" branch (folder exists) and one for the "False" branch (folder needs to be created).
   • These nodes are responsible for setting the folderId variable that the Google Drive upload node will use.
   • Ensure the "Edit Fields" node in the "False" branch correctly extracts the ID of the newly created folder from the "Google Drive" (Create Folder) node.
   • Ensure the "Edit Fields" node in the "True" branch correctly extracts the ID of the existing folder from the "Google Drive" (Find Folder) node.
6. Configure "Google Drive" (Upload File) Node:
   • Ensure this node is configured to use the folderId variable set by the preceding "Edit Fields" nodes.
   • Map the file input from the "On form submission" node to the file upload field in the Google Drive node. You might need to use an expression like {{ $json.fileData }} or similar, depending on how your form trigger outputs the file data.
7. Activate the Workflow: Once configured, activate the workflow.
8. Test: Submit your n8n form with some test files and a folder name to ensure files are uploaded correctly and folders are created/used as expected.