{"id":14249,"date":"2023-06-07T09:47:25","date_gmt":"2023-06-07T02:47:25","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=14249"},"modified":"2023-08-16T14:04:05","modified_gmt":"2023-08-16T07:04:05","slug":"complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/","title":{"rendered":"Complete data-driven tasks faster with new smart chip data extraction in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Co_gi_thay_doi\" >What\u2019s changing\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Ai_bi_anh_huong\" >Who\u2019s impacted<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Tai_sao_lai_su_dung\" >Why you\u2019d use it<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Thong_tin_them\" >Additional details<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/complete-data-driven-tasks-faster-with-new-smart-chip-data-extraction-in-google-sheets\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In continuing our efforts to <\/span><a href=\"https:\/\/workspace.google.com\/blog\/productivity-collaboration\/more-flow-less-work-smart-canvas\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">help you deliver more with smart canvas<\/span><\/a><span style=\"font-weight: 400;\">, which Google recently introduced <\/span><a href=\"https:\/\/workspaceupdates.googleblog.com\/2023\/04\/multi-chip-youtube-chips-google-sheets.html\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">additional smart chip functionality in Google Sheets<\/span><\/a><span style=\"font-weight: 400;\">. Building upon this, you\u2019ll also be able to quickly extract information from smart chips for advanced sorting, filtering and analysis to drive your projects forward.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">With smart chip data extraction, you can enrich your Sheets with information from people, file, and events chips. More specifically, this feature allows you to pull out metadata associated with specific smart chips into its own cell, while maintaining a connection with the chip it was extracted from.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">For example, if you need to keep track of a set of documents, their owners and details, such as creation time or who last modified the file, you can do so by extracting those fields from the relevant file chips as shown below.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14251\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/wsu_dataextraction5.gif\" alt=\"Google Sheet helps complete data-driven tasks faster with the new smart chip&#039;s data extraction feature 1\" width=\"600\" height=\"372\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/wsu_dataextraction5.gif 2560w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/wsu_dataextraction5-768x476.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/wsu_dataextraction5-1536x953.gif 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/wsu_dataextraction5-2048x1270.gif 2048w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/wsu_dataextraction5-18x12.gif 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You can keep your extractions up to date by navigating to the \u201cRefresh &amp; manage\u201d section of the extraction sidebar to update your data and reflect the latest changes.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ai_bi_anh_huong\"><\/span><b>Who\u2019s impacted<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_lai_su_dung\"><\/span><b>Why you\u2019d use it<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Smart chip data extraction allows you to track and organize data more easily, and also perform deeper analyses using data that is derived from smart chips. Useful actions include using file chips to understand when a document was last updated or using people chips to sort and filter employees based on job location to best delegate region specific tasks.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_them\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You can also nest arrays of chip extractions to perform more complex analyses. The example below uses a range of people chips in B3:B11 to count the number of unique office locations for nine different individuals. Example formula extraction across range of people chips<\/span><\/p>\n<p style=\"text-align: justify;\"><b><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14252 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/Screenshot_149.png\" alt=\"Google Sheet helps complete data-driven tasks faster with the data extraction feature of the new smart chip 2\" width=\"600\" height=\"208\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/Screenshot_149.png 600w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/06\/Screenshot_149-18x6.png 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/b><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: There is no admin control for this feature.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">To perform sidebar extraction:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Open the data extractions sidebar (via either the Data menu, right clicking on a cell\/range with people, event or file chips and navigating to \"Data extractions,\" or clicking on the \"Data extractions\" link in people, event or file hover cards)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Select the range that contains the chips you want to extract data from<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Choose what data you want to extract from the selected chips<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Pick the range where you want the data to be extracted to<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">To perform formula extraction:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Start by typing = in a cell where you want the information extracted<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Navigate to the cell or range with chips in them and select it<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Add a period after the cell or range of cells and choose from the autocomplete what to extract<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Accept the dialog confirming what will be extracted<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">To refresh data in the data extraction sidebar:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Open the extraction sidebar<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Click Refresh &amp; manage<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Find the smart chips data you want to refresh<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Click Refresh data<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">To refresh all smart chips data, click Refresh all at the bottom of the sidebar.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Visit the Help Center to learn more about <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/13524011\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">extracting data from smart chips in your Google Sheets.\u00a0<\/span><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 17, 2023<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 14, 2023<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Extraction of data already stored in chips (Name and Email for people chips. MIME Type, URL, File Name for file chips. URL and Summary for event chips.)<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Available to all Google Workspace customers and users with personal Google Accounts<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Extraction of all available data\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Available to <a href=\"https:\/\/gcloudvn.com\/en\/google-workspace\/\">Google Workspace Business Standard<\/a>, Business Plus, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, <a href=\"https:\/\/gcloudvn.com\/en\/google-workspace-for-education\/\">Education Standard<\/a> and Teaching and Learning Upgrade<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Not available to Essentials Starter, Business Starter, Frontline Starter, Frontline Standard, and Nonprofits<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Not available to users with personal Google Accounts<\/span><\/li>\n<\/ul>\n<p class=\"p1\" style=\"text-align: justify;\">For more detailed product information or to need technical support, you can contact Gimasys - Premier Partner of Google in Vietnam at the following information:<\/p>\n<ul class=\"ul1\" style=\"text-align: justify;\">\n<li class=\"li2\"><b>Hotline:\u00a0<\/b>0974 417 099 (HCM) | 0987 682 505 (HN)<\/li>\n<li class=\"li3\"><span class=\"s3\"><b>Email:\u00a0<\/b><a href=\"mailto:gcp@gimasys.com\" target=\"_blank\" rel=\"nofollow noopener\"><span class=\"s4\">gcp@gimasys.com<\/span><\/a><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p class=\"p4\" style=\"text-align: right;\"><b>Source:\u00a0<\/b><span class=\"s5\"><b>Gimasys<\/b><\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i\u00a0 Trong vi\u1ec7c ti\u1ebfp t\u1ee5c n\u1ed7 l\u1ef1c c\u1ee7a Google \u0111\u1ec3 gi\u00fap b\u1ea1n l\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u h\u01a1n v\u1edbi canvas th\u00f4ng minh, g\u1ea7n \u0111\u00e2y Google \u0111\u00e3 gi\u1edbi thi\u1ec7u ch\u1ee9c n\u0103ng smart chip b\u1ed5 sung trong Google Sheet. D\u1ef1a tr\u00ean&hellip;<\/p>","protected":false},"author":2,"featured_media":14250,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-14249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/14249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=14249"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/14249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/14250"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=14249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=14249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=14249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}