Notion + Orcabase

Turn your Notion databases into answers.

Track content, roadmaps or hiring in Notion databases? Sync the pages you share through Fivetran and ask how many, how fast and what’s stuck, in plain words.

Get started How to connect

Synced by Fivetran
Syncs every 6 hours
No Fivetran account needed

AgentNotion connected

How many posts did we publish each month this year?

Reading your Notion data…

We published 14 posts in August, the most this year.

Brewing guides are the most common type.
Posts spend 9 days on average between draft and published.
Four posts have been in review for over two weeks.

Posts published by month

How I got this· 4 steps

Read the content calendar you shared from Notion
Counted pages marked published each month
Measured days from draft to published
Flagged pages stuck in review

Example answer. Numbers are illustrative.

In plain words

Can I build reports on Notion databases?

Notion is great for keeping track, less so for counting. Fivetran copies the databases and pages you share into a database Orcabase hosts for you, with their properties: status, dates, owners, tags.

Ask “how many posts did we publish each month?” or “what’s stuck in review?” and get the answer with a chart.

Ask in plain words

What you can ask about your Notion data

The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.

Meet the data agent

How many posts did we publish each month?
Which roadmap items are behind?
How long do pages sit in review?
How many candidates are at each hiring stage?
Who owns the most open tasks?
Which tags come up most?
What changed on the roadmap this month?
Show me items created by week.

What comes in

Your Notion data, ready to ask about.

A copy in a database Orcabase hosts for you, with its own folder for each app.

Databases

The Notion databases you share, with their properties.

Pages

Each page in them, with its properties and when it last changed.

Users

Who created and edited what.

Only what you share

Fivetran sees only the pages and databases you share with it in Notion.

Numbers worth defining

Define them once. Every answer agrees.

Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Notion data.

How metrics work

Published per month
Pages moved to published, each month.
Time in review
Average days a page spends in review.
Open items
Items not yet done, by owner or status.
On-time delivery
Share of items done by their due date.

Dashboards to start with

Your Notion numbers at a glance.

Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.

Content

3 charts

Published per month
Time in review
Posts by type

Roadmap

3 charts

Items by status
Behind their date
Open items by owner

About dashboards

Better together

Ask across Notion and the rest of your business.

The best questions need more than one app. The agent can pull from several sources for one answer.

“Which posts from our content calendar bring the most search clicks?”

Notion + Google Search Console

“Which published posts bring the most visitors?”

Notion + Google Analytics

“Which roadmap items in Notion still have open issues in Linear?”

Notion + Linear

How to connect

Connect Notion, step by step.

1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Notion. Pick the database to sync into.
2
Connect Notion on Fivetran’s page
Click Authorize on Fivetran’s page, sign in to Notion, and choose the pages to share. You can share more later from a page’s Connections menu.
3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Notion data.

What you’ll need

A Notion login that can share the pages and databases you want.
The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.

At a glance

How it connects: Synced by Fivetran
How fresh: Every 6 hours, as standard.
Where your data lives: A copy in a database Orcabase hosts for you, with its own folder for each app.
Who can set it up: An admin in your organization.
Your login: You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
Cost: Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.

Sync apps with FivetranStep-by-step, in the docs.

Questions

About Notion and Orcabase

More in the docs: Sync apps with Fivetran

Does Fivetran see my whole Notion workspace?

No. It only sees the pages and databases you share with it.

Can I chart any Notion database?

Yes. Properties like status, dates, people and numbers come along, so any database can be counted, grouped and charted.

Do I need a Fivetran account?

No. Orcabase uses its own. You sign in to Notion on Fivetran’s page, and the data lands in a database Orcabase hosts for you, so there’s nothing else to set up or pay Fivetran for.

How fresh is my Notion data in Orcabase?

Fivetran syncs it every 6 hours as standard, and an admin can run a sync by hand at any time. The page for each source shows when it last synced and when it syncs next.

What does syncing cost?

Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard. Each distinct row that’s added or changed in a month counts once, however often it changes, and the first full copy is free. You choose which tables sync, so you only spend the allowance on what you need.

Keep exploring

More data sources

All data sources

Your Notion data already has the answers.

Connect it, ask your first question, and pin the answers you want to see every week.

Get started All data sources