Discussions
Save Google Forms uploads to a Shared Drive
Google Forms is a great way to quickly generate a web form to collect information. However, if your form includes a file upload field, the Form must be saved to your Personal Drive folder and any files that are uploaded in Form submissions are saved in the same location. This becomes a nuisance for organisations wanting to use Forms as we usually want form submissions saved to a Shared Drive location.
Luckily, this can be easily achieved using zenphi.
Create a Flow using a Forms trigger and configure it to start whenever your Form is submitted.
Inside the Flow, drag on a ‘Foreach Loop’. Next drag on a Move Item action inside the loop.
![](https://www.linkpicture.com/q/67.png)
Configure the Foreach Loop to iterate over the collection of files that are submitted with the Form. To do this, select the Trigger->(File Upload form field).
![](https://www.linkpicture.com/q/68.png)
Next, configure the Move Item to move each uploaded file in the form to a folder in a Shared Drive.
![](https://www.linkpicture.com/q/69_3.jpeg)
In the File or folder field, select the ID of the file in the Foreach Loop action. Set your destination location using the Drive picker.
![](https://www.linkpicture.com/q/70_12.png)
And that’s it. You will need to repeat this for each File Upload field you have in your Google Form. You could also create a new Folder for each submission at the start of the Flow and store the files in subfolders if necessary.