Skip to content

Uploading data to a Notion Database

In this walkthrough tutorial you will learn how to upload data to Notion in cURL and Python. Airflow integration example also included.

saja
saja
2 min read
Time to get some Notions (credits)

Notion is a platform designed to blend your workflow into an all-in-one workspace. It has many options and features adapted to all kinds of usage.

I started using Notion recently, and I figured I'd use the Database mode that Notion offers. I wanted to keep track of members subscribed to blef.fr's newsletter, by uploading every member to a Notion Database.

We'll walk through the process of creating a database in Notion, and uploading data to it.

First, create a database in your workspace. Go to workspace and add a page. Type '/table' and choose full page table. You'll then have to create an integration and share your database with this integration, tutorial here.

Now that you got your database ID and your Notion key, you can start making API requests.

We'll go over Notion requests using cURL and Python.

Requesting Notion's API using cURL

Here's what a Notion HTTP request looks like :

curl -X POST https://api.notion.com/v1/pages -H "Authorization: Bearer $NOTION_KEY" -H "Content-Type: application/json" -H "Notion-Version: 2021-08-16" --data @your_json_file.json

Let's say that your database has four columns, Name, Country, Email and Subscription.

Name is a Title property, Country is a Text field, Email is an email format and Subscription is a Select Option.

In order to insert data to this database, you must create a JSON file respecting the following format :

You can find this JSON file here.

For more information about Notion's properties objects : documentation.

For more examples on how to use Notion's API : postman.

Requesting Notion's API using Python

Start by importing modules json and requests. Store your API headers and API endpoint in variables :

API_ENDPOINT = "https://api.notion.com/v1/pages"
HEADERS =  {"Authorization": "Bearer YOUR_API_TOKEN", "Content-Type": "application/json" ,"Notion-Version": "2021-08-16"}

Then open your JSON file containing what you want to add into the database.

with open ('PATH_TO_YOUR_JSON', 'r') as f:
    DATA = json.load(f)

Make a POST request with Headers and Data.

r = requests.post(API_ENDPOINT, data=json.dumps(DATA), headers=HEADERS)

Print the request's content to see the returned message.

print(r.content) 

Use the NotionHook I created

I found an unofficial Python API for notion (link here) but I didn't find anything Airflow related, so I figured I'd make my own Notion Hook (link here). It has three methods : creating a database, retrieving a database and uploading data to a database.

You can also find my Airflow Pull Request here, leave a thumbs up if you come by!

data engineeringNotionAirflow

Data Explorer

The hub to explore Data News links

Search and bookmark more than 2500 links

Explore

saja

Data engineer Intern @ blef.fr

Comments


Related Posts

Members Public

dbt multi-project collaboration

Use cross-project references without dbt Cloud. This article showcases what you can do to activate dbt multi-project collaboration.

Members Public

How to get started with dbt

What's a dbt model, a source and a macro? Learn how to get started with dbt concepts.