Chat with your Google Sheets data
Updated 2026-10-07
Connect a Google Sheet and ask it what you want to know: Intellrise writes the SQL, draws the chart, pins it to a dashboard and hands you the result as PDF, Excel or PowerPoint, in one place.
Google Sheets are on the free plan and never count against its one database, so this costs nothing to try. Pro, $29 a month, adds uploads and scheduled email reports; a team of five pays $100. You also add a free AI key, which takes about a minute (how).
- 1
Get your Google Sheets connection details
No database credentials are needed. You authorise access to your Google account, then pick the spreadsheet and tab you want to analyse.
- 2
Create your account and add your AI key
Sign up, then add an AI key. A free Google Gemini key takes about a minute to create (how).
- 3
Add the Google Sheets connection
Add a data source, choose Google Sheets, authorise your Google account, and select the spreadsheet and tab. The first row is treated as column headers.
- 4
Let the AI read and annotate your schema
The analyst treats each tab as a table and infers column types. You can rename columns or describe what they mean, so questions map cleanly.
- 5
Type your first question
Ask something like "Total by category from this sheet". On a question the analyst judges complex — a join, a query spanning two sources, several steps — it shows a readable plan and waits for you to approve it before running anything; on one it judges simple it runs first and shows you afterwards. Either way you get the same two controls on every answer: Show SQL gives you the exact query that produced the number, and Show table gives you the rows it returned with their count. That is how you check a figure instead of trusting it. Refine by chatting, then pin it to a dashboard or save it as a report.
Why connect Google Sheets instead of exporting
A static export goes stale the moment you download it, and when an assistant only ever sees that exported file it has to guess what your columns mean. A connected AI data analyst reads live Google Sheets data, shows you a readable plan before running anything on the complex questions (simple ones it runs first and shows you after), and saves what your fields mean against the source itself — so the next question already knows them, and answers stay current and consistent.
Google Sheets: things to know
- Keep a clean header row and consistent column types — merged cells and mixed types make inference harder.
- Google Sheets is uncounted on the Free plan, so it's a good first source to try.
Example questions to ask your Google Sheets data
- Total by category from this sheet
- Month-over-month change in the revenue column
- Rows where status is overdue, grouped by owner
Frequently asked questions
No. The analyst reads values to answer questions and never writes back.
Yes. Cross-source questions can join a Google Sheet with your database, CSV or Excel data.
Related
The one-stop AI data analyst that knows your schema.
One place from question to finished work: the SQL, the chart, a dashboard your whole team can open, and a report that emails itself every morning. It learns what your columns mean, so nobody explains a field twice. Start free with one database plus Google Sheets, or take 14 days of Pro with no card.
Every new account starts on a 14-day Pro trial with no card. After it lapses, the free tier stays free.