Google Workspace just got a significant upgrade this October, with Gemini AI now citing its sources directly in Sheets cells, presentation editing across entire slide decks, and compact pivot table layouts that'll save you from horizontal scrolling nightmares. If your team uses Sheets for research, Slides for client presentations, or pivot tables for reporting, these updates directly affect how quickly you can get work done.

Let's break down what's actually changed and why it matters for your business.

What's new with Gemini in Google Sheets?

The biggest update here is cell-level citations for web sources. When you use the AI function to generate data in Sheets, Gemini now shows you exactly where that information came from—right there in the cell.

Why does this matter? Because AI-generated data without sources is, frankly, a liability. You can't send a client a spreadsheet full of market research figures and just hope they're accurate. Now you can actually verify each piece of information and include source references when you share the work.

The update also supports larger requests, so you can process more data in one go rather than breaking tasks into smaller chunks.

For teams doing competitive analysis, market research, or any kind of data gathering, this is genuinely useful. You get the speed of AI-assisted work with the accountability of sourced information.

How do compact pivot tables help with reporting?

Anyone who's built a multi-level pivot table knows the pain: your report ends up so wide you're scrolling sideways forever, or you have to squint at compressed columns that cut off your labels.

Google Sheets now offers a compact form layout for pivot tables. It keeps hierarchical data readable without spreading across your entire screen. If you regularly build financial reports, sales breakdowns by region and product, or any nested data analysis, this layout option makes your outputs cleaner and easier to share.

It's a small change, but the kind that saves you formatting time every single week.

Can Gemini edit an entire presentation at once?

Yes—and this is where things get interesting for anyone who spends hours tweaking slide decks.

Previously, AI assistance in Slides worked slide-by-slide. Now you can give Gemini a single prompt in the side panel and it'll apply changes across multiple slides or your whole presentation.

Practical uses:

Update company branding across a 40-slide deck
Match the visual style of one presentation to another (useful when merging content from different team members)
Refresh content throughout—say, updating statistics or changing product names across every relevant slide

This doesn't replace thoughtful design work, but it handles the tedious bulk edits that used to eat up your afternoon.

What about file creation in the Gemini app?

The Gemini app now lets you create, preview, and edit files directly within your chat. You can expand to full screen, highlight specific text to ask questions about it, or have Gemini refine sections.

For quick document drafts, code snippets, or working through ideas before moving them into Docs or Sheets, this keeps everything in one place. Less switching between apps, more getting things done.

If your organisation uses Google Workspace through Blue Chip Technologies Ltd., these features are rolling out automatically—no action required on your end.

Frequently asked questions

Are Gemini features included with all Google Workspace plans?
No. Gemini AI features require a Workspace plan that includes Gemini capabilities, or the Gemini add-on. Check your current subscription to confirm access.

Do cell-level citations work with all data sources?
Citations appear when Gemini pulls information from web sources. Data generated from your own spreadsheets or internal calculations won't show external citations since there's no external source to reference.

Will the compact pivot table layout affect my existing reports?
No. It's an optional layout you apply to new or existing pivot tables. Your current reports stay exactly as they are unless you choose to change them.

Can Gemini edit presentations created by other team members?
Yes, as long as you have editing access to the presentation. The AI works on whatever slides you can edit.

Ready to get more from Google Workspace?

If you're not sure whether your current setup includes these Gemini features—or you'd like help rolling out Google Workspace to your team—Blue Chip Technologies Ltd. can help. We support clients globally with remote setup and ongoing assistance.

Get in touch: