I have a Google form that includes the upload of 5 files that could be Word, Excel, or PDF format.
When I receive a new response, I get the update of the Google Spreadsheet with the answers and the links to these files.
Now, these files are uploaded to the Google Form Response Folders.
How can I grab these files and move them to a New Folder under the Customer Name (filled in the Google Form). The files’ names change depending on the Customer and we have no way to know what the file’s name is going to be.
I have tried to create separate Zaps for each folder:
1. New File
2. Move File
But it asks for the File’s name, wouldn’t it be logical for the Zap to know that we are talking about this specific file that has just been uploaded to the folder?
Also, is it possible to have one Zap, trigger after another one is done? If the first File is uploaded I can create:
1. New File Uploaded
2. Create New Folder
3. Move File to New Folder (Even though this is not working)
But the other zaps are going to throw an error if the folder has not been created yet.
How can I move all the files uploaded through a Google Form to a Folder and change their names?
- Beginner
- 3 replies
+14- Zapier Expert
- 31047 replies
Hi
Help us have more info by posting screenshots showing how the file links are formatted in the GSheet.
Are the file links all in the same column or in different columns?
What file name format are you trying to use? (provide specific examples)
+5
I think if you look at the new file uploaded it will have the File ID in the response. You could select that as the file name for the move file. You can then move it to the folder you’ve just created. This ID should change each time a new file is uploaded.
+11- Community Manager
- 7532 replies
Hi there,
Were you able to get the Move File action working by referencing the File ID instead of it’s name, as Badger suggested?
Keen to ensure you’re all set so let us know whether you need any further help at all!
- Beginner
- 3 replies
Hey
+11- Community Manager
- 7532 replies
Yay! I’m so pleased you got it working,
If you’re open to sharing, we’d love to learn more about the workaround you used to get the file ID. It could be really helpful for others who might be facing a similar challenge. 🧡
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.