ds@mcpanalytics.aiEmail your data and your question and get an answer about your own data, with the method shown.Email your data and question. Get an answer.
Spreadsheets and files connector

Airtable analytics from your own data

One table from your Airtable base, with the columns your table has, analysis-ready.

Connect Airtable →Try a free tool on a sample

What you can learn from your Airtable data

Once Airtable is connected, these are the questions your data can answer. Each one has a free tool that shows the method on a sample first.

Data profile

What is in the data, and what is missing.

Fits your records.

Try the free toolSee a sample report

Pareto (80/20)

The few items or customers that bring most of the results.

Fits your records.

Try the free toolSee a sample report

Anomaly detection

Days or numbers that look out of the ordinary.

Fits your records.

Try the free toolSee a sample report

What data it brings

  • records: The records of the table you named: one column per field in the table, plus the record id and the created date.

A question you can ask

“How many records were created per month?”

Ask it in your own words. You get the answer, with the steps that made it.

How to connect it

You connect with a key you create in your Airtable account. It takes a few minutes.

  1. In your MCP Analytics account, open Connectors and choose Airtable. The setup form opens there.
  2. At airtable.com/create/tokens choose Create new token.
  3. Name it, add the scope data.records:read, and under Access choose only the base you want to analyse.
  4. Create the token and copy it (it starts with pat). It is shown once.
  5. Paste it into the setup form, and type the base ID and the table name in the setup form.

Airtable help page for this step →

We test the connection before we save it, so you know right away if a step was missed.

Open Connectors →

What we keep, and how to disconnect

We keep the key or login you give us, encrypted, and use it only to read the data you ask about. Other accounts cannot see your connections. To stop, open Connectors in your account and choose Remove on the Airtable row; that deletes the saved key. You can also cancel the key in Airtable itself.

Questions

What can I learn from my Airtable data?

You can see what is in the data, and what is missing, the few items or customers that bring most of the results, and days or numbers that look out of the ordinary. Each one has a free tool that shows the method on a sample.

Will this change anything in my Airtable account?

No. We only read. Nothing in Airtable is changed.

Can I use a file instead?

Yes. Export a CSV from Airtable and upload it. Connecting just saves you the export each time.

Can I combine Airtable with my other data?

Yes. Connect each source, then ask a question that names both.

Other spreadsheets and files connectors