skills.rest
aniketpanjwani
aniketpanjwaniCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

newsletter-events-write

Generate markdown newsletters from SQLite events using natural language formatting preferences.

40|13|Updated Dec 13, 2025
Search Tags:#markdown#newsletter#formatting#CLI#events
One-click install
npx skills add https://github.com/aniketpanjwani/local_media_tools --skill newsletter-events-write
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: newsletter-events-write
Source: https://github.com/aniketpanjwani/local_media_tools/tree/main/skills/newsletter-events-write
Command: npx skills add https://github.com/aniketpanjwani/local_media_tools --skill newsletter-events-write

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Convert your stored events into polished newsletters exactly the way you want, saving you hours of manual drafting.

Core Features & Use Cases

  • Natural-language Formatting: Claude formats newsletters according to your plain-English preferences.
  • Data-driven Output: Newsletters are generated from the events in your SQLite database.
  • Output Ready: Saves the markdown file newsletter_YYYY-MM-DD.md in the current directory.

Quick Start

Use the CLI to load events and generate a newsletter. For example:

  • Load upcoming events with the plugin: /newsletter-events:load
  • Then generate the newsletter: /newsletter-events:write

Frequently Asked Questions about newsletter-events-write

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a newsletter from events stored in SQLite?▼

Generate a newsletter by loading events from your SQLite database using the CLI tool, then use the write command to format them into a markdown file. Claude applies your natural-language formatting preferences to create newsletter_YYYY-MM-DD.md with event details sorted by date.

What event fields can I include in my generated newsletter?▼

Newsletters pull from SQLite event fields: title, venue, date, time, description, category, price, is_free, ticket_url, event_url, and source_url. You control which fields appear through formatting preferences, and Claude formats them according to your specifications.

Do I need to set up formatting preferences before generating a newsletter?▼

Formatting preferences are optional. If you provide plain-English preferences, Claude honors them in the newsletter layout. If preferences are missing, Claude applies sensible defaults to structure your events into a polished markdown file.

Can I automate newsletter creation from scraped events?▼

Yes. Store scraped events in SQLite at a configured path, then use the CLI to load events and trigger newsletter generation. Claude automatically formats them into markdown newsletters without manual drafting.

What output format does the newsletter use?▼

Newsletters are saved as markdown files named newsletter_YYYY-MM-DD.md in your current directory. Markdown formatting lets you easily share, version, or convert newsletters to other formats downstream.

Related Skills

Explore More Content & Communication Skills→
aniketpanjwanianiketpanjwani
40

newsletter-events-update-event

Re-scrape event pages via Firecrawl and update event records in the database.

Community
Advanced
mahg-esmahg-es
3

multi-platform-publish

Automate cross-platform content publishing to Blogger, X/Twitter, LinkedIn, Medium, and email newsletters.

Official
Intermediate
roach88roach88
2

scraping-websites

Crawl static and JavaScript-rendered websites and extract structured data.

Community
Intermediate
dull-birddull-bird
6

do.ai-newsletters

Fetch RSS feeds, deduplicate titles, rank AI news, and write Markdown digests to Obsidian.

Community
Advanced