--- title: Step-by-Step Guide to Automating Your Freelance Project Workflow in Notion siteUrl: https://logzly.com/notionflow author: notionflow (Notion Flowcraft) date: 2026-06-15T20:34:09.749555 tags: [productivity, notion, freelance] url: https://logzly.com/notionflow/step-by-step-guide-to-automating-your-freelance-project-workflow-in-notion --- Ever felt like you’re juggling client emails, invoices, and task lists all at once? I’ve been there—late night coffee, a spreadsheet that looks like a maze, and a deadline that sneaks up like a cat. Automating the flow in Notion can turn that chaos into a calm river. Let’s walk through a simple system that lets you focus on the creative part of freelancing while Notion handles the rest. ## Why automate now? Freelancers wear many hats. One minute you’re a designer, the next you’re an accountant. When every hour counts, a manual checklist becomes a hidden time‑suck. Automation saves minutes, reduces errors, and gives you a clear view of what’s coming up. Plus, it feels pretty satisfying to watch a status change all by itself. ## Overview of the workflow We’ll build three core pieces: 1. **Project database** – where each client job lives. 2. **Task database** – the to‑do items linked to each project. 3. **Automation rules** – simple formulas and filters that move cards, calculate totals, and send you reminders. All of this lives inside a single Notion page, so you never have to jump between apps. If you already use a content calendar, our **[custom Notion content calendar template](/notionflow/how-to-build-a-custom-notion-content-calendar-template-that-saves-5-hours-a-week)** can complement this setup and keep deadlines in sync. ## Step 1: Create a master Project database ### 1.1 Add a new table - Open a fresh page in Notion. - Type “/table” and choose “Full page”. Name it **Projects**. ### 1.2 Set up key columns | Column | Type | What it holds | |--------|------|---------------| | Name | Title | Project name (e.g., “Website redesign for Acme”) | | Client | Text | Client name | | Status | Select | Options: Pitch, In‑Progress, Review, Completed | | Start date | Date | When the work begins | | Due date | Date | Final deadline | | Budget | Number | Project fee | | Total tasks | Rollup | Counts linked tasks (we’ll add this later) | Keep the table tidy—only the columns you really need. You can always hide a column later. ### 1.3 Add a template button At the top of the table click “+ New” and choose “New template”. Call it **New Project**. Inside the template, add a brief checklist: - ☐ Send proposal - ☐ Get signed contract - ☐ Set up client folder When you click the button, Notion will copy this checklist into a new project row, saving you the typing. ## Step 2: Build a Task database linked to Projects ### 2.1 Create the Task table - On the same page, type “/table” again and pick “Inline”. Name it **Tasks**. ### 2.2 Important columns | Column | Type | Purpose | |--------|------|---------| | Task | Title | Short description | | Project | Relation | Links each task to a row in Projects | | Due | Date | When the task should be done | | Status | Select | To‑Do, Doing, Done | | Hours | Number | Estimated hours | | Completed on | Date | Auto‑filled when status changes to Done | When you add the **Relation** column, Notion will ask you to connect it to the Projects table. Choose **Projects** and allow a two‑way link. This creates a back‑link in Projects called “Tasks”. ### 2.3 Add a rollup in Projects Go back to the Projects table, edit the **Total tasks** column, set it to roll up the linked Tasks, and choose “Count”. Now each project shows how many tasks belong to it. ## Step 3: Automate status changes and reminders Notion doesn’t have native “if‑then” scripts, but clever use of formulas and filtered views does the trick. ### 3.1 Auto‑move tasks to “Done” - Add a **Formula** column in Tasks called **Auto‑Done**. - Use this formula: `if(prop("Status") == "Done", now(), prop("Completed on"))` - This writes the current date into **Completed on** the moment you mark a task as Done. ### 3.2 Highlight overdue items - Add another formula column **Late?** with: `if(and(prop("Due") < now(), prop("Status") != "Done"), "⚠️", "")` - In a filtered view, set the filter to show only rows where **Late?** is not empty. You’ll get a quick “red flag” list of overdue tasks. ### 3.3 Weekly project snapshot Create a new **Board view** in Projects and group by **Status**. Then add a filter: `Due date is within next week`. This board shows every project that needs attention in the coming seven days, without you digging through the whole table. ## Step 4: Connect invoicing (optional but handy) If you bill by the hour, add a **Formula** in Tasks called **Earned**: `prop("Hours") * 0.0` (replace 0.0 with your hourly rate). Then in Projects, add a rollup that sums **Earned** across linked tasks. You’ll see a live estimate of how much each project is worth as you log hours. For freelancers who also need to plan publication dates, the **[ready‑to‑use Notion content calendar template](/notionflow/readytouse-notion-content-calendar-template-to-double-your-publishing-speed)** can be linked to your Projects database to keep client deliverables aligned with your publishing schedule. ## Step 5: Test it out 1. Click **New Project** and fill in a fake client. 2. Add three tasks using the **New** button in the Tasks table. Link each to the project. 3. Mark one task as **Done** and watch the **Completed on** date appear. 4. Change the due date of another task to yesterday; see the ⚠️ appear. 5. Switch the project status to **Review** and notice the board view moving the card. If anything feels off, tweak the select options or formula syntax. Notion’s error messages are usually clear—just a little green text telling you what’s missing. ## Step 6: Keep it tidy Automation works best when the data stays clean. - Use consistent naming for clients (e.g., “Acme Corp” not “Acme” in one row and “Acme Corp.” in another). - Archive completed projects by adding a **Select** option “Archived” and filtering it out of your main views. - Review your formulas every month; a new service or rate change may need an update. ## My personal shortcut When I first tried this system, I set the **Due date** of every task to the same day as the project’s due date. It looked neat, but I kept getting a flood of red flags the night before a deadline. The fix? Add a **Buffer** column (Number) that adds a few days to each task’s due date. Then change the **Late?** formula to compare against `prop("Due") + prop("Buffer")`. Suddenly my alerts became useful nudges instead of panic alarms. ## Wrap‑up You now have a lean, automated workflow that lives entirely inside Notion. Projects stay organized, tasks move themselves, and you get a quick glance at what’s due. The best part? All of this is built with free Notion features—no extra apps, no code, just a few clicks and a bit of patience. Give it a try on your next freelance gig. You’ll be amazed how much mental space you free up when the system does the heavy lifting.