Skip to main content

Notion

This page contains the setup guide and reference information for Notion.

Features​

FeatureSupported?
Full Refresh - OverwriteYes
Full Refresh - AppendYes
Incremental - AppendYes
Incremental - Append + DedupedYes

Note: Users stream only supports full refresh sync mode.

Prerequisites​

  • Access to a Notion workspace
  • Client ID (when using Access Token to authenticate)
  • Client Secret (when using Access Token to authenticate)
  • Access Token

Setup guide​

Step 1: Create an integration in Notion​​

  1. Log in to your Notion workspace and navigate to the My integrations page.

  2. Click + New integration.

    NOTE: You must be the owner of the Notion workspace to create a new integration. Notion New Integration

  3. Enter a Name for your integration. Make sure you have selected the correct workspace from the Associated workspace dropdown menu, and click Submit.

  4. Inside the integration you just created, click Capabilities from the left sidebar. Check the following capabilities based on your use case:

    • Read content: required for all connections.
    • Read comments: required if you wish to sync the Comments stream
    • Read user information (either with or without emails): required if you wish to sync the Users stream

Step 2: Make your integration public and obtain credentials​

Using OAuth 2.0​

  1. Inside the integration you just created, click Distribution from the left sidebar, and toggle the switch to make the integration public. Notion Public Distribution

  2. Fill out the required fields in the Organization information and OAuth Domain & URIs section.

  3. Once you click Submit after filling out all the required field, you will be directed to the Secrets tab. Copy your Client ID, Client Secret and Authorization URL. Notion Secrets

  4. You need to use your integration's Authorization URL to set the necessary page permissions and send a request to obtain your Access Token. A thorough explanation of the necessary steps is provided in the official Notion documentation.

  5. You're ready to set up Notion in Daspire!

Using Access Token​

If you are authenticating via Access Token, you will need to manually share each page you want to sync with Daspire.

  1. Navigate to the page(s) you want to sync with Daspire. Click the ••• menu at the top right of the page, scroll down to Add connections, and choose the integration you created in Step 1. Notion Add Connection

  2. Once you have done that to all the pages you want to sync, go back to your integration, and copy the Access Token from the Secrets tab.

  3. You're ready to set up Notion in Daspire!

Step 3: Set up Notion in Daspire​

  1. Select Notion from the Source list.

  2. Enter a Source Name.

  3. Copy and paste the Client ID, Client Secret and Access Token you acquired after setting up your public integration.

  4. (Optional) You may optionally provide a Start Date in the format: YYYY-MM-DDTHH:mm:ss.SSSZ. When using incremental syncs, only data generated after this date will be replicated. If left blank, Daspire will set the start date two years from the current date by default.

  5. Click Save & Test.

Output schema​

This Source is capable of syncing the following core Streams:

Data type mapping​

Integration TypeDaspire Type
stringstring
numbernumber
arrayarray
objectobject

Performance considerations​

The integration is restricted by Notion request limits. The Notion integration should not run into Notion API limitations under normal usage.

Troubleshooting​

Max number of tables that can be synced at a time is 6,000. We advise you to adjust your settings if it fails to fetch schema due to max number of tables reached.