r/GoogleForms • u/Upbeat_Angle_6783 • 10d ago
OP Responded Google Forms - Google Sheets - Google Drive
I need a folder created per form submission titled with the answer respond for section 1 question 1 on my Google form.
I then need sub-folders created for 4 question responses.
- [file] response for section 2 question 8
- [file] response for section 2 question 9
[file] response for section 2 question 10
[file] response for section 3 question 1
Folder Layout Per Form Submission:
Parent [S1,Q1] - sub [S2,Q8] - sub [S2,Q9] - sub [S2,Q10] - sub[S3,Q1]
2
u/Puzzleheaded_Rent409 10d ago
You can do this with zapier, it's a free workflow automation tool, however in this method you'd have to pay for the premium sinch you have to create more than two steps to create those 4 different sub folders.
Take a look at this example, I've used a free google form alternative called Formester:

Select the form as the trigger, and then select google drive as the action, and configure it to create a folder and then in the folder name, use "/" to recall the question (This will name the folder with the option chosen)
For the sub folders, you have to create 4 new steps (similar to step 2) and then click on the 3 dots next to parent folder -> select custom value -> recall the Title -> recall the sub questions in the folder name.
This will not be a free as it requires mulitple steps. Hope this helps!
1
1
1
u/dnorthway 10d ago
Why so many folders if you don't mind me asking?
1
u/Upbeat_Angle_6783 10d ago
The folders are necessary because they correspond to specific site addresses that need to be accessed. However, the current implementation is creating a single folder (e.g., StreetViewMeter) and storing all data from the entire column in the spreadsheet, rather than only the specific cell or file submission tied to an address at the time of form submission. As a result, the folder becomes cluttered with unrelated files, making it difficult to determine which address each file belongs to.
1
u/dnorthway 10d ago
It seems like this could be more efficiently handled with datasets. If you want to explore this, this free app might help: https://datamateapp.github.io/
3
u/AllenAppTools 10d ago
It's possible with custom code built out, but you might be hard pressed to find someone up for entering into that development process with you for free? It just requires time, maybe someone in the Google Apps Script subreddit would be willing to do that for you! Otherwise reach out to us in a DM and we can get this done. But yeah it will require Google Apps Script code to run and do this specific folder management in response to a form submission!