Chat with your Google Sheets data

AI to analyze Google Sheets data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Google Sheets
You
What was our total revenue in Q3 from the sales sheet?
Google Sheets
Your Q3 revenue from the sales sheet totaled $47,850, representing a 12% increase over Q2 performance.
Via Kondado MCP
You
How many active projects do we have in the tracker?
Project Tracker
You currently have 23 active projects in your tracker, with 8 marked as high priority in column Z.
Via Kondado MCP
You
What is the average order value this month?
Sales Metrics
The average order value this month is $142.50, up from $128.30 last month according to your sheet.
Via Kondado MCP
You
Which region had the highest conversion rate?
Regional Data
The North region shows the highest conversion rate at 3.42%, significantly above the 2.1% average.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Google Sheets data with Claude and ChatGPT

Connect your Google Sheets to Kondado and start asking Claude, ChatGPT or any MCP client about your spreadsheet data in natural language. Query quarterly revenue totals directly from your sheets, compare monthly KPIs across different columns to spot trends, or check the status of specific project records without manual filtering or complex formulas. The AI reads your replicated data through the MCP connection and returns precise, contextual answers in seconds, turning static spreadsheets into interactive business intelligence.

Kondado replicates Google Sheets data to a structured destination and exposes it via an MCP server, enabling direct analysis through Claude, ChatGPT and other MCP clients. The data structure includes 1 pipeline with fields such as col_x, col_y and col_z. The same data also powers ready reports in Power BI and Looker Studio for visual monitoring.

Marketing analysts can ask about campaign performance metrics stored in their sheets without building pivot tables, while e-commerce managers query inventory levels or daily order values simply by typing questions in chat. Finance teams compare budget versus actuals across different time periods, and operations managers check project completion statuses across multiple rows and columns. Everyone gets instant insights from their Google Sheets data without writing a single formula or exporting CSV files.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your Google Sheets data by Kondado in minutes.

View Google Sheets dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Google Sheets data in natural language.

View MCP setup →

The Spreadsheet pipeline listed below unlocks your Google Sheets data for conversational analysis. This pipeline organizes your information with structured fields including col_x, col_y and col_z, enabling you to ask Claude or ChatGPT about specific metrics stored in each column. You can analyze trends in col_x, compare performance values across col_y, or filter records based on col_z criteria to isolate specific segments. While this single pipeline captures your complete spreadsheet contents, you can combine it with additional data sources on Kondado for broader cross-functional analysis. Updates occur on a configurable schedule, ensuring your AI assistant always references the most current figures from your Google Sheets.

How to connect Google Sheets to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT
AI vocabulary

Google Sheets tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

1
Table
3
Fields
∞
Ad-hoc questions
Spreadsheet
Integrates organized data with fields such as col_x, col_y, and col_z, enabling detailed analysis and information cross-referencing.
Full docs on the wiki → Connect Google Sheets now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect Google Sheets at app.kondado.com.br

Connect your Google Sheets data source on Kondado at app.kondado.com.br and select a Via Kondado destination. Your spreadsheet data lands in a structured format ready for AI access and for the Power BI and Looker Studio dashboard templates.

2
Add Kondado MCP in Claude or ChatGPT

In Claude Web or Desktop, or directly in ChatGPT, add the Kondado MCP server in the connection settings. Authorize once via OAuth at app.kondado.com.br to enable natural language queries about your Google Sheets data, with identical setup steps for both clients and no CLI commands needed.

3
Ask questions or open dashboards

Start asking questions in chat using natural language about your Google Sheets metrics, trends and records. For visual recurring monitoring and chart views, open one of the ready Power BI or Looker Studio dashboard templates powered by the same data.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What business questions can Claude or ChatGPT answer about my Google Sheets data? ▼
You can ask about totals and averages stored in specific columns, compare values across different time periods or categories, identify top-performing rows based on numeric fields, and filter records matching specific criteria in col_x, col_y or col_z. The AI interprets your natural language questions and queries the replicated data to return precise figures and insights.
How do I configure Claude Web or Desktop to access my Google Sheets data through Kondado? ▼
Open the connection settings in Claude Web or Claude Desktop and add the Kondado MCP server. Authorize your account once via OAuth at app.kondado.com.br to grant read access to your replicated Google Sheets data. The setup uses a graphical interface with no command line tools or JSON configuration required.
How does authentication work when connecting ChatGPT to my Google Sheets via Kondado? ▼
ChatGPT users add the Kondado MCP server in the connection settings and complete a one-time OAuth authorization at app.kondado.com.br. This secure flow grants the AI read-only access to your replicated spreadsheet data without sharing your actual Google credentials with the chat client.
Can the AI write data back to my Google Sheets or execute actions? ▼
No, the integration provides read-only analytical access for chat-based insights. The AI can analyze, summarize and answer questions about your data, but cannot modify values, add rows, or perform actions within your Google Sheets. For data modifications, you must use the Google Sheets interface directly.
How often does the data update when I am chatting with Claude about my Google Sheets? ▼
Kondado replicates your Google Sheets data on a configurable schedule that you control. Depending on your settings, the AI may reference data updated hourly or daily, ensuring your answers reflect recent changes without claiming near-real-time updates.
What dashboard templates are available for visual monitoring of Google Sheets data? ▼
Kondado offers ready report templates in Power BI and Looker Studio that use the same replicated data powering your AI chat. These templates provide visual charts and recurring monitoring views, while the AI chat offers on-demand exploratory analysis through natural language questions.
What is the difference between asking the AI in chat versus opening a ready dashboard? ▼
Chat-based analysis with Claude or ChatGPT allows spontaneous, specific questions about your Google Sheets data with immediate textual answers. Ready dashboards in Power BI or Looker Studio provide fixed visual reports optimized for recurring monitoring and trend visualization using the same underlying data.

Try out all the features for free for 14 days