google-workspace-gemini

name	google-workspace-gemini
description	Design Google Workspace Gemini implementations and optimize productivity workflows. Use when planning Gemini adoption, creating prompts, integrating AI into Workspace, or comparing with alternatives.
version	1.0.0
license	MIT

Google Workspace Gemini Specialist

Note: Review PROFILE.md in this skill folder for user-specific use cases, optimization strategies, and comparison frameworks.

Master Briefing: Global brand voice at ~/.superskills/master-briefing.yaml applies automatically. Skill profile overrides when conflicts exist.

Implement and optimize Google Workspace with Gemini AI to boost personal and team productivity through intelligent document creation, data analysis, and workflow automation.

Core Workflow

1. Setup & Configuration

• Assess Workspace usage and needs
• Configure Gemini access and permissions
• Identify high-value use cases
• Establish productivity baselines

2. Use Case Mapping

• Map Gemini capabilities to workflows
• Prioritize by impact and frequency
• Create role-specific prompt libraries
• Design integrated workflows

3. Prompt Optimization

• Develop effective prompts for each app
• Test and refine for quality
• Build reusable prompt templates
• Document best practices

4. Workflow Integration

• Integrate Gemini into daily routines
• Combine with Workspace automation
• Measure productivity improvements
• Iterate and optimize

Quality Checklist

• Use cases aligned with actual workflows
• Prompts tested and optimized
• Integration points identified
• Productivity metrics established
• Prompt library documented
• Team training completed (if applicable)
• Privacy and data practices reviewed
• ROI tracked and reported

Google Workspace Gemini Overview

See PROFILE.md for:

• Personal productivity workflows
• Specific use case examples
• Comparison with M365 Copilot

Gemini in Workspace Apps:

Gemini in Gmail:

• Draft emails from bullet points
• Summarize email threads
• Suggest replies with context
• Polish and formalize messages
• Extract action items

Gemini in Docs:

• Generate content from prompts
• Rewrite and refine text
• Summarize long documents
• Create outlines and structures
• Format and organize content

Gemini in Sheets:

• Generate formulas from descriptions
• Analyze data and create insights
• Build charts and visualizations
• Track and categorize data
• Create pivot tables and summaries

Gemini in Slides:

• Generate presentations from topics
• Create custom images for slides
• Design layouts and themes
• Transform docs to presentations
• Generate speaker notes

Gemini in Meet:

• Generate meeting summaries
• Create action items automatically
• Transcribe meetings
• Translate in real-time
• Background generation

Gemini in Chat:

• Summarize conversation threads
• Answer questions from context
• Draft responses
• Search across Workspace

Prompt Engineering Best Practices

Effective Prompt Structure

[Task] + [Context] + [Style/Format] + [Constraints]

Example:
"Write a project proposal for implementing AI tools in our 
marketing department. Include sections on goals, timeline, 
budget, and expected ROI. Use professional but accessible 
language. Keep it to 2 pages."

The 5 W's for Better Prompts

• What: Specific task or output needed
• Who: Audience or perspective
• Where: Context or location
• When: Timeframe or urgency
• Why: Purpose or goal

Prompt Templates by App

Gmail - Email Composition:

"Draft an email to [recipient] about [topic]. 
Tone: [professional/casual/formal]. 
Include: [key points]. 
Length: [brief/detailed]."

Docs - Content Creation:

"Create a [document type] about [topic] for [audience]. 
Include sections on [points]. 
Style: [tone and voice]. 
Length: [word count/pages]."

Sheets - Data Analysis:

"Analyze this data to [goal]. 
Create [chart/pivot table] showing [insight]. 
Highlight [metrics] and provide [number] recommendations."

Slides - Presentation:

"Create a [presentation type] about [topic] for [audience]. 
[Number] slides covering [key points]. 
Style: [minimal/creative/professional]. 
Include images for each slide."

Meet - Meeting Prep:

"Summarize this document and create talking points for 
a meeting about [topic]. Include questions to ask and 
potential objections to address."

Use Case Library Template

APP: [Gmail/Docs/Sheets/Slides/Meet]

TASK: [Brief description of the task]

FREQUENCY: [Daily/Weekly/Monthly]

TIME SAVED: [Estimated hours/minutes]

PROMPT:
"[Optimized prompt template with placeholders]"

BEFORE GEMINI:
[Manual process description]

AFTER GEMINI:
[AI-assisted process]

RESULT:
[Time saved, quality improvement, other benefits]

TIPS:
- [Optimization tip 1]
- [Optimization tip 2]

Workflow Integration Patterns

Personal Productivity Workflows

Morning Email Triage:

1. Gemini summarizes overnight emails
2. Drafts responses to routine requests
3. Flags urgent items for attention
4. Creates task list from action items

Content Creation Pipeline:

1. Outline in Docs with Gemini
2. Generate first draft sections
3. Refine and fact-check
4. Create presentation in Slides
5. Format for distribution

Data Analysis Routine:

1. Import data to Sheets
2. Gemini generates analysis formulas
3. Creates visualizations
4. Summarizes insights in Docs
5. Presents findings in Slides

Team Collaboration Workflows

Project Planning:

1. Brainstorm in Docs with Gemini
2. Create project timeline in Sheets
3. Generate presentation for stakeholders
4. Draft emails to team with assignments

Meeting Efficiency:

1. Gemini creates agenda from context
2. Meet transcribes and summarizes
3. Action items extracted to Doc
4. Follow-up emails drafted in Gmail

Gemini vs. Copilot Comparison

When to Choose Gemini

• Primary Workspace: Already using Google Workspace
• Collaboration focus: Real-time team collaboration critical
• Cost: More affordable pricing
• Simplicity: Easier setup and management
• Mobile: Better mobile app integration

When to Choose Copilot

• Primary Workspace: Already using Microsoft 365
• Enterprise features: Advanced compliance needs
• Depth: More sophisticated in Office apps
• Integration: Deeper integration with Windows ecosystem

Feature Comparison

Capability	Gemini	Copilot
Email drafting	✓ Good	✓ Good
Document creation	✓ Good	✓ Excellent
Data analysis	✓ Good	✓ Excellent
Presentation design	✓ Excellent (images)	✓ Good
Meeting summaries	✓ Good	✓ Excellent
Cross-app intelligence	✓ Developing	✓ Strong
Pricing	Lower	Higher
Availability	Workspace plans	M365 E3/E5

Productivity Measurement

Metrics to Track

• Time saved: Hours per week on key tasks
• Output volume: Documents/emails/analyses created
• Quality: Error rate, revision cycles
• Adoption: % of team using Gemini regularly
• Satisfaction: User feedback scores

Measurement Methods

• Time logs: Before/after for common tasks
• Self-reporting: Weekly surveys
• Usage analytics: Workspace admin console
• Output tracking: Count deliverables
• Quality checks: Peer review scores

ROI Calculation

COST:
- Gemini for Workspace: $30/user/month
- Training/setup: One-time investment
TOTAL: $360/user/year + setup

BENEFIT:
- Time saved: [hours/week × 50 weeks × hourly rate]
- Quality improvement: [value of fewer errors]
- Increased output: [additional deliverables × value]
TOTAL: $[benefit per user per year]

ROI: ([Benefit - Cost] / Cost) × 100

Advanced Techniques

Iterative Prompting

Start broad, refine with follow-ups:

1. Initial prompt: General request
2. Review output, identify gaps
3. Follow-up: "Add more detail on..."
4. Follow-up: "Change tone to..."
5. Final: "Format as..."

Context Stacking

Build on previous interactions:

• "Using the outline we just created..."
• "Based on the analysis above..."
• "Following the same format..."

Constraint Optimization

Be specific about limits:

• Word/page count
• Tone and style
• Required sections
• Data sources to use
• Format requirements

Avoid

• Vague Prompts: "Write something" → Specific task with details
• One-Shot Only: Single prompt → Iterate and refine
• No Review: Trust blindly → Always verify and edit
• Ignore Context: Generic prompts → Include relevant background
• Over-Reliance: Let AI do everything → Use as augmentation
• No Documentation: Lose good prompts → Build prompt library

Escalate When

• Data privacy or compliance concerns
• Need for custom integration (Apps Script)
• Enterprise deployment questions
• Technical issues with Gemini access
• Comparison with other tools needed
• ROI not meeting expectations
• Training needs beyond individual use