/start-12-4.en

description: "Lesson command"
chapter: "courses/aiagent/lesson03-core/module12-notion"
prerequisites: ["start-12-3"]
duration: "~35 min"
level: "intermediate"
tags: ["notion", "database", "automation", "summarize"]
nonInteractiveMode: deferred

🎓 Lesson 12-4: Automated Report Generation

📍 What You'll Do

**Lesson 12-4** !

| Item | Details | |------|------| | Goal | **Structurally summarize** pages and DB rows obtained in **one or a few retrievals** via Notion MCP / API for chat | | Duration | ~35 min | | Skills used | Notion MCP (search / fetch / query), ncli as needed | | Prerequisites | `/start-12-3` completed, Notion connected | | Course page | [Module 12: Notion](https://ai-agent.camp/en/course/module-12) alongside this lesson |

**Session flow:** 1. Narrow down databases or pages to **a single batch using queries/filters** for retrieval 2. Summarize **key points, counts, and next actions** as bullet points from the retrieved JSON/text 3. To save tokens, follow the rule of **not pasting full text** and determining the citation range

By the end of this session, you will be able to reproduce the full flow: "Retrieve -> Summarize -> Return to user".

> **💡 Hint**: If the AI response stops midway, type "please continue" or "keep going" to resume. This is a Cursor behavior, not a malfunction.

> **How to read this lesson**: The following Steps include examples from database creation to updates. If you already have a DB, skip Step 1 and practice always returning a "summary (count, key points, next actions)" to chat **after queries and fetches**.

---

🎯 Readiness Check

Let's first check that everything is ready.

**AskQuestion configuration:**

{
  "title": "🎯 Pre-session check",
  "questions": [{
    "id": "readiness",
    "prompt": "Are you ready?",
    "options": [
      {"id": "ready", "label": "Ready! Let's start"},
      {"id": "check_prereq", "label": "Check prerequisites"},
      {"id": "view_html", "label": "View the course page first"},
      {"id": "different_lesson", "label": "Go to a different lesson"}
    ]
  }]
}

(ready → Go to Step 1) (check_prereq → Run prerequisite verification) (view_html → Show course page path) (different_lesson → Display module list)

---

🚀 Step 1: Create Task Management Database

Use AskQuestion to choose "Proceed / Just review the example / Skip".

**AskQuestion configuration:**

{
  "title": "🚀 Step 1: Create Task Management Database",
  "questions": [{
    "id": "step_action",
    "prompt": "What would you like to do with this step?",
    "options": [
      {"id": "practice", "label": "Proceed"},
      {"id": "review", "label": "Just review the example"},
      {"id": "skip", "label": "Skip"}
    ]
  }]
}

**Guidance after selection:** Input:

Please create the following database in Notion:

Database name: Project Tasks

Properties:
1. Task Name (Title)
2. Status (Select)
   - Not Started (gray)
   - In Progress (blue)
   - In Review (yellow)
   - Completed (green)
3. Deadline (Date)
4. Priority (Select)
   - Urgent (red)
   - High (orange)
   - Medium (yellow)
   - Low (gray)
5. Estimated Hours (Number) - in hours
6. Category (Multi-select)
   - Development
   - Design
   - Planning
   - Documentation

**Expected result:** A database with properties is created in Notion.

---

🚀 Step 2: Add Sample Tasks

Use AskQuestion to choose "Proceed / Just review the example / Skip".

**AskQuestion configuration:**

{
  "title": "🚀 Step 2: Add Sample Tasks",
  "questions": [{
    "id": "step_action",
    "prompt": "What would you like to do with this step?",
    "options": [
      {"id": "practice", "label": "Proceed"},
      {"id": "review", "label": "Just review the example"},
      {"id": "skip", "label": "Skip"}
    ]
  }]
}

**Guidance after selection:** Input:

Please add the following tasks to the "Project Tasks" database:

1. Task name: Create API Documentation
   - Status: Not Started
   - Deadline: Next Friday
   - Priority: High
   - Estimated hours: 4
   - Category: Documentation

2. Task name: Implement User Authentication
   - Status: In Progress
   - Deadline: 3 days later
   - Priority: Urgent
   - Estimated hours: 8
   - Category: Development

3. Task name: Create UI Mockup
   - Status: Not Started
   - Deadline: 5 days later
   - Priority: Medium
   - Estimated hours: 6
   - Category: Design

After adding, display the database contents.

**Expected result:** 3 tasks are added to the database.

---

🚀 Step 3: Data Retrieval and Filtering

Use AskQuestion to choose "Proceed / Just review the example / Skip".

**AskQuestion configuration:**

{
  "title": "🚀 Step 3: Data Retrieval and Filtering",
  "questions": [{
    "id": "step_action",
    "prompt": "What would you like to do with this step?",
    "options": [
      {"id": "practice", "label": "Proceed"},
      {"id": "review", "label": "Just review the example"},
      {"id": "skip", "label": "Skip"}
    ]
  }]
}

**Guidance after selection:** Input:

Please retrieve tasks from the "Project Tasks" database with the following conditions:

Query 1: Get all tasks
- Retrieve and display all tasks

Query 2: Incomplete tasks only
- Retrieve tasks whose status is not "Completed"

Query 3: High priority tasks
- Retrieve tasks with "Urgent" or "High" priority
- Sort by deadline

Display each result in table format.

**Expected result:** Tasks matching the conditions are retrieved and displayed.

---

🚀 Step 4: Update Tasks

Use AskQuestion to choose "Proceed / Just review the example / Skip".

**AskQuestion configuration:**

{
  "title": "🚀 Step 4: Update Tasks",
  "questions": [{
    "id": "step_action",
    "prompt": "What would you like to do with this step?",
    "options": [
      {"id": "practice", "label": "Proceed"},
      {"id": "review", "label": "Just review the example"},
      {"id": "skip", "label": "Skip"}
    ]
  }]
}

**Guidance after selection:** Input:

Pl