Store Google Form Responses in 3 different spreadsheets depending on form choices

Question

I have created a form in which students have to tell if they've formed a group of 4, 5 or 6 members and correspondingly fill out the email id's of all members in the group.
Right now, all the responses land in a single document, like this

I want that depending on the group size, 3 different spreadsheets be created. To say, All group of 4 responses in 1 spreadsheet, all group of 5 in one spreadsheet and all group of 6 responses in one spreadsheet. So 3 spreadsheets for the 3 group options. I was going through the web and I see its possible via App scripts but I couldnt figure out how. Any leads on this?

Answer 1

The easiest way would be to use an installable trigger on the form which is called on form submission. Rather than using the default functionality of adding all responses to a "Form Responses" sheet, your script would then take the raw form data and add it to the appropriate sheet based on the group size.

Answer 2

no need to use script for this which is not trivial to do and handle all possible errors.

instead simply use a combination of importRange and filter/query to the other spreadsheets from the master responses.

by using spreadsheet formulas your spreadsheets will always update correctly and instantly.