6 Google Sheets jobs I've fully handed to Gemini that I'll never do by hand again
Android Police 2026-07-11 11:01:23
Context: Ben Khalesi, an Android Police writer, has started using Gemini, an AI tool integrated with Google Sheets, to automate various tasks, freeing up time and increasing efficiency. With Gemini's capabilities, Khalesi has handed over six specific jobs that he previously did manually, leveraging its ability to process and analyze data. This integration has significantly impacted Khalesi's workflow, particularly in handling data cleanup, creating project trackers, and generating visuals.
Key Facts
- In March 2026, Gemini scored 70.48% on SpreadsheetBench V1-Full, a test that gathers 912 questions from real-life situations in varied formats, indicating its near-human-expert level performance.
- Gemini can create a fully formatted table with headers and placeholder data from a single prompt, such as building a project tracker with columns for client name, project scope, status, due date, and estimated fee.
- The AI tool can standardize names to Title Case, remove duplicate entries, and perform data cleanup, although it may require manual checks for regional date formats and potential misreads.
- Gemini can generate complex formulas, such as INDEX/MATCH syntax, and walk users through the logic, but may occasionally require manual adjustments, like adding dollar signs to ensure correct formula functionality.
- The integration of Gemini with Google Sheets includes a dedicated formula troubleshooter that can read broken formulas and neighboring cells to identify the point of failure and suggest fixes.