Get customer queries emailed direct to your inbox

// Restrict the script's authorization to the form it is bound to.

//@OnlyCurrentDoc

// This is the first function we'll run manually, just once.

// Its job is to set up an "event listener" or "trigger"

// that waits for the form to be submitted.

function createFormSubmitTrigger() {

  // Get the current Google Form that this script is attached to.

  var form = FormApp.getActiveForm();

  // Check if a trigger for this script already exists.

  // This prevents us from accidentally creating multiple triggers

  // which would send multiple emails for each submission.

  var currentTriggers = ScriptApp.getProjectTriggers();

  if(currentTriggers.length > 0)

    return; // If a trigger exists, stop here.

  // Create a new trigger:

  // - "onFormSubmit" is the name of the function to run when the trigger fires.

  // - "forForm(form)" specifies that this trigger is for *this* particular Google Form.

  // - "onFormSubmit()" tells the trigger to activate specifically when the form is submitted.

  // - ".create()" makes the trigger active.

  ScriptApp.newTrigger("onFormSubmit").forForm(form).onFormSubmit().create();

}

// This function is the main worker!

// It's automatically called by the trigger *every time* someone submits the form.

// The 'e' parameter is super important – it's an "event object" that

// contains all the information about the form submission.

function onFormSubmit(e) {

  // From the 'e' (event) object, we grab the specific response that was just submitted.

  var formResponse = e.response;

  // A form response is made up of multiple "item responses" – one for each question.

  // This line gets all of those individual question-and-answer pairs.

  var itemResponses = formResponse.getItemResponses();

  // We start building the email's content (HTML for nice formatting).

  // The '<br>' tags are HTML for a line break, like pressing Enter.

  var emailBodyHtml = "You've received a new contact form submission from your Google Site:\n\n";

  // Now, we go through each question and its answer from the submission.

  itemResponses.forEach(function(itemResponse) {

    // Get the actual question text (e.g., "What is your name?").

    var title = itemResponse.getItem().getTitle();

    // Get the answer the user provided for that question.

    var response = itemResponse.getResponse();

    // Add the question (in bold using <b> tags) and its answer to our email body.

    emailBodyHtml += "<b>" + title + "</b><br>" + response + "<br><br>";

  });

  // Finally, we call another function to send the email with the HTML content we just built.

  sendEmailHtml(emailBodyHtml);

}

// This function is responsible for actually sending the email.

function sendEmailHtml(htmlBody) {

  // MailApp.sendEmail is a built-in Apps Script service for sending emails.

  // We pass it an object with several properties:

  // - 'to': The email address(es) where the notification should be sent.

  // - 'subject': The subject line of the email.

  // - 'htmlBody': The content of the email, interpreted as HTML.

  MailApp.sendEmail({

    to: "your-email@example.com", // <-- IMPORTANT: CHANGE THIS EMAIL ADDRESS!

    subject: "New Contact Form Submission from Your Google Site!",

    htmlBody: htmlBody // This is the HTML content generated by onFormSubmit

  });

}