Building a Content Flywheel on Notion

I recently worked with a client who produces a cryptocurrency podcast and video series across Africa, to develop a content flywheel in Notion.

Our primary goal of this project was to develop a seamless workflow between the client’s production pipeline and the associated subtasks, that would keep their entire team on track, while working on several projects at once.

For this specific build, we utilized Notion’s databases, database templates, and native database automation.

The workflow;

• Projects are added to the Production database,
• as the project moves through the pipeline, sub-tasks are auto-created in the Tasks database using Database Automation.
• The client’s team then completes any assigned tasks to complete the project.

Production Database (screenshot)

Database automation setup (screenshot)

The Production Status triggers the Database Automation, then adds a new page to the Tasks database, using the appropriate template, and lastly adds the relation of the task…