← Projects

Workflow automation

Notion Sync

A desktop automation that mirrors records from multiple Notion databases into one central operational database.

Independent project - working prototype
  • Electron
  • Node.js
  • Notion API
  • JSON
  • Automation
Notion gap

Connected views are not a real merge

Notion can display multiple data sources and separate views, but it does not give users a true merged database where records from different source tables live in one operational layer. That matters whenever someone wants one consistent table instead of mentally switching between views.

What the tool does

Several source databases, one working table

Notion Sync mirrors selected source databases into one central target database. It keeps a persistent mapping, tracks deletions and gives the user a small desktop status surface, so the central table becomes the place where work is actually handled.

Future product direction

From desktop helper to permissioned sync service

The stronger version is a hosted connector-based service: users grant Notion permissions, the tool checks schema compatibility, warns about mismatches and runs continuously without requiring a desktop process to stay alive.

Database merge model

From separated views to one operational layer

The core idea is the merge boundary: source databases stay independent, but the user gets one central table that behaves like the working surface.

01Source DB A
02Source DB B
03Source DB C
04Notion API
05Schema mapping
06Deletion tracking
07Central target DB
08Status surface

Roadmap

Product path

Working

Desktop prototype

Electron app, status GUI, tray mode and user-data storage behavior.

Working

Sync core

Mirrors source records into a central database with persistent mapping state.

Next

Robustness

Conflict handling, property mismatch warnings and clearer sync diagnostics.

Future

Cloud service

Permissioned connectors, scheduled sync and schema checks without desktop dependency.

Portfolio angle

Why this is general

  • The problem is not limited to study modules; it applies to any Notion workspace split across separate databases.
  • The valuable proof is the merge behavior: source tables, mapping state, deletion handling and one central target.
  • A future demo should show Notion before the tool, the sync run, and the unified database after the tool.