Do alerts work when using Smartsheet Sync add-on with Google forms?

Beth Schumann

I am using a Google form to populate a smartsheet. I thought I could get an alert everytime data gets added to the form, but it seems that nothing is happening, even though I set the alert for "anything" and "right away."

 

Any ideas? Does this feature just not work because it's not a real person editing the row?

 

Thanks,

Beth

J. Craig Williams

They should, I believe.

 

Craig

Beth Schumann

Thanks, but they actually are not working with a synced Google Form I just set up, so I'm not sure why.

J. Craig Williams

I have reproduced the problem - I created a Google Form and submitted several responses without getting any email from the Alert.

I added a WebForm in Smartsheet, submitted a response and got the email right away.

 

Looks like it isn't working.

Did it ever?

 

Craig

Shaine Greenwood

Hi All—When using an integration such as with Google Forms, new rows added to a sheet will be made from the user's account that set up the integration.

 

Since this is the case, Beth, all changes to the form will appear to be made from your account with your email address (you can right-click in cells from your Google Form submissions and select View History to confirm this).

 

Notifications will only be sent to you when changes have been made from other collaborator's accounts, you won't receive a Notification email from changes that have been made from your account—whether they come from you directly editing your sheet, or from an integration such as Google Forms.

 

You'd have to set up a Google Form and establish a connection with Smartsheet through a different email address in order to receive a notification email when changes have been made. (Although that might be a bit of a pain.)

J. Craig Williams

That is very interesting.

 

If you use gmail, here's a trick to get more email without more email, if you know what I mean.

 

You can create an email address with a + sign

exampleguy@gmail.com and exampleguy+googlesync@gmail.com 

will both go to the same inbox.

That means you could sign up for google sync using an alternative email address and your gmail, at least, would be the same.

At least, that is the theory. I haven't tried that with other google products.

 

Craig

Beth Schumann

Thankyou, but does that mean that I can set up alerts to go to someone else's inbox when someone fills in the Google form? If I am the account owner on both the Google forms and the Smartsheet, can a third person get a notification when a line is added automaticaly to the Smartsheet by google forms? That would work for my situation.

 

thanks

J. Craig Williams

That should be OK.

 

Craig