โ† Workflow Builder |

๐ŸŒณ Decision Tree

| ๐Ÿงฐ Agent Toolkit | ๐Ÿงญ Initiative Picker

Agent Generation Decision Tree

Google Ecosystem Tools โ€” What an individual can do today without building custom software

๐Ÿงฐ Available Tools (No Custom Development Required)

1
Google AI Studio โ€” Prompt playground, test & export
2
Gemini App + Gems โ€” Custom persistent agents
3
NotebookLM โ€” Source-grounded research AI
4
Google Sheets โ€” Structured data + batch ops
5
Google Apps Script โ€” Automation + API calls
6
Google Docs + Gemini โ€” Inline AI writing assist
7
Vertex AI Agent Studio โ€” Visual agent builder (low-code)
8
Google Colab โ€” Python notebooks + GPU
9
Gemini API โ€” Programmatic model access
10
Agent Dev Kit (ADK) โ€” Python agent framework
11
Google Cloud Workflows โ€” Serverless orchestration
12
Google Forms โ€” Input collection + triggers
13
Google Antigravity โ€” Agent-first IDE & SDK: parallel subagents, scheduled tasks, coding agents

๐ŸŽฏ START: What do you want to improve?

Pick the primary goal. You can combine paths later.

๐ŸŽจ Content Quality

Prompts produce better, more accurate outputs

โšก Speed

Produce more content faster across many inputs

๐Ÿ“ Consistency

Same structure and quality every time

๐Ÿค– Automation

Hands-off, scheduled, or event-driven operation

๐ŸŽจ

Path 1: Content Quality

Q1: Do you have examples of good AND bad outputs from your current prompts?
โœ“ YES โ€” I have examples

โ†’ Few-Shot Refinement Loop

Use your good outputs as few-shot examples. Feed bad outputs back as "don't do this" constraints.

Google AI Studio Gemini App
Complexity:
Low
~1-2 hours
Steps:
1. Open AI Studio โ†’ System Instruction mode
2. Paste current prompt + 2-3 good output examples
3. Test with new input โ†’ compare to desired quality
4. Add constraints based on bad output patterns
5. Export final prompt via "Get Code"
๐Ÿ“‹ AI Studio example setup:
1. Go to aistudio.google.com โ†’ click + Create New
2. Select Freeform prompt or Structured prompt
3. In System Instruction box, paste:
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"
5. Click Run โ†’ iterate on the System Instruction until output quality is right
6. Click Get Code (top right) โ†’ copies as Python/curl/Node.js API call
โœ— NO โ€” Starting fresh

โ†’ Structured Prompt Engineering

Use a "Prompt Engineer" Gem to help you design the prompt from scratch using best practices.

Gemini Gems Google AI Studio Google Docs
Complexity:
Low-Med
~2-4 hours
Steps:
1. Create a "Prompt Engineer" Gem with meta-prompt expertise
2. Describe your agent's purpose conversationally
3. Take Gem's draft โ†’ test in AI Studio
4. Iterate 3-5 rounds between Gem feedback and Studio testing
5. Document final prompt in Google Docs library
๐Ÿ’Ž How to create a Gem:
1. Go to gemini.google.com โ†’ Gem Manager โ†’ + New Gem
2. Name it: "Prompt Engineer" (or your domain, e.g. "HR Strategy Expert")
3. Paste this system instruction:
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 prompts
5. The Gem remembers your conversation context across messages
Create one Gem per domain: "Org Design Expert", "Technical Architect", "Change Manager", etc.
Q2: Does the content require domain-specific knowledge or company data?
โœ“ YES โ€” Domain-specific / needs grounding

โ†’ Source-Grounded Generation

Upload your framework docs, example outputs, and reference material. Let the AI learn from YOUR sources.

NotebookLM Google Docs Gemini API (Search grounding)
Complexity:
Low
~30 min setup
Steps:
1. Create NotebookLM notebook for your domain
2. Upload: framework docs, gold-standard outputs, terminology guides
3. Ask: "Write a system instruction for an agent that produces X"
4. Generate Audio Overview โ†’ listen for missed connections
5. Generate Mind Map โ†’ visualise concept relationships
6. Feed back into AI Studio for testing
โœ— NO โ€” General purpose

โ†’ Stay with Methods Above + Search Grounding

Use AI Studio's built-in Google Search grounding for factual accuracy. No custom sources needed.

Google AI Studio Gemini API (Google Search tool)
Complexity:
Low
~10 min toggle
Q3: Do you need the AI to critique and improve its own outputs?
โœ“ YES โ€” Self-improving loop

โ†’ Evaluator + Generator Pattern

Create TWO prompts: one generates, one evaluates. Feed evaluation back as refinement hints.

Google AI Studio Google Sheets Apps Script
Complexity:
Medium
~4-6 hours
Steps:
1. Create Generator prompt in AI Studio
2. Create Evaluator prompt (scores output 1-10 + lists issues)
3. In Sheets: Col A = input, Col B = generated, Col C = evaluation
4. Apps Script chains: generate โ†’ evaluate โ†’ regenerate if score < 7
5. Log improvement patterns โ†’ feed back into Generator prompt
โœ— NO โ€” Manual review is fine

โ†’ Manual Rating in Sheets

Generate outputs, manually rate them ๐Ÿ‘/๐Ÿ‘Ž, then use patterns from good outputs to improve the prompt.

Google Sheets Google AI Studio
Complexity:
Low
~1 hour
โšก

Path 2: Speed (Produce More, Faster)

Q1: Is the task repetitive across many entities? (departments, people, products, etc.)
โœ“ YES โ€” Same prompt, different inputs (5+ entities)

โ†’ Batch Processing via Sheets

Put all inputs in rows. Run the same prompt template across all of them in one click.

Google Sheets Apps Script Gemini API
Complexity:
Low-Med
~2 hours setup
Steps:
1. Sheet columns: Entity | Context | Prompt_Template | Output | Rating
2. Apps Script: loop rows, call Gemini API, write outputs
3. Add "Run All" button to Sheet's custom menu
4. Rate outputs โ†’ filter failures โ†’ adjust template โ†’ re-run failures only
5. Once template hits >80% acceptance โ†’ lock it as "stable"
โœ— NO โ€” Unique inputs each time

โ†’ Prompt Templates + Quick Fill

Pre-build prompt templates with {{PLACEHOLDER}} variables. Fill and fire from AI Studio or Gemini App.

Google AI Studio Gemini Gems Google Docs
Complexity:
Low
~30 min
Q2: Does the workflow have multiple sequential phases? (output of step 1 โ†’ input of step 2)
โœ“ YES โ€” Multi-phase chain (like our 6-phase framework)

โ†’ Cascade Automation

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.

Google Sheets (multi-tab) Apps Script Gemini API Google Colab Google Antigravity
Complexity:
Medium
~4-6 hours
Steps (Sheets path):
1. Create one Sheet tab per phase: Phase1, Phase2, ... Phase6
2. Each tab: Col A = input from prior tab's output, Col B = this phase's output
3. Apps Script function: runCascade() executes phases in sequence
4. Human review checkpoint between phases (highlight for approval)
5. Optional: run in Colab for more complex parsing between phases
๐Ÿš€ Antigravity path:
1. Download Antigravity 2.0 โ†’ Create Project โ†’ Add your workspace
2. Prompt: /goal "Run a 6-phase agent brainstorm for [department]. Phase 1: analyse org structure. Phase 2: generate insights..."
3. The agent reads your files, generates each phase, and iterates autonomously
4. Use Scheduled Tasks: /schedule "Every Monday 9am, regenerate phase 6 deliverables for Q3 initiatives"
5. Spawn parallel subagents โ€” one per department โ€” to batch multiple cascades simultaneously
Best when: you want the agent to iterate on its own output and self-correct errors.
โœ— NO โ€” Single-step generation

โ†’ Parallel Batch (fastest)

Fire all generations simultaneously. No dependencies between outputs.

Google Sheets Apps Script (parallel fetch) Gemini API Batch endpoint
Complexity:
Low-Med
~1-2 hours
Q3: Do you need to process large documents (>50 pages) as input context?
โœ“ YES โ€” Long documents

โ†’ Long Context + Document Processing

Gemini supports 1M+ token context. Upload entire documents and process in one call.

Gemini API (Long Context) NotebookLM Google AI Studio
Complexity:
Low-Med
~1 hour
Steps:
1. Upload document to NotebookLM for initial analysis
2. Use NotebookLM's summaries to identify key sections
3. In AI Studio: upload full doc + system instruction
4. Use Context Caching (API) for repeated queries against same doc
5. Process results back through your prompt pipeline
โœ— NO โ€” Short inputs

โ†’ Standard API calls are fine

No special handling needed. Use standard Gemini Flash for speed + cost efficiency.

Gemini API (Flash) Google AI Studio
Complexity:
Low
๐Ÿ“

Path 3: Consistency (Same Quality Every Time)

Q1: Can you define the exact output structure/schema you want?
โœ“ YES โ€” I know the exact format

โ†’ Structured Output Mode (JSON Schema)

Force the model to respond in your exact schema. Guarantees format compliance every time.

Google AI Studio (Structured Output) Gemini API (response_schema) Google Sheets (parse JSON)
Complexity:
Low-Med
~1-2 hours
Steps:
1. Define JSON schema with all required fields, types, and enums
2. In AI Studio: enable Structured Output โ†’ paste schema
3. Test with 5+ varied inputs โ†’ confirm 100% schema compliance
4. In Gemini API: set response_mime_type: "application/json"
5. In Sheets: parse JSON output into structured columns automatically
โœ— NO โ€” Output is freeform / creative

โ†’ Template Anchoring + Few-Shot

Use the "completion strategy" โ€” start the output format in the prompt and let the model continue the pattern.

Google AI Studio Gemini Gems
Complexity:
Low
~1 hour
Steps:
1. In your prompt, include the beginning of the desired output format
2. Add 2-3 complete examples showing the exact style/structure
3. Add explicit constraints: word count, section names, tone rules
4. Test with diverse inputs to ensure the pattern holds
5. Use temperature=0 for maximum determinism
Q2: Do multiple people need to use the same agent/prompts?
โœ“ YES โ€” Team-wide usage

โ†’ Shared Prompt Library + Gems

Centralise prompts in a shared Doc. Create team Gems. Use Sheets as the "execution layer."

Google Docs (shared) Gemini Gems Google Sheets (shared) Google Forms (input)
Complexity:
Low-Med
~3-4 hours
Steps:
1. Google Docs: Create "Agent Prompt Library" with versioned prompts
2. Gems: Create shared Gems for each agent persona
3. Google Forms: Build input form for non-technical users
4. Sheets: Form responses โ†’ trigger generation โ†’ results back to Sheet
5. Add a "feedback" column for users to rate/comment on outputs
โœ— NO โ€” Solo use

โ†’ Personal Gems + AI Studio Saved Prompts

Save your prompts in AI Studio. Create personal Gems for quick conversational access.

Google AI Studio (Saved Prompts) Gemini Gems
Complexity:
Low
~30 min
Q3: Do you need version control on prompt changes?
โœ“ YES โ€” Track what changed and why

โ†’ Sheets Version Tracker + Docs History

Use Google Docs' built-in version history for prompts. Track prompt performance metrics in Sheets.

Google Docs (Version History) Google Sheets (metrics) Apps Script (change log)
Complexity:
Low-Med
~1-2 hours
Steps:
1. Docs: One Doc per agent. Use "Named Versions" for each stable release
2. Sheet: "Prompt Changelog" with Date | Version | Change | Reason | Before/After Score
3. Apps Script: auto-log when the prompt Doc is edited
4. A/B test: run same inputs through V(n) and V(n+1), compare scores
5. Only "promote" new version if it beats the old on your eval set
โœ— NO โ€” Latest version is fine

โ†’ Simple prompt file in Docs/AI Studio

Just keep one canonical prompt. AI Studio auto-saves your recent prompts.

Google AI Studio
Complexity:
Low
๐Ÿค–

Path 4: Automation (Hands-Off Operation)

Q1: Is the workflow linear? (input โ†’ fixed steps โ†’ output, no branching decisions)
โœ“ YES โ€” Linear pipeline

โ†’ Apps Script Pipeline

Build a simple sequential pipeline: trigger โ†’ gather context โ†’ generate โ†’ format โ†’ deliver.

Google Apps Script Google Sheets Gemini API Google Docs (output) Gmail (notifications)
Complexity:
Medium
~4-6 hours
Steps:
1. Design flow: Trigger (form/timer/edit) โ†’ Read inputs โ†’ Call API โ†’ Write output
2. Apps Script: implement as functions chained by runPipeline()
3. Add "Config" sheet tab: model name, temperature, API key name, prompts
4. Add error handling: retry on 429, log failures to "Errors" tab
5. Deploy as custom menu button OR time-driven trigger
6. Output to: Sheet cells, new Google Doc, or email summary
๐ŸŒ Or build as a standalone HTML app:
Use Antigravity / any coding agent to generate a self-contained HTML tool:
/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.
Deploy on Cloud Run, GitHub Pages, or simply share the .html file.
This is how the Agent Brainstormer itself was built!
โœ— NO โ€” Needs branching / decisions / multi-turn

โ†’ Vertex AI Agent Studio or Antigravity

Use Agent Studio's visual canvas for decision logic, or Antigravity for code-first autonomous agents with subagents and tool use.

Vertex AI Agent Studio Google Antigravity Gemini API Agent Garden (templates)
Complexity:
Medium
~1-2 days
Steps (Agent Studio):
1. Open Agent Studio in GCP Console
2. Define system instruction + tool declarations
3. Draw the reasoning loop on the visual canvas
4. Add branching: if score > threshold โ†’ path A, else โ†’ path B
5. Test multi-turn in the built-in playground
6. Deploy to Agent Runtime when stable
๐Ÿš€ Antigravity path (code-first agents):
1. Antigravity 2.0: type your goal and the agent autonomously decides which tools to use, branches on output quality, retries failures
2. With Skills: create .antigravity/skills/brainstorm-cascade.md defining your multi-phase workflow as a reusable skill
3. With Rules: create .antigravity/rules/output-format.md to enforce section headers, scoring tables, etc.
4. Antigravity CLI: agy "Analyse the Engineering function and produce a brainstorm cascade"
5. SDK for programmatic control:
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")
Best when: workflow needs file access, command execution, or self-correction loops.
Q2: Does the agent need to call external APIs or access databases?
โœ“ YES โ€” External integrations needed

โ†’ Function Calling + Agent Framework

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.

Gemini API (Function Calling) Agent Dev Kit (ADK) Google Antigravity SDK Google Colab Cloud Workflows
Complexity:
Med-High
~2-5 days
Steps:
1. Define tool schemas (function declarations) for each external API
2. Test in AI Studio with Function Calling enabled
3. Option A: Apps Script + UrlFetchApp for simple integrations
4. Option B: ADK in Colab for multi-tool agents
5. Option C: Cloud Workflows for serverless orchestration
6. Deploy via Agent Runtime or Cloud Run
๐Ÿš€ Antigravity SDK โ€” connect external APIs:
from 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.
Best when: you want the agent to decide WHEN to call each API based on the task.
โœ— NO โ€” Self-contained (text in, text out)

โ†’ Apps Script or Agent Studio (simpler path)

No external tools needed. Keep it simple with Sheets + Apps Script or the Agent Studio canvas.

Apps Script Vertex AI Agent Studio
Complexity:
Low-Med
~2-4 hours
Q3: Should it run on a schedule or trigger from events?
โœ“ Schedule-based (daily/weekly/monthly)

โ†’ Time-Driven Triggers

Apps Script has built-in cron-like triggers. Set it and forget it.

Apps Script (Triggers) Google Sheets Gmail (summary email)
Complexity:
Low-Med
~1 hour
Steps:
1. Apps Script โ†’ Edit โ†’ Triggers โ†’ Add Trigger
2. Set: Time-driven โ†’ Week timer โ†’ Monday 9am
3. Trigger function checks for new/changed rows โ†’ generates โ†’ emails summary
4. Add "Last Run" and "Changed Since" columns for smart re-processing
5. Monthly: review all outputs, update quality metrics
โœ— Event-driven (form submit, Sheet edit, email received)

โ†’ Event Triggers + Forms

Trigger generation when something happens: form submission, spreadsheet edit, or email arrives.

Apps Script (onEdit / onFormSubmit) Google Forms Google Sheets Gmail (trigger on receive)
Complexity:
Low-Med
~2-3 hours
Steps:
1. Create Google Form for input collection (non-technical users)
2. Link Form to Sheet (auto-populates responses)
3. Apps Script: onFormSubmit(e) trigger โ†’ read new row โ†’ generate โ†’ write output
4. Notify submitter via email with results
5. Alternative: onEdit trigger for when a specific cell changes
Q4: Do you need the agent to have persistent memory across sessions?
โœ“ YES โ€” Remember past interactions

โ†’ Full Agent Build (ADK / Antigravity)

This requires a proper agent framework with session management and persistent memory. Antigravity 2.0 natively supports parallel agents, projects, and scheduled tasks.

Agent Dev Kit (ADK) Google Antigravity 2.0 Vertex AI Agent Runtime Agent Platform Memory Bank Google Colab (prototyping)
Complexity:
High
~1-2 weeks
Steps:
1. Prototype in Colab with ADK quickstart
2. Or use Antigravity 2.0: create a Project, spawn agents with /goal
3. Antigravity SDK: Python scripts for custom agent logic + tools
4. Use Scheduled Tasks (cron) for recurring autonomous runs
5. Deploy to Agent Runtime for production, or keep in Antigravity for dev workflows
โš ๏ธ Only do this after exhausting simpler approaches above.
๐Ÿš€ Building a persistent agent in Antigravity:

Option 1 โ€” Interactive (no code):
1. Antigravity 2.0 โ†’ New Project โ†’ Add your folders
2. /goal "You are a weekly sprint planning agent. Each Monday, read JIRA board state, analyse velocity, and produce a sprint plan doc."
3. /schedule "Every Monday 9am" โ€” now it runs autonomously on schedule
4. Review results in the Inbox when you start your day

Option 2 โ€” SDK (programmable):
from 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")
Option 3 โ€” Gem (simplest, no memory):
1. Go to gemini.google.com โ†’ Create a Gem
2. Name: "Sprint Planner". Paste your system instruction
3. Chat with it manually each week โ€” paste board state, get plan back
Choose based on how autonomous you need it: Gem (manual) โ†’ Antigravity (autonomous) โ†’ SDK (fully custom).
โœ— NO โ€” Stateless is fine (each run independent)

โ†’ Use simpler methods above

Stateless workflows fit perfectly in Apps Script, Sheets, or Agent Studio without memory management.

Apps Script Agent Studio Sheets (history in rows)
Complexity:
Low-Med

๐Ÿ“‹ Quick Reference: Tool โ†’ Use Case Matrix

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

๐Ÿšฆ The Golden Rule

Start in AI Studio. Scale in Sheets. Automate in Apps Script. Orchestrate in Antigravity.
Only build custom tools after doing it manually 10+ times.

๐Ÿงช
Week 1
Experiment
AI Studio + Gems
โ†’
๐Ÿ“Š
Week 2
Scale
Sheets + Batch
โ†’
โš™๏ธ
Week 3
Automate
Apps Script + Triggers
โ†’
๐Ÿ—๏ธ
Week 4+
Build
Only if needed