Skip to main content
2 of 4
deleted 11 characters in body
ale
  • 52.9k
  • 42
  • 165
  • 314

create a multiple choice question in Google form based on list of data

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem()
.setTitle('Do you prefer cats or dogs?')
.setChoiceValues(['Cats','Dogs'])
.showOtherOption(true);

However, how do I make it so that the list of choices come from a spreadsheet?

Subhi
  • 41
  • 1
  • 1
  • 2