Skip to main content
Best answer

How do I upload multiple files on Google Drive when a form submission on Google Forms contain multiple attachments?

  • February 25, 2023
  • 5 replies
  • 1208 views

Dlader

I have a Google Form where there are multiple instances where a user will upload 1-10 photos per instance. When the zap triggers I am having difficulty getting those photos relocated to specific folders in Google Drive. It creates a zip file however the photos are not contained in the zip file, just long text files. What can I do to fix this?

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @Dlader 

Good question.

Make sure your GForm is connected to a GSheet to save the responses.

https://support.google.com/docs/answer/2917686?hl=en

 

Then you can use GSheet as your Zap trigger.

There will be a field that has the URLs of the files.

 

You can use the Looping app to iterate thru each file link: https://zapier.com/apps/looping/help

You can use a Formatter > Text > Split (split at “id=” and keep the last segment).

Example: https://drive.google.com/open?id=XXX would result in XXX

 

Then you can use the Zap action: GDrive - Move File

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31147 replies
  • Answer
  • February 25, 2023

Hi @Dlader 

Good question.

Make sure your GForm is connected to a GSheet to save the responses.

https://support.google.com/docs/answer/2917686?hl=en

 

Then you can use GSheet as your Zap trigger.

There will be a field that has the URLs of the files.

 

You can use the Looping app to iterate thru each file link: https://zapier.com/apps/looping/help

You can use a Formatter > Text > Split (split at “id=” and keep the last segment).

Example: https://drive.google.com/open?id=XXX would result in XXX

 

Then you can use the Zap action: GDrive - Move File

 


Dlader
  • Author
  • Beginner
  • 1 reply
  • February 27, 2023

Your answer makes total sense and it works. Thank you!


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • February 28, 2023

Yay! 🎉 Glad to hear that did the trick for ya. Thanks for letting us know. 🤗


This is very helpful. Thank you!

What if there are multiple times in a form where multiple files are collected? For example, All Logo Variations, and 10 photos as separate questions.

 

Is it possible to have two loops within a zap, or must i create multiple zaps so that I can loop multiple file uploads that correspond to different form questions?


Brem
Forum|alt.badge.img+6
  • Zapier Staff
  • 404 replies
  • April 6, 2023

Hi @vervecreative 

I suggest creating multiple Zaps if you like to loop multiple files.

Also, I recommend creating the Zap to see if the workflow you want to achieve will work for you.