{"id":9674,"date":"2021-03-18T00:00:00","date_gmt":"2021-03-17T23:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9674"},"modified":"2021-03-18T00:00:00","modified_gmt":"2021-03-17T23:00:00","slug":"chat-feature-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/spreadsheets-tips\/chat-feature-in-google-sheets\/","title":{"rendered":"Como usar o recurso de bate-papo do Planilhas Google"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Few are aware that Google Drive applications have built-in chat features. This is just one of the ways G Suite differentiates itself from competitors such as Microsoft Office. Google\u2019s software is cloud-based and had collaboration built in from the very beginning. In contrast, competitors in the space only recently adopted real-time collaboration and web-based editing.<\/p>\n<p>The G Suite platform apps are build around collaboration. There are, of course, external chat platforms like Hangouts that have a larger feature set. However, if you just need a quick way to ask a question and get an answer, the internal <a href=\"https:\/\/support.google.com\/docs\/answer\/2494891?co=GENIE.Platform%3DDesktop&amp;hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">Google Sheets chat feature<\/a> is your best option.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Google Sheets and collaboration<\/h3>\n<p>Historically, Google\u2019s office style software always had collaboration as its main differentiator. Simultaneous editing was always a feature of the Google Drive apps. It was implemented much sooner than in the Apple and Microsoft equivalents for example.<\/p>\n<p>Take a look at the screenshot below. Here, you see that Google already promoted real-time collaboration in 2009. During that time, spreadsheets were still called Google Docs, and Drive wasn&#8217;t even a thing. <\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/1-2009.png&#8221; alt=&#8221;Google Sheets chat 1&#8243; title_text=&#8221;1 2009&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>With simultaneous editing as a core feature of the Google Docs software suite, it was only a matter of time before a chat feature was added.<\/p>\n<p>Today, all three of the core Google Drive software (Docs, Sheets, and Slides) have similar chat features. It isn\u2019t much compared to independent chat platforms like WhatsApp or Messenger. For its use case, however, it gets the job done.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to enable chat in Google Sheets<\/h3>\n<p>Most importantly, chat is not available whilst working on a Google Sheet document by yourself. In fact, there are a couple conditions that you need to meet for chat to work between you and collaborators.<\/p>\n<p>First of all, everyone needs to have access to your document, so you\u2019ll have to share it with them. Click the green share button in the upper right corner, next to your profile picture to do that.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/2-Share-Button.png&#8221; alt=&#8221;Google Sheets chat 2&#8243; title_text=&#8221;2 Share Button&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Secondly, you and your collaborators must have the document open at the same time.<\/p>\n<p>To tell if there are other people in the document at the same time as you, look to the left of the share button. Here you see all active collaborators&#8217; profile pictures.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/3-Users.png&#8221; alt=&#8221;Google Sheets chat 3&#8243; title_text=&#8221;3 Users&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Finally, you\u2019re able to start chatting. The chat button appears on top of the profile picture stack in the upper right-hand corner.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/4-Chat-Button.png&#8221; alt=&#8221;Google Sheets chat 4&#8243; title_text=&#8221;4 Chat Button&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Chat isn&#8217;t showing in Google Sheets<\/h4>\n<p>It is possible that you can&#8217;t see the chat feature in your Google Sheets file. In order to chat in Google Sheets (and all Google Drive apps), you and at least one other person in the document have to follow these rules:<\/p>\n<ul>\n<li>You cannot use the Android, iOS, or iPadOS versions of Sheets.<\/li>\n<li>You must be logged into a Google Account.<\/li>\n<li>You cannot be in Anonymous Mode.<\/li>\n<li>You need to use the desktop version of the app.<\/li>\n<\/ul>\n<p>If you meet all of the conditions above, simply click the chat bubble and start typing! Your collaborators will get the following notification:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/5-Chat-Notification.png&#8221; alt=&#8221;Google Sheets chat 5&#8243; title_text=&#8221;5 Chat Notification&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>How to use chat in Sheets<\/h4>\n<p>When you take a look at the chat panel, you\u2019ll notice that it\u2019s pretty basic. It&#8217;s missing some chat features like an emoji keyboards, text formatting options, and a tagging systems to target individuals for example.<\/p>\n<p>Basically, the only thing you can do in Google Sheets chat is type unformatted text. If you need more functionality in your chat, I suggest moving to a stand-alone platform like Hangouts.<\/p>\n<p>On top of that, consider other chat options if you need to see previous conversations. Because chat is erased when you leave the document in Google Sheets.<\/p>\n<p>The only other thing that the chat window does is show room activity. It logs when someone joins the document and when someone leaves. In short, you know who sees your messages and who doesn&#8217;t.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/6-Chat-in-Use.png&#8221; alt=&#8221;Google Sheets chat 6&#8243; title_text=&#8221;6 Chat in Use&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Note that you can continue to type even though everyone else left the chat room.<\/p>\n<p>This is only possible when you already have the chat room open though.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Other collaboration features in Google Sheets<\/h3>\n<p>In combination with other collaboration tools native to Sheets, the chat feature is a very useful tool. Check out this list of other live collaboration tools that make working together in Sheets a breeze. You won\u2019t need an external communication tool like Skype or Discord.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>1. Live cursor<\/h4>\n<p>When multiple people work in a document simultaneously, you see everyone\u2019s cursor. As they type, the text appears on your screen as well.<\/p>\n<p>You could, for example, highlight a section of text, then ask a question in the chat, and everyone immediately knows what you&#8217;re talking about.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/7-Live-Cursor.png&#8221; alt=&#8221;Google Sheets chat 7&#8243; title_text=&#8221;7 Live Cursor&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>2. Comments<\/h4>\n<p>Comments probably are the best way to communicate in the Google Drive apps. Basically, comments are chats you directly attach to a specific selection in your document.<\/p>\n<p>They\u2019re available even when no one else is in the document. Moreover, You can assign comments to other collaborators.<\/p>\n<p>This is an important feature when working together, but perhaps not at the same time as the rest of your team.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/8-comments.png&#8221; alt=&#8221;Google Sheets chat 8&#8243; title_text=&#8221;8 comments&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>3. Suggested edits<\/h4>\n<p>Even though this feature isn\u2019t available in Sheets, it is a main tenant of Google Docs collaboration.<\/p>\n<p>Moreover, Google Docs has chat as well, and everything in this blog post applies to chat in that program too.<\/p>\n<p>Do you want to suggest a change to the document, but get the opinion of your teammates first? The suggested edits feature makes this possible. Use it to do revisions on work where you don\u2019t have the final say.<\/p>\n<p>Use suggested edits combined with chat and live cursor to discuss changes with your team before you make them.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/9-Suggested-Edits.png&#8221; alt=&#8221;Google Sheets chat 9&#8243; title_text=&#8221;9 Suggested Edits&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Final thoughts<\/h3>\n<p>The Google Sheets chat feature is just one of the many collaborative tools in the app. It doesn\u2019t have the bells and whistles that many other chat platforms have however.<\/p>\n<p>Instead, it\u2019s built with simplicity in mind, just enough to keep your team on the same page while working together on a spreadsheet. On top of that, it works well with the other collaborative tools in Google Sheets.<\/p>\n<p><span>If you\u2019d like to learn more about the various features in Google Sheets, why not take a look at our blog post on<a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/get-notified-if-someone-edits-my-google-sheets\/\" target=\"_blank\" rel=\"noopener\"> How to get Google Sheets notifications.<\/a><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.4.8&#8243; background_color=&#8221;#f9f9ff&#8221; custom_padding=&#8221;15px|25px|15px|25px|true|true&#8221; border_width_left=&#8221;3px&#8221; border_color_left=&#8221;#808e95&#8243; global_module=&#8221;26540&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p style=\"font-size: 0.9em; padding-bottom: 0px;\"><em style=\"color: #808e95; \"><strong>Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n<p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few are aware that Google Drive applications have built-in chat features. This is just one of the ways G Suite differentiates itself from competitors such as Microsoft Office. Google\u2019s software is cloud-based and had collaboration built in from the very beginning. In contrast, competitors in the space only recently adopted real-time collaboration and web-based editing. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":33182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"One of the most exciting features of the early internet boom was the ability to chat with other people in real time. And to this day, it still remains one of the highest used features on the internet. If anything, this has only increased with the time. We know that Google Sheets has been innovating on the collaborative front. A team of people can work on a Google Sheets file from anywhere, regardless of the location and device. But can they discuss in real time while working on the application? Yes, they can! The chat feature in Google Sheets is yet another step to promote collaboration.\n<h3>Introduction<\/h3>\nA chat utility is typically a messenger that lets two or more users discuss in real time, it is almost like conversing with text messages. To facilitate teamwork, Google Sheets built-in a chat feature within the application. All the users who have access to a particular Google Sheets file can utilize this feature to discuss things right over the file. This is much faster and effective than picking up a phone or sending out an email because we have the context of the discussion right in front of us.\n<h3>Bringing chat to life<\/h3>\nWe can trigger the chat feature in Google Sheets UI only if there are two or more users working on the file at the same time. Otherwise, the chat option won't be available. And it makes sense this way.&nbsp;Because who do we chat with if there's no one's actively working on the file?\n\nLet's say we have three users viewing the file at the moment. And one of the users wants to know other's perspective. All he has to do is click on the <strong>Show chat<\/strong> button to open a chat window and fire the message away.\n\n<img class=\"aligncenter size-full wp-image-10000\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Chat-feature-in-Google-Sheets-Illustration-2.1.png\" alt=\"Chat feature in Google Sheets - Illustration 2\" width=\"969\" height=\"670\">\n\nAs soon as he does that, the other two users will see a notification that they received a message. Pretty much similar to the notifications we are used to in our mobile devices these days. This is how it looks.\n\n<img class=\"aligncenter wp-image-10003 size-full\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Chat-feature-in-Google-Sheets-Illustration-3.1.png\" alt=\"Chat feature in Google Sheets - Illustration 3\" width=\"955\" height=\"313\">\n\nAlso, the title of the browser tab will briefly flash with a text indicating that there is an incoming message. All that the other users now should do is click on the \"<strong>Show chat<\/strong>\" button and respond accordingly. Unsurprisingly, this response will reciprocate among the group.\n\n<img class=\"aligncenter size-full wp-image-10004\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Chat-feature-in-Google-Sheets-Illustration-4.png\" alt=\"Chat feature in Google Sheets - Illustration 4\" width=\"969\" height=\"670\">\n\nYou may notice that the chat window will not obscure the spreadsheet real estate. We can keep working on the file while chatting with other users.\n<h3>Leave and close the chat<\/h3>\nWe will understand when other users are no longer working on the Google Sheets file. On the chat windows title, we will see the count and list of users available for chat. Not just that, Google Sheets also notifies when users leave, within the chat window.\n\n<img class=\"aligncenter size-full wp-image-10009\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/Chat-feature-in-Google-Sheets-Illustration-5.png\" alt=\"Chat feature in Google Sheets - Illustration 5\" width=\"969\" height=\"670\">\n\nTo hide the chat window, click on the erstwhile \"<strong>Show chat<\/strong>\" button, which now operates as \"<strong>Hide chat<\/strong>\". Or simply, click on the <strong>X<\/strong> button on the top right corner of the chat window.\n\nLet us know if you have any remarks or questions by commenting down below or chat with us by clicking on the button on the right side below! :-)","_et_gb_content_width":"","footnotes":""},"categories":[29],"tags":[28],"class_list":["post-9674","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets-tips","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=9674"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9674\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/33182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}