Notion

Analyze databases, pages, and workspace activity

Connect Notion to Scoop to analyze your workspace structure, track content activity, and understand how your team uses Notion for collaboration.

AI-Assisted Setup

When connecting Notion to Scoop, choose "Guide me with AI" for an intelligent, guided setup experience.

Available Analysis Templates

TemplateObjectData ModeBest ForWhat You'll Analyze
Database Inventory (Default)databasesSnapshotWorkspace organizationDatabase structure, key data sources
Page Activity & EditspagesSnapshotContent trackingCreation activity, recent edits
Workspace MembersusersSyncTeam directoryTeam composition, collaboration
Archived ContentpagesSnapshotContent cleanupArchived or trashed pages

Example Questions You Can Answer

Workspace Organization:

  • "How many databases do we have in the workspace?"
  • "Which databases were created this month?"
  • "What's the distribution of databases by parent page?"
  • "How many databases are archived?"
  • "Who creates the most databases?"

Content Activity:

  • "Which pages were edited this week?"
  • "Who is most active in editing content?"
  • "How many pages have been created over time?"
  • "What's the ratio of active to archived pages?"
  • "Which pages haven't been touched in months?"

Team Collaboration:

  • "Who are all the members in our workspace?"
  • "How many human users vs bots/integrations?"
  • "Who edits the most content?"
  • "What's our content creation trend by person?"

Content Health:

  • "How many pages are in the trash?"
  • "What content has been archived?"
  • "Which databases are no longer maintained?"
  • "What's our stale content percentage?"

Need Something Different?

If the templates above don't match your needs, select "Something else" and describe what you want to analyze. For example:

  • "I want to track database edit frequency"
  • "I need to see content organized by parent page"
  • "I want to identify unused databases"

Scoop's AI will recommend the right configuration for your specific use case.

Snapshotting for Content Tracking

Notion content changes constantly - pages get edited, databases grow, content gets archived. Configure your extracts as Snapshot datasets to:

  • Track content creation velocity over time
  • Monitor editing activity patterns
  • Identify stale content that needs attention
  • Compare workspace structure changes

Pro Tip: Enable snapshotting for databases and pages. Documentation teams need historical data to understand content freshness and identify areas that need updates.

Connecting Notion to Scoop

  1. Create a new dataset in Scoop
  2. Select Notion from the application list
  3. Enter your Internal Integration Token
    • Go to Notion Integrations
    • Create a new integration or select an existing one
    • Copy the Internal Integration Token
  4. Important: Share pages/databases with your integration
    • Open the pages or databases you want to analyze
    • Click "Share" and invite your integration
  5. Choose your analysis template or customize
  6. Save and extract data

What Data You Get

Databases (11 fields)

Structured data containers with custom properties.

FieldDescription
Database IDUnique identifier (prefixed with NO)
TitleDatabase name
DescriptionDatabase description
Created DateWhen database was created
Last Edited DateMost recent edit time
Created ByUser who created the database
Last Edited ByUser who last edited
Parent Typeworkspace, page_id, or block_id
Parent IDID of parent container
URLLink to database
ArchivedWhether database is archived
Is InlineWhether database is inline in a page

Pages (11 fields)

Documents and content pages.

FieldDescription
Page IDUnique identifier
TitlePage title
Created DateWhen page was created
Last Edited DateMost recent edit time
Created ByUser who created the page
Last Edited ByUser who last edited
Parent Typeworkspace, database_id, page_id, or block_id
Parent IDID of parent container
URLLink to page
ArchivedWhether page is archived
In TrashWhether page is in trash

Users (5 fields)

Workspace members and integrations.

FieldDescription
User IDUnique identifier
NameUser or bot name
Typeperson or bot
EmailEmail address (people only)
Avatar URLProfile picture URL

Analysis Examples

Content Velocity

Track how fast content is created:

  • Daily/weekly page creation rate
  • Database creation trends
  • Content growth over time

Activity Monitoring

Understand who's active:

  • Most active editors
  • Recent edit activity
  • Content creation by user

Workspace Health

Assess documentation freshness:

  • Stale content (not edited recently)
  • Archived vs active ratio
  • Trash accumulation

Organization Insights

Understand workspace structure:

  • Databases per parent page
  • Content hierarchy analysis
  • Integration (bot) usage

Best Practices

  • Share with Integration: Only content shared with your integration will be accessible
  • Start with Databases: Databases are often the most valuable data sources
  • Enable Snapshotting: Track content changes over time
  • Monitor Archived Content: Regularly review what's being archived or trashed

Troubleshooting

Connection Issues

  • Verify your Internal Integration Token is correct
  • Ensure the integration is active (not revoked)
  • Check that you've shared relevant pages/databases with the integration

Missing Data

  • Only content shared with the integration is accessible
  • Ensure pages and databases are explicitly shared (workspace-level access isn't automatic)
  • Some workspace-level data requires workspace integration capabilities

Permission Errors

  • The integration needs to be added to each page/database you want to analyze
  • Parent pages don't automatically grant access to child pages
  • Check Notion's integration settings to verify capabilities