Skip to content

Video guide 6 of 12 · Your data · 1:53

Importing and connecting data in SimpleKPI

Three ways to bring in figures that already live somewhere else: a spreadsheet, a connected app, or the API.

What this guide shows

  • Import any spreadsheet. The AI reads it, works out your KPIs, dates and figures, and asks about anything unclear.
  • Check what it found, new KPIs and ones you already have, before anything is saved.
  • Connect Google Sheets, Xero, Google Analytics, Stripe, Search Console or Zendesk, then choose the metrics and how often to update.
  • Create an API key in Settings and choose what it can read and write.
  • Turn on MCP in Settings to connect an AI tool such as Claude or ChatGPT.

Transcript

What's said in the video, by chapter. Press a time to play from there.

Three ways in

We'll import a spreadsheet, connect an app, and look at the API.

Import any spreadsheet

Start with a spreadsheet, any spreadsheet. On the KPIs page, choose Import a spreadsheet and drop your file in. AI reads it, and works out your KPIs, their dates and their figures. If anything's unclear, it asks. Answer, and it reads the sheet again. Then check what it found before anything is saved: which KPIs are new, and which you already have. Continue, and it's done.

Connect an app

For figures that change every day, connect the app they come from. In Settings, under Connections, add a connection: Google Sheets, Xero, Google Analytics, Stripe, Search Console or Zendesk. Sign in, then choose the metrics you want. The ones we recommend are ticked for you. Pick how far back to go, and how often to update. From then on, those KPIs fill themselves, and KPI Data shows the figures come from a connection. Using a system that isn't listed? Request a data connection, and tell us what you use.

The API

If you have a developer, the API can send figures in from your own systems. In Settings, under API, create a key, and choose what it can read and write. Copy it straight away: you'll only see it once. The documentation is linked right there. And to connect an AI tool such as Claude or ChatGPT, turn on MCP in Settings.

Get started with your KPI Software

Get started for free