Notion Workflow Automator

Automate Notion workflows by creating databases, pages, templates, and integrations using the Notion API. Use when you need to set up project management systems, knowledge bases, content calendars, or automated documentation pipelines in Notion.

Prerequisites

• Notion integration token (create at https://www.notion.so/my-integrations)
• Target workspace with the integration connected to relevant pages
• NOTION_TOKEN environment variable or pass token directly

Usage

"Set up a content calendar in Notion for our blog"
"Create a sprint planning database with custom properties"
"Build a knowledge base template with categories and tags"
"Sync GitHub issues to a Notion database"
"Create a meeting notes template with action items tracking"

How It Works

1. Workspace Discovery

• List accessible databases and pages via Notion API
• Map existing structure to understand the workspace layout
• Identify where new content should be created

curl -s -H "Authorization: Bearer $NOTION_TOKEN" \
  -H "Notion-Version: 2022-06-28" \
  "https://api.notion.com/v1/search" \
  --data '{"filter":{"property":"object","value":"database"}}' | python3 -c "
import json, sys
data = json.load(sys.stdin)
for r in data.get('results', []):
    title = ''.join(t['plain_text'] for t in r.get('title', []))
    print(f'{r[\"id\"]}: {title}')
"

2. Database Design

When creating databases, analyze the use case and design optimal properties:

Project Management:

• Status (select): Not Started, In Progress, In Review, Done, Blocked
• Priority (select): P0-Critical, P1-High, P2-Medium, P3-Low
• Assignee (people)
• Due Date (date)
• Sprint (select)
• Story Points (number)
• Tags (multi-select)

Content Calendar:

• Publication Date (date)
• Status (select): Idea, Drafting, Review, Scheduled, Published
• Channel (multi-select): Blog, Twitter, LinkedIn, Newsletter
• Author (people)
• Content Type (select): Article, Thread, Video, Infographic
• SEO Keywords (rich_text)

Knowledge Base:

• Category (select)
• Tags (multi-select)
• Last Reviewed (date)
• Owner (people)
• Status (select): Draft, Published, Needs Update, Archived

3. Template Generation

Create page templates with structured content:

• Meeting notes with attendees, agenda, decisions, action items
• Sprint retrospective with what went well, improvements, actions
• RFC/design doc with problem statement, proposed solution, alternatives, decision
• Bug report with reproduction steps, expected/actual behavior, environment
• Weekly status update with accomplishments, plans, blockers, metrics

4. Automation Rules

Design workflow automations:

• Status transitions: When status changes to "Done", auto-set completion date
• Recurring tasks: Generate weekly/monthly recurring items
• Cross-database relations: Link sprint items to epics, bugs to features
• Rollup calculations: Sprint velocity, completion rates, team workload
• Notifications: Flag overdue items, approaching deadlines

5. Content Population

• Generate initial content for templates using AI
• Pre-populate databases with sample data for testing
• Import data from CSV, JSON, or other tools
• Create linked databases for different team views

6. Integration Setup

Guide users through connecting Notion with external tools:

• GitHub: Sync issues, PRs, and commits to Notion databases
• Slack: Post database updates to channels
• Calendar: Sync Notion dates to Google Calendar
• CI/CD: Update deployment status in Notion

Output

Produces a structured report:

## Notion Workspace Setup Complete

### Created
- 📊 Database: "Q2 Sprint Board" (ID: abc123)
  - 8 properties configured
  - 3 views: Board, Table, Calendar
- 📄 Templates: 4 page templates added
  - Sprint Planning, Retrospective, Bug Report, Weekly Update
- 🔗 Relations: Connected to "Product Roadmap" database

### Automation Notes
- Status → Done auto-sets "Completed On" property
- Overdue items flagged with 🔴 icon daily
- Weekly rollup calculates sprint velocity

### Next Steps
1. Connect the integration to your Slack workspace
2. Import existing backlog from [source]
3. Share database with team members

Error Handling

• Invalid token → guide through integration creation
• Missing permissions → show which pages need integration access
• API rate limits → batch operations, retry with backoff
• Schema conflicts → validate property types before creation