Automate Email Notifications from Google Forms Using Google Apps Script: GAS094

Introduction

I'm creating an add-on for Google Forms that utilizes Google Apps Script to automate email notifications based on user responses. You'll have the flexibility to personalize the email subject, body, cc, and bcc fields. Additionally, a straightforward workflow allows you to distribute emails to various groups based on specific form field values. Essentially, it's a classic mail merge application designed to streamline communication and enhance efficiency.

YouTube

If you're a visual learner and prefer watching video instructions, I highly recommend checking out this video.

Instructions (4 Steps)

To establish your own project, adhere to the following steps:

Step 1

Utilizing the provided link, you can create a duplicate of my project on your Google Drive. To make the form more relevant to your business, modifications are necessary.

Make a copy

Step 2

To meet the authorization requirements, open the copied Google Forms document. In the add-on menu, locate the custom menu named "Mailman" Within this menu, select any of the available buttons.

* Check the authorization guide if unfamiliar with the process.

A Complete Guide to Authorize GAS Project

Step 3

After completing the authorization process, navigate to the Google Forms add-on menu and select "Settings".

Mailman Field - A single or multiple select field from your form that will be used to send the email notification, you can then enter the comma separated email addresses for each option.

Subject - The email notification subject, you can use placeholders here.

CC - Optional, comma separated email addresses.

BCC -  Optional, comma separated email addresses.

Body - The email notification body, you can also use placeholders here.

ON/OFF Toggle - Enable or disable the email notification.

SAVE - Save the settings.

TEST - Send a test email to yourself.

REFRESH - If you've made any edits to your Google Form, consider refreshing the page to ensure that the settings display the most up-to-date form fields.

Step 4

With your settings configured and the toggle enabled, submit a test response from the form to receive a similar email like this.

Other Features

• To understand my code, open the Apps Script editor. To do this, navigate to "Extensions" in the menu bar, and then select "Apps Script.”

GoogleAppsScript Playlist (Subscribe for New Projects)

Links

Hire me on Upwork  Donate (PayPal) YouTube Github Twitter / X Instagram