Updated
Updated · 9to5Google · May 31
Gemini Cuts 1 Hour of Sheets Work by Generating Complex Formulas
Updated
Updated · 9to5Google · May 31

Gemini Cuts 1 Hour of Sheets Work by Generating Complex Formulas

2 articles · Updated · 9to5Google · May 31

Summary

  • Google Sheets became a standout Gemini use case for the author after the AI generated context-aware formulas for a spreadsheet handling player names, payments and payout structures.
  • After spending 1 hour trying to build the sheet manually, he used Gemini’s Sheets integration to produce formulas such as COUNTIF and XLOOKUP that he said he would not have found on his own.
  • The formulas still needed manual tweaks, reinforcing his view that AI works best as an assistant for users who already understand spreadsheets rather than a full replacement.
  • That experience contrasted with his broader skepticism after I/O 2026, where he said many Gemini features in Search and elsewhere still feel flashy but not clearly better.
  • He said Workspace may offer Gemini’s most practical applications so far, citing Sheets formula generation and some Slides image creation as more useful than higher-profile demos like Docs Live.

Insights

Why do many users still struggle to find practical daily uses for Google's heavily promoted Gemini AI?
As AI Overviews reduce organic clicks, what is the future for content creators who rely on Google search traffic?
From AI errors to phones hijacking apps, is big tech's rapid software integration starting to erode user trust?