Google Sheets Project & Productivity

Connect Google Sheets


Dashboards, a full API and MCP access over your Google Sheets data. Hosted in Finland. Self-hostable, or buy the platform outright and run it yourself.

Portable technical infrastructure to any cloud.

A production-ready foundation designed to scale. Plug in pre-built modules for common workflows, or build your own on top.

Enterprise-grade from day one

Live from the first day, and portable later to any system. No vendor lock-in to Jourier: take the code, the schema and the models and run them yourself.

Hosted in Finland

Data and AI run in a Finnish data centre. UpCloud in Helsinki, and Mistral trained with CSC on the LUMI supercomputer in Kajaani.

Enterprise modular architecture

Scales to any level, from a new startup to a large enterprise. Build your own modules, or change the ones that ship.

The stack behind the unicorns

Talos Linux, Kubernetes and Cilium. GitOps deployments, a separate database per customer, automated security controls and self-healing.

Google Sheets API

One API over Google Sheets and everything else

Most systems expose one API shaped around their own storage. Useful, but you build against that shape, handle its pagination, and repeat the exercise for every other system you own.

Jourier reads Google Sheets and serves the result as modelled JSON, on one endpoint, alongside every other system you connect. It is joined, typed and reconciled to what the dashboards show.

  • Issues, sprints, worklogs and every status transition as first-class objects
  • The same numbers the dashboards use, from one definition
  • Read-only against Google Sheets; nothing is created or transitioned
Your data, your query
# cycle time by issue type, this quarter
GET /v1/delivery/cycle_time?period=2026-Q3

{
  "source": "google-sheets",
  "as_of":  "2026-08-16T06:12:00Z",
  "rows": [
    { "type": "Bug", "cycle_days": 12.4,
      "in_review_days": 7.1, "delta": 4.1 }
  ]
}
Google Sheets MCP

Ask Claude about your own backlog

Model Context Protocol is how an AI assistant calls a real tool instead of guessing. Jourier exposes your connected systems as MCP tools, so Claude, Cursor or any MCP client can query Google Sheets directly, and answer from the issue history rather than from a plausible sentence about it.

Every answer resolves to rows you can open. The model retrieves; it does not compute the number, which is the only reason the answer is worth having.

  • Works with Claude Desktop, Cursor, and any MCP-compatible client
  • Scoped to what that user is allowed to see
  • Self-hosted models available, so your delivery data never leaves the EU
Claude · jourier
You
Which issue types slipped most
this quarter, and where did they sit?

Claude
Bugs, up 4.1 days. Most of it waiting
in review, not in progress.
Where the data lands

Google Sheets data in the tool you already use

Each has its own setup page: what syncs, how often, and what the schema looks like on arrival.

Connecting Google Sheets

Paste credentials, nothing to install

Access is granted per customer, so connecting is a matter of pasting keys. Nothing is installed and no port is opened.

What you'll need

Service account JSON key
{ "type": "service_account", "project_id": ..., "private_key_id": ... }
Spreadsheet link
https://docs.google.com/spreadsheets/d/1hLd9Qqti3UyLXZB2aFfUWDT7BG-arw2xy4HR3D-dwUb/edit
Access
Read only
Questions

Google Sheets and Jourier, answered

Can I get Google Sheets data into a dashboard?

Yes. Jourier reads Google Sheets and serves throughput, cycle time and stall points as dashboards that are already built. You connect Google Sheets and they fill with your own issues, so there is no modelling project first.

Does Jourier write anything back to Google Sheets?

No. The connection is read-only against Google Sheets. Nothing is written back.

Where is Google Sheets data stored when I use Jourier?

In Finland, on EU infrastructure, under EU law. The AI that reads it is self-hosted, so your data is never a US vendor’s training material.

How long does connecting Google Sheets take?

The connector is live. Connecting is a matter of pasting credentials: nothing is installed and no port is opened, and data flows the same day.

Can I use Google Sheets data from Claude or another AI tool?

Yes. Jourier exposes MCP tools, so Claude, Cursor or any MCP client can query Google Sheets directly and answer from the issue history rather than from a plausible sentence about it. Access is scoped to what that user is allowed to see.

Can I run it on my own infrastructure?

Yes. It is standard Kubernetes built on open components. You can take the manifests and run it on your own cluster whenever you decide to, and there is no proprietary runtime holding you in.

Does this work with other systems as well as Google Sheets?

Yes. Jourier serves Google Sheets alongside every other system you connect, on one endpoint, joined, typed and reconciled to what the dashboards show.

Get started
Self-serve

Try the demo

Instant access to Jourier Lens. Business email only.