Question

How do I create a Google Drive folder and organize uploaded files from a Google Form submission?

  • 4 March 2024
  • 7 replies
  • 121 views

Userlevel 1
Badge

Upon submission of a Google Form, how do I create a Google Drive Folder and place files uploaded into that folder that were collected within the form? 

I have a form that has 3 different questions, each containing images for PDF files. When the form recipient completes the form, I want the following actions to occur:

  1. Create a new Google Drive folder (I figured this out)
  2. Find the files uploaded in the form across all 3 questions and upload them into the new folder that was created (this is the step I can not figure out)

Any suggestions? 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7
Badge +14

Hi @cfalcone01 

Try using the Looping app to handle 1+ files: https://zapier.com/apps/looping/help

Userlevel 1
Badge

@Troy Tessalone Troy, after my initial trigger, I don’t even see any options to “get files from google form results” > am I missing something? 

Here is a screenshot of my current Zap. You’ll see with the trigger and first action, I am able to “Create a new Google Drive folder upon a new form submission” but then the next action options aren’t there to “get form results”...

 

Userlevel 7
Badge +14

@cfalcone01 

The Zap trigger step should return links for the uploaded files.

Make sure to test with a GForm trigger example that has files submitted.

You probably don’t need another GForms Zap step.

Userlevel 1
Badge

@Troy Tessalone I submitted a form with uploaded files. Wouldn’t I need another GForms Zap step to “get” those specific files? or would that be with another app?

Userlevel 7
Badge +14

@cfalcone01 

Search the DATA OUT from the Zap trigger step for “http” to see if the submitted file links that get hosted on GDrive are returned.

Userlevel 1
Badge

Yes, I see those files are returned for each of my “upload a file” question in the GForm. However, what do you suggest I use for this third action (“3. Action”) in order to send those file links to the new folder I created? 

 

Userlevel 7
Badge +14

@cfalcone01 

Try using the Looping app to handle 1+ files: https://zapier.com/apps/looping/help