The latest batch of Google updates to its workspace tools highlights AI's promise to automate mundanity in the workplace. Google Docs, Slides, Sheets and Drive all have new AI-powered features, the company announced Tuesday. The one thing all these updates have in common? Gemini is using your files, emails and chats to give you relevant information, not random answers gleaned from the web.
These updates come as AI is playing a bigger role in our work lives, for better or worse. Agentic tools like Claude Cowork and coding assistants like Anthropic's Claude Code and OpenAI's Codex are more capable than chatbots and able to handle tasks announced independently. AI tools are also becoming more customized, with Google's personalized intelligence rolling out across its platforms to help refine AI outputs to things that are relevant and useful for you. Google continues that trend with this new batch of Workspace updates.
New Gemini AI features in Google Workspace apps will cite their sources after each query. For example, if you ask Gemini in Google Docs to fill out an itinerary template, it will pull the information from your email, chats and files. The "sources" tab in the Gemini side panel will show you where it found the information it used, like your flight confirmation email and chats discussing dinner plans. Seeing where Gemini pulled its answers from is also how you'll double-check Gemini's work.
The most impressive new features are in Sheets, where AI can fill in the holes in your spreadsheets. You can describe what you want the AI to do with a simple prompt and avoid writing an exact formula. You can click on an empty cell, select the pop-up that says "Drag to fill with Gemini," then highlight the cells you want Gemini to fill in. That deploys an AI agent to search the web to fill each cell with the necessary information.
For example, if you have a spreadsheet of the contact info for local companies, you can have Gemini search the web to fill in a the location, CEO and other publicly available information of each company. The tool aims to dramatically reduce the time needed for manual data entry. Gemini can also summarize, categorize and create charts with prompts alone.
Gemini can use information in your files, emails and chats to do tasks. Google/CNET
You can also chat with Gemini in Sheets and have it scour your raw data to make custom reports and charts. No need for pivot tables if they confound you as much as they baffle me. One of the biggest uses of AI at work is helping create presentations.
In Google Slides, you can now tell Gemini in natural language what you want to appear on a slide, and it will create it, matching the style of your existing slides. You can also ask Gemini to edit your slides if you don't want to waste time painstakingly moving design elements around the slide. The AI should fill the slides with relevant information based on your instructions and the work files it has access to, so you shouldn't need to replace a bunch of filler text.
If you use Docs, Sheets and Slides through the Workspace account of your company, then you won't be able to turn off AI features individually. The managing company is in control of AI access for users. Personal users can tweak their settings to limit Gemini. The new features are rolling out in beta now, in English only, to Google AI Ultra and Pro subscribers in the US, as well as some Google Workspace customers who are part of the Gemini Alpha testing program.
For more, check out the new cowork feature in Copilot and how to use Perplexity AI for deep research.