Back to guide/General Productivity

Google Workspace Integration

Gemini's deep Google integration means it understands Workspace products natively. Asking for Apps Script automation and reusable templates turns one-off tasks into permanent workflows.

gemini-promptsworkspace_toolcurrent_statedesired_outcome
Edit View
Prompt
I need help with a Google {{workspace_tool}} task.

Current state: {{current_state}}
Goal: {{desired_outcome}}

Provide:
1. **Step-by-step instructions** using the actual Google {{workspace_tool}} UI (reference menu paths like File > Download > CSV)
2. **Formulas/scripts** if applicable — use Google Apps Script (not Excel VBA) syntax
3. **Automation opportunity**: Can this be automated with Apps Script? If yes, provide a complete script with:
   - Trigger setup instructions (time-based, on-edit, etc.)
   - Error handling and logging
   - A description of what to modify for different use cases
4. **Template**: If this is a repeating task, create a template structure I can reuse

Format any formulas as code blocks. For Apps Script, include the full function — not snippets.

Variables to customize

{{workspace_tool}}{{current_state}}{{desired_outcome}}

Why this prompt works

Gemini's deep Google integration means it understands Workspace products natively. Asking for Apps Script automation and reusable templates turns one-off tasks into permanent workflows.

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.

Related prompts

Task Decomposition Agent

Forcing the agent to plan before acting prevents premature execution and wasted steps. Explicit dependency mapping enables parallel execution and catches logical gaps early.

Tool Selection Agent

The ReAct pattern (Reason + Act) creates an explicit reasoning trace that improves tool selection accuracy. The error-handling rule prevents infinite retry loops.

Prompt Compressor

Explicitly requiring all functional requirements to be preserved prevents the model from over-compressing and losing critical instructions.

Memory Management Agent

Explicit memory read/write instructions create agents that improve over time. Categorization keeps memories organized, and the deduplication rule prevents context bloat.