Best answer

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

  • 25 February 2023
  • 5 replies
  • 927 views

Userlevel 1

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?

icon

Best answer by Troy Tessalone 25 February 2023, 04:47

View original

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

Userlevel 7
Badge +14

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

 

Userlevel 1

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

Userlevel 7
Badge +9

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?

Userlevel 4
Badge +6

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.