How to Get Email Notification when User Submits Data Using Google Form ?
We can use Google Document for creating google documents like Word,Excel and Presentation. Google Document also provides us to create Form that can be embedded in the Webpage.Whenever user submits form then the entered data is stored in the excel file.
How to Get Email Notification when User Submits Data Using Google Form?
Steps to Get Email Notification when user Submits Data Using Form:
- We must have Google Account to access Google docs.
- Access your Google account and Go to Google Documents.
- Create Sample Form so that we can embed that form in our webpage.
- Create form using Google docs. Add Controls such as Textbox and Textarea in the form.
- Now Copy the code given and embed this code in your webpage or survey page. Now Survey page will have form and a submit button. User can fill information and after finishing he/she can submit data.
- As soon as Used Click on the Submit Button, Entered data will gets collected in the excel file inside Google Docs.
- Our aim is that, instead of checking excel sheet again and again we should get direct email notification in our mail so that admin can be informed about entered data.
- Open Excel File in Google Docs ==> Click on Tools ==> Notification Rules .
- Check this option (A user submits a form)
- User will get notifications as soon as user submits a form.
- Open Script Editor –
- Inside Script Editor Copy This Script so that you will get user entered data in email notification. Copy paste the following script and save it.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | function sendFormDataByEmail<span style="color: #308080">(</span>e<span style="color: #308080">)</span> <span style="color: #406080">{</span> var email <span style="color: #308080">=</span> <span style="color: #800000">"</span><span style="color: #1060b6">myname@domain.com</span><span style="color: #800000">"</span><span style="color: #406080">;</span> var subject <span style="color: #308080">=</span> <span style="color: #800000">"</span><span style="color: #1060b6">Google Docs Form Submitted</span><span style="color: #800000">"</span><span style="color: #406080">;</span> var message <span style="color: #308080">=</span> <span style="color: #800000">"</span><span style="color: #800000">"</span><span style="color: #406080">;</span> <span style="color: #200080;font-weight: bold">for</span><span style="color: #308080">(</span>var field in e<span style="color: #308080">.</span>namedValues<span style="color: #308080">)</span> <span style="color: #406080">{</span> message <span style="color: #308080">+</span><span style="color: #308080">=</span> field <span style="color: #308080">+</span> <span style="color: #1060b6">' :: '</span> <span style="color: #308080">+</span> e<span style="color: #308080">.</span>namedValues<span style="color: #308080">[</span>field<span style="color: #308080">]</span><span style="color: #308080">.</span>toString<span style="color: #308080">(</span><span style="color: #308080">)</span> <span style="color: #308080">+</span> <span style="color: #800000">"</span><span style="color: #0f69ff">n</span><span style="color: #0f69ff">n</span><span style="color: #800000">"</span><span style="color: #406080">;</span> <span style="color: #406080">}</span> MailApp<span style="color: #308080">.</span>sendEmail<span style="color: #308080">(</span>email<span style="color: #308080">,</span> subject<span style="color: #308080">,</span> message<span style="color: #308080">)</span><span style="color: #406080">;</span> <span style="color: #406080">}</span> |
- Next go to Triggers –> Current Script’s Triggers and associates the Send Mail function with “On Form Submit” event.
- Save the Google script, authorize Google Docs to access your Gmail account (for sending email) and you’re done.