Conversational analytics with Google Sheet and C1 by Thesys

Conversational analytics with Google Sheet and C1 by Thesys

Turn any Google Sheet into a chat-powered dashboard. Ask questions in plain English and get interactive charts, tables, and UI (not just text) powered by C1 by Thesys. Outcome: faster insights from spreadsheet data. No filters, pivot tables, or manual chart building.

Check out a working demo of this template here.

Example Use Cases

You can use this setup for many real-world scenarios, such as:

Lead Tracking

• Upload your leads data to Google Sheets
• Ask questions like:
• “How many new leads came from LinkedIn?”
• “Which region generated the most leads?”

Marketing Campaign Analysis

• Store campaign performance data in a sheet
• Ask:
• “Which campaign had the highest conversion rate?”
• “Compare email vs paid ads performance”

How it works

1. User sends a prompt
2. C1 model based on prompt will use CoinGecko MCP to fetch live data
3. C1 Model generates a UI Schema Response
4. Schema is rendered as UI using Thesys GenUI SDK on the frontend

Setup

Make sure you have the following:

1. Thesys API Key

You’ll need an API key to authenticate and use Thesys services. 👉 Get your key here

2. Google Sheet as a Data Source

Prepare a Google Sheet that contains your data:

• Column headers in the first row
• Clean, structured data (no merged cells)
• Example columns:
• date
• campaign_name
• leads
• cost

Facing setup issues?

If you get stuck or have questions:

• 💬 Join the Thesys Community

• 📧 Email support: [email protected]