A notion source plugin for CloudQuery that loads data from notion to any database, data warehouse or data lake supported by CloudQuery, such as PostgreSQL, BigQuery, Athena, and many more.
In Order for CloudQuery to sync resources from your Notion setup, you will need to create a notion integration key and export the Token in NOTION_SECRET_KEY environment variable. How to create the notion integration key? see here. Make sure to give proper Content Capabilities and User Capabilities from capabilities settings. Also give your integration page permissions see here. Only pages and databases with permission will able to sync.
export NOTION_SECRET_KEY=<your_notion_integration_key>The following source configuration file will sync to a PostgreSQL database. See the CloudQuery Quickstart for more information on how to configure the source and destination.
kind: source
spec:
name: "notion"
path: "cloudquery/notion"
version: "${VERSION}"
destinations:
- "postgresql"
spec:
bearer_token: "${NOTION_SECRET_KEY}"