How to Create a File Upload Form & Upload Files to Google Drive Using Pabbly Connect

Learn how to create a file upload form and automatically upload files to Google Drive using Pabbly Connect in this detailed tutorial. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Creating a File Upload Form with Jotform

To start the integration process, we will create a file upload form using Jotform. This form will allow users to submit their assignments along with their details. By utilizing Pabbly Connect, we will automate the process of uploading these files to Google Drive.

In your Jotform account, create a new form and add the necessary fields such as name, email, phone number, and a file upload field. Once your form is ready, you can proceed to integrate it with Pabbly Connect for automation.

2. Connecting Jotform to Pabbly Connect

To connect your Jotform with Pabbly Connect, you need to access the Pabbly Connect dashboard. After signing up, click on ‘Create Workflow’ and name it appropriately, such as ‘Jotform to Google Drive’.

Next, you will set up the trigger event in Pabbly Connect. Select Jotform as the app and choose the ‘New Response’ event. This will generate a webhook URL that you will need to add to your Jotform settings under the Integrations tab. Follow these steps:

• Open your Jotform form and go to Settings.
• Select Integrations and search for Webhooks.
• Paste the webhook URL from Pabbly Connect and complete the integration.

After completing these steps, make a test submission on your Jotform to ensure that the integration captures the data correctly in Pabbly Connect.

3. Uploading Files to Google Drive via Pabbly Connect

Once you have successfully connected Jotform to Pabbly Connect, the next step is to upload the files to Google Drive. In the action window of your workflow, select Google Drive as the app and choose the ‘Upload a File’ action event.

Connect your Google Drive account by clicking on the ‘Connect with Google’ button. You will need to provide the URL of the file uploaded in the Jotform response. Here’s how you can do it:

• From the Jotform response data, map the file URL to the Google Drive upload field.
• Specify the folder ID in Google Drive where you want the file to be stored.
• Provide a name for the file, ensuring to include the file extension.

After setting up these fields, click on ‘Save and Send Test Request’ to upload the file. Verify that the file appears in the specified Google Drive folder.

4. Sending Confirmation Emails via Gmail

To enhance user experience, you can send a confirmation email to users who submit the form. In Pabbly Connect, add another action step and select Gmail as the app. Choose the ‘Send Email’ action event.

Connect your Gmail account and set up the email details. You will need to map the recipient’s email address from the Jotform response data. Here’s how to configure the email:

Set the email subject, such as ‘Assignment Submitted’. Compose the email body, including a greeting and confirmation message. Optionally, you can add attachments if needed.

Once you’ve configured the email settings, click on ‘Save and Send Test Request’ to send the confirmation email. Check your Gmail inbox to confirm receipt of the email.

5. Testing and Verifying the Automation

After setting up the entire automation process, it’s crucial to test the workflow to ensure everything is functioning correctly. Go back to your Jotform and submit a new test entry with a file upload.

Once you submit the form, Pabbly Connect should capture the response and automatically upload the file to Google Drive, followed by sending a confirmation email to the user. Here’s how to verify:

Check Google Drive to see if the uploaded file appears in the designated folder. Look in your Gmail inbox for the confirmation email.

If both actions are completed successfully, your automation using Pabbly Connect is working perfectly. You can now streamline the process of collecting file uploads and managing them efficiently.

Conclusion

In this tutorial, we demonstrated how to create a file upload form using Jotform and automate the upload of these files to Google Drive using Pabbly Connect. We also covered how to send confirmation emails via Gmail. This integration not only saves time but also enhances the user experience significantly.