Why an AI Can Build You a Spreadsheet — and Then Never Touch It Again

Ask an AI if it "connects to your spreadsheet," and you'll almost always hear yes. That one word is hiding at least three different capabilities, and which one you actually get depends on which AI — and which door it's using to get in. We tested this ourselves, live, across four platforms.

Tier 1: just read. Claude's built-in Google Drive connector and Perplexity's Drive connector do the same thing: open your spreadsheet, read every cell, hand it back as a clean export. Genuinely useful for a summary or a quick question. Neither can change a single cell — not "limited," the write button doesn't exist in that connection.

Tier 2: create, once. The surprise. That same kind of connection can also generate a brand-new spreadsheet from scratch — we did it, seeded a fresh sheet with real data, and it came back as a fully working spreadsheet. But the moment it exists, that connection can't touch it again. Not the new one, not any other one. One shot, then frozen.

Tier 3: read/write, for real. Two platforms cleared this bar, for different reasons. Through Composio — an integration layer that plugs an AI into an app's actual API, not just its files — we wrote a formula straight into a cell, =SUM(B2:B4), and read back the correct answer: 24.5. Separately, Gemini — Google's own AI, built directly into Sheets rather than reaching in from outside — writes and fixes formulas in place, and as of an April 2026 update, can build and edit entire spreadsheets from a plain-language description, showing you the plan before it executes.

The detail worth remembering: Gemini isn't playing by the "outside AI" rules. Every other tool here reaches your spreadsheet through Google Drive's file system — read, or create-once. Gemini skips that door because it lives inside the product. That's why it can do things a connected outside AI structurally cannot, regardless of how good the underlying model is.

Even within one company, "connected" can mean two things. ChatGPT's own chat connector behaves like the read-only tier by default — but a separate native add-on, installed inside Sheets itself rather than through ChatGPT's settings, does real reads and writes (launched beta April 22, 2026; went generally available May 5, 2026). Same company, two different doors.

Before you trust an AI with real spreadsheet work, ask one question: "If I tell you to change a number, will you show me the cell you changed and the new number — not describe what you'd do?" If the honest answer is no, you're in the read-only or create-once tier — fine for plenty of tasks. If yes, you're in the tier that can actually do the work.

This is the same idea underneath MCP — not every connection built on it goes the same depth, and now you know how to check which one you're holding.