Skip to content

indranilbanerjee/neels-plugins / hermes/digital-marketing-pro/social/skills/parse-calendar

parse-calendar

Unverified

Parse a content calendar or plan from DOCX, XLSX, Notion or pasted text into structured posts. "load this month's calendar"

/socialforge:parse-calendar — Calendar Parser

Parse a monthly social media content calendar into structured JSON that drives the entire production pipeline.

Context efficiency

Asset-heavy skill. Grep before Read the asset catalog (${CLAUDE_PLUGIN_DATA}/socialforge/brands/<brand>/asset-index.json) — never list the asset directory. Reference generated images / videos by path, not by loading metadata. Brand profile loads once per session.

Supported Formats

FormatHow It Works
DOCXRead tables and structured text from Word documents
XLSXRead rows from Excel spreadsheets (one row per post)
NotionRead from Notion database via MCP (requires Notion connector)
Structured textParse markdown or plain text with consistent formatting — pasted inline (--paste) or from a .txt path

Required Fields Per Post

Every post in the calendar must have (or the system will ask for missing ones):

FieldRequiredDescription
post_idAuto-generatedUnique identifier (e.g., P01, P02)
dateYesPublishing date (YYYY-MM-DD)
platformYesTarget platform(s) — linkedin, instagram, x, facebook, etc.
content_typeYesstatic, carousel, video, story, reel, text_only
tierYesHERO, HUB, or HYGIENE
topicYesWhat the post is about
caption_briefYesBrief description of the copy direction
visual_briefRecommendedWhat the image should show
hashtagsOptionalPost-specific hashtags (brand hashtags added automatically)
ctaOptionalCall-to-action text or link
campaignOptionalCampaign this post belongs to
notesOptionalSpecial instructions

Process

  1. Detect format — Check file extension or URL pattern
  2. Extract posts — Parse each post entry from the source
  3. Validate fields — Check required fields present. For missing fields, ask the user.
  4. Normalize — Standardize dates, platform names, content types to schema format
  5. Assign post IDs — Sequential (P01, P02, ...) if not already present
  6. Cross-reference platforms — Check all platforms exist in brand's platform-config.json
  7. Flag issues — Duplicate dates, missing briefs, unsupported content types
  8. Save — Write calendar-data.json to ${CLAUDE_PLUGIN_DATA}/socialforge/output/{brand}/{YYYY-MM}/ (falls back to ~/socialforge-workspace/output/... when ${CLAUDE_PLUGIN_DATA} is unset)

Output

Calendar parsed: 28 posts for April 2026
  LinkedIn: 12 posts (4 carousels, 6 static, 2 video)
  Instagram: 10 posts (3 carousels, 4 reels, 3 static)
  X: 6 posts (all text+image)

Issues found: 2
  - P14: Missing visual_brief (will need manual input during asset matching)
  - P22: Date falls on Sunday — confirm intentional weekend post?

Calendar saved: ${CLAUDE_PLUGIN_DATA}/socialforge/output/acme-corp/2026-04/calendar-data.json

After Parsing

Ask: "Would you like to:

  • Match assets to posts? (/socialforge:match-assets)
  • Review the parsed calendar first? (I'll show the full post list)
  • Fix issues? (I'll walk through each flagged item)"

Timeout & Fallback

  • DOCX/XLSX parsing: 30-second timeout. If file is too large, suggest splitting by week.
  • Notion: 60-second timeout per database query. If Notion is slow, offer to export and parse locally.
  • If format is unrecognized: Ask user to describe the structure, then parse adaptively.
canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill.Stars: 196kUpdated Claude CodeCodexVerifiedInstall