Gemini Workspace prompt pack

Gemini Prompts for Google Workspace

Use these Gemini prompts for Gmail, Docs, Sheets, Calendar, Meet, and Drive workflows: summaries, drafts, trackers, reports, handoffs, and automation planning.

Browse Prompts All Prompts Resources

Use This Page For

Use these prompts when the work already lives in Google Workspace and the bottleneck is summarizing, drafting, tracking, routing, or reviewing information. The prompts are written for practical workflow support, not fully unsupervised automation.

For sensitive email, customer, HR, legal, or financial data, use placeholders or summaries and keep a human approval step before anything is sent or shared.

Prompt Selection Framework

Name the workflow

Define the trigger, source document, destination, owner, review step, and final output before asking Gemini to draft or summarize.

Keep humans in review

Use Gemini to prepare drafts, summaries, and trackers, then keep approvals for customer-facing, legal, financial, or sensitive work.

Standardize outputs

Ask for tables, naming conventions, fields, labels, and status definitions so the workflow can repeat cleanly.

Copy-ready pack

30 Practical Prompts

Each prompt includes the best use case, variables to replace, customization notes, and the output you should expect.

Prompt 1

Workspace Workflow Map

Best for: Designing a repeatable process before automating it.

Act as a Google Workspace operations designer. Map this workflow.
Workflow: [WORKFLOW]
Apps involved: [GMAIL / DOCS / SHEETS / CALENDAR / MEET / DRIVE]
Trigger: [TRIGGER]
Source inputs: [INPUTS]
Final output: [OUTPUT]
Review owner: [OWNER]
Return: step-by-step flow, fields needed, app used at each step, manual review points, failure cases, and automation candidates.

Variables

  • [WORKFLOW]
  • [GMAIL / DOCS / SHEETS / CALENDAR / MEET / DRIVE]
  • [TRIGGER]
  • [INPUTS]
  • [OUTPUT]
  • [OWNER]

Customize

Start with one recurring workflow. Broad automation requests usually create messy handoffs.

Expected Output

A practical workflow blueprint with review checkpoints.

Prompt 2

Gmail Triage Rules

Best for: Creating labels and response priorities.

Build Gmail triage rules for this inbox.
Role or team: [TEAM]
Common email types: [EMAIL TYPES]
Urgent signals: [URGENT SIGNALS]
Low-priority signals: [LOW PRIORITY]
Return: labels, priority rules, reply deadlines, routing logic, and examples of emails for each label.

Variables

  • [TEAM]
  • [EMAIL TYPES]
  • [URGENT SIGNALS]
  • [LOW PRIORITY]

Customize

Use real email types and escalation rules from your team.

Expected Output

A clear triage system that can guide manual or automated processing.

Prompt 3

Gmail Reply Draft

Best for: Drafting a professional response from context.

Draft a Gmail reply.
Incoming email: [EMAIL]
Goal of reply: [GOAL]
Tone: [TONE]
Constraints or policy: [CONSTRAINTS]
Needed next step: [NEXT STEP]
Return: concise reply, warmer reply, direct reply, and missing information I should confirm before sending.

Variables

  • [EMAIL]
  • [GOAL]
  • [TONE]
  • [CONSTRAINTS]
  • [NEXT STEP]

Customize

Ask Gemini to identify missing facts before you send customer-facing replies.

Expected Output

Several reply options plus verification notes.

Prompt 4

Inbox Digest

Best for: Summarizing a batch of messages.

Summarize these emails into an action digest.
Emails: [EMAIL BATCH]
Owner: [OWNER]
Time window: [TIME WINDOW]
Return: urgent items, waiting-on items, decisions needed, suggested replies, deadlines, and a table of sender, topic, action, owner, and due date.

Variables

  • [EMAIL BATCH]
  • [OWNER]
  • [TIME WINDOW]

Customize

Use this for daily or weekly inbox review. Remove sensitive data if needed.

Expected Output

A prioritized email action list.

Prompt 5

Calendar Agenda Builder

Best for: Creating a focused meeting agenda.

Create a meeting agenda for Google Calendar.
Meeting title: [TITLE]
Attendees: [ATTENDEES]
Goal: [GOAL]
Pre-read or context: [CONTEXT]
Duration: [DURATION]
Return: agenda, timing, decisions needed, prep tasks, and calendar description text.

Variables

  • [TITLE]
  • [ATTENDEES]
  • [GOAL]
  • [CONTEXT]
  • [DURATION]

Customize

Include the decision the meeting must produce, not only discussion topics.

Expected Output

A meeting agenda ready to paste into Calendar.

Prompt 6

Meet Notes Summary

Best for: Turning meeting notes into actions.

Summarize these Google Meet notes.
Notes or transcript: [NOTES]
Meeting goal: [GOAL]
Attendees: [ATTENDEES]
Return: summary, decisions, action items with owners, open questions, risks, and follow-up email draft.

Variables

  • [NOTES]
  • [GOAL]
  • [ATTENDEES]

Customize

Ask for action owners and deadlines so notes become operational.

Expected Output

A meeting recap with actions and follow-up.

Prompt 7

Action Item Tracker

Best for: Creating a Sheets tracker from notes.

Convert these notes into a Google Sheets action tracker.
Notes: [NOTES]
Project: [PROJECT]
Return columns for task, owner, due date, status, dependency, source note, risk, and next update. Then populate the first version of the table.

Variables

  • [NOTES]
  • [PROJECT]

Customize

Include dependencies and source notes so people can trace why tasks exist.

Expected Output

A table ready to paste into Sheets.

Prompt 8

Focus Block Calendar Plan

Best for: Protecting deep work time.

Create a Google Calendar focus plan.
Work priorities: [PRIORITIES]
Existing commitments: [COMMITMENTS]
Energy pattern: [ENERGY]
Deadline pressure: [DEADLINES]
Return: weekly focus blocks, meeting-free windows, admin blocks, and rules for when to move a block.

Variables

  • [PRIORITIES]
  • [COMMITMENTS]
  • [ENERGY]
  • [DEADLINES]

Customize

Make calendar blocks realistic for your meeting load.

Expected Output

A schedule plan with protected focus time.

Prompt 9

Docs Brief Generator

Best for: Writing a first draft of a project brief.

Create a Google Docs project brief.
Project: [PROJECT]
Problem: [PROBLEM]
Stakeholders: [STAKEHOLDERS]
Goals: [GOALS]
Constraints: [CONSTRAINTS]
Return: background, goals, scope, non-goals, timeline, owners, risks, and decision log.

Variables

  • [PROJECT]
  • [PROBLEM]
  • [STAKEHOLDERS]
  • [GOALS]
  • [CONSTRAINTS]

Customize

Include non-goals to keep scope under control.

Expected Output

A structured project brief for Docs.

Prompt 10

Proposal Draft

Best for: Creating a client or internal proposal.

Draft a proposal in Google Docs format.
Client or stakeholder: [CLIENT]
Problem: [PROBLEM]
Recommended solution: [SOLUTION]
Scope: [SCOPE]
Timeline: [TIMELINE]
Proof: [PROOF]
Return: executive summary, approach, deliverables, timeline, assumptions, pricing placeholder, and next step.

Variables

  • [CLIENT]
  • [PROBLEM]
  • [SOLUTION]
  • [SCOPE]
  • [TIMELINE]
  • [PROOF]

Customize

Flag assumptions and missing details before sharing externally.

Expected Output

A proposal draft with sections and review notes.

Prompt 11

Policy Document Outline

Best for: Standardizing team rules.

Create a policy document outline.
Policy topic: [TOPIC]
Audience: [AUDIENCE]
Reason for policy: [REASON]
Requirements: [REQUIREMENTS]
Return: purpose, scope, definitions, rules, examples, exceptions, owner, review cycle, and FAQ.

Variables

  • [TOPIC]
  • [AUDIENCE]
  • [REASON]
  • [REQUIREMENTS]

Customize

Use plain language and examples so the policy is usable.

Expected Output

A Docs-ready policy structure.

Prompt 12

Sheets Formula Helper

Best for: Writing or debugging formulas.

Help me create a Google Sheets formula.
Goal: [GOAL]
Sheet columns: [COLUMNS]
Example rows: [EXAMPLES]
Current formula if any: [FORMULA]
Return: recommended formula, explanation, edge cases, and a test table.

Variables

  • [GOAL]
  • [COLUMNS]
  • [EXAMPLES]
  • [FORMULA]

Customize

Provide column names and examples. Formula prompts fail when sheet structure is unclear.

Expected Output

A formula with explanation and tests.

Prompt 13

Sheets Data Cleanup Plan

Best for: Cleaning messy spreadsheet data.

Create a data cleanup plan for Google Sheets.
Dataset description: [DATASET]
Columns: [COLUMNS]
Known issues: [ISSUES]
Desired final format: [FORMAT]
Return: cleanup steps, formulas or functions, validation rules, duplicate handling, and QA checklist.

Variables

  • [DATASET]
  • [COLUMNS]
  • [ISSUES]
  • [FORMAT]

Customize

Add a few example rows so Gemini can identify exact cleanup patterns.

Expected Output

A cleanup workflow and QA checklist.

Prompt 14

KPI Dashboard Spec

Best for: Planning a Sheets reporting dashboard.

Design a Google Sheets KPI dashboard.
Team: [TEAM]
Goals: [GOALS]
Available data: [DATA]
Reporting cadence: [CADENCE]
Return: dashboard sections, metrics, formulas, chart ideas, data validation rules, and weekly update process.

Variables

  • [TEAM]
  • [GOALS]
  • [DATA]
  • [CADENCE]

Customize

Tie every metric to a decision. Avoid vanity metrics.

Expected Output

A dashboard spec ready to build in Sheets.

Prompt 15

Sheets Insight Summary

Best for: Explaining changes in a spreadsheet.

Analyze this Sheets data summary.
Data pasted: [DATA]
Business question: [QUESTION]
Time period: [PERIOD]
Return: key changes, likely causes, anomalies, questions to verify, and a concise executive summary.

Variables

  • [DATA]
  • [QUESTION]
  • [PERIOD]

Customize

Use sampled or summarized data if the full sheet is too large.

Expected Output

Insights with caveats and follow-up questions.

Prompt 16

Drive Folder Standard

Best for: Cleaning up file organization.

Create a Google Drive folder and naming standard.
Team: [TEAM]
File types: [FILE TYPES]
Current problems: [PROBLEMS]
Access rules: [ACCESS]
Return: folder structure, naming convention, owner rules, archive policy, and rollout checklist.

Variables

  • [TEAM]
  • [FILE TYPES]
  • [PROBLEMS]
  • [ACCESS]

Customize

Include access sensitivity so the folder plan does not create permission issues.

Expected Output

A Drive organization standard.

Prompt 17

SOP Builder

Best for: Documenting repeatable work.

Write a standard operating procedure.
Process: [PROCESS]
Owner: [OWNER]
Trigger: [TRIGGER]
Tools: [TOOLS]
Exceptions: [EXCEPTIONS]
Return: purpose, prerequisites, step-by-step instructions, screenshots needed, QA checks, and escalation path.

Variables

  • [PROCESS]
  • [OWNER]
  • [TRIGGER]
  • [TOOLS]
  • [EXCEPTIONS]

Customize

Add exceptions and escalation rules. SOPs fail when edge cases are hidden.

Expected Output

A Docs-ready SOP.

Prompt 18

Project Tracker

Best for: Tracking project status in Sheets.

Create a project tracker for Google Sheets.
Project: [PROJECT]
Workstreams: [WORKSTREAMS]
Stakeholders: [STAKEHOLDERS]
Milestones: [MILESTONES]
Return: columns, status definitions, risk fields, update cadence, sample rows, and dashboard summary fields.

Variables

  • [PROJECT]
  • [WORKSTREAMS]
  • [STAKEHOLDERS]
  • [MILESTONES]

Customize

Define statuses clearly so the tracker is not just a task dump.

Expected Output

A project tracking table and update rhythm.

Prompt 19

Approval Workflow

Best for: Reducing unclear handoffs.

Design an approval workflow in Google Workspace.
Asset type: [ASSET]
Requester: [REQUESTER]
Approvers: [APPROVERS]
Review criteria: [CRITERIA]
Deadline: [DEADLINE]
Return: workflow steps, Docs comments process, Gmail notifications, status tracker fields, and escalation rules.

Variables

  • [ASSET]
  • [REQUESTER]
  • [APPROVERS]
  • [CRITERIA]
  • [DEADLINE]

Customize

Limit approvers where possible. Too many review steps slow the process.

Expected Output

An approval process that can run across Docs, Gmail, and Sheets.

Prompt 20

Customer Feedback Synthesis

Best for: Summarizing feedback from forms or emails.

Synthesize customer feedback.
Feedback data: [FEEDBACK]
Source: [SOURCE]
Product area: [AREA]
Return: themes, representative quotes, severity, frequency, customer segment, recommended actions, and a Sheets table.

Variables

  • [FEEDBACK]
  • [SOURCE]
  • [AREA]

Customize

Ask Gemini to separate common themes from loud one-off complaints.

Expected Output

A prioritized feedback summary and table.

Prompt 21

Sales Pipeline Update

Best for: Turning account notes into a weekly update.

Create a sales pipeline update.
Pipeline notes: [NOTES]
Period: [PERIOD]
Forecast categories: [CATEGORIES]
Return: executive summary, changes by stage, risk accounts, expansion opportunities, next actions, and Gmail-ready update.

Variables

  • [NOTES]
  • [PERIOD]
  • [CATEGORIES]

Customize

Include forecast rules so Gemini does not overstate deal confidence.

Expected Output

A weekly pipeline summary with action items.

Prompt 22

Support Ticket Routing

Best for: Classifying support requests.

Classify these support tickets.
Tickets: [TICKETS]
Categories: [CATEGORIES]
Priority rules: [RULES]
Return: table with ticket, category, priority, likely owner, suggested reply, missing information, and escalation flag.

Variables

  • [TICKETS]
  • [CATEGORIES]
  • [RULES]

Customize

Keep customer-sensitive decisions under human review.

Expected Output

A routing table and draft replies.

Prompt 23

Hiring Scorecard

Best for: Structuring interview notes.

Create a hiring scorecard.
Role: [ROLE]
Interview stage: [STAGE]
Competencies: [COMPETENCIES]
Notes: [NOTES]
Return: scorecard criteria, evidence from notes, risks, follow-up questions, and decision summary.

Variables

  • [ROLE]
  • [STAGE]
  • [COMPETENCIES]
  • [NOTES]

Customize

Use evidence-based notes to reduce vague interview feedback.

Expected Output

A structured hiring evaluation.

Prompt 24

Employee Onboarding Checklist

Best for: Planning onboarding in Docs and Sheets.

Create an onboarding checklist.
Role: [ROLE]
Team: [TEAM]
First 30 days goals: [GOALS]
Tools and access: [TOOLS]
Return: pre-start tasks, first-day agenda, 30-day plan, owner checklist, Drive docs needed, and manager check-ins.

Variables

  • [ROLE]
  • [TEAM]
  • [GOALS]
  • [TOOLS]

Customize

Add access requirements to avoid first-week delays.

Expected Output

A practical onboarding plan for Docs or Sheets.

Prompt 25

Expense Review Table

Best for: Reviewing spending in Sheets.

Review this expense data.
Expense data: [DATA]
Policy rules: [RULES]
Period: [PERIOD]
Return: flagged expenses, category totals, unusual patterns, missing receipts, and questions for the owner.

Variables

  • [DATA]
  • [RULES]
  • [PERIOD]

Customize

Use policy text and avoid making final approval decisions without review.

Expected Output

An expense review summary with flags.

Prompt 26

Privacy Review Checklist

Best for: Checking sensitive Workspace content before sharing.

Review this content for privacy and sharing risk.
Content summary: [CONTENT]
Audience: [AUDIENCE]
Sharing channel: [CHANNEL]
Policy constraints: [POLICY]
Return: sensitive data risks, redactions needed, access rules, safer wording, and approval checklist.

Variables

  • [CONTENT]
  • [AUDIENCE]
  • [CHANNEL]
  • [POLICY]

Customize

Do not paste sensitive data if your policy prohibits it. Use summaries or placeholders.

Expected Output

A privacy-focused review checklist.

Prompt 27

Automation QA Checklist

Best for: Testing a Workspace workflow before rollout.

Create a QA checklist for this Workspace automation.
Workflow: [WORKFLOW]
Apps involved: [APPS]
Trigger: [TRIGGER]
Failure risks: [RISKS]
Return: test cases, sample inputs, expected outputs, permission checks, rollback plan, and launch criteria.

Variables

  • [WORKFLOW]
  • [APPS]
  • [TRIGGER]
  • [RISKS]

Customize

Test permissions and edge cases before relying on automation.

Expected Output

A pre-launch QA plan.

Prompt 28

Apps Script Spec

Best for: Preparing requirements for a simple script.

Write a Google Apps Script specification.
Workflow goal: [GOAL]
Source app and data: [SOURCE]
Destination: [DESTINATION]
Trigger: [TRIGGER]
Error handling: [ERRORS]
Return: requirements, pseudo-code, permissions needed, test cases, and user-facing setup notes.

Variables

  • [GOAL]
  • [SOURCE]
  • [DESTINATION]
  • [TRIGGER]
  • [ERRORS]

Customize

Use this as a spec for implementation. Review code and permissions before deploying.

Expected Output

A script-ready requirements document.

Prompt 29

Weekly Executive Update

Best for: Summarizing team progress.

Draft a weekly executive update.
Team: [TEAM]
Wins: [WINS]
Metrics: [METRICS]
Risks: [RISKS]
Decisions needed: [DECISIONS]
Return: concise update, KPI table, risks, asks, and a Gmail-ready version.

Variables

  • [TEAM]
  • [WINS]
  • [METRICS]
  • [RISKS]
  • [DECISIONS]

Customize

Separate FYI updates from decisions needed.

Expected Output

An executive-ready update.

Prompt 30

Change Management Message

Best for: Announcing a new workflow.

Draft a change management message.
Change: [CHANGE]
Audience: [AUDIENCE]
Reason: [REASON]
Impact: [IMPACT]
Support resources: [RESOURCES]
Return: announcement email, FAQ, training plan, resistance risks, and success metrics.

Variables

  • [CHANGE]
  • [AUDIENCE]
  • [REASON]
  • [IMPACT]
  • [RESOURCES]

Customize

Name what changes for the audience and what stays the same.

Expected Output

A rollout communication pack.

Related Prompt Paths

Gemini Workspace Automation Planner

Use a deeper prompt for designing a full Workspace automation process.

Productivity prompts

Browse prompts for task planning, meetings, documentation, and workflow improvement.

Prompt to workflow guide

Turn useful prompts into repeatable workflows with human checkpoints.

FAQ

What are Gemini prompts for Google Workspace?

They are task-specific instructions for using Gemini inside or alongside Gmail, Docs, Sheets, Calendar, Meet, and Drive to summarize, draft, classify, plan, and review work.

Can Gemini automate Google Workspace?

Gemini can help draft workflow steps, summarize Workspace content, create formulas, and plan automations. Fully automated workflows may still need Google Apps Script, add-ons, APIs, or manual review depending on the task.

What should I include in a Gemini Workspace prompt?

Include the Workspace app, source material, desired output format, owner, deadline, review rules, privacy limits, and what Gemini should do if information is missing.