Notion Database Automation

Automate common Notion database operations like batch page creation, data filtering, content generation, and export. Use when you need to automate workflows...

Security Scan

The skill mostly implements the described Notion operations, but its metadata and documentation mismatch the code (missing files/templates, undeclared required credential, and references to AI features not implemented), so review before installing.

Purpose & Capability

The Python scripts call only the Notion API and implement querying, creating, updating (batch_create and export_csv exist), and exporting — which matches the stated purpose. However the documentation references additional artifacts that are not present (templates/ files and a batch_update.py script are mentioned but not included), and the README promises 'AI-generated summary' features that are not implemented and no LLM dependency is present. These mismatches reduce confidence in the package completeness and intent.

Instruction Scope

SKILL.md instructs the agent/user to pass a Notion API token (or set NOTION_API_TOKEN) and to share databases with the integration. The runtime instructions and code interact only with Notion endpoints and CSV/JSON files, which is appropriate. However SKILL.md also mentions using OpenClaw secrets and templates that are not shipped; the instructions rely on an environment variable that the registry metadata did not declare. There are minor import/path assumptions (some examples use scripts.notion_client while code uses a top-level notion_client import) that could cause runtime confusion.

Install Mechanism

There is no install spec (instruction-only style) and requirements.txt lists only requests. No external downloads, unknown URLs, or archive extraction are used. This is low-risk from an install mechanism perspective.

Credentials

The package requires a Notion API token (NOTION_API_TOKEN) to operate — the code enforces this — but the registry metadata lists no required environment variables or primary credential. That mismatch is important: the skill will need a secret but the manifest doesn't declare it. No other unrelated credentials are requested, which is proportionate, but the omission from metadata and the ability to pass the token via arguments means users should be careful about how they provide the token.

Persistence & Privilege

The skill does not request always:true, does not modify other skills, and has no install-time persistence. It runs only when invoked and does not claim or require elevated platform privileges.

What to consider before installing

This package appears to implement Notion database operations and uses only the official Notion API, but there are a few red flags you should consider before installing: - The manifest claims no required env vars, but both the docs and the code require a Notion API token (NOTION_API_TOKEN). Treat this token like any secret: only provide an integration token with minimal scope and share the specific databases with that integration rather than granting workspace-wide privileges. - The SKILL.md mentions files and features that aren't present (templates/ directory, a batch_update.py script, and 'AI-generated summary' behavior). That suggests the package or its documentation is incomplete or out-of-sync. Ask the publisher for the missing files or a corrected manifest if you need those features. - Review the code yourself (or have someone you trust do it) before giving the token to the skill. The scripts only make requests to api.notion.com and read/write CSV/JSON files, which is expected, but you should verify there are no hidden endpoints or additional network calls in other versions. - When testing, use a throwaway Notion integration and database (or limit integration access) so any unexpected behavior is contained. Avoid supplying long-lived or highly privileged tokens until you are confident in the package. If you need higher confidence, request a corrected manifest (declare NOTION_API_TOKEN as a required env var and include missing files) or obtain the package from a trusted source that publishes templates and the full codebase.

Automate repetitive tasks with Notion databases. Save hours of manual work by scripting common database operations.

Core Capabilities

1. Query and filter database entries

• Filter by any property type (text, select, date, checkbox, number)
• Sort by any column
• Fetch all matching entries with pagination handled automatically

2. Batch create pages

• Create multiple database entries from CSV/JSON data
• Auto-set all property types including relations and rollups
• Generate page content with AI

3. Batch update entries

• Update existing pages based on filters
• Bulk change property values
• Archive or delete multiple entries

4. Export database

• Export entire database to CSV/JSON/Markdown
• Preserve all property types
• Ready for analysis or backup

5. Create database from template

• Quickly spin up new databases from predefined schemas
• Common templates included (task tracker, content calendar, CRM)

Supported Property Types

• ✅ Text & Title
• ✅ Number
• ✅ Select & Multi-select
• ✅ Date
• ✅ Checkbox
• ✅ People
• ✅ URL
• ✅ Email
• ✅ Phone
• ✅ Relation
• ✅ Rollup (read-only)

Quick Start

Prerequisites

1. Create a Notion integration at https://www.notion.so/my-integrations
2. Get your API token
3. Share your database with the integration

Example: Query a database

from scripts.notion_client import NotionDBClient

client = NotionDBClient(api_token="YOUR_TOKEN")
entries = client.query_database(
    database_id="YOUR_DB_ID",
    filter={
        "property": "Status",
        "select": {
            "equals": "To Do"
        }
    },
    sorts=[{"property": "Created", "direction": "descending"}]
)

for entry in entries:
    print(entry["properties"]["Name"]["title"])

Example: Create multiple pages from CSV

from scripts.batch_create import create_from_csv

create_from_csv(
    api_token="YOUR_TOKEN",
    database_id="YOUR_DB_ID",
    csv_file="data.csv"
)

Common Workflows

Content Calendar Automation

1. Import a list of article topics from a spreadsheet
2. Auto-create calendar entries in Notion with scheduled publish dates
3. Add status = "Scheduled" automatically

Task Management Automation

1. Filter tasks due today
2. Send summary to your email/chat
3. Mark old tasks as archived automatically

CRM Lead Processing

1. When new leads come in, create Notion entries automatically
2. Assign properties based on source
3. Add AI-generated summary of the lead

Scripts

scripts/notion_client.py

Wrapper around the Notion API with simplified interface for common operations.

scripts/batch_create.py

Batch create database entries from CSV or JSON.

scripts/batch_update.py

Batch update entries matching filter conditions.

scripts/export_csv.py

Export entire Notion database to CSV file.

templates/

Pre-built database schemas for common use cases:

• content_calendar.json - Content calendar for bloggers/marketers
• task_tracker.json - Simple task tracker
• crm_basic.json - Basic CRM for small business

Authentication

The skill expects your Notion API token to be provided. You can:

• Pass it directly in code
• Set it as environment variable NOTION_API_TOKEN
• Use OpenClaw secrets for secure storage

When to use this skill

✅ Use when:

• You have repetitive tasks to do on a Notion database
• You need to import bulk data into Notion
• You want to export Notion data for analysis
• You need automated daily/weekly summaries from Notion

❌ Don't use when:

• You just need to manually edit a few pages (use the Notion UI)
• You don't have a Notion API token
• The database is not shared with your integration