A Google App script tutorial for Google Sheet, Google Form and Google Mail
We are going to design a Google form. For one of the fields we are going to create a select list which shall pull content from an existing Google Spreadsheet.
When the user submits data through this form, the response is first stored in another Google spreadsheet and response details are also sent to a Gmail account.