Google Sheets logo

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.

Connect Google Sheets
app.dataki.ai / chat Google Sheets · Pipeline

Which accounts are furthest behind their targets this month?

Reading the schema, writing the query…
SQL 90 ms · read-only 
SELECT account, target - closed_won AS gap
FROM   targets
WHERE  month = 'September'
ORDER BY gap DESC
LIMIT 5
Gap to target September · 5 rows
Northwind TradersGlobexInitechUmbrella HealthSoylent Foods $0$10k$20k$30k$40k$50k

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 · dataki (MCP) Google Sheets · Pipeline

Read the Pipeline sheet and tell me which deals are likely to slip this month.

  1. list_sources · finds Google Sheets · Pipeline
  2. get_data_context · reads the tables and what the columns mean
  3. query · runs the SQL read-only, returns the rows
  4. render_ui · draws the chart from those rows, in the chat
server URL streamable http
https://dataki.ai/api/mcp

03Setting it up

Connecting Google Sheets

Google sign-in, then pick a sheet.

Open Dataki

The answer is still there tomorrow.

Ask in plain language. Dataki writes the SQL, runs it against your warehouse and draws the chart. Anything worth keeping becomes a dashboard with a link — not a message that scrolls away.

app.dataki.ai / chat

Which channels actually brought in revenue last quarter?

Queried bigquery · payments · 1.2 GB scanned 
SELECT channel,
       SUM(amount) AS revenue
FROM   payments
WHERE  created_at >= DATE_TRUNC(CURRENT_DATE(), QUARTER)
GROUP BY channel
ORDER BY revenue DESC

Revenue by channel

Q3 · 5 rows

Organic search
$412,900
Partner referral
$268,400
Email
$151,200
Paid social
$96,700
Direct
$61,300

One click later, that chart is a dashboard of its own:

app.dataki.ai/d/revenue-by-channel

Live, not a screenshot. It re-runs the query on a schedule, so the number your team reads on Friday is Friday's number.

  • Share the link with anyone. Viewers are free on every plan.
  • Edit the SQL by hand whenever the model gets the logic almost right.
  • Drop the same dashboard into your own product with one line of HTML.
Start free See how it works

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 against Google Sheets and returns a chart. The generated query is shown with every result, so you can verify or edit it.
Is there a hosted Google Sheets MCP server?
Dataki is one. Its remote MCP server reaches Google Sheets through a read-only connection you set up once in Dataki, so nothing is installed on your machine and no connection string goes into an assistant's config. It offers tools to list sources, read the schema and its documented meaning, 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 keep the answer as a dashboard widget. Dataki queries Google Sheets directly at read time, so there is no pipeline to build, no warehouse to sync into and no copy of your data to keep current.
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 the assistant can read the schema and run read-only queries. It gets the rows back; the credentials stay encrypted in Dataki and are never handed to the model.