notion-database-exporter

This tool exports Notion's database in csv format.

Usage (node/npm)

The supported node version is 16.15. Other versions have not been tested.

1. Install command.

npm i -g notion-database-exporter

2. Add Notion Integration from the following page.

https://www.notion.so/my-integrations

3. Copy the token

4. Open the page containing the database (even the parent page), click the Share button in the upper right corner, and then click the Invite button.

5. Select the integration you just created.

6. Create notion-db-exporter-secret.yml in the folder where you run the command and write the token you just copied.

notionToken: XXXX

7. The following command will output CSV to the notion-db-csv folder.

notion-database-exporter --export

You can also only display a list of databases.

notion-database-exporter --list

Command Options

option	description	default
-c, --config	Specify the path to the configuration file	./notion-db-exporter.yml
-s, --secret	Specify the path to the secret file	./notion-db-exporter-secret.yml
-l, --list	display a list of databases	true
-e, --export	export databases	false

Configuration

You can change the settings by placing notion-db-exporter.yml in the folder where you run the command.

# Output directory.
outDir: './notion-db-csv'

# if want to filter database by title or id so enable below
#includes:
#  - title: "Your Database Title1"
#  - title: "Your Database Title2"
#  - id: "Your Database id1"
#  - id: "Your Database id2"
#excludes:
#  - title: "Your Database Title1"
#  - id: "Your Database id1"

For development

Build

npm run build
# or
npm run watch

Run

dist/main.js

Run tests

npm run test

Build container

docker build --tag example-container .

Run container

docker run example-container example

Release new version

Document

Update all packages

npm install -g npm-check-updates
ncu -u
npm install

# Check
npm run test
npm run build
node dist/main.js