Google Ecosystem Tools โ What an individual can do today without building custom software
Pick the primary goal. You can combine paths later.
Prompts produce better, more accurate outputs
Produce more content faster across many inputs
Same structure and quality every time
Hands-off, scheduled, or event-driven operation
Use your good outputs as few-shot examples. Feed bad outputs back as "don't do this" constraints.
You are an organisational design analyst. Given a department context,
produce a structured brainstorm with:
- 3 strategic initiatives (title + 2-line rationale)
- Risk assessment (high/medium/low per initiative)
- Recommended next steps
## Examples of GOOD output:
[paste your best output here]
## DO NOT:
- Use generic consulting jargon
- Suggest initiatives without specific metrics
4. In the User input, type a test prompt like "Engineering team, 45 people, APAC region"Use a "Prompt Engineer" Gem to help you design the prompt from scratch using best practices.
You are an expert prompt engineer. Help me design system instructions for AI agents.
For each agent I describe, produce:
1. A structured system instruction (role, context, task, format, constraints)
2. 2-3 few-shot examples
3. Evaluation criteria to judge output quality
Ask clarifying questions before drafting. Iterate based on my feedback.
4. Click Save โ now chat with it to collaboratively design promptsUpload your framework docs, example outputs, and reference material. Let the AI learn from YOUR sources.
Use AI Studio's built-in Google Search grounding for factual accuracy. No custom sources needed.
Create TWO prompts: one generates, one evaluates. Feed evaluation back as refinement hints.
Generate outputs, manually rate them ๐/๐, then use patterns from good outputs to improve the prompt.
Put all inputs in rows. Run the same prompt template across all of them in one click.
Pre-build prompt templates with {{PLACEHOLDER}} variables. Fill and fire from AI Studio or Gemini App.
Chain phases in Sheets tabs or Apps Script. Each phase's output auto-feeds the next phase's prompt. Or use Antigravity to orchestrate subagents per phase.
runCascade() executes phases in sequence/goal "Run a 6-phase agent brainstorm for [department]. Phase 1: analyse org structure. Phase 2: generate insights..."/schedule "Every Monday 9am, regenerate phase 6 deliverables for Q3 initiatives"Fire all generations simultaneously. No dependencies between outputs.
Gemini supports 1M+ token context. Upload entire documents and process in one call.
No special handling needed. Use standard Gemini Flash for speed + cost efficiency.
Force the model to respond in your exact schema. Guarantees format compliance every time.
response_mime_type: "application/json"Use the "completion strategy" โ start the output format in the prompt and let the model continue the pattern.
Centralise prompts in a shared Doc. Create team Gems. Use Sheets as the "execution layer."
Save your prompts in AI Studio. Create personal Gems for quick conversational access.
Use Google Docs' built-in version history for prompts. Track prompt performance metrics in Sheets.
Just keep one canonical prompt. AI Studio auto-saves your recent prompts.
Build a simple sequential pipeline: trigger โ gather context โ generate โ format โ deliver.
runPipeline()/goal "Build me a single-file HTML app that:
- Has a form: department name, team size, region
- Calls the Gemini API with my system instruction
- Renders markdown output in a styled panel
- Stores API key in localStorage (user provides once)"
Result: a portable HTML file anyone can open locally โ no server needed.Use Agent Studio's visual canvas for decision logic, or Antigravity for code-first autonomous agents with subagents and tool use.
.antigravity/skills/brainstorm-cascade.md defining your multi-phase workflow as a reusable skill.antigravity/rules/output-format.md to enforce section headers, scoring tables, etc.agy "Analyse the Engineering function and produce a brainstorm cascade"from antigravity import Agent, Tool
agent = Agent(model="gemini-2.5-pro", tools=[read_csv, call_api])
result = agent.run("Analyse org chart and produce phase 4 scoring")Use Gemini's function calling to let the model decide when to call your APIs. Or use ADK/Antigravity SDK for complex orchestration with parallel subagents.
UrlFetchApp for simple integrationsfrom antigravity import Agent, Tool
@Tool
def query_jira(project_key: str, status: str) -> str:
"""Search Jira issues by project and status."""
resp = requests.get(f"{JIRA_URL}/rest/api/3/search", ...)
return resp.json()
agent = Agent(tools=[query_jira, read_confluence, push_slack])
Or use MCP servers in Antigravity settings โ pre-built connectors for Jira, GitHub, Slack, databases.No external tools needed. Keep it simple with Sheets + Apps Script or the Agent Studio canvas.
Apps Script has built-in cron-like triggers. Set it and forget it.
Trigger generation when something happens: form submission, spreadsheet edit, or email arrives.
onFormSubmit(e) trigger โ read new row โ generate โ write outputonEdit trigger for when a specific cell changes
This requires a proper agent framework with session management and persistent memory. Antigravity 2.0 natively supports parallel agents, projects, and scheduled tasks.
/goal "You are a weekly sprint planning agent. Each Monday, read JIRA board state, analyse velocity, and produce a sprint plan doc."/schedule "Every Monday 9am" โ now it runs autonomously on schedulefrom antigravity import Agent, Tool, Memory
memory = Memory(persist="./agent_state.json")
agent = Agent(
model="gemini-2.5-pro",
memory=memory,
tools=[read_jira, update_confluence, send_slack],
instructions="You are a sprint planner. Remember past velocity."
)
agent.run("Plan next sprint based on current board state")Stateless workflows fit perfectly in Apps Script, Sheets, or Agent Studio without memory management.
| Tool | Best For | Effort | Cost | When to Use |
|---|---|---|---|---|
| Google AI Studio | Prompt testing, few-shot design, structured output | Low | Free | ALWAYS start here |
| Gemini Gems | Persistent agent personas, conversational testing | Low | $20/mo | When you want a reusable "expert" to talk to |
| NotebookLM | Source-grounded research, synthesis, audio summaries | Low | Free | When you have source docs to ground outputs in |
| Google Sheets | Batch processing, tracking, structured data store | Low | Free | When processing 5+ entities through same prompt |
| Apps Script | Automation, triggers, API calls, pipelines | Med | Free | When you want things to run without clicking |
| Google Docs | Prompt library, version history, shared documentation | Low | Free | When you need to share/version prompts with team |
| Google Forms | Input collection from non-technical users | Low | Free | When others need to submit requests for generation |
| Gemini API | Programmatic access, function calling, batch, streaming | Med | Free tier / pay | When calling from code (Scripts, Colab, apps) |
| Google Colab | Prototyping, data processing, complex logic, ADK dev | Med | Free / Pro | When Sheets/Script can't handle the complexity |
| Agent Studio | Visual agent design, multi-turn, branching logic | Med | GCP credits | When agent needs decisions / conversation / tools |
| Agent Dev Kit | Complex multi-agent, persistent memory, production deploy | High | GCP costs | LAST resort โ only when nothing else works |
| Google Antigravity | Parallel coding agents, scheduled tasks, SDK for custom agents, IDE with full codebase understanding | Med | Free | When you need autonomous agents running in parallel across codebases or recurring tasks |
| Cloud Workflows | Serverless orchestration, multi-service pipelines | High | Pay-per-exec | Production pipelines with SLA requirements |
Start in AI Studio. Scale in Sheets. Automate in Apps Script. Orchestrate in Antigravity.
Only build custom tools after doing it manually 10+ times.