How to send custom email to user with Google Form

Whenever you design any google form, and the user fill-up the form, Do you want the user to get notified with a custom email. Sounds exciting? Let’s get started

Create a custom form

– Create a custom form with required fields. – Go to Settings at right side of form – make sure you tick, Collect email addresses checkbox

Configure the form to store data in a spreadsheet

– Go to Responses tab – Click on Spreadsheet icon, Add exiting or new spreadsheet to store data

Go to Spreadsheet

Go to Scripts Editor

– Click on Tools – Select – Script Editor

It will pop up google apps script window in new tab

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

Add Trigger

– In left pane, Select Triggers (Allow pop-up) – Click on “Add Trigger”

Choose mentioned details

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?

Thank You