把 Flomo 同步到 Notion 的得到电子书笔记，导出到 ReadWise

dedao-flomo-notion-readwise.py

import csv
from notion_client import Client
from notion_client.helpers import iterate_paginated_api


# Flomo 在 Notion 中的同步数据库需要增加两个字段：
# - 得到电子书：formula 字段，公式为 `contains(prop("Tags"), "得到/电子书")`
# - 书名：formula 字段，公式为 `replaceAll(prop("Tags"), "得到/电子书/", "")`


NOTION_TOKEN = '<notion-auth-token>'
FLOMO_DB_ID = '<flomo-sync-database-id>'

notion = Client(auth=NOTION_TOKEN)


pages = iterate_paginated_api(notion.databases.query, **{
    "database_id": FLOMO_DB_ID,
    "filter": {
        "property": "得到电子书",
        "formula": {
            "checkbox": {
                "equals": True
            }
        }
    }
})


with open('dedao.csv', 'w', encoding='utf-8') as csvfile:
    fieldnames = ["Highlight", "Title", "Author", "URL", "Note", "Location", "Date"]
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    
    writer.writeheader()


    for page in pages:
        for result in page:
            page_id = result["id"]
            props = result["properties"]
            book_title = props["书名"]["formula"]["string"]
            created_at = props["Created At"]["date"]["start"]
            blocks = notion.blocks.children.list(page_id).get("results")
            block = blocks[0]
            block_text = block["paragraph"]["rich_text"][0]["plain_text"]
            
            lines = block_text.splitlines()
            highlight_text = lines[-3]
            note_text = lines[1] if len(lines) == 5 else ""
            
            
            writer.writerow({
                "Highlight": highlight_text,
                "Title": book_title,
                "Author": "",
                "URL": "",
                "Note": note_text,
                "Location": "",
                "Date": created_at,
            })