Google has launched substantial updates to integrate Gemini AI into the Google Sheets application, primarily aiming to address one of the biggest challenges facing AI adoption in work environments: reliability. It is no longer just about the model's ability to generate data; users can now see the digital sources the AI relied on directly within the cells.
Addressing the Issue of Credibility and Data Verification
The problem of "hallucination" or providing incorrect information with high confidence is a major obstacle to relying on AI for analytical tasks. Through the new update, if Gemini populates data derived from the web—such as comparing hotel prices or travel costs—the source link will appear directly in the relevant cell. This change facilitates a quick auditing process without the need for manual searching for the origin of the information, reducing the time spent reviewing machine-generated data.
A Leap in Performance and Capacity
Alongside improving reliability, Google has achieved a significant improvement in processing speed and efficiency. Gemini can now handle up to 3,000 cells in a single request, representing a qualitative leap for massive tasks such as classifying hundreds of reviews or organizing complex datasets. Google claims that this feature completes certain tasks (involving 500 cells) at a speed exceeding manual entry by 55 times.
Improvements in User Experience and Compatibility
The update was not limited to AI; it also included traditional spreadsheet tools to enhance productivity:
- Integrated Pivot Table Layout: A new design for pivot tables has been introduced, grouping them into a single column with expandable sections, making it easier to handle large tables on screens.
- Improved Excel Compatibility: Google Sheets can now maintain the original pivot table formatting when importing or exporting Microsoft Excel files, solving a technical issue users faced when navigating between the two systems.
What Changes in Practice?
For analysts and managers who rely on data, this update means narrowing the gap between "speed" and "accuracy." The ability to process thousands of cells with the click of a button, with direct evidence (the source) for every piece of information, transforms Google Sheets from a mere organizational tool into a reliable data analysis assistant capable of handling large datasets with high efficiency and reducing the risks of human or machine errors.