{"id":21424,"date":"2025-02-26T16:03:33","date_gmt":"2025-02-26T09:03:33","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=21424"},"modified":"2025-02-26T16:03:44","modified_gmt":"2025-02-26T09:03:44","slug":"generate-charts-and-valuable-insights-using-gemini-in-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/generate-charts-and-valuable-insights-using-gemini-in-google-sheets\/","title":{"rendered":"Generate charts and valuable insights using Gemini 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\/generate-charts-and-valuable-insights-using-gemini-in-google-sheets\/#Co_gi_thay_doi\" >What\u2019s changing<\/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\/generate-charts-and-valuable-insights-using-gemini-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\/generate-charts-and-valuable-insights-using-gemini-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\/generate-charts-and-valuable-insights-using-gemini-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\/generate-charts-and-valuable-insights-using-gemini-in-google-sheets\/#_Bat_dau\" >\u00a0Getting 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\/generate-charts-and-valuable-insights-using-gemini-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\/generate-charts-and-valuable-insights-using-gemini-in-google-sheets\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">X\u00e2y d\u1ef1ng h\u00ecnh \u1ea3nh h\u00f3a d\u1eef li\u1ec7u v\u00e0 x\u00e1c \u0111\u1ecbnh xu h\u01b0\u1edbng trong d\u1eef li\u1ec7u l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng kinh doanh quan tr\u1ecdng, tuy nhi\u00ean, n\u00f3 c\u00f3 th\u1ec3 t\u1ed1n th\u1eddi gian v\u00e0 th\u01b0\u1eddng qu\u00e1 s\u1ee9c. \u0110\u1ec3 c\u1ea3i thi\u1ec7n tr\u1ea3i nghi\u1ec7m n\u00e0y, ch\u00fang t\u00f4i \u0111ang gi\u00fap ng\u01b0\u1eddi d\u00f9ng Sheets, t\u1eeb ch\u1ee7 doanh nghi\u1ec7p nh\u1ecf \u0111\u1ebfn nh\u00e0 ph\u00e2n t\u00edch ti\u1ebfp th\u1ecb, d\u1ec5 d\u00e0ng h\u00ecnh \u1ea3nh h\u00f3a v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u b\u1eb1ng Gemini trong Sheets.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Starting today, Gemini in Sheets can perform actions or answer questions to address a wide variety of scenarios. Specifically, you can ask Gemini questions about your data and Gemini can provide valuable insights, such as contextual trends, patterns, and correlations between different variables in your data. Gemini will also generate charts based on your data that you can insert as static images over cells in your spreadsheet. For example:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A marketing manager analyzing campaign performance can ask \"Provide some insights on my top 3 performing channels by conversion rate\" and can receive a detailed breakdown with supporting visualizations.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A small business owner managing cash flow can ask \"Predict my net income for the next quarter based on historical data\" to proactively identify potential shortfalls.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A financial analyst investigating inventory trends can ask \"Identify any anomalies in inventory levels for Product X\" to uncover potential supply chain issues or unusual demand patterns.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_21459\" aria-describedby=\"caption-attachment-21459\" style=\"width: 1594px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/generate-charts-and-valuable-insights-using-gemini-in-google-sheets\/attachment\/screenshot-2025-02-26-at-11-37-22-min\/\" rel=\"attachment wp-att-21459\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21459\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.37.22-min.png\" alt=\"\" width=\"1594\" height=\"896\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.37.22-min.png 1594w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.37.22-min-768x432.png 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.37.22-min-1536x863.png 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.37.22-min-18x10.png 18w\" sizes=\"auto, (max-width: 1594px) 100vw, 1594px\" \/><\/a><figcaption id=\"caption-attachment-21459\" class=\"wp-caption-text\"><em>Ask Gemini in Sheets to share insights and trends from the data.<\/em><\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_21460\" aria-describedby=\"caption-attachment-21460\" style=\"width: 1604px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/generate-charts-and-valuable-insights-using-gemini-in-google-sheets\/attachment\/screenshot-2025-02-26-at-11-36-38-min\/\" rel=\"attachment wp-att-21460\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21460\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.36.38-min.png\" alt=\"\" width=\"1604\" height=\"896\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.36.38-min.png 1604w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.36.38-min-768x429.png 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.36.38-min-1536x858.png 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-26-at-11.36.38-min-18x10.png 18w\" sizes=\"auto, (max-width: 1604px) 100vw, 1604px\" \/><\/a><figcaption id=\"caption-attachment-21460\" class=\"wp-caption-text\"><em>Ask Gemini in Sheets to visualize data with a chart or bar graph.<\/em><\/figcaption><\/figure>\n<h2><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><span style=\"font-weight: 400;\">End users\u00a0<\/span><\/p>\n<h2><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><span style=\"font-weight: 400;\">This update reflects Gemini in Sheets\u2019 enhanced intelligence as it now yields valuable outputs by transforming your requests into Python code, executing on them and then analyzing the results to perform multi-layered analysis. As a result, you\u2019re able to do things like identify top-performing products and then instantly dive into their sales trends \u2014 all without writing a single line of code.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thong_tin_them\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">For the most accurate results, ensure your data is in a consistent format, with clear headers and no missing values.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">When asking Gemini in Sheets to analyze your data, be as specific as possible in your prompts to ensure Gemini understands your request.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">For complex analysis, Gemini in Sheet's performance is most consistent in files below 1 million cells.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">For some simpler questions about your data, Gemini in Sheets may still provide answers using formulas instead of Python code.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Charts are generated as static images and can be easily inserted into your sheet.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Charts are not linked to your sheet data, so they won't update automatically if your data changes.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Once inserted, charts cannot be modified. If you need to make changes, you'll need to generate a new chart.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"_Bat_dau\"><\/span><b>\u00a0Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: To access Gemini in the side panel of Workspace apps, users need to have smart features and personalization turned on. Admins can turn on default personalization setting for their users in the Admin console. End users: On web from chat.google.com, click on a space, thread, or message, then click the \"Ask Gemini\u201d icon at the top of the page to open Gemini in the side panel of Chat. From there, you can select from suggested prompts or type in your own query. Visit the Help Center to learn more about collaborating with Gemini in Google Chat and ensuring your smart feature settings are turned on.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: You can access Gemini for Sheets in the side panel by clicking on \u201cAsk Gemini\u201d (spark button) in the top right corner of Sheets. Visit the Help Center to learn more about collaborating with Gemini in Sheets.<\/span><\/li>\n<\/ul>\n<h2><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>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release and Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 29, 2025, with expected completion by February 20, 2025<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Available to 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 One AI Premium\u00a0<\/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*\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i X\u00e2y d\u1ef1ng h\u00ecnh \u1ea3nh h\u00f3a d\u1eef li\u1ec7u v\u00e0 x\u00e1c \u0111\u1ecbnh xu h\u01b0\u1edbng trong d\u1eef li\u1ec7u l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng kinh doanh quan tr\u1ecdng, tuy nhi\u00ean, n\u00f3 c\u00f3 th\u1ec3 t\u1ed1n th\u1eddi gian v\u00e0 th\u01b0\u1eddng qu\u00e1 s\u1ee9c. \u0110\u1ec3&hellip;<\/p>","protected":false},"author":2,"featured_media":21458,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-21424","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\/21424","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=21424"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/21424\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/21458"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=21424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=21424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=21424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}