Notion
Unstructured
Sync Notion data anywhere.
- Certified
- Generally available
- 5 streams
- 5 entities
- Read & write
- 5Streams
- 5Entities
- 6Actions
- 50+Destinations
Everything Notion can do in Airbyte
Sync to your warehouse
Land 5 Notion tables in 50+ destinations on a schedule you control.
Live entity actions
Read, create and update Notion records at runtime through typed entity actions.
Context store search
Query synced Notion data with filters, sorting and semantic search, without spending Notion API rate limits.
One authorization
Authenticate Notion once. The same connection powers scheduled syncs and runtime actions.
Sync capabilities
- Available onCloud, Self-Managed Enterprise
- Destinations50+ Airbyte connectors
- Connector version4.0.20
Set up in 9 steps
- 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.
Every table you can sync from Notion
Blocks
Retrieves content blocks for all synced pages, including recursively nested child blocks up to 30 levels deep. Block types child_page, child_database, and ai_block are excluded.
Comments
Retrieves comments on all synced pages. Requires the Read comments integration capability.
Data Sources
Retrieves data source objects. In the Notion API 2025-09-03, a data source represents a structured table that contains pages and properties — previously called a "database." This stream replaces the former Databases stream as of v4.0.0. For details on migrating, see the Notion migration guide.
Pages
Retrieves page objects from all shared pages.
Users
Retrieves user objects from the workspace. Requires the Read user information integration capability.
Supported Notion actions
List
Read live records straight from the Notion API.
Get
Fetch a single record by ID.
Context Store Search
Query synced data with filters and sorting, with no API rate limits.
Create
Write a new record back into Notion.
Update
Patch fields on an existing record.
Semantic Search
Natural-language search across synced Notion records.
Authenticate Notion once
OAuth2.0
RecommendedAccess Token
What teams build with Notion
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
Related connectors
Common questions
Do I need more than one Notion connection?
No. One Notion authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.
Do Notion entity actions need a sync to run first?
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.
What is ETL?
ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.
What data can you extract from Notion?
Notion's API provides access to a wide range of data types, including:
1. Pages: This includes all the pages in a Notion workspace, including their properties and content.
2. Databases: Notion's databases are a powerful way to organize and manage data. The API provides access to all the databases in a workspace, including their properties and content.
3. Blocks: Notion's blocks are the building blocks of pages and databases. The API provides access to all the blocks in a workspace, including their content and properties.
4. Users: Notion's API provides access to information about the users in a workspace, including their name, email address, and profile picture.
5. Workspaces: The API provides access to information about the workspaces themselves, including their name and ID.
6. Integrations: Notion's API allows developers to create integrations with other tools and services, such as Slack or Zapier.
Overall, Notion's API provides a comprehensive set of tools for accessing and manipulating data within a workspace, making it a powerful platform for building custom applications and workflows.
How do I transfer data from Notion?
1. Open the Notion source connector page on Airbyte.com.
2. Click on the "Add a new source" button.
3. Select "Notion" from the list of available sources.
4. Enter a name for the source connector.
5. Click on the "Create source" button.
6. 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.
7. Click on the "Check connection" button to test the connection.
8. If the connection is successful, click on the "Save" button to save the source connector.
9. You can now use the source connector to extract data from your Notion database.
What are top ETL tools to transfer data from Notion?
The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.
What is ELT?
ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.
Difference between ETL and ELT?
ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.
Start moving Notion data today
Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Notion actions.