Compare AI chatbot responses side by side in Google Sheets

Sends your prompt to two AI models at once, logs both answers in Google Sheets, and shows them side by side so you can pick the best one.

How the work actually flows

It branches. Every path runs; all paths must finish before it continues.

Pattern: Parallel Split (2) ยท Synchronisation (3)

flowchart TD trig(("user asks a question")):::human s0["send question to both models"]:::task s1[("log both answers in sheet")]:::store s2["display answers side by side"]:::task trig --> s0 s1 --> s2 gx{"+ query each ai model"}:::gate s0 --> gx p00["generate answer"]:::task gx -->|"model a"| p00 p10["generate answer"]:::task gx -->|"model b"| p10 jn{"+ both answers ready"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"both ai answers logged and compared"/]:::out pay{{"quick side by side model comparison"}}:::pay s2 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
A stepA personA record or sheetEvery pathWaits for allResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsAI Chatbots & AssistantsSpreadsheet & Database Ops
Connects
Google SheetsOpenRouterOpenAI

The problem it solves

When you're testing which AI model to use for a project, you end up copying the same question into different chat windows and trying to remember which answer was better. There's no easy record of what each model said, so comparing them fairly is hard, especially if you want a colleague to weigh in.

Who it fits

A business building an AI-powered tool or agent who needs to pick the best-performing language model before going live.

How it works

  1. You type a question into the chat
  2. The question is sent to two different AI models at the same time
  3. Each model answers using its own memory of the conversation
  4. Both answers are logged in Google Sheets next to your question
  5. You see both replies side by side in the chat to compare instantly
What you get

Confidence in which AI model wins

You get two AI models answering your question side by side in Google Sheets, making it easy to see which response fits your project best.

What you get

A Google Sheet log of every question and both AI models' answers, plus a side-by-side view in the chat.

What you need

A Google account and API access to at least two AI language model providers, such as OpenRouter or OpenAI.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Turn fitness tracking into a pirate-themed game with AI

Scores your workouts and meals with AI and rewards you with a growing pirate-style bounty to keep you motivated.

Standard

Write SEO blog posts and newsletters automatically with AI agents

A team of AI agents researches, outlines, writes, and edits complete blog posts or newsletters ready to publish.

Advanced

Find and message solo lawyers for outreach automatically

Finds solo lawyers on LinkedIn through search, researches each one, and drafts a personalized message for outreach.

Advanced

Grade math quiz answers automatically and update quest status in Sheets

Checks a student's quiz answer automatically and updates their progress sheet with a fun reward message.

Standard
Back to the AI Playbook