List
Read live records straight from the Notion API.
Send Notion blocks, comments and data sources to any warehouse, lake or AI app.
Source
Notion

Overview
The Airbyte Notion connector extracts data from Notion and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with scheduled sync. It publishes 5 streams you can select per connection.
Land 5 Notion tables in 50+ destinations on a schedule you control.
Read, create and update Notion records at runtime through typed entity actions.
Query synced Notion data with filters, sorting and semantic search, without spending Notion API rate limits.
Authenticate Notion once. The same connection powers scheduled syncs and runtime actions.
5 streams
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
| Sync modes | FullIncr. |
|---|
Setup
Open the Notion source connector page on Airbyte.com.
Click on the "Add a new source" button.
Select "Notion" from the list of available sources.
Enter a name for the source connector.
Click on the "Create source" button.
In the "Connection Configuration" section, enter the following credentials: - Integration Token: This can be obtained from the Notion API page. Follow the instructions on the page to create a new integration and obtain the token. - Database ID: This is the ID of the database you want to connect to. You can find this by opening the database in Notion and copying the ID from the URL.
Click on the "Check connection" button to test the connection.
If the connection is successful, click on the "Save" button to save the source connector.
You can now use the source connector to extract data from your Notion database.
| Field | Type | Description |
|---|---|---|
| credentials | object | Choose either OAuth (recommended for Airbyte Cloud) or Access Token. See our docs for more information. |
| num_workers | integer | Number of worker threads to use for the sync. Higher values can speed up large syncs but may increase rate-limit pressure against Notion's limit of approximately three requests per second per integration. |
| start_date | string | UTC date and time in the format YYYY-MM-DDTHH:MM:SS.000Z. During incremental sync, any data generated before this date will not be replicated. If left blank, the start date will be set to 2 years before the present date. |
6 actions
Read live records straight from the Notion API.
Fetch a single record by ID.
Query synced data with filters and sorting, with no API rate limits.
Write a new record back into Notion.
Patch fields on an existing record.
Natural-language search across synced Notion records.
Full parameter-level details live in the Notion entity reference.
Hybrid deployment
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
Your environment
Airbyte control plane
Use cases
List all users in my Notion workspace
Show me all pages in my Notion workspace
What data sources exist in my Notion workspace?
Get the details of a specific page by ID
List child blocks of a specific page
Show me comments on a specific page
What properties does the 'Roadmap' data source have?
Who are the bot users in my workspace?
Create a new page titled 'Meeting Notes' under page X
Update the icon of page X to a rocket emoji
Add a paragraph block saying 'Hello World' to page X
Mark the to-do block as completed
Archive page X
Update the title of data source X to 'Project Tracker'
Find pages created in the last week
List data sources that have been recently edited
Show me all archived pages
FAQ
No. One Notion authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.
No. Entity actions read and write through the Notion API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.
5 streams: Blocks, Comments, Data Sources, Pages, Users.
Check the stream list on this page for the sync modes each Notion table supports.
Run the Notion connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Free 14-day trial. One connection powers your scheduled syncs and your live Notion actions.