Projects09. Notion Database SchemaExecutive Summary
Executive Summary0 min read

09. Notion Database Schema

Inside the content engine: Explore the advanced Notion Database schema that acts as the command center for OmniPost AI's n8n Agentic workflows.

📋 Notion Content Calendar Properties Reference

Database Name: Social Content Queue
Purpose: Central hub for managing content lifecycle across multiple social platforms
Last Updated: January 12, 2026


📖 Table of Contents


Overview

Notion Content Queue
Notion Content Queue

Notion Database Schema
Notion Database Schema

The Social Content Queue database is the backbone of the Omni-Post AI automation system. It manages the entire content lifecycle from ideation to multi-platform publishing. This document provides a complete reference of all properties for use in n8n automations.

Total Properties: 31


Property Categories

CategoryCountPurpose
Core Content3Title and categorization
Publishing Control3Status tracking and platform selection
SEO & Metadata6Search optimization and canonical URLs
Platform-Specific Drafts5Generated content for each platform
Asset Management5Images and file handling
Scheduling & Timing4Posting times and dates
System & Tracking5Internal IDs and logs

All Properties (Detailed)

1. Core Content Properties


📝 Content Pages

AttributeValue
TypeTitle
DescriptionThe primary name/title of the content entry. This is the main identifier for each content piece.
Usage in AutomationUsed to identify the content item being processed. Appears as the row name in the database.
Example ValuesATC-01: ₹3 Lakh Organic Revenue Case Study, Agentic AI

📂 Category

AttributeValue
TypeMulti-select
DescriptionCategorizes the content by topic/theme. Multiple categories can be assigned to a single entry.
Available Options
OptionColorDescription
LearningsYellowPersonal learning insights and takeaways
ProjectsPinkProject-related content and case studies
AIRedArtificial Intelligence related content
Web DevelopmentBlueWeb dev tutorials and insights
Technical DocumentationGrayTechnical deep-dives and documentation
n8nPurpleN8N automation-specific content

⭐ Priority

AttributeValue
TypeSelect
DescriptionIndicates the priority level for content creation and publishing.
Available Options
OptionColorDescription
HighRedUrgent content that should be prioritized
MediumYellowStandard priority content
LowGreenCan be scheduled for later

2. Publishing Control Properties


📤 Post To

AttributeValue
TypeMulti-select
DescriptionSpecifies which platforms this content should be published to. Acts as the target platform selector.
Available Options
OptionColorDescription
XBlackTwitter/X platform
LinkedInBlueLinkedIn platform
BlogGreenPersonal Sanity.io blog
Dev.toPurpleDev.to blogging platform
HashnodeBlueHashnode blogging platform

🔄 Status

AttributeValue
TypeSelect
DescriptionThe overall workflow status of the content piece. Tracks where the content is in the generation/approval pipeline.
Available Options
OptionColorDescription
Pending ApprovalYellowContent generated, awaiting review
Needs EditOrangeContent requires manual edits
Posted To All PlatformsGreenSuccessfully published everywhere

✅ Post Status

AttributeValue
TypeMulti-select
DescriptionGranular status tracking for each individual platform posting. Shows which platforms have received the content.
Available Options
OptionColorDescription
LinkedInPostGeneratedBlueDraft created for LinkedIn
Posted at XBlackSuccessfully posted to Twitter/X
Posted at LinkedInBlueSuccessfully posted to LinkedIn
Posted at Portfolio BlogGreenSuccessfully posted to Sanity blog
Posted at Dev.toPurpleSuccessfully posted to Dev.to
Posted at HashnodeTealSuccessfully posted to Hashnode

3. SEO & Metadata Properties


🔗 Shared_Slug

AttributeValue
TypeText
DescriptionURL-friendly slug used across all blog platforms. Ensures consistent URLs across Sanity, Dev.to, and Hashnode.
FormatLowercase, hyphen-separated (e.g., nextjs-n8n-automation-revenue-case-study)
Example Valuesnextjs-n8n-automation-revenue-case-study

🏷️ Shared_SEO_Title

AttributeValue
TypeText
DescriptionThe SEO-optimized title used in meta tags across all blog platforms.
Example Values₹3 Lakh Organic Revenue Case Study: Next.js & n8n Automation

📄 Shared_SEO_Description

AttributeValue
TypeText
DescriptionMeta description for SEO purposes. Used in search engine snippets and social sharing previews.
Character LimitRecommended 150-160 characters
Example ValuesHow I built a zero-cost lead generation machine using Next.js 14 and n8n that generated ₹3,00,000+ in organic revenue for an aviation institute.

🌐 Shared_Canonical_URL

AttributeValue
TypeURL / Formula
DescriptionThe canonical URL pointing to the primary blog version. Used to prevent duplicate content issues across platforms.
FormatFull URL to the primary blog post
Example Valueshttps://amansuryavanshi.me/blog/nextjs-n8n-automation-revenue-case-study

🏷️ Shared_Tags

AttributeValue
TypeMulti-select
DescriptionTechnical tags and topics used across all platforms for categorization and discoverability. Extensive list of technology and topic tags.
Available Options (Extensive List)
TagCategory
NextjsFramework
n8nAutomation
AutomationGeneral
SEOMarketing
CaseStudyContent Type
Next.js 14 automationFramework
n8n lead generationAutomation
organic revenue case studyContent Type
zero-cost tech stackArchitecture
business automation specialistProfessional
React optimizationFramework
Core Web VitalsPerformance
code splittingPerformance
lazy loadingPerformance
WebPPerformance
Tailwind CSS optimizationPerformance
React.memoPerformance
useMemoPerformance
next/dynamicFramework

📂 hasImages / Assets

AttributeValue
TypeCheckbox
DescriptionBoolean flag indicating whether this content has associated images or assets.
Valuestrue (checked) / false (unchecked)
Usage in AutomationUsed to conditionally fetch and process images in the workflow.

4. Platform-Specific Draft Properties


🐦 Twitter Draft

AttributeValue
TypeText (Long)
DescriptionGenerated content optimized for Twitter/X. Contains the full thread or tweet content.
FormatTwitter-optimized text with hashtags, mentions, and thread formatting
Example Content#NextJS #n8n #automation #SEO (hashtag section) + thread content

💼 LinkedIn Draft

AttributeValue
TypeText (Long)
DescriptionGenerated content optimized for LinkedIn's professional audience. Longer-form, professional tone.
FormatLinkedIn-style post with section headers, bullet points, and professional formatting
Example StructureHook → Problem → Solution → Results → Technical Details → CTA

📝 Sanity Blog Draft

AttributeValue
TypeText (Rich Text / Long)
DescriptionFull blog article content for the Sanity.io-powered personal blog. Contains complete article with all sections.
FormatMarkdown or Portable Text compatible format
Sections Typically IncludedIntroduction, Problem Statement, The Workflow Logic, Technical Hurdles, Pro Tips, Conclusion

💻 DevTo Draft

AttributeValue
TypeText (Long)
DescriptionBlog content formatted for Dev.to's markdown-based platform.
FormatMarkdown with Dev.to frontmatter compatibility
Special FeaturesMermaid diagram support, code syntax highlighting

🟦 Hashnode Draft

AttributeValue
TypeText (Long)
DescriptionBlog content formatted for Hashnode's publishing platform.
FormatMarkdown with Hashnode-specific formatting
Special FeaturesMermaid diagrams, implementation deep-dives

📰 Hashnode_Subtitle

AttributeValue
TypeText
DescriptionSubtitle/deck text specifically for Hashnode articles. Appears below the main title.
Example Values## Implementation Deep Dive: The Non-Blocking Webhook Strategy

5. Asset Management Properties


🖼️ imagesURL

AttributeValue
TypeText / URL
DescriptionURL(s) to the images associated with this content. Can contain multiple comma-separated URLs.
FormatSingle URL or comma-separated list of URLs

📎 images

AttributeValue
TypeFiles & Media
DescriptionDirect file attachments for images associated with the content.
Supported FormatsPNG, JPG, WebP, GIF

📋 Image Task List

AttributeValue
TypeText
DescriptionList of image-related tasks or descriptions for image generation.
UsagePlanning image assets needed for the content

AttributeValue
TypeURL
DescriptionDirect link to the Google Drive folder containing all assets for this content piece. Session-based organization.
FormatGoogle Drive folder URL

📝 Notes

AttributeValue
TypeText (Long)
DescriptionGeneral notes, reminders, or additional context for the content piece.
UsageManual notes, special instructions, or context for future reference

6. Scheduling & Timing Properties


⏰ Processing Started

AttributeValue
TypeDate & Time
DescriptionTimestamp when the automation workflow started processing this content item.
FormatMonth DD, YYYY HH:MM AM/PM
Example ValuesJanuary 12, 2026 7:21 AM, October 23, 2025 7:30 AM

📅 PostedAt

AttributeValue
TypeDate & Time
DescriptionTimestamp when the content was actually published to the platforms.
FormatDate and time

💼 LinkedIn Best Time To Post

AttributeValue
TypeText
DescriptionRecommended optimal posting time for LinkedIn based on audience engagement data.
FormatTime recommendation or schedule

🐦 Twitter Best Time to post

AttributeValue
TypeText
DescriptionRecommended optimal posting time for Twitter/X based on audience engagement data.
FormatTime recommendation or schedule

7. System & Tracking Properties


🔢 ManualOrder

AttributeValue
TypeNumber
DescriptionManual ordering/sorting value for arranging content in a specific sequence.
UsageOverride automatic sorting when needed

🆔 SessionID

AttributeValue
TypeText
DescriptionUnique session identifier generated during workflow execution. Used for session-based file organization and preventing cross-contamination in concurrent runs.
FormatUUID or timestamp-based identifier

📊 Engagement Score

AttributeValue
TypeNumber
DescriptionMetric tracking the engagement level of posted content. Can be manually updated or calculated.
UsageTrack content performance post-publishing

⚠️ ErrorLog

AttributeValue
TypeText (Long)
DescriptionError messages and logs captured during automation execution. Used for debugging failed workflows.
UsageDebugging, error tracking, workflow monitoring

Quick Reference Table

Property NameTypeRequiredUsed in Part 1Used in Part 2
Content PagesTitle✅ Yes
Post ToMulti-select✅ Yes
StatusSelect✅ Yes
Post StatusMulti-select❌ No
CategoryMulti-select❌ No
PrioritySelect❌ No
Processing StartedDate & Time❌ No
Shared_SlugText✅ Yes
Shared_SEO_TitleText✅ Yes
Shared_SEO_DescriptionText✅ Yes
Shared_Canonical_URLURL✅ Yes
Shared_TagsMulti-select❌ No
hasImages / AssetsCheckbox❌ No
imagesURLText❌ No
imagesFiles❌ No
Image Task ListText❌ No
NotesText❌ No
ErrorLogText❌ No
Drive Folder LinkURL❌ No
PostedAtDate & Time❌ No
Engagement ScoreNumber❌ No
Twitter DraftText✅ Yes
LinkedIn DraftText✅ Yes
Sanity Blog DraftText✅ Yes
DevTo DraftText✅ Yes
Hashnode DraftText✅ Yes
Hashnode_SubtitleText❌ No
SessionIDText✅ Yes
ManualOrderNumber❌ No
LinkedIn Best Time To PostText❌ No
Twitter Best Time to postText❌ No

🔧 Usage Notes for Automations

Fetching Content from Notion

When building n8n workflows that interact with this database:

  1. Filter by Status: Use Status = Pending Approval to get items ready for publishing
  2. Filter by Post To: Check Post To contains the target platform
  3. Check hasImages: Conditionally process images only when hasImages / Assets is true
  4. Update Post Status: Add platform-specific status after successful posting

Updating Properties via API

javascript

Session Management

  • Always generate a unique SessionID at the start of each workflow run
  • Use SessionID to organize Google Drive folders and track related files
  • Reference SessionID when logging errors to ErrorLog

Document Version: 1.0
Created: January 12, 2026
Maintained by: Omni-Post AI Automation System
Related Docs: Executive Summary | Architecture & Flow