NotionAI & Automation

Build a Self-Managing Agency in Notion: 5-Minute Setup

Daniel Canosa·

I've been building these self-managing systems for my clients since 2021, and honestly, the transformation is pretty incredible.

Before we implement this system, our clients are spending more than 20 hours per week just on client delivery alone.

After the 5-minute setup I'm about to walk you through? Two to three hours per week.

That's not a typo. We're talking about an 85% reduction in hands-on delivery time, which means founders can finally step back and focus on growth instead of being buried in project management.

The Core Problem (And Why Hiring More People Makes It Worse)

Here's what I see with every service provider who's trying to scale.

They hit that point where client delivery is eating up all their time. Setting up new projects, managing tasks, making sure nothing falls through the cracks.

The natural instinct? Hire someone to help.

But then what happens? Now you're spending your time training this person, babysitting them, telling them what to do, when to do it, how to do it.

You're creating tasks for them manually, or worse, managing everything through Slack messages and WhatsApp threads. I hope you're not one of them.

What if there was a system that automatically tells your team member exactly what they need to do, when they need to do it, and how to do it?

Without you having to babysit anyone.

That's what we're building today. A system that automatically generates tasks, assigns them to the right person, and includes built-in documentation showing exactly how to complete each task.

But before we dive into the setup, bear in mind there's one critical requirement.

Since tasks are generated automatically, you need a standardized process. Something you follow every single time.

This is the first thing we ensure our clients have. If they don't have it, we help them define it beforehand.

If you're a company doing lots of different things, offering different services, fulfilling every service in a different way, this is going to be very hard for you. Most of what you do will stay manual.

My recommendation? Take a look at all the services you're providing. See which ones generate the most revenue and which ones you enjoy doing the most.

Find the service where both of these things are true, then focus your offering there and work on making it as standardized as possible.

Once you get your process standardized, you'll have something like this:

Linear workflow diagram showing a standardized process with sequential tasks (Kickoff Call → Prep Prep → Create webflow pages → Build → Internal QA → QA Done → Implement Feedback → Send for final acceptance → Handoff) with fulfillment phase indicated by yellow bar
Linear workflow diagram showing a standardized process with sequential tasks (Kickoff Call → Prep Prep → Create webflow pages → Build → Internal QA → QA Done → Implement Feedback → Send for final acceptance → Handoff) with fulfillment phase indicated by yellow bar

This is a real output from one of our clients. Of course, I've changed the names for privacy, but this linear path with all the different tasks is exactly what we need to build our automated system.

The Three-Database Setup That Makes Everything Work

Now, let's build this in Notion. We need three different databases working together.

Database #1: Projects

Every project represents something you're doing for a client. In my case, since we build Notion workspaces, all my projects are Notion builds.

Here's the key thing. I always think in terms of scalability. I want the same system to work whether we're two people today or 50 people in five years.

Projects database structure showing Strategist and Developer role properties with columns for Project Name, Status, Strategist, Developer, Due Date, and Priority
Projects database structure showing Strategist and Developer role properties with columns for Project Name, Status, Strategist, Developer, Due Date, and Priority

For my Notion builds, we have two different positions. The Strategist (typically me) who helps companies standardize their process and maps out how the Notion system will work. And the Developer who actually builds the workspace following that plan.

This gives me flexibility. In some projects, I'm both roles. In others, I'm only the strategist. But in the future, if I have multiple developers, I can assign them here.

What does this mean? Every task that needs to be done by the developer will automatically be assigned to whoever is in that Developer field for that specific project.

Database #2: Tasks

This is where all the magic happens. Tasks get created automatically and assigned dynamically based on the project setup.

Database #3: SOPs

This contains all the documentation showing exactly how to complete each task. When a task gets created, it automatically links to the relevant SOP.

Three-database setup overview showing Projects, Tasks, and SOPs databases with sample data, statuses, assignees, and project relationships
Three-database setup overview showing Projects, Tasks, and SOPs databases with sample data, statuses, assignees, and project relationships

Setting Up the Automation (The 5-Minute Magic)

Here's where everything comes together. I want tasks to be created automatically whenever a project moves to the "Active" phase.

Let me walk you through the setup.

First, I'll create an automation called "Active Project." The trigger is simple: when the project status changes to "Active," we want to create tasks.

Status filter dropdown menu showing 'Active' option selected for filtering projects by automation trigger
Status filter dropdown menu showing 'Active' option selected for filtering projects by automation trigger

Setting up task creation:

For each task, I need to define several things:

  • The task name (for example, "Turn standard process into a list of tasks")
  • A dynamic due date
  • The assignee
  • A link to the relevant SOP

For the due date, I use a formula that automatically sets the due date to two days from when the automation triggers.

Selecting the Due Date property from the Edit property dropdown to configure dynamic due dates for automated tasks
Selecting the Due Date property from the Edit property dropdown to configure dynamic due dates for automated tasks

For the assignee, since this particular task is the developer's responsibility, I use a custom formula that pulls whoever is listed as the Developer in the trigger page.

Edit formula dialog showing available trigger page properties including 'Whoever triggered' and 'Page creator' for dynamic assignee configuration
Edit formula dialog showing available trigger page properties including 'Whoever triggered' and 'Page creator' for dynamic assignee configuration

I can create as many tasks as I need by duplicating this setup and changing the task names. Let's say I also need "Set up first dashboard" and "Set up second dashboard" tasks.

Automation setup dialog showing task creation with assignee set to 'Developer', due date configured with dateAdd(2), and multiple task rows demonstrating how to configure automatic task creation with correct parameters
Automation setup dialog showing task creation with assignee set to 'Developer', due date configured with dateAdd(2), and multiple task rows demonstrating how to configure automatic task creation with correct parameters

Now, whenever a project goes to Active status, all these tasks get created automatically with the correct assignee, due date, and project link.

But here's the thing. These tasks are created, but they don't tell someone HOW to complete them.

That's where the SOPs database comes in.

SOPs database showing task documentation with entries like 'How to turn standard process into a list of tasks', organized by type (Strategic/Operational) with owner and project assignment
SOPs database showing task documentation with entries like 'How to turn standard process into a list of tasks', organized by type (Strategic/Operational) with owner and project assignment

I can link each automated task to its corresponding SOP right in the automation setup.

Linking tasks to SOPs in automation workflow - selecting SOP documentation from dropdown menu to connect with task automation rules
Linking tasks to SOPs in automation workflow - selecting SOP documentation from dropdown menu to connect with task automation rules

So when Daniel (or whoever the developer is) receives a task like "Turn standard process into a list of tasks," he just clicks on the linked SOP and gets all the steps he needs to take.

The beautiful part? Every time a new task is created and linked to an SOP, it's always linked to the same one. So when we update the SOP, it doesn't matter because all past and future tasks will always reference the latest version.

Basically, this is how we turn a standardized process with a set of steps into a workable system that runs itself.

Some of my clients used to keep their task lists in Word documents or Excel files. For every new project, they'd copy and paste them, then manually modify properties for each project.

Now everything is completely automated. You just need to think about which statuses will trigger which sets of tasks with which SOPs.

But it all comes back to having a standardized process like the one I showed you earlier.

Bear in mind, this isn't all rainbows. If your process changes frequently, you'll need to update your automations. And if you're doing completely custom work for every client, this approach won't work for you.

But for service providers with repeatable processes, this system can give you back 15-18 hours per week. That's time you can spend growing your business, working on strategy, or honestly, just taking a break.

The key is starting with one standardized service and building from there. Once you see how powerful this is, you'll want to systematize everything else too.

Ready to see where your business stands with AI and automation? Take our AI Readiness Scorecard to find out.

Get more like this in your inbox

AI implementation insights for service business founders. No fluff.