Mode Analytics API · unofficial, by Cotlet

Create your own Mode Analytics API

Mode Analytics: the API is for members of a Mode Business Workspace, with a token (checked 20 Nov 2026). With Cotlet you can build your own. Do a job once with your AI agent in your Mode Analytics account, save it as an endpoint, and call it from n8n, Make, Zapier or your own code. Each endpoint runs in your own signed-in Mode Analytics session and returns only what your login can see.

Try it free now

Free 7-day trial, 2,000 credits, no card

Cotlet is an independent service. It is not affiliated with, endorsed by or sponsored by Mode Analytics. Mode Analytics is a trademark of its owner. If Mode Analytics's own integrations cover what you need, use them first.

curl
curl -X POST "https://cotlet.dev/api/v1/custom/failed-runs" \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"since": "2026-11-19"}'
Node.js
const url = "https://cotlet.dev/api/v1/custom/failed-runs";
const res = await fetch(url, {
  method: "POST",
  headers: {
    Authorization: `Bearer ${process.env.COTLET_API_KEY}`,
    "Content-Type": "application/json",
  },
  body: JSON.stringify({ since: "2026-11-19" }),
});
const { data } = await res.json();
Python
import os
import requests

key = os.environ["COTLET_API_KEY"]
res = requests.post(
    "https://cotlet.dev/api/v1/custom/failed-runs",
    headers={"Authorization": f"Bearer {key}"},
    json={"since": "2026-11-19"},
)
data = res.json()["data"]
Response 200 OK · JSON
{
  "data": [
    {
      "report": "Weekly revenue",
      "collection": "Finance",
      "started_at": "2026-11-20T02:10",
      "error": "Query timed out"
    },
    {
      "report": "Churn by plan",
      "collection": "Growth",
      "started_at": "2026-11-20T03:00",
      "error": "Column not found"
    }
  ]
}

01 Build

How do you build a Mode Analytics endpoint with Cotlet?

  1. Sign in to Mode Analytics in your Cloud Browser.

    You type your password yourself. Cotlet keeps the signed-in session, encrypted, never the password.

  2. Do the job once with your agent.

    For example: "List the report runs since yesterday that failed, with the report name, its collection and the error."

  3. Save it as an endpoint.

    Give it a name, choose its inputs, such as a date or a collection, and the fields it returns.

  4. Call it with your Cotlet API key.

    Each endpoint gets its own address, POST https://cotlet.dev/api/v1/custom/<name>. You send JSON in and get JSON back, from the same signed-in Mode Analytics session.

02 Endpoints

Example endpoints you could build for Mode Analytics

Cotlet ships no fixed list of Mode Analytics endpoints. You decide which endpoints you build and what each one returns.

  • POST /api/v1/custom/failed-runs

    Failed report runs

    Report, collection, start time and error for each failed run

  • POST /api/v1/custom/report-results

    Results of a report

    The rows of the latest run of a report

  • POST /api/v1/custom/stale-reports

    Reports not run lately

    Reports in a collection with the date of their last run

  • POST /api/v1/custom/report-editors

    Who can edit a report

    The people with edit access to a report

  • POST /api/v1/custom/rerun-report writes

    Rerun a report

    A new run of the report you name, with its status

A call to an endpoint you built could look like this:

Request

curl -X POST "https://cotlet.dev/api/v1/custom/failed-runs" \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"since": "2026-11-19"}'

The answer is JSON, with your fields under data:

Response · 200 OK

{
  "data": [
    {
      "report": "Weekly revenue",
      "collection": "Finance",
      "started_at": "2026-11-20T02:10",
      "error": "Query timed out"
    },
    {
      "report": "Churn by plan",
      "collection": "Growth",
      "started_at": "2026-11-20T03:00",
      "error": "Column not found"
    }
  ]
}

When you save an endpoint, Cotlet gives you its curl example and an OpenAPI description to paste into n8n, Make or your code.

03 Uses

What can you use your Mode Analytics endpoints for?

  • Schedule Cotlet endpoint Slack or email

    A morning check in n8n or Make.

    Failed report runs from the night, sent to Slack or email before the team starts.

  • Schedule endpoint Google Sheets

    Numbers in a sheet.

    The results of a report pulled into Google Sheets on a schedule.

  • Monthly endpoint task list

    A clean-up list.

    Reports nobody has run in months, listed for the team to archive.

  • Chat agent endpoint report results

    Your own data assistant.

    A chat agent that reads the latest results before it answers a question about the numbers.

04 Access

What can an endpoint see and change?

An endpoint works in your own Mode Analytics session, so it can read and change only what your Mode Analytics login can. An owner login sees the whole business. A team login sees what its permissions allow. You choose what each endpoint does when you build it.

An endpoint that changes something, such as rerunning a report, first runs as a dry run: Cotlet shows you each request it would send, and nothing is sent. You allow the writes once in the Cotlet console and set a daily cap. A call over the cap fails whole, never half done.

05 Official API

Does Mode Analytics have an official API?

Mode Analytics: its API reference says the API is for members of a Mode Business Workspace; it reads, creates, updates and deletes resources with a token (checked 20 Nov 2026). Query results export as CSV from the Data tab. The full picture with sources: Does Mode Analytics have an API or MCP server?

Want ChatGPT or Claude to work in Mode Analytics instead of code? See the Mode Analytics MCP server.

06 Pricing

What does it cost?

per successful call
10 credits
when a call fails
0
in the smallest pack
≈ 500 calls
free trial, no card
7 days

A call to your endpoint costs 10 credits when it succeeds and nothing when it fails, with no browser minutes on top. Credits come in one-time packs from $29 for 5,000 credits, so a pack covers about 500 successful calls. The free trial gives you 2,000 credits for 7 days, no card.

Mode Analytics API with Cotlet: questions

Is this an official Mode Analytics API?

No. Cotlet is independent and not affiliated with Mode Analytics. The endpoints you build run in your own signed-in Mode Analytics account.

Do I need to code?

Not to build an endpoint: you do the job once with your agent and save it. To call it, you need a tool that sends HTTP requests, such as n8n, Make, Zapier or a script.

What happens when Mode Analytics changes its screens?

An endpoint works while Mode Analytics works the way it did when you built it. If Mode Analytics changes and a call fails, you get an email. After 3 failures in a row the endpoint turns off until you rebuild it with your agent or in the console. A failed call costs nothing.

How long can a call take?

Up to 90 seconds, and the answer can be up to 1 MB of JSON.

Build your first Mode Analytics endpoint

Sign in once, do the job with your agent and save it as an endpoint.

Try it free now

No card. Takes about 5 minutes.