How to get notified when someone submits a Google form?

Getting Notified When Someone Submits a Google Form

Google Forms is a powerful tool for creating and managing online forms, surveys, and questionnaires. One of the most useful features of Google Forms is the ability to receive notifications when someone submits a form. In this article, we will explore how to get notified when someone submits a Google Form.

Why Do I Need to Get Notified When Someone Submits a Google Form?

Before we dive into the solution, let’s consider why you might need to get notified when someone submits a Google Form. Here are a few scenarios:

• You want to send a follow-up email to the respondent after they’ve submitted a form.
• You want to notify the respondent that their submission has been received and is being processed.
• You want to send a notification to your team or colleagues after a certain number of submissions.

How to Get Notified When Someone Submits a Google Form

To get notified when someone submits a Google Form, you can use the following methods:

Method 1: Using Google Forms Notifications

Google Forms provides a built-in notification system that allows you to receive notifications when someone submits a form. Here’s how to set it up:

• Go to your Google Form and click on the "Settings" icon (gear icon) in the top right corner.
• Click on "Notifications" from the left menu.
• Select the notification type you want to receive (e.g. email, SMS, or in-app notification).
• Choose the frequency of notifications (e.g. every time a form is submitted, every 30 minutes, etc.).
• Click "Save" to save your changes.

Method 2: Using Google Apps Script

Google Apps Script is a powerful scripting language that allows you to automate tasks in Google Apps. You can use it to create a script that sends notifications when someone submits a Google Form. Here’s an example script:

• Create a new Google Apps Script project.

• Open the script editor and paste the following code:

  function onFormSubmit(e) {
  
  var form = e.source.getForm();
  
  var response = form.getResponses();
  
  var submissions = response.getSubmissions();
  
  var submissionsCount = submissions.length;
  
  var notificationType = e.notificationType;
  
  var notificationMessage = e.message;
  
  var notificationSubject = e.subject;
  
  
  
  if (notificationType == 'email') {
  
  var emailService = GoogleAppsScriptServiceApp.getMailService();
  
  var subject = notificationSubject;
  
  var body = 'You have received a new submission from ' + notificationMessage + '.';
  
  var mail = emailService.sendEmail({
  
    to: 'recipient@example.com',
  
    subject: subject,
  
    body: body
  
  });
  
  } else if (notificationType == 'sms') {
  
  var smsService = GoogleAppsScriptServiceApp.getSMSService();
  
  var message = 'You have received a new submission from ' + notificationMessage + '.';
  
  var phone = '1234567890'; // Replace with your phone number
  
  var sms = smsService.sendSms({
  
    to: phone,
  
    message: message
  
  });
  
  } else if (notificationType == 'in-app') {
  
  var notificationService = GoogleAppsScriptServiceApp.getNotificationService();
  
  var notification = notificationService.createNotification({
  
    title: notificationSubject,
  
    body: notificationMessage
  
  });
  
  }
  
  }

• Save the script and open the script editor.
• Click on the "Triggers" button in the left menu.
• Click on the "Create trigger" button.
• Select "On form submit" as the trigger type.
• Set the "Event" field to "onFormSubmit".
• Set the "Script" field to the script you just created.
• Click "Save" to save your changes.

Method 3: Using a Third-Party Service

There are several third-party services available that allow you to receive notifications when someone submits a Google Form. Here are a few options:

• Mailchimp: Mailchimp is a popular email marketing service that allows you to receive notifications when someone submits a form.
• HubSpot: HubSpot is a marketing, sales, and customer service platform that allows you to receive notifications when someone submits a form.
• Notion: Notion is a note-taking and collaboration platform that allows you to receive notifications when someone submits a form.

Conclusion

Getting notified when someone submits a Google Form is a useful feature that allows you to stay on top of your submissions. By using the methods outlined in this article, you can set up notifications to receive when someone submits a form, whether it’s an email, SMS, or in-app notification. Whether you’re using Google Forms for a personal project or a business, getting notified when someone submits a form can help you stay organized and focused.