Articles to Notion

This workspace converts long-form article drafts into clean CSV files for Notion import.

Folder Structure

• data/raw/: Original article text blocks (copy/paste input).
• data/processed/: Output CSV files.
• schema/: Locked column definitions.
• logs/: Validation and missing-field tracking.

CSV Schema (Locked)

day_number,title,type_category,content_type,summary,why_it_works,how_they_did_it,my_comment_tip,source_url,image_url

Input Format

Paste all articles into one file (for example data/raw/batch_01.txt) and separate each article with:

--

Recommended first line per article:

Day 29 - AppSumo Lifetime Deal to Seed Reviews

Optional URLs can appear anywhere in each article, for example:

Source: https://example.com/article
Image: https://example.com/image.png

Conversion Script

1. Category analysis only (recommended first pass):

python3 scripts/convert_articles.py --input data/raw/batch_01.txt --analyze-only

2. Generate CSV outputs:

python3 scripts/convert_articles.py --input data/raw/batch_01.txt

The script auto-fills:

• day_number and title from Day X - ... when present
• type_category as multi-label values joined by ;
• content_type from title framing
• summary, why_it_works, how_they_did_it, my_comment_tip from freeform sections

Outputs

• data/processed/articles.csv: Main Notion import file.
• data/processed/articles_readable.csv: Simplified, readable version for Sheets.