– Create a custom form with required fields. – Go to Settings at right side of form – make sure you tick, Collect email addresses checkbox
– Go to Responses tab – Click on Spreadsheet icon, Add exiting or new spreadsheet to store data
– Name your Apps Script Copy below code
1. namedValues are your column names 2. htmlBody will contain Body of email as well as cc and bcc email IDs 3. namedValues['Your name'] here Your name is column name 4. In Body tag, you can use HTML Markups
1. Choose which function to run: onFormSubmit 2. Choose which deployment should run: Head 3. Select event source: From SpreadSheet 4. Select event type: On form submit 5. Failure notification settings: Notify me immediately
You have added email notification trigger, which will drop email as mentioned whenever someone fills up the Google Form
There are 100s and 1000s of different use cases to utilize this functionality. You can design as per your need simply with mentioned code
Let us know in the comment section, what have you created using this email functionality?