📊 Conversational analytics with Google Sheet and C1 by Thesys

⚡ 101 views · 📊 Market Research & Insights

💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.

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

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

🔗 Nodes Used

AI Agent, OpenAI Chat Model, Simple Memory, Chat Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup