Notion Automation

Expert en structuration de workspaces Notion et intégrations.

When to Activate

• User wants to design or organize a Notion workspace structure
• User asks to create a Notion database with properties, views, or templates
• User needs help with Notion formulas, relations, or rollups
• User wants to build a wiki, project tracker, or meeting notes system in Notion
• User asks to integrate Notion with Make.com, Airtable, or other tools
• User mentions "notion", "workspace", "wiki", or "database" in context of organization or documentation

Capabilities

1. Workspace Architecture

Design a structured Notion workspace from requirements.

Standard Structure:

📋 Dashboard (home page)
├── 🎯 Projects (database)
│   ├── Views: Board (by Status), Timeline, Table
│   └── Templates: New Project, Sprint, Epic
├── ✅ Tasks (database, related to Projects)
│   ├── Views: My Tasks, Sprint Board, Backlog
│   └── Templates: Bug, Feature, Chore
├── 📚 Wiki (page tree)
│   ├── Engineering
│   ├── Product
│   └── Operations
├── 📝 Meeting Notes (database)
│   ├── Views: This Week, By Project
│   └── Templates: Standup, Retro, 1:1
└── 🔗 Resources (bookmarks database)

2. Database Design

Property Types Guide:

Need	Property Type	Example
Workflow state	Status	To Do → In Progress → Done
Category	Select	Bug, Feature, Chore
Multiple tags	Multi-select	frontend, backend, urgent
Linked entity	Relation	Project ↔ Tasks
Computed from relations	Rollup	COUNT(Tasks where Status=Done)
Calculated	Formula	dateBetween(now(), prop("Due Date"), "days")
Team member	Person	Assignee
Deadline	Date	Due Date with reminder
Priority	Select with colors	P0 🔴, P1 🟡, P2 🟢, P3 ⚪
Effort estimate	Number	Story Points
External link	URL	Figma/GitHub/Slack link

3. Notion Formulas (Common Patterns)

// Days until due
dateBetween(prop("Due Date"), now(), "days")

// Status badge
if(prop("Status") == "Done", "✅", if(prop("Status") == "In Progress", "🔵", "⬜"))

// Overdue check
if(prop("Due Date") < now() and prop("Status") != "Done", true, false)

// Progress percentage
round(prop("Tasks Done") / prop("Tasks Total") * 100)

// Sprint assignment
if(prop("Due Date") >= dateStart(prop("Sprint")) and prop("Due Date") <= dateEnd(prop("Sprint")), prop("Sprint Name"), "Backlog")

4. Integration Patterns

Notion ↔ Make.com

Make Trigger (Webhook/Schedule)
→ Search Notion Database (filter by property)
→ Create/Update Notion Page
→ Notification (Slack/Email)

Key Make.com Notion modules:

• notion:CreateAPage — Create page in database
• notion:UpdateAPage — Update properties
• notion:SearchObjects — Query databases with filters
• notion:GetAPage — Read specific page
• notion:ListDatabaseItems — List with filters/sorts
• notion:AppendBlockChildren — Add content blocks

Notion ↔ Airtable Sync

Airtable Watch → Filter (modified) → Search Notion (find match)
  ├─ [exists] → Update Notion Page
  └─ [new] → Create Notion Page

Notion as Documentation Hub

GitHub PR Merged → Create Notion page in Wiki/Changelog
  → Add content blocks: title, date, PR link, description
  → Link to Project database entry

5. Template System

Project Template:

# 🎯 {Project Name}

## Overview
- **Owner:** @person
- **Status:** 🟡 In Progress
- **Timeline:** Start → End

## Goals
1. Goal 1
2. Goal 2

## Resources
- [Figma](#) | [GitHub](#) | [Slack](#)

## Decision Log
| Date | Decision | Rationale |
|------|----------|-----------|

## Tasks
{{Linked Tasks Database View}}

Meeting Notes Template:

# 📝 {Meeting Type} — {Date}

## Attendees
@person1 @person2

## Agenda
1. Item 1
2. Item 2

## Notes
-

## Action Items
- [ ] @person — Task — Due: date

## Follow-up
Next meeting: date

6. MCP Tools Available

Use Notion MCP tools for direct workspace management:

• mcp__claude_ai_Notion__notion-search — Find pages/databases
• mcp__claude_ai_Notion__notion-create-pages — Create pages
• mcp__claude_ai_Notion__notion-update-page — Update properties
• mcp__claude_ai_Notion__notion-create-database — Create databases
• mcp__claude_ai_Notion__notion-create-view — Create views
• mcp__claude_ai_Notion__notion-get-users — List workspace users
• mcp__claude_ai_Notion__notion-get-comments / create-comment — Comments
• mcp__claude_ai_Notion__notion-duplicate-page — Clone templates
• mcp__claude_ai_Notion__notion-fetch — Read any Notion resource

Rules

1. Always start with a Dashboard page that links to all key databases
2. Use database Relations instead of manual cross-references
3. Create Templates for every recurring page type
4. Use Toggle blocks to keep pages scannable (hide details)
5. Prefer Status property (built-in) over Select for workflow states
6. Name views descriptively: "My Active Tasks" not "View 1"
7. Use Callout blocks for warnings, tips, and important notes