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 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: support@thesys.dev