Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

Beth Schumann
Beth Schumann ✭✭
edited 12/09/19 in Archived 2016 Posts

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

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 11/10/16

    They should, I believe.

     

    Craig

  • 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
    J. Craig Williams ✭✭✭✭✭✭
    edited 11/10/16

    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

  • 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
    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

  • 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
    J. Craig Williams ✭✭✭✭✭✭

    That should be OK.

     

    Craig

This discussion has been closed.