how to get email notification when google form is submitted

Get Real-Time Email Alerts for Google Form Submissions

By Christopher Harris
AD

Google Forms, a versatile tool for creating online forms, doesn't offer built-in email notification upon form submission. However, you can set up automatic email notifications using Google Apps Script. This guide will walk you through the process of getting email notifications when a Google Form is submitted.

Before we dive in, ensure you have a Google account and understand the basics of Google Forms and Google Apps Script. If not, familiarize yourself with these tools to make the most of this tutorial.

Setting Up Google Apps Script

Google Apps Script is a Javascript-based scripting language and custom function platform running in the cloud. It's used to automate tasks across Google products like Forms, Sheets, and Docs.

AD
How to edit google forms responses after submit? | Email notification
How to edit google forms responses after submit? | Email notification
Google Forms - Email Notification Script - Send Confirmation Emails to Users
Google Forms - Email Notification Script - Send Confirmation Emails to Users
How to Send Email Based on Response in Google Forms
How to Send Email Based on Response in Google Forms

To set up Google Apps Script for email notifications, follow these steps:

Accessing Google Apps Script

1. Click on the three vertical dots (⋮) in the upper right corner of your Google Form.

How to create a Google Form with conditional email notifications using Google Apps Script — helloteacherlady.com
How to create a Google Form with conditional email notifications using Google Apps Script — helloteacherlady.com
How to edit google form after submit? | Email notification
How to edit google form after submit? | Email notification

2. Select 'Select script editor' from the menu. This will open the Google Apps Script editor in a new tab.

Creyditing the Script

3. Delete any existing code in the 'Code.gs' file, and replace it with the following script:

AD

`function sendFormNotification(e) {
var email = 'youremail@example.com'; // Replace with your email
var subject = 'New form response';
var body = '

  • Name: '+e.values[0]
    +'
  • Email: '+e.values[1]+'
    ' +'
  • Message: '+e.values[2]+'
';
MailApp.sendEmail(email, subject, body);
}
`

4. Update 'youremail@example.com' with your email address.

Triggering the Script

Now that you've set up the script, it's time to trigger it whenever a form is submitted.

AD

Create a Form Submit Trigger

1. Click on the clock icon (or click 'Edit' > 'Current project's triggers' in the menu).

2. In the bottom-right corner of the popup that appears, click '+ Add Trigger' ︎.

3. Select 'sendFormNotification' from the dropdown menu, and choose 'From spreadsheet' as the event source.

AD

4. Click 'Save' to create the trigger.

Voila! You've successfully set up automatic email notifications for Google Form submissions. Test your form submission to confirm receipt of the email notifications.

Remember, Google Apps Script is powerful, but it might not be necessary for every use case. Explore other automation tools and methods to find the best fit for your needs. Happy automating!

AD