Notion DB to SQLITE script

notion2sqlite.py

# quick and dirty way to convert notion db to an un-parsed sqlite db.
import requests
import json
import sqlite3


DB_ID = "YOUR-DB-ID-HERE"
API_SECRET = "YOUR-API-KEY-HERE"

url_query = f"https://api.notion.com/v1/databases/{DB_ID}/query"
headers = {
    'Authorization': f'Bearer {API_SECRET}',
    'Notion-Version': '2022-06-28',
}
response_query = requests.post(url_query, headers=headers)

data_query = json.loads(response_query.text)

conn = sqlite3.connect('notion_table.db')
c = conn.cursor()

table_name = "NotionTable"
fields = data_query['results'][0]['properties'].keys()
field_string = ', '.join([f'{field} TEXT' for field in fields])
c.execute(f'CREATE TABLE {table_name} ({field_string});')

values_string = ', '.join(['?' for _ in fields])
for result in data_query['results']:
    values = [str(result['properties'][field]) for field in fields]
    c.execute(f'INSERT INTO {table_name} VALUES ({values_string});', values)

conn.commit()
conn.close()