Simple way to read Google Sheet into a Google Form using Google Apps Script. Creates a simple Google Forms survey from spreadsheet on Google Sheets using checkboxes and limiting to one response per user.
-
Create a Google Sheet
-
Add checkbox options to column A, one per line
-
Go to Tools -> Script Editor
-
Copy Code.gs to the editor
-
Click Run icon
-
Click View -> Logs to see Published and Edit link