Connecting to Data · Legacy self-service product
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
| Template | Object | Data Mode | Best For | What You'll Analyze |
|---|---|---|---|---|
| Database Inventory (Default) | databases | Snapshot | Workspace organization | Database structure, key data sources |
| Page Activity & Edits | pages | Snapshot | Content tracking | Creation activity, recent edits |
| Workspace Members | users | Sync | Team directory | Team composition, collaboration |
| Archived Content | pages | Snapshot | Content cleanup | Archived 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
- Create a new dataset in Scoop
- Select Notion from the application list
- Enter your Internal Integration Token
- Go to Notion Integrations
- Create a new integration or select an existing one
- Copy the Internal Integration Token
- Important: Share pages/databases with your integration
- Open the pages or databases you want to analyze
- Click "Share" and invite your integration
- Choose your analysis template or customize
- Save and extract data
What Data You Get
Databases (11 fields)
Structured data containers with custom properties.
| Field | Description |
|---|---|
| Database ID | Unique identifier (prefixed with NO) |
| Title | Database name |
| Description | Database description |
| Created Date | When database was created |
| Last Edited Date | Most recent edit time |
| Created By | User who created the database |
| Last Edited By | User who last edited |
| Parent Type | workspace, page_id, or block_id |
| Parent ID | ID of parent container |
| URL | Link to database |
| Archived | Whether database is archived |
| Is Inline | Whether database is inline in a page |
Pages (11 fields)
Documents and content pages.
| Field | Description |
|---|---|
| Page ID | Unique identifier |
| Title | Page title |
| Created Date | When page was created |
| Last Edited Date | Most recent edit time |
| Created By | User who created the page |
| Last Edited By | User who last edited |
| Parent Type | workspace, database_id, page_id, or block_id |
| Parent ID | ID of parent container |
| URL | Link to page |
| Archived | Whether page is archived |
| In Trash | Whether page is in trash |
Users (5 fields)
Workspace members and integrations.
| Field | Description |
|---|---|
| User ID | Unique identifier |
| Name | User or bot name |
| Type | person or bot |
| Email address (people only) | |
| Avatar URL | Profile 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