Notion

Connect your Notion workspace to your data warehouse. Sync pages, blocks, users, and comments to BigQuery, Redshift, Postgres, Databricks, and more.

Using the Erathos platform

When selecting Notion as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:

• Token — your Notion internal integration token, used to authenticate all requests to the Notion API

With this connection created you can seamlessly move your Notion data to your BigQuery, Redshift or Postgres data warehouse.

How to find my token?

To generate a Notion integration token, go to https://www.notion.so/my-integrations and click New integration. Give it a name, select the workspace you want to connect, and click Submit.

After creating the integration, copy the Internal Integration Token shown on the integration settings page. Then go to each Notion page or database you want to sync and add the integration under Share → Invite, granting it the appropriate access level.

Paste the token into the Token field on the Erathos platform and click Save and close to complete the setup.

Endpoints and fields

users

Sync type availability: Full-refresh

Field	Type
id	text
name	text
type	text
avatar_url	text

pages

Sync type availability: Full and incremental refresh

Cursor: last_edited_time

Parent of blocks, comments

Field	Type	Cursor
id	text
created_time	timestamp
last_edited_time	timestamp	✓
archived	boolean
url	text
parent.type	text

blocks

Sync type availability: Full-refresh

Child of pages

Field	Type
id	text
type	text
created_time	timestamp
last_edited_time	timestamp
has_children	boolean
archived	boolean

comments

Sync type availability: Full-refresh

Child of pages

Field	Type
id	text
discussion_id	text
created_time	timestamp
last_edited_time	timestamp
created_by.id	text
parent.type	text

Entity Relationships