Notion
Support Level: Certified
Latest Version: 2.0.8
Definition Id: 6e00b415-b02e-4160-bf02-58176a0ae687
This page contains the setup guide and reference information for the Notion source connector.
Prerequisites
- Access to a Notion workspace
Setup guide
To authenticate the Notion source connector, you need to use one of the following two methods:
- OAuth2.0 authorization (recommended for Airbyte Cloud)
- Access Token
For Airbyte Cloud users: We highly recommend using OAuth2.0 authorization to connect to Notion, as this method significantly simplifies the setup process. If you use OAuth2.0 authorization in Airbyte Cloud, you do not need to create and configure a new integration in Notion. Instead, you can proceed straight to setting up the connector in Airbyte.
We have provided a quick setup guide for creating an integration in Notion below. If you would like more detailed information and context on Notion integrations, or experience any difficulties with the integration setup process, please refer to the official Notion documentation.
Step 1: Create an integration in Notion and set capabilities
- Log in to your Notion workspace and navigate to the My integrations page. Select New integration.
You must be the owner of the Notion workspace to create a new integration associated with it.
- Enter a Name for your integration. Make sure you have selected the correct workspace from the Associated workspace dropdown menu, and click Submit.
- In the navbar, select Capabilities. Check the following capabilities based on your use case:
- Read content: required for all connections.
- Read comments: required if you wish to sync the
Commentsstream - Read user information (either with or without emails): required if you wish to sync the
Usersstream
Step 2: Share pages and acquire authorization credentials
Access Token (Cloud and Open Source)
If you are authenticating via Access Token, you will need to manually share each page you want to sync with Airbyte.
- Navigate to the page(s) you want to share with Airbyte. Click the ••• menu at the top right of the page, select Add connections, and choose the integration you created in Step 1.
- Once you have selected all the pages to share, you can find and copy the Access Token from the Secrets tab of your Notion integration's page. Then proceed to setting up the connector in Airbyte.
OAuth2.0 (Open Source only)
If you are authenticating via OAuth2.0 for Airbyte Open Source, you will need to make your integration public and acquire your Client ID, Client Secret and Access Token.
- Navigate to the Distribution tab in your integration page, and toggle the switch to make the integration public.
- Fill out the required fields in the Organization information and OAuth Domain & URIs section, then click Submit.
- Navigate to the Secrets tab to find your Client ID and Client Secret.
- 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. Once you have your Client ID, Client Secret and Access Token, you are ready to proceed to the next step.
Step 3: Set up the Notion connector in Airbyte
- Log in to your Airbyte Cloud account, or navigate to your Airbyte Open Source dashboard.
- In the left navigation bar, click Sources. In the top-right corner, click New source.
- Find and select Notion from the list of available sources.
- Enter a Source name of your choosing.
- Choose the method of authentication from the dropdown menu:
Authentication for Airbyte Cloud
- OAuth2.0 (Recommended): Click Authenticate your Notion account. When the popup appears, click Select pages. Check the pages you want to give Airbyte access to, and click Allow access.
- Access Token: Copy and paste the Access Token found in the Secrets tab of your private integration's page.
Authentication for Airbyte Open Source
- Access Token: Copy and paste the Access Token found in the Secrets tab of your private integration's page.
- OAuth2.0: Copy and paste the Client ID, Client Secret and Access Token you acquired after setting up your public integration.
- (Optional) You may optionally provide a Start Date using the provided datepicker, or by programmatically entering a UTC date and time 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, Airbyte will set the start date two years from the current date by default. - Click Set up source and wait for the tests to complete.
Supported sync modes
The Notion source connector supports the following sync modes:
| Stream | Full Refresh (Overwrite/Append) | Incremental (Append/Append + Deduped) |
|---|---|---|
| Blocks | ✓ | ✓ |
| Comments | ✓ | ✓ |
| Databases | ✓ | ✓ |
| Pages | ✓ | ✓ |
| Users | ✓ |
Supported Streams
The Notion source connector supports the following streams:
Performance considerations
The connector is restricted by Notion request limits. The Notion connector should not run into Notion API limitations under normal usage. Create an issue if you encounter any rate limit issues that are not automatically retried successfully.
Changelog
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 2.0.8 | 2023-11-01 | 31899 | Fix table_row.cells property in Blocks stream |
| 2.0.7 | 2023-10-31 | 32004 | Reduce page_size on 504 errors |
| 2.0.6 | 2023-10-25 | 31825 | Increase max_retries on retryable errors |
| 2.0.5 | 2023-10-23 | 31742 | Add 'synced_block' property to Blocks schema |
| 2.0.4 | 2023-10-19 | 31625 | Fix check_connection method |
| 2.0.3 | 2023-10-19 | 31612 | Add exponential backoff for 500 errors |
| 2.0.2 | 2023-10-19 | 31599 | Base image migration: remove Dockerfile and use the python-connector-base image |
| 2.0.1 | 2023-10-17 | 31507 | Add start_date validation checks |
| 2.0.0 | 2023-10-09 | 30587 | Source-wide schema update |
| 1.3.0 | 2023-10-09 | 30324 | Add Comments stream |
| 1.2.2 | 2023-10-09 | 30780 | Update Start Date in config to optional field |
| 1.2.1 | 2023-10-08 | 30750 | Add availability strategy |
| 1.2.0 | 2023-10-04 | 31053 | Add undeclared fields for blocks and pages streams |
| 1.1.2 | 2023-08-30 | 29999 | Update error handling during connection check |
| 1.1.1 | 2023-06-14 | 26535 | Migrate from deprecated authSpecification to advancedAuth |
| 1.1.0 | 2023-06-08 | 27170 | Fix typo in blocks schema |
| 1.0.9 | 2023-06-08 | 27062 | Skip streams with invalid_start_cursor error |
| 1.0.8 | 2023-06-07 | 27073 | Add empty results handling for stream Blocks |
| 1.0.7 | 2023-06-06 | 27060 | Add skipping 404 error in Blocks stream |
| 1.0.6 | 2023-05-18 | 26286 | Add parent field to Blocks stream |
| 1.0.5 | 2023-05-01 | 25709 | Fixed ai_block is unsupported by API issue, while fetching Blocks stream |
| 1.0.4 | 2023-04-11 | 25041 | Improve error handling for API /search |
| 1.0.3 | 2023-03-02 | 22931 | Specified date formatting in specification |
| 1.0.2 | 2023-02-24 | 23437 | Add retry for 400 error (validation_error) |
| 1.0.1 | 2023-01-27 | 22018 | Set AvailabilityStrategy for streams explicitly to None |
| 1.0.0 | 2022-12-19 | 20639 | Fix Pages stream schema |
| 0.1.10 | 2022-09-28 | 17298 | Use "Retry-After" header for backoff |
| 0.1.9 | 2022-09-16 | 16799 | Migrate to per-stream state |
| 0.1.8 | 2022-09-05 | 16272 | Update spec description to include working timestamp example |
| 0.1.7 | 2022-07-26 | 15042 | Update additionalProperties field to true from shared schemas |
| 0.1.6 | 2022-07-21 | 14924 | Remove additionalProperties field from schemas and spec |
| 0.1.5 | 2022-07-14 | 14706 | Added OAuth2.0 authentication |
| 0.1.4 | 2022-07-07 | 14505 | Fixed bug when normalization didn't run through |
| 0.1.3 | 2022-04-22 | 11452 | Use pagination for User stream |
| 0.1.2 | 2022-01-11 | 9084 | Fix documentation URL |
| 0.1.1 | 2021-12-30 | 9207 | Update connector fields title/description |
| 0.1.0 | 2021-10-17 | 7092 | Initial Release |