Conversational analytics with Google Sheet and C1 by Thesys

Description

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
User sends a prompt
C1 model based on prompt will use CoinGecko MCP to fetch live data
C1 Model generates a UI Schema Response
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]