{"id":25253,"date":"2026-05-15T08:42:45","date_gmt":"2026-05-15T01:42:45","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=25253"},"modified":"2026-05-15T08:42:45","modified_gmt":"2026-05-15T01:42:45","slug":"build-and-edit-complex-spreadsheets-with-gemini-in-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/build-and-edit-complex-spreadsheets-with-gemini-in-google-sheets\/","title":{"rendered":"Build and edit complex spreadsheets with Gemini in Google Sheets"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">We\u2019re excited to introduce new Gemini in Sheets capabilities that enable you to build and edit entire spreadsheets using simple natural language.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Whether you need a quick view of your small business's financial health or a complex project tracker, Gemini in Sheets orchestrates the multi-step construction from start to finish. Workspace Intelligence synthesizes data across your files, emails, chats, and the web to help you visualize your data with stylized tables, formulas, pivot tables, and charts.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Gemini in Sheets can handle complex, multi-step tasks that previously required expert-level knowledge of Sheets. For example, you can ask Gemini to do end-to-end creation to \"build a P&amp;L dashboard leveraging my historic service incidents and rate cards,\" or do side-by-side editing to \u201cadd scorecards and bar charts above my sales and inventory data\u201d. Gemini will synthesize relevant information, construct a plan for your approval, and then build out the entire formatted spreadsheet.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Key capabilities include:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End-to-end creation: Build entire spreadsheets from a single prompt, including data retrieval and formatting.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Side-by-side editing: Refine and update existing models, budgets, or analysis directly in the side panel.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Workspace Intelligence: Automatically pull context and data from other Workspace apps to ensure your spreadsheet is accurate and relevant.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Advanced task fulfillment: Leverages Sheets\u2019 most powerful tools, like pivot tables and complex formulas, without requiring manual configuration.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Advanced optimization: Handle complex optimization problems that typically require complex manual formulas or third-party tools. Powered by research from Google DeepMind and Google Research OR-Tools.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">State-of-the-art performance: Gemini in Sheets achieved a <\/span><b>70,48%<\/b><span style=\"font-weight: 400;\"> success rate in autonomously manipulating complex, real-world spreadsheets on the full SpreadsheetBench dataset, nearing human expert ability.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/students-can-now-create-personal-class-notebooks-with-notebooklm-in-google-classroom\/attachment\/build-and-edit-complex-spreadsheets-with-gemini-in-google-sheets-6590\/\" rel=\"attachment wp-att-25214\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25214\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Build-and-edit-complex-spreadsheets-with-Gemini-in-Google-Sheets-6590.gif\" alt=\"\" width=\"960\" height=\"600\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Build-and-edit-complex-spreadsheets-with-Gemini-in-Google-Sheets-6590.gif 960w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Build-and-edit-complex-spreadsheets-with-Gemini-in-Google-Sheets-6590-768x480.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2026\/05\/Build-and-edit-complex-spreadsheets-with-Gemini-in-Google-Sheets-6590-18x12.gif 18w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 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\/build-and-edit-complex-spreadsheets-with-gemini-in-google-sheets\/#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-2\" href=\"https:\/\/gcloudvn.com\/en\/build-and-edit-complex-spreadsheets-with-gemini-in-google-sheets\/#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-3\" href=\"https:\/\/gcloudvn.com\/en\/build-and-edit-complex-spreadsheets-with-gemini-in-google-sheets\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\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: This feature is available by default if Gemini for Workspace in Sheets is enabled. Note that enabling Workspace Intelligence expands the range of supported use cases.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: You must have Workspace smart features enabled to take advantage of these features. Eligible users will see the Gemini icon in the Sheets side panel. Simply describe the spreadsheet or edit you need to begin collaborating. Visit the Help Center to learn more about building and editing spreadsheets with Gemini in Sheets.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for the improved Gemini in Sheets experience, allowing users to experiment with this feature. Users will see a notification when they use this feature, informing them of the promotional access period. Per-user usage limits will apply after July 15; we\u2019ll provide more information in the Help Center in advance of updated usage limits going into effect.<\/span><\/p>\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 domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026<\/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 May 6, 2026<\/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<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Business: Business Standard and Plus<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enterprise: Enterprise Standard and Plus<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">AI Add-ons: AI Expanded Access*; AI Ultra Access*; Google AI Pro for Education<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Consumer: Google AI Pro and Ultra<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">*Once promotional limits are no longer in effect, users with AI Expanded Access and AI Ultra Access add-on licenses will have higher limits on usage of Gemini in Sheets.<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>Google r\u1ea5t vui m\u1eebng gi\u1edbi thi\u1ec7u c\u00e1c kh\u1ea3 n\u0103ng m\u1edbi c\u1ee7a Gemini trong Google Sheets cho ph\u00e9p b\u1ea1n x\u00e2y d\u1ef1ng v\u00e0 ch\u1ec9nh s\u1eeda to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh b\u1eb1ng ng\u00f4n ng\u1eef t\u1ef1 nhi\u00ean \u0111\u01a1n gi\u1ea3n. Cho d\u00f9 b\u1ea1n c\u1ea7n c\u00e1i nh\u00ecn&hellip;<\/p>","protected":false},"author":2,"featured_media":25213,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-25253","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\/25253","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=25253"}],"version-history":[{"count":1,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/25253\/revisions"}],"predecessor-version":[{"id":25254,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/25253\/revisions\/25254"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/25213"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=25253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=25253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=25253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}