New Gemini features add citations and bulk editing to Google Sheets and Slides
By OAS
· 2 min read · Automation · Data safety
Google Workspace added several Gemini-powered capabilities this week. The AI function in Sheets now adds cell‑level web citations, and Gemini can edit whole presentations in Slides. The updates aim to make AI‑generated content easier to verify and speed up document work.
In short
- Gemini now adds source citations to AI‑generated cells in Sheets.
- Compact pivot tables reduce scrolling in large reports.
- Gemini can edit an entire Slides deck with one prompt.
What it means for you
- Small businesses can see exactly where AI‑generated data in Sheets comes from, helping keep client information accurate.
- Bulk editing in Slides reduces the time needed to update marketing decks, proposals, or training slides.
- The new pivot‑table layout makes large reports easier to read on any screen.
The details
What happened
Google announced four Gemini‑related updates:
* In Google Sheets, the AI function now includes a citation link for each cell that was generated from the web. This lets you view the source directly in the spreadsheet.
* Sheets also adds a compact form layout for pivot tables, reducing horizontal scrolling for multi‑level tables.
* The Gemini app now offers “immersive explorations,” an interactive visual library that can be accessed from the student hub and soon within chat.
* Gemini can create, preview, edit, and refine files and code inside its chat window.
* In Google Slides, Gemini can edit multiple slides or an entire deck with a single prompt, updating content, visual styles, or matching another presentation’s design.
What it means for your business
These tools let you verify AI‑generated data without leaving a spreadsheet, which is useful when preparing quotes, financial models, or client reports. The compact pivot layout makes dense data easier to read on laptops or tablets, simplifying internal reporting. Bulk slide editing speeds up the creation of marketing or client‑facing decks, letting you refresh branding or data across a whole presentation with one request.
What to do
* When using the AI function in Sheets, check the citation link that appears in each cell to confirm the source before sharing the data.
* Switch to the compact pivot‑table layout (Settings → Pivot table → Compact form) for large reports to improve readability.
* Try the Gemini app’s file‑creation feature for quick drafts of documents or code snippets, then edit directly in the chat window.
* In Slides, open the Gemini side panel, enter a prompt describing the changes you want, and let Gemini apply them to the whole deck.
* Keep an eye on the Google Workspace Updates blog for further details and examples.
What to do this week
0 of 4 done
Practical AI and tech for running a small business.
The Open Arm Brief: answering calls and leads, automating busywork, getting found on Google, keeping data safe and avoiding scams. 5 minutes, Tuesday and Thursday mornings.
Free. One-click unsubscribe. Privacy
Sources (each opens the publisher's page)
More from AI News
What happened ·
Perplexity launches always‑on AI agents for ongoing work
According to The Decoder, Perplexity announced a new “Teammates” AI agent that stays active around the clock to handle ongoing tasks. The agents run on separate virtual machines and are accessed via threads in the Perplexity app or Slack, and they are available only on the Max plan, which costs $200 per month.
Read the storyHow it works ·
Perplexity’s “Teammates” AI agents for everyday workplace tasks
The Verge reports that Perplexity AI introduced “Teammates,” always‑on AI agents that can handle multiple jobs in a workspace. The agents run on Perplexity Computer, can be accessed via threads in the app or Slack, and require a $200‑per‑month Max plan subscription.
Read the storyWhat happened ·
Google Drive adds beta auto‑encryption for confidential files
Google Workspace says its new beta feature lets admins automatically apply client‑side encryption to Docs, Sheets, Slides and Drive files that meet policy rules. The encryption is applied in place and works on My Drive and shared drives, helping meet compliance standards like HIPAA.
Read the story
