(1) Click on the Tools button and click on the Script Editor.

While you are in the Sheet, launch the Apps Script Editor. More tips on Google Apps Script here Step3: Write the Automation Script to Prefill Google Forms After adding the questions you need to add the options under each question as shown below. If you prefer working with the Google Sheet click here. When trying to use Google Spreadsheet to autofill Google Forms, you have to make sure that you copy the same question. Now that we have added the questions to the Google Form, it's time to add the questions to the Google Sheet. Step2: Add the questions to the Google Sheet The Google Form Contains the following questions: In order to not ask the same questions twice, and reuse the data that had already been collected, I decided to create a Feedback form using Google Apps Script to autofill the options in the Google Form using the Google Sheet containing the student data. During event registrations, we had collected the data on attendees, the events and the speakers which were stored in Google Sheets. At the end of the Technical fest, we had to send out a feedback form to record their experience and suggestions on the various events that were conducted. Recently the College I study at had a Technical Fest that had multiple technical events.

Google app creator