The AI Function in Sheets Is Not Free
Google's =AI() function, and the "Fill with Gemini" entry point that sits on top of it, are genuinely useful. You write an instruction in a cell — categorise this feedback, extract the city from this address, summarise this comment — and Gemini applies it down the column at scale. It is the closest thing to native AI in a spreadsheet.
It is also gated. The Gemini side panel and the =AI() function require a paid plan: Google Workspace Business Standard or above, or a Google One AI Premium subscription on a personal account. Business Starter includes AI assistance in Gmail but not the full spread across core apps. Google has continued to adjust the tiers through 2026 — from 15 July 2026, accounts with AI Expanded Access licences get higher usage ceilings on both Fill with Gemini and the =AI() function.
So if you are on a free Gmail account, or on Business Starter, the function you have been reading about is not available to you. That is the single most common source of confusion on this topic, and most "free AI for Sheets" listicles never say it.
Gemini API Free Tier — The Real Free Route Best Free Option
Here is what does work at no cost. Google AI Studio issues a free API key to any Google account, and that key can be called from Google Apps Script inside your spreadsheet — letting you build your own AI function without a Workspace subscription.
The free tier is not a token trial. On Gemini 2.5 Flash and Flash-Lite you get roughly 1,500 requests per day, with a generous per-minute token allowance. For a spreadsheet task — categorising a few hundred rows of survey responses, cleaning a column of messy company names — that is more than enough, and it is the only free path that handles large columns of data.
One change to be aware of: as of April 2026, the Pro-series models moved to paid-only. The free tier is now Flash and Flash-Lite. For classification, extraction and summarisation over spreadsheet cells, Flash is the right tool anyway — it is fast and cheap by design, and the tasks are not reasoning-heavy.
Free tier: ~1,500 requests/day on Flash and Flash-Lite. Free API key, any Google account, no card required.
Best for: Bulk operations down a column, and anyone unwilling to pay a subscription for occasional AI use.
Limitation: You write a small Apps Script wrapper yourself. It is perhaps twenty lines, but it is not zero setup — and rate limits apply per project, so check the live limits in AI Studio for your own project rather than trusting any article, this one included.
The Privacy Catch Nobody Mentions Read Before Uploading
This is the part that matters more than any feature comparison. Google's terms allow free-tier API prompts to be used for model training. The paid tier and Vertex AI do not carry that permission.
Think about what a spreadsheet usually contains. Customer names. Email addresses. Salary data. Unreleased financials. Support tickets with personal details. Sending that through a free API tier that may be used for training is a different decision from sending an anonymous block of marketing copy, and if you handle EU personal data it is a decision with legal weight attached.
The practical rule: use the free tier for data you would be comfortable posting publicly — anonymised rows, product categories, generic text. The moment real personal or commercial data is involved, either move to the paid tier, strip the identifying columns first, or use a tool that processes locally in your browser. Anonymising a column before analysis is a two-minute job with a deduplication and text transformation pass, and it removes the problem entirely.
ChatGPT and Claude — Upload the File Instead Free Tier Available
For one-off analysis, the simplest free option is not a spreadsheet integration at all. Export your sheet to CSV, upload it to ChatGPT or Claude, and ask questions in plain language. Both run real analysis on the file rather than guessing from a description, and both will produce charts and explain the steps they took.
This beats an in-sheet function for exploratory work — "which region is underperforming and why", "find the outliers in this column" — because you are having a conversation, not writing a formula. It is worse for anything repetitive: there is no way to apply the result back down a column automatically.
Free tiers on both are usable but metered, with tighter limits on file uploads and analysis runs than the paid plans. Both sit at $20/month if you outgrow them.
Best for: Exploratory questions about a dataset you already have, especially when you want the reasoning explained.
Limitation: Manual export/import each time, and no way to push results back into the sheet at scale. Before uploading, clean the file first — analysis quality drops sharply on messy input.
Julius AI and Rows — Evaluation, Not Workflow
Two tools come up constantly in this category, and both are worth knowing about — with realistic expectations of what "free" buys you.
Julius AI is a dedicated AI data analyst: connect a spreadsheet, ask questions, get statistical analysis and charts with the Python it ran shown underneath. It is good at what it does. The free plan allows 15 messages per month, and they do not roll over. A single real analysis session typically runs 15 to 30 messages, so the free tier is an evaluation of the product, not a way to work. Paid starts around $20/month, with 50% off for students and educators.
Rows is a spreadsheet built with AI functions native to it, plus integrations that pull live data from other services. Its free plan is permanently free and needs no card, but includes just 5 AI Tasks per month and a 1MB file import limit. Plus is $8/user/month ($6 billed annually) for 200 tasks; Pro is $79/month plus $8/user for 1,000.
Neither is a bad product. But if you arrived looking for free AI spreadsheet analysis you can use weekly, 15 messages or 5 tasks a month will not get you there. The Gemini API route will.
Comparison Table
| Tool | Free Tier | Works In Sheets | Best For |
|---|---|---|---|
| =AI() in Sheets | None — paid plan required | Native | Paid Workspace users |
| Gemini API (AI Studio) | ~1,500 req/day (Flash) | Via Apps Script | Bulk column work |
| ChatGPT / Claude | Metered free tier | No — CSV upload | Exploratory questions |
| Julius AI | 15 messages/month | Connects to file | Statistical analysis |
| Rows | 5 AI Tasks/month | Own spreadsheet | Live data integrations |
Which Should You Actually Use?
- Repetitive work down a column, no budget: Gemini API free tier via Apps Script. It is the only free option that scales.
- One-off "what does this data tell me": export to CSV and ask ChatGPT or Claude. Fastest path to an answer.
- Sensitive or personal data: not the free API tier. Paid tier, or anonymise the columns first.
- Statistical rigour with visible working: Julius, accepting you will pay after 15 messages.
- Already on paid Workspace: just use
=AI(). You are paying for it either way.
One habit worth adopting whichever you choose: clean the data before the AI touches it. Inconsistent casing, duplicate rows and stray whitespace all degrade output quality, and they cost you requests against your quota while producing worse answers. A pass through a duplicate remover and a whitespace cleaner takes seconds and measurably improves what comes back.