{"id":24118,"date":"2025-11-17T09:09:48","date_gmt":"2025-11-17T02:09:48","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=24118"},"modified":"2025-11-17T09:09:48","modified_gmt":"2025-11-17T02:09:48","slug":"gemini-in-google-sheets-can-now-analyze-data-across-multiple-tables","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-can-now-analyze-data-across-multiple-tables\/","title":{"rendered":"Gemini in Google Sheets can now analyze data across multiple tables"},"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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-can-now-analyze-data-across-multiple-tables\/#Co_gi_thay_doi\" >What\u2019s changing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-can-now-analyze-data-across-multiple-tables\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-can-now-analyze-data-across-multiple-tables\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-can-now-analyze-data-across-multiple-tables\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Starting today, Gemini in Sheets can understand and analyze multiple tables within a single tab of a spreadsheet.  This new functionality allows you to ask questions and perform analysis that spans multiple data sources, dramatically increasing the power and accuracy of your queries. You can select or deselect tables to focus Gemini\u2019s attention, and you can also directly make a selection within a table to be used as input for your query.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can use this update while:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Generating formulas: Generate complex formulas that reference and perform calculations across several tables in one go. For example, you can now have Gemini write XLOOKUP functions to look up values from one table to use in another, or aggregate data from multiple tables into a single summary calculation.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Analyzing and generating charts: Ask Gemini to analyze data scattered across multiple tables to uncover insights and create data visualizations. You can get a holistic view of your data, whether you\u2019re identifying top performers by combining sales data from different tables, or creating a single chart that compares sales performance data from separate tables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n: \u00c1p d\u1ee5ng c\u00e1c thay \u0111\u1ed5i cho nhi\u1ec1u b\u1ea3ng c\u00f9ng m\u1ed9t l\u00fac ch\u1ec9 v\u1edbi m\u1ed9t y\u00eau c\u1ea7u. V\u00ed d\u1ee5: gi\u1edd \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Gemini \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t qu\u00e1n tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c x\u00e2y d\u1ef1ng m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p duy nh\u1ea5t \u0111\u1ec3 t\u00f3m t\u1eaft d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Targeting analysis with selections: You can now make selections within your tables to focus Gemini\u2019s analysis. Ask for summaries of specific data, find outliers in a selected range, or generate formulas based on the data you\u2019ve highlighted. For example, you can select a column and ask, \"What are the trends in the selected column?\"<\/span><\/li>\n<\/ol>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/new-latex-features-in-the-gemini-app\/attachment\/gemini-in-google-sheets\/\" rel=\"attachment wp-att-24109\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24109\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Gemini-in-Google-Sheets.gif\" alt=\"\" width=\"1504\" height=\"923\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Gemini-in-Google-Sheets.gif 1504w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Gemini-in-Google-Sheets-768x471.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Gemini-in-Google-Sheets-18x12.gif 18w\" sizes=\"auto, (max-width: 1504px) 100vw, 1504px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Prompt: \u201cGenerate a formula that fills the column next to due date that looks up the assigned teammate based on task id\u201d<\/span><\/p>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/new-latex-features-in-the-gemini-app\/attachment\/generate-one-chart-of-trends-over-time-which-contain-the-data-from-all-three-teams\/\" rel=\"attachment wp-att-24108\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24108\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Generate-one-chart-of-trends-over-time-which-contain-the-data-from-all-three-teams.gif\" alt=\"\" width=\"1504\" height=\"966\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Generate-one-chart-of-trends-over-time-which-contain-the-data-from-all-three-teams.gif 1504w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Generate-one-chart-of-trends-over-time-which-contain-the-data-from-all-three-teams-768x493.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/11\/Generate-one-chart-of-trends-over-time-which-contain-the-data-from-all-three-teams-18x12.gif 18w\" sizes=\"auto, (max-width: 1504px) 100vw, 1504px\" \/><\/a><br \/>\n<span style=\"font-weight: 400;\">Prompt: \u201cGenerate a formula that fills the column next to due date that looks up the assigned teammate based on task id\u201d<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on.\u00a0<\/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;\">This feature will be on by default.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 20, 2025<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Available for Google Workspace:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Business Standard and Plus\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enterprise Standard and Plus\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Customers with the Gemini Education or Gemini Education Premium add-on\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Google AI Pro and Ultra<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Anyone who previously purchased these add-ons will also receive this feature:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Gemini Business*\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Gemini Enterprise* <\/span><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i B\u1eaft \u0111\u1ea7u t\u1eeb h\u00f4m nay, Gemini trong Sheets c\u00f3 th\u1ec3 hi\u1ec3u v\u00e0 ph\u00e2n t\u00edch nhi\u1ec1u b\u1ea3ng ch\u1ec9 trong m\u1ed9t tab duy nh\u1ea5t c\u1ee7a b\u1ea3ng t\u00ednh. Ch\u1ee9c n\u0103ng m\u1edbi n\u00e0y cho ph\u00e9p b\u1ea1n \u0111\u1eb7t c\u00e2u h\u1ecfi v\u00e0&hellip;<\/p>","protected":false},"author":2,"featured_media":24107,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-24118","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\/24118","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=24118"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/24118\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/24107"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=24118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=24118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=24118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}