Google forms auto-notification when updated

October 23, 2009 7:36 AM

Looking for a way to have Google forms/spreadsheet send an e-mail notification when a form has been filled out.

We're thinking about using Google Forms to collect data from stakeholders. These forms would be updated at random intervals, completely unknown to those who needs the data. However, far as I can tell, there's no easy way to notify the form's owner that an update has been made. Anyone know of a way to make this happen? Bonus points for highlighting new responses.
--Yes, I know people can just manually check the spreadsheet for updates, but that doesn't always work out very well.

posted by jmd82 to computers & internet (3 comments total)

We do this exact thing in my company. Once inside the spreadsheet, Go to Share > Set Notification Rules and you'll be able to set a variety of notification rules, even to send an e-mail when a particular row is updated.
posted by ukdanae at 7:52 AM on October 23, 2009

Ah hah, I had totally missed the giant blue SHARE square. Thanks!
posted by jmd82 at 8:14 AM on October 23, 2009

It's also under Tools->Notification Rules
posted by idb at 10:44 AM on October 23, 2009