notion_pandas

A library that transforms notion tables into pandas dataframes by connecting with Notion API

Installation

1. pip install -r ./requirements.txt
2. Create an integration here.
3. Save your token from the previous page
4. Save the id_table when you are in your table the address will look similar to this https://www.notion.so/d1234?v=5678. You need to save the string after the / and before the ?
5. On the top left of your table visualization you have tre dots (...) click on that, after click on add connections and search for the integration you have create in point 2 and click confirm
6. Use this library 😎

Example

from NotionPandas import NotionPandas 
import pandas as pd

npd = NotionPandas("token", "id_table")
npd.to_csv('test.csv')

df =  npd.return_pandas()
df.head()