Connectors

/

Notion

Data replication

Sync Notion data anywhere.

Notion is an all-in-one workspace that allows users to organize their personal and professional lives in one place. It combines features of note-taking apps, project management tools, and databases to create a customizable and flexible platform. Users can create pages, databases, and boards to manage tasks, projects, and information. Notion also offers a variety of templates and integrations with other apps to enhance productivity. Its user-friendly interface and collaborative features make it a popular choice for individuals and teams looking to streamline their workflows and stay organized.

  • Certified
  • Generally available
  • 5 streams
  • 5 entities
  • Read & write
Sync Notion dataRead the docs
Notion

One connector

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.

Specifications

What to know before you sync Notion

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version4.0.20
  • Release stageGenerally available

Sync capabilities

  • Destinations50+ Airbyte connectors

Set up in 9 steps

  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.

5 streams

Every table you can sync from Notion

  • Blocks

  • Comments

  • Data Sources

  • Pages

  • Users

6 actions

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.

Full parameter-level details live in the Notion entity reference.

Authentication

Authenticate Notion once

    • Recommended

    OAuth2.0

  • Access Token

Use cases

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

What is the schema of a specific data source?

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

Add a comment to page X saying 'Looks good!'

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

Explore

Related connectors

PerigonUnstructuredStandard Sources cloudself-managed-enterprise
ShutterstockUnstructuredStandard Sources cloudself-managed-enterprise
TavusUnstructuredStandard Sources cloudself-managed-enterprise
Web ScrapperUnstructuredStandard Sources cloudself-managed-enterprise
AssemblyAIUnstructuredStandard Sources cloudself-managed-enterprise
Clarif-aiUnstructuredStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

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.

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.

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.

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.

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.

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.

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.

Try it freeTalk to sales