I’m new to Make.com and I need help with Google Forms integration. I have a checkbox question on my Google Form. I want each user’s selected options to appear in my Google Sheet. Specifically:
All selected options from one user should be listed in the same column, but
Each selected option should be on a separate row.
How can I set up Make.com to do this automatically?
Most forms and especially Google forms already support putting the answers in a Google sheet. What you want in your sheet is a formula to pull the answers from that sheet, not a Make scenario.
I agree with Stoyan. Google Sheets can definetly do it. When you create a form, go to the Responses tab and click Link to Sheets. It will ask you to create a new Sheets file or use an existing one.
That file will contain a table called Form_Responses, with the Timestamp and all your aswers as columns. Once you have answers, the checkbox question column will show values as Option 1, Option2, ...
What you need is to unpivot these values. On another tab, split() the column and create values with all columns concatenated, separated by “|”, one for each option selected. Then, split that again by “|” to get the full row. Use ARRAYFORMULA to make sure values don’t overlap and QUERY to limit the search only to rows with values.
Something like this:
=QUERY(ARRAYFORMULA(SPLIT(FLATTEN(Form_Responses[Timestamp] & "|" & SPLIT(Form_Responses[<YOUR CHKBOX COL>], ", ")), "|")), "where Col2 is not null")
Concatenate other columns as needed.
Or, if you really want to use Make, just iterate over the values of the checkbox question and aggregate them to create an array, repeating the values of the other columns. Then bulk insert the array to Google Sheets.
What is your goal?
What is the problem & what have you tried?