Home » Services

Using Google Forms? Get Notified Of Submissions!

18. November 2009 by 5 Comments

Google Spreadsheet Form If your Google Sites or custom website is using Google Forms for data collection, you're probably quite familiar with going to the spreadsheet to collect information submitted by your site visitors. However, many times you want to know RIGHT AWAY that a customer is reaching out to you because they are a hot lead that you'll want to contact immediately.

Select Notification Rules from the Tools menuThe easiest way to do this is to subscribe to changes to this form. You do this from the "Tools" menu and selecting "Notification rules..."

Set Notification Rules screen On the resulting screen, you have your choice of options but most people will want to select the checkboxes for notification when "A user  submits a form" and to notify with "Email - right away". Once you've made these changes, you will receive an email notification each time a form is submitted.

Google Docs: forms list gadgetIf you are using a product like Google Sites for your intranet or you are using iGoogle as your default home page, you can always add the Google Docs: Forms List gadget. This will give you a list of all of your forms, the number of responses in the form, the number of new ones since the last time you viewed the spreadsheet as well as the date of the last submission. You can do this by using "Insert" menu, selecting "More Gadgets" and on Setup your gadget screen search for "Google Docs: forms list" to find the gadget. The results will look like the following and are very helpful if you are monitoring multiple forms.

Let us know using the comments below if you've tried this technique and if you've found it helpful. Or better yet, if you have a better way of doing things, please share this with all of us using the comment section below.

Comments (5) -

jenny
United States jenny said:

thanks a lot

mjg
United States mjg said:

I'm glad that you found it useful!

mjg
United States mjg said:

I THINK that anyone that has editor access to the spreadsheet behind the form can subscribe to the results.

Let me test that...

Yup, that is the case. They can't have just VIEW access though as they won't be able to access the Tools menu to do the notification.

Sorry for the delay in getting back to you. Your comment got lost in the spam onslaught we've been experiencing lately.

Savana
United States Savana said:

I do use Google forms and even docs due to its flexibility and the features that are similar to MS excel and sheet. I use this always for data collection because, at the same I can share this with a person I would like to.

http://www.blurbez.com/

vintage fashion
United States vintage fashion said:

Google docs and forms are so convenient. Writing and editing on the run, sharing - excellent.

Add comment




  Country flag
biuquote
  • Comment
  • Preview
Loading