Notifications with Google Hangouts?

kristajoy
kristajoy ✭
edited 12/09/19 inSmartsheet Basics

I have Google Hangouts bot activated in Smartsheet and the two bots connected. Despite that, I can't manage to create an Automated Notification that sends to Google Hangouts. Anyone know how to do that? I would expect an option to appear here (see screenshot) like the Slack option does but I can't make it pop up. Help?

Capture.PNG

Tags:
· Share on Facebook Share on Twitter

Comments

  • Sean Morgan
    Sean Morgan Employee

    Hi kristajoy,

    Thank you for your inquiry. The Google Hangouts notifications are sent to users via a standard automated request, reminder or alert. There is no separate workflow for Hangouts. For other users to receive notifications from the Smartsheet bot, they will have to follow the same process of activating the bot via Google Hangouts Chat and have their email address included within the automated workflow.

    Example:

    I have set up an alert to notify me when any value changes in my Primary Column. Below is a screenshot of my workflow. As you can see, all that is included is my Smartsheet email. Once the rows are changed and the sheet is saved, I receive an alert via Google Hangout Chats informing me that an update has been made.

    Additional information regarding Hangouts Notifications can be found here:

    If you wish to receive notifications from only hangout chats and not via Email as well, you can alter your notification settings by navigating to your Profile and Select Apps & Integrations. The above articles explain this in more detail.

    Kind Regards

    Sean

    Test.PNG

    · Share on Facebook Share on Twitter
  • Daryl Peereboom
    Daryl Peereboom ✭

    I'm having a related issue. I have the chat bot installed and connected... but everytime I try sending myself an update or approval request it just comes in as a blank chat message from smartsheet bot.

    · Share on Facebook Share on Twitter
  • Sean Morgan
    Sean Morgan Employee

    Hi there@Daryl Peereboom,

    There could be a few issues causing this. One may be the browser used. Please can you test this in different browsers (Google Chrome, Firefox, Edge) to idenytify if the same behaviour occurs.

    If the issue is still occuring after attempting the above, you may want to reach out to the Smartsheet Support team for further investigation:https://help.smartsheet.com/contact

    问候

    Sean

    · Share on Facebook Share on Twitter
  • Zachw
    Zachw ✭✭✭

    I am having the same issue as Daryl reported.

    I have had the google chat smartsheet notifications bot setup/working perfectly for last ~6 months

    Only In the last ~48 hours, this seems to have broken. I still get the notification with a timestamp but they are all showing up blank, usually there is a 'card' that details what each notification is, with link to the item in smartsheet, etc.

    I have tried troubleshooting by removing/deleting the smartsheet google chat bot and re-adding/re-configuring it.

    Notifications still are all blank


    Chrome

    Version 81.0.4044.122 (Official Build) (64-bit)

    smartsheet_google_chat_notifications.png


    I already opened a support ticket with smartsheet but curious if this is something others are also experiencing

    · Share on Facebook Share on Twitter
  • Aaron D.
    Aaron D. ✭

    I noticed the same as you@ZachwThat's exactly how the notifications look in my chat as well.

    · Share on Facebook Share on Twitter
  • urmila.kukreja
    urmila.kukreja Employee

    谷歌聊天机器人已经决心的问题ed for all new notifications. We are continuing to work with Google to resolve the issue so past notifications can display correctly.

    问候,

    Urmila Kukreja

    Senior Product Manager

    · Share on Facebook Share on Twitter

Categories

Everything will remain as is. They just will no longer be able to access.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107734,"type":"question","name":"Summarizing result of a formula","excerpt":"Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because the points are calculated by a formula - if I just enter numbers, I can get a sum, but if the number are the result of a formula, the sum = 0.…","snippet":"Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because…","categoryID":321,"dateInserted":"2023-07-18T14:42:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T14:05:42+00:00","insertUserID":149226,"insertUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T14:03:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":149226,"lastUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T14:03:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":43,"score":null,"hot":3379471107,"url":"https:\/\/community.smartsheet.com\/discussion\/107734\/summarizing-result-of-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107734\/summarizing-result-of-a-formula","format":"Rich","lastPost":{"discussionID":107734,"commentID":385918,"name":"Re: Summarizing result of a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385918#Comment_385918","dateInserted":"2023-07-19T14:05:42+00:00","insertUserID":149226,"insertUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T14:03:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T12:07:36+00:00","dateAnswered":"2023-07-18T15:44:21+00:00","acceptedAnswers":[{"commentID":385758,"body":"

It is fine using a formula as long as the formula is outputting numbers. What formula are you using?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107740,"type":"question","name":"Smartsheet ownership","excerpt":"The person who created and \"owns\" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?","snippet":"The person who created and \"owns\" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?","categoryID":321,"dateInserted":"2023-07-18T15:14:59+00:00","dateUpdated":null,"dateLastComment":"2023-07-18T21:01:34+00:00","insertUserID":76851,"insertUser":{"userID":76851,"name":"Kitty","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kitty","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/6c\/fb\/n6cfbd4e9f8b51ef6eac617de4934460f.jpg","dateLastActive":"2023-07-18T18:11:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-19T13:42:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3379409193,"url":"https:\/\/community.smartsheet.com\/discussion\/107740\/smartsheet-ownership","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107740\/smartsheet-ownership","format":"Rich","lastPost":{"discussionID":107740,"commentID":385833,"name":"Re: Smartsheet ownership","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385833#Comment_385833","dateInserted":"2023-07-18T21:01:34+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-19T13:42:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-18T15:52:14+00:00","dateAnswered":"2023-07-18T15:49:34+00:00","acceptedAnswers":[{"commentID":385764,"body":"

If there is anyone shared to the sheet as Admin, they should be able to make the necessary changes or share someone else to the sheet as Admin so that the changes can be made. Otherwise you are just going to have to wait until the owner of the sheet is able to share someone to it as Admin.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4854,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • What happens when a user account has been deleted?

    We do a lot of collaborating on our sheets with contractors outside our organization. What happens when that contractor leaves their employment and their company deletes their account? Does all of the data/contributions the contractor did on our sheets remain or do they disappear when their user account is deleted?

  • Summarizing result of a formula

    Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because the points are calculated by a formula - if I just enter numbers, I can get a sum, but if the number are the result of a formula, the sum = 0.…

  • Smartsheet ownership

    The person who created and "owns" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video