Dataki for Google Sheets
Ask Google Sheets in plain English
Turn a spreadsheet into a real dashboard. Dataki reads your Google Sheets, answers questions about them in plain English, and keeps the charts live as the sheet changes.
Connects directly Google sign-in, then pick a sheet.
Which accounts are furthest behind their targets this month?
Northwind Traders is $48K short of its September target, the furthest of any account.
01Questions
What people ask Google Sheets
Each one becomes a query against Google Sheets, run read-only, with the SQL shown beside the chart so anyone who reads SQL can check it. Anything worth keeping goes on a dashboard that refreshes on its own.
- Which accounts are furthest behind their targets this month?
- What is the total pipeline by stage, and how did it change since last week?
- Which rows have missing owners or close dates?
- Chart monthly spend by category from the budget sheet.
02From your assistant
Ask Google Sheets from Claude, ChatGPT or Cursor
Dataki runs a hosted MCP server. Add it to your assistant once and it can read your Google Sheets schema and run read-only queries through Dataki. The assistant gets the rows back; the Google Sheets credentials stay encrypted in Dataki and never reach the model.
Setup for your assistant:
Claude 
ChatGPT 
Cursor 
VS Code Read the Pipeline sheet and tell me which deals are likely to slip this month.
- list_sources · finds Google Sheets · Pipeline
- get_data_context · reads the tables and what the columns mean
- query · runs the SQL read-only, returns the rows
- render_ui · draws the chart from those rows, in the chat
https://dataki.ai/api/mcp Live dashboards
Every answer can become a live dashboard.
Ask in plain English. Dataki writes the SQL, runs it on your database and charts the answer. Keep it as a dashboard with its own link, and your team sees current numbers every time they open it.
3 views · Updated just now
One click turns the answer into a dashboard:
Always current. The query runs again whenever the dashboard opens, so Friday's meeting sees Friday's numbers.
- Share it
- Send the link to anyone. Viewers are free on every plan.
- Refine it
- The SQL is always visible. Adjust it by hand or ask for a change.
- Embed it
- Put the same dashboard in your own product with two HTML tags.
Using Dataki with Google Sheets
- Can I query Google Sheets in plain English instead of writing SQL?
- Yes. Dataki reads your Google Sheets schema, turns a plain-English question into a query, runs it on Google Sheets and returns a chart. The query is shown with every result, so you can check or edit it.
- Is there a hosted Google Sheets MCP server?
- Yes, Dataki. Its remote MCP server reaches Google Sheets through a read-only connection you set up once in Dataki: nothing to install, and no connection string in your assistant's config. Assistants can list sources, read the schema and what it means, run read-only SQL, draw charts in the conversation and save dashboards. Every query is logged with the key that ran it.
- How do I build a dashboard from Google Sheets data without an ETL pipeline?
- Connect Google Sheets to Dataki with a read-only connection, ask your question and save the answer as a dashboard widget. Dataki queries Google Sheets live, so there is no pipeline to build, no warehouse to sync and no copy of your data to maintain.
- Can Claude, ChatGPT or Cursor query my Google Sheets data?
- Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect Google Sheets to Dataki, add that URL as a connector in Claude or ChatGPT (or in Cursor, VS Code or Claude Code with a Dataki key), and your assistant can read the schema and run read-only queries. It works with the results, while your credentials stay encrypted in Dataki and never reach the model.