How to Connect Notion CLI to OpenClaw

1# Option A: Install official Notion SDK for scripting:
2npm install -g @notionhq/client
3# Verify:
4node -e "const { Client } = require('@notionhq/client'); console.log('Notion SDK ready')"
5
6# Option B: Install community Notion CLI:
7npm install -g notion-cli-js
8# Verify:
9notion-cli --version
10
11# Option C: Use npx for one-off operations without global install:
12npx @notionhq/client --version
13
14# Test with your API key:
15export NOTION_API_KEY="secret_xxxxxxxxxxxxxxxxxxxx"
16node -e "
17const { Client } = require('@notionhq/client');
18const notion = new Client({ auth: process.env.NOTION_API_KEY });
19notion.users.me().then(u => console.log('Connected as:', u.type));
20"

1# ~/.openclaw/config.yaml
2integrations:
3  notion_cli:
4    env:
5      NOTION_API_KEY: "${NOTION_API_KEY}"   # Injected into all CLI command environments
6      NOTION_VERSION: "2022-06-28"
7    script_dir: ~/.openclaw/notion-scripts   # Directory for Notion CLI scripts
8    node_path: /usr/local/bin/node           # Path to node binary (run: which node)
9    databases:
10      projects: "a1b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6"
11      tasks: "b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6q7"
12      reports: "c3d4e5f6g7h8i9j0k1l2m3n4o5p6r8s9"
13    timeout: 120                             # Max seconds for a CLI command to run
14    output_format: json                      # Expected output format from scripts

1#!/usr/bin/env node
2// ~/.openclaw/notion-scripts/query-database.js
3// Usage: node query-database.js DATABASE_ID [status_filter]
4
5const { Client } = require('@notionhq/client')
6
7const notion = new Client({ auth: process.env.NOTION_API_KEY })
8const databaseId = process.argv[2]
9const statusFilter = process.argv[3]
10
11if (!databaseId) {
12  process.stderr.write('Usage: node query-database.js DATABASE_ID [status_filter]\n')
13  process.exit(1)
14}
15
16async function queryDatabase() {
17  const filter = statusFilter ? {
18    property: 'Status',
19    select: { equals: statusFilter }
20  } : undefined
21
22  const response = await notion.databases.query({
23    database_id: databaseId,
24    filter,
25    sorts: [{ property: 'Created', direction: 'descending' }],
26    page_size: 100
27  })
28
29  // Output clean JSON to stdout
30  const results = response.results.map(page => ({
31    id: page.id,
32    title: page.properties.Name?.title?.[0]?.text?.content || 'Untitled',
33    status: page.properties.Status?.select?.name || null,
34    created: page.created_time
35  }))
36  console.log(JSON.stringify({ count: results.length, items: results }, null, 2))
37}
38
39queryDatabase().catch(err => {
40  process.stderr.write(`Error: ${err.message}\n`)
41  process.exit(1)
42})

1#!/usr/bin/env node
2// ~/.openclaw/notion-scripts/bulk-update-status.js
3// Usage: node bulk-update-status.js DATABASE_ID OLD_STATUS NEW_STATUS [--dry-run]
4
5const { Client } = require('@notionhq/client')
6const notion = new Client({ auth: process.env.NOTION_API_KEY })
7
8const [,, databaseId, oldStatus, newStatus] = process.argv
9const dryRun = process.argv.includes('--dry-run')
10
11async function getAllPages(dbId, filterStatus) {
12  let allPages = []
13  let cursor
14  do {
15    const response = await notion.databases.query({
16      database_id: dbId,
17      start_cursor: cursor,
18      filter: { property: 'Status', select: { equals: filterStatus } },
19      page_size: 100
20    })
21    allPages = allPages.concat(response.results)
22    cursor = response.has_more ? response.next_cursor : null
23    process.stderr.write(`Fetched ${allPages.length} pages...\n`)
24  } while (cursor)
25  return allPages
26}
27
28async function run() {
29  const pages = await getAllPages(databaseId, oldStatus)
30  process.stderr.write(`Found ${pages.length} pages with status '${oldStatus}'\n`)
31  if (dryRun) {
32    console.log(JSON.stringify({ dry_run: true, would_update: pages.length, from: oldStatus, to: newStatus }))
33    return
34  }
35  let updated = 0
36  for (const page of pages) {
37    await notion.pages.update({
38      page_id: page.id,
39      properties: { Status: { select: { name: newStatus } } }
40    })
41    updated++
42    await new Promise(r => setTimeout(r, 350)) // Respect rate limit (3 req/sec)
43  }
44  console.log(JSON.stringify({ updated, from: oldStatus, to: newStatus }))
45}
46
47run().catch(err => { process.stderr.write(err.message + '\n'); process.exit(1) })

1# ~/.openclaw/config.yaml — scheduled Notion CLI batch jobs
2workflows:
3  notion-nightly-export:
4    schedule: "0 23 * * *"           # Run at 11 PM every night
5    timezone: "America/New_York"
6    steps:
7      - name: export-tasks-db
8        type: shell
9        command: node ~/.openclaw/notion-scripts/query-database.js
10        args:
11          - "{{config.integrations.notion_cli.databases.tasks}}"
12        capture_stdout: true
13        on_failure: notify_and_stop
14      - name: save-export
15        type: shell
16        command: bash
17        args:
18          - "-c"
19          - "echo '{{steps.export-tasks-db.output}}' > ~/.openclaw/backups/tasks-$(date +%Y%m%d).json"
20      - name: cleanup-old-backups
21        type: shell
22        command: find
23        args:
24          - "~/.openclaw/backups"
25          - "-name"
26          - "tasks-*.json"
27          - "-mtime"
28          - "+30"
29          - "-delete"
30
31  notion-weekly-stale-cleanup:
32    schedule: "0 9 * * 1"            # Every Monday at 9 AM
33    steps:
34      - name: archive-stale-tasks
35        type: shell
36        command: node ~/.openclaw/notion-scripts/bulk-update-status.js
37        args:
38          - "{{config.integrations.notion_cli.databases.tasks}}"
39          - "In Progress"
40          - "Stale"