GEMINI LABJP
NANOLITE — Nano Banana 2 Lite is here: Google's fastest and most cost-efficient Gemini Image model, made for running lightweight image generation cheaplyOMNIFLASH — Gemini Omni Flash is in public preview, a natively multimodal model that lets enterprises and developers build custom, dynamic video workflowsAGENTS — Managed Agents expand with background: true for async server-side runs and polling, remote MCP server integration, and refreshing credentials across interactionsMEMORY — The Memory Bank IngestEvents API is generally available, decoupling event ingestion from memory generation so you can stream content continuouslyTHROUGHPUT — Provisioned Throughput now lets you submit up to seven pending orders for the same model and regionDEPRECATE — Image generation models shut down on August 17, and the Grok 4.1 family on the Gemini Enterprise Agent Platform on August 20NANOLITE — Nano Banana 2 Lite is here: Google's fastest and most cost-efficient Gemini Image model, made for running lightweight image generation cheaplyOMNIFLASH — Gemini Omni Flash is in public preview, a natively multimodal model that lets enterprises and developers build custom, dynamic video workflowsAGENTS — Managed Agents expand with background: true for async server-side runs and polling, remote MCP server integration, and refreshing credentials across interactionsMEMORY — The Memory Bank IngestEvents API is generally available, decoupling event ingestion from memory generation so you can stream content continuouslyTHROUGHPUT — Provisioned Throughput now lets you submit up to seven pending orders for the same model and regionDEPRECATE — Image generation models shut down on August 17, and the Grok 4.1 family on the Gemini Enterprise Agent Platform on August 20
Articles/Dev Tools
Dev Tools/2026-03-14Beginner

Gemini in Google Workspace 2026: New Features in Docs, Sheets, Slides & Drive

A deep dive into Google's March 2026 Gemini Workspace update — covering Help me create, Ask Gemini in Drive, Match writing style, and AI-powered Sheets. Includes code samples for developers.

gemini102google-workspace7docssheetsdriveproductivity13

In March 2026, Google shipped a major update to Gemini in Google Workspace — one that moves the AI assistant beyond simple text generation toward something more like an intelligent layer connecting your entire organization's knowledge. Below, we go feature by feature through what actually shipped—and how to fold each one into your daily work or rebuild it inside your own apps.

What's New at a Glance

Here's a quick overview of the new capabilities:

  • Docs: "Help me create" auto-generates full drafts by pulling context from Drive, Gmail, and Chat; "Match writing style" enforces a consistent tone across long documents
  • Sheets: A single prompt can pull data from Gmail, Chat, and Drive to create a formatted spreadsheet from scratch
  • Drive: Natural language search now shows an "AI Overview" at the top of results; "Ask Gemini in Drive" lets you ask questions across all your files
  • Availability: Rolling out first to Google AI Ultra and Pro subscribers in English globally (Drive features US-only for now)

Google Docs Updates

"Help me create" — From Blank Page to First Draft

The previous "Help me write" feature would insert AI-generated text at your cursor position. The new "Help me create" goes further: it actively gathers information from your Gmail threads, Chat conversations, and Drive files to generate a structured first draft.

How to use it:

  1. Open a new Google Doc
  2. Click the "Help me create" button in the toolbar or bottom-left of the canvas
  3. Describe what you want to create (e.g., "Write a weekly status report based on last week's project updates")
  4. Gemini searches your connected workspace data and assembles a draft

This is particularly powerful for documents you write repeatedly — progress reports, proposals, meeting recaps — where the source material already exists somewhere in your workspace.

"Match writing style" — Consistent Voice Across Long Documents

Collaborative editing often leaves a document feeling tonally inconsistent — formal in one section, casual in another. "Match writing style" analyzes the dominant voice and style of your document and flags passages that deviate from it, offering specific rewrite suggestions.

For technical writers and content teams, this feature alone can cut editing cycles significantly.


Google Sheets Updates

Build a Spreadsheet With a Single Prompt

Gemini in Sheets has evolved from a formula suggester to a proactive data aggregator. With the new update, you can describe a spreadsheet you want and Gemini will pull relevant data from Gmail, Chat messages, and Drive files to populate it automatically.

Use cases:

  • "Summarize last month's support emails by category and count" → Gemini reads your Gmail threads and builds a categorized frequency table
  • "Create a task tracker from Project X's Slack messages" → Gemini extracts action items and owners from Chat

Apps Script + Gemini API Sample

For developers, here's how to call the Gemini API directly from Google Apps Script to analyze Sheets data:

// Apps Script: Analyze Sheets data using the Gemini API
function analyzeSheetWithGemini() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const data = sheet.getDataRange().getValues();
 
  // Convert sheet data to a CSV string
  const csvData = data.map(row => row.join(",")).join("\n");
 
  // Call Gemini API (gemini-3-flash model)
  const apiKey = PropertiesService.getScriptProperties().getProperty("GEMINI_API_KEY");
  const url = `https://generativelanguage.googleapis.com/v1beta/models/gemini-3-flash:generateContent?key=${apiKey}`;
 
  const payload = {
    contents: [{
      parts: [{
        text: `Analyze the following spreadsheet data and provide:
1. The main trends you observe
2. Three actionable improvement recommendations
 
Data:
${csvData}`
      }]
    }]
  };
 
  const options = {
    method: "post",
    contentType: "application/json",
    payload: JSON.stringify(payload)
  };
 
  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());
 
  // Write analysis to a new sheet
  const analysisSheet = SpreadsheetApp.getActiveSpreadsheet()
    .insertSheet("Gemini Analysis");
  const analysisText = result.candidates[0].content.parts[0].text;
  analysisSheet.getRange("A1").setValue(analysisText);
 
  Logger.log("Analysis complete: " + analysisText.substring(0, 100));
}
 
// Expected output (logged):
// Analysis complete: ## Spreadsheet Analysis
// ### Main Trends
// 1. Q3 revenue increased 20% year-over-year, driven primarily by...
// ### Recommendations
// 1. Consider segmenting by region to identify underperforming markets
// 2. The churn column has 15% missing values — data quality improvement needed
// 3. Add a rolling 3-month average column for smoother trend visualization

Attach this to a time-based trigger and you've got a lightweight automated analytics pipeline.


Google Drive Updates

"AI Overview" in Search Results

When you search Drive using natural language, Gemini now surfaces an AI Overview panel at the top of results — a synthesized summary of the most relevant information pulled from your matching files, with source citations.

For example, searching for "Q4 budget proposal" might return an AI Overview that says: "You have three documents related to Q4 budget planning. The most recent (Budget_Proposal_v3.docx, updated Oct 14) projects total spending at $2.4M with a 12% increase in R&D allocation."

"Ask Gemini in Drive" — Cross-Document Q&A

Ask Gemini in Drive opens a chat panel in Drive that can answer questions by reasoning across all your documents, emails, and calendar data simultaneously.

Examples of what you can ask:

  • "What are the outstanding action items from Project Alpha's meeting notes?"
  • "What's the deadline mentioned in the contract I received last week?"
  • "Which marketing strategy documents include competitive analysis?"

This is the closest Google Workspace has come to a true enterprise knowledge assistant — no file hunting, no tab switching.


Workspace Gemini vs. Gemini API: Key Differences

Understanding where Workspace Gemini ends and the API begins is important for developers:

FeatureWorkspace GeminiGemini API (Google AI Studio)
Target audienceBusiness / end usersDevelopers
Access methodUI buttons inside appsAPI key + code
CustomizabilityLow (fixed UI flows)High (full prompt control)
BillingWorkspace subscriptionPer-token usage
Best forDay-to-day productivityCustom apps & integrations

A common pattern is to prototype with Workspace Gemini, then replicate the workflow via the API to embed it in your own product.


Replicating Workspace Features with Python + Gemini API

Here's a Python example that mimics "Ask Gemini in Drive" — fetching a Google Doc's content and analyzing it with the Gemini API:

# Requirements:
# pip install google-generativeai google-api-python-client google-auth-httplib2 google-auth-oauthlib
 
import google.generativeai as genai
from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials
 
genai.configure(api_key="YOUR_GEMINI_API_KEY")
 
def analyze_google_doc(doc_id: str) -> str:
    """
    Fetch a Google Document and analyze it with the Gemini API.
 
    Args:
        doc_id: The Google Docs file ID from the URL
                (the part between /d/ and /edit)
 
    Returns:
        Gemini's analysis as a string
    """
    # Authenticate and fetch document content
    creds = Credentials.from_authorized_user_file("token.json")
    service = build("docs", "v1", credentials=creds)
    document = service.documents().get(documentId=doc_id).execute()
 
    # Extract plain text from document body
    content = ""
    for element in document.get("body", {}).get("content", []):
        if "paragraph" in element:
            for part in element["paragraph"].get("elements", []):
                if "textRun" in part:
                    content += part["textRun"].get("content", "")
 
    # Send to Gemini for analysis
    model = genai.GenerativeModel("gemini-3-flash")
    prompt = f"""
Analyze the following document and provide:
 
1. **Summary** (under 100 words)
2. **Key points** (3–5 bullets)
3. **Improvement suggestions** (style, structure, and content)
 
Document content:
{content[:8000]}
"""
 
    response = model.generate_content(prompt)
    return response.text
 
# Example usage
doc_id = "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms"
result = analyze_google_doc(doc_id)
print(result)
 
# Expected output:
# ## Document Analysis
#
# ### 1. Summary
# This document is a Q3 sales report showing 15% year-over-year growth,
# with strong performance in the enterprise segment and new customer acquisition.
#
# ### 2. Key Points
# - Q3 revenue: $12M (115% of target)
# - New customer acquisition up 30% YoY
# - Product A has the highest repeat rate at 68%
# - APAC region underperformed at 82% of target
#
# ### 3. Improvement Suggestions
# - Add an executive summary at the top for quick scanning
# - Include charts for the revenue trend data
# - The conclusion section could be strengthened with next-quarter projections

How to Get Access

As of March 2026, the new Workspace Gemini features are rolling out in the following order:

  1. Google AI Ultra subscribers — first access to all features
  2. Google AI Pro subscribers — access to most features, with some in beta
  3. Google Workspace Business/Enterprise — enable via Admin Console → Apps → Google Workspace → Gemini
  4. Free Google account users — timeline not yet announced

Language availability: "Help me create" and "Match writing style" are available globally in English. Drive AI Overview and Ask Gemini in Drive are currently US-only.


Wrapping Up

The March 2026 Workspace update marks a meaningful shift in what "AI in productivity tools" actually means. Rather than a text autocomplete sitting inside a document, Gemini is now functioning as a cross-workspace intelligence layer — connecting Docs, Sheets, Drive, Gmail, and Chat into a unified knowledge surface.

For developers, the takeaway is clear: the patterns Google is shipping in Workspace (RAG over user documents, structured data extraction from unstructured sources, style normalization) are exactly the kinds of workflows the Gemini API lets you build for your own products.

Start experimenting in Google AI Studio, and when you're ready to go deeper, the Gemini API gives you all the building blocks.

Further reading:

  • [Google AI Studio Getting Started Guide]((/articles/gemini-dev/google-ai-studio-guide)
  • [Gemini API Quickstart: Your First API Call and Beyond]((/articles/gemini-api/gemini-api-quickstart)
  • [Vertex AI Quickstart: Enterprise Gemini Deployment]((/articles/gemini-dev/vertex-ai-quickstart)
Share

Thank You for Reading

Gemini Lab is ad-free, supported entirely by members like you. We publish practical guides daily with implementation code, benchmarks, and production-ready patterns. If you've found it useful, we'd love to have you on board.

  • Copy-paste ready implementation code
  • New advanced guides published daily
  • $5/mo or $10 for lifetime access
View Membership →

If you found this article helpful, a small tip ($1.50) would mean a lot to us. Your support helps keep this site ad-free and covers server and hosting costs.

Related Articles

Dev Tools2026-07-02
After the One-Click Deploy — Hardening an AI Studio Gemini App on Cloud Run for Real Production Use
AI Studio's one-click deploy to Cloud Run gives you a working URL in minutes — but not a production service. A practical checklist for API key storage, authentication, cost ceilings, and observability, with copy-paste gcloud commands.
Dev Tools2026-06-30
Tracing Which Prompt Revision Moved Your Quality — Prompt Versioning for a Gemini Pipeline
Editing prompts in place erases the trail: when quality shifts you can't tell whether the model moved or your wording did. Here's a small system that pins prompts by content hash, stamps every generation with the model ID and revision, and bisects a quality drop down to the exact revision boundary, with copy-paste Python.
Dev Tools2026-06-17
Running Gemini Chat History on Redis — Field Notes on Not Losing Conversation State in Production
Keep a Gemini ChatSession in process memory and it evaporates on every redeploy or scale event. Here is how I back it with Redis in production, covering token budgets, concurrent sends, SDK coupling, and graceful degradation, with the code I actually run.
📚RECOMMENDED BOOKS
Build a Large Language Model (From Scratch)
Sebastian Raschka
LLM Dev
Prompt Engineering for LLMs
Berryman & Ziegler
Prompting
AI Engineering
Chip Huyen
AI Eng
* Contains affiliate links
See all →