Email Notifications for Google Forms

Email Notifications for Google Forms helps you automatically send email messages every time a respondent submits your Google Form. You can email notifications to yourself (the form owner), the form respondent or create notification rules and send emails to different people based on the form answers.The form notification emails can be customised and you can include any of the form fields (including Quiz score) in the email subject or the email body using the {{form field title}} notation. You can send emails in plain text or use HTML for professional emails.The Google Add-on can also send push notifications to your iPhone, iPad or Android when a new form is submitted. The mobile notification can include answers to form questions submitted by the respondent.If you have included any File Upload fields in your Google Form, the email notification will include links to the uploaded file in your Google Drive. Thus you can directly open the files from the email itself without having to find them in the Drive. You can also include dynamic barcode and QR codes in email messages generated from form answers.Google Forms and Email Notifications can be used by schools and organizations to quickly communicate with parents, students and employees who could be working from home during the Coronavirus (COVID-19) crisis.To learn more, check the help center and tutorials at https://digitalinspiration.com/docs/GA08------------------------------------------------------- Uses of the Google Forms Email Notifications Add-on-------------------------------------------------------1. Send confirmation emails to customers when they fill your contact form2. Save leads in your CRM by forwarding the form responses in emails3. Teachers can send acknowledgements to parents when students fill the form4. Get real-time notifications on your mobile phone when a new form is submitted5. Send coupon codes, event tickets, invites, product codes using QR codes and BarcodePremium Benefits------------------Compare free with premium at https://digitalinspiration.com/google-forms-premium-11184You can email up to 20 form responses per day with the free edition. Premium users on Google Apps (GSuite) can send up 1500 email responses per day while Gmail users can create up to 400 form responses daily. The limit resets midnight PST.Premium users can specify a condition and the form data will be forwarded to different people depending on the user's selection in the form. Conditions can be simple (like when product name is iPhone, send the email to iPhone support team) or you can use regex for specifying more complex conditions.The add-on includes branding in the outgoing email notifications. If you would like to remove the branding, please upgrade to premium (volume licenses and Google Apps domain licenses are also available).Premium users have the option to add one more email addresses in the CC or BCC fields including support for dynamic email fields computed from form answers.Premium Upgrade available at https://digitalinspiration.com/buyUpdate Date Time Formats---------------------------The default date time format is MMM dd, YYYY. You can go to the Add-ons menu, choose Email Notifications for Forms, Manage Form Settings and update the date format as well as the Google Forms' timezone. Here are some sample datetime formats:yyyy-MM-d hh:mm a -- 2016-11-28 06:30 PMyy-MMM-d HH:mm:ss -- 2016-Nov-28 18:30:22MMMM d, yyyy h:mm a -- July 12, 2016 12:19 PMEEE, d MMM yyyy -- Wed, 4 Jul 2016yyyy/MM/dd HH:mm:ss -- 2016/11/29 12:08:56----------------------------Google Forms Troubleshooting----------------------------If you are not receiving email notifications for new form submissions, please try the following steps:1. The notification add-ons sends emails through your Gmail account. Thus you need to have the Gmail service enabled for your Google Account.2. Ensure that your daily email limit is not zero.3. Ensure that you are not using multiple notification add-ons. Go to your forms' add-on menu and ensure that "Email Notifications for Forms" is available. You can remove other notification add-ons.4. Go to the add-on menu and choose Restart Add-on. This will reinitialize the email sending triggers for the form.5. If you have Google Apps for Education or Google Apps (free legacy edition), you would need to enable the Gmail service for your domain.6. Are are logged into multiple Google accounts in the same browser? Open Google Chrome, go to the menu and choose New Incognito Window. Here open the same Google Form in edit view and try adding a rule.If you still have issues, send the debug logs from the add-ons menu.Multiple Notifications Issue---------------------------If you are getting multiple email notifications for every new form submissions, please go to the Troubleshooting menu and choose Restart Notifications. If the issue is not resolved, go to https://digitalinspiration.support for support.Google Forms Tips:-------------------A: If you use Salesforce, Insightly, Hubspot or another CRM, you can redirect all form submission to the CRM with this add-on. Just get the email address for posting leads to your CRM and set up a notification rule that forwards all form responses to that email address.Changelog and Release Notes---------------------------v211 (October 02, 2020) - Added support for dynamic barcode and QR codes in email notifications based on form answers. Email validation algorithm improved.v210 (May 17, 2020) - Send conditional email notifications based on quiz scores of students in Google Forms. Improved the integrated Form Limiter that helps you open and close Google Forms on schedule.v209 (May 2, 2020) - Added option to specify a fallback email address of the user to notification when the form response does not match any of the specified conditions in the Google Form. Switch to ES5 since V8 has some unresolved issues with triggers.v208 (Mar 1, 2020) - Major release. Completely rewritten the Google Forms app for Chrome V8 which makes it faster and better.v207 (Sep 5, 2019) - Google Security Assessment complete. Scopes updated to reduce the number of permissions requested by the app.v205 (Jan 7, 2018) - Added option to include Google Form Quiz Scores in Email Notifications. Use markers {{Quiz Score}}, {{Total Quiz Score}} and {{Quiz Score Percent}} in email message body. The table rows are highlighted red or green based on the correctness of the quiz answer.v204 (Dec 25, 2018) - Added Google Form Limiter to help you set limits on your form. Open and close Google Form automatically at a specific date and time.v200 (Dec 03, 2018) - Support for rich push mobile notifications via IFTTT. Better support for resending old email notifications. Improved event handling for debugging form responses. Added support for CC and BCC addresses in the premium version. Migrated to ES6. Email notifications can be sent via the MailApp service for GSuite domains where Gmail is unavailable.v180 (Feb 21, 2018) - Improved conditional email notifications for sending email responses to multiple people based on user's answers.v177 (Jan 23, 2018) - New YouTube video tutorial added. Checks added for Gmail service and third-party cookies. Gmail is only required for higher email quota for Google Forms addon.v162 (Dec 18,2017) - If the third-party cookies were disabled in Google Chrome, the templates were not getting saved. This is now resolved. Image uploading capabilities integrated in email editor.v150 (Nov 28, 2017) - Create notification email templates in visual (WYSIWYG) mode or write your own HTML emails.v132 (Nov 20, 2017) - Major Upgrade. Add an Email Designer for creating notification emails, upload logos and other images in your emails directly from the add-on. Send emails from a generic no-reply email address. Option to remove the branding mark from emails. Rewritten the module for sending conditional notifications. Add names to individual rules for easy identificationv131 (Oct 16, 2017) - Added support for Checkbox Grid, File Uploads in Google Forms and List Items. Questions of type TIME are nicely formatted. Bug Fixesv128 (Sep 27, 2017) - Knowledge base available at https://digitalinspiration.com/docs/GA08v115 (July 5, 2017) - Improved formatting of the HTML table for displaying form responses. Added StackDriver console logging for improved error tracking.v109 (May 27, 2017) - The answers table in the email notification now groups answers by sections or pages for better readability.v102 (May 3, 2017) - Added option to manually resend email notifications to previous form responses.v99 (April 2, 2017) - Set up email notification based on form answers.v94 (Feb 22, 2017) - Added support for File Upload in Google Forms. The link in the email notifications will directly point to the uploaded file in the Google Drive of the form owner.v90 (Feb 19, 2017) - Added option to specify reply-to address for email notifications. Switched from military time to human readable time. Dates formatted in your specified format. Added checks to ensure form notifications are sent when triggers are inactive.v82 (Jan 14, 2017) - Added option to temporarily disable form notifications. Bug fixes.v75 (Dec 15, 2016) - Mobile notifications for Google Forms, powered by IFTTT.v63 (November 18, 2016) Increased daily email sending limit for Gmail users from 50 to 400 emails per day. Email reminder sent to form owner when daily limit is exhausted.v56 (November 2, 2016) Use your preferred datetime formats for Response Date. Update the default timezone of the form responses.v55 (September 9, 2016) Response dates are now correctly captured in the form owner's local timezone.v53 (August 23, 2016) Restart option added, bug fixes, improved debug log, switched to new activation screen.v50 (July 19, 2016) If your Google Forms is collecting respondents' email addresses, you can use the {{Username}} field to include the collected email into form notification.v40 (April 20, 2016) Email notifications neatly formats responses to checkboxes, multiple grid, and linear scale questions.v30 (April 15, 2016) Added support for non-English characters (accents, umlauts, foreign languages). Use the variable {{Username}} to include the respondent's email in the form body (if available).v20 (April 12, 2016) Send debug logs to the developer for troubleshooting. Bugfix related to editing email notification rules.v12 (March 14, 2016) Added support for the multiple-choice grid in email notifications.