skills.rest
OrionArchitekton
OrionArchitektonCOMMUNITY
Explore all skills by this author →
Website𝕏@danmercedeGitHub

tbm-newsletter

Fetch top-performing ClickHouse content, create an HTML newsletter draft, and initiate Slack approval.

Updated Aug 23, 2026
Search Tags:#automation#newsletter#marketing#reporting#content curation#slack integration
One-click install
npx skills add https://github.com/OrionArchitekton/cosmocrat-core --skill tbm-newsletter
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: tbm-newsletter
Source: https://github.com/OrionArchitekton/cosmocrat-core/tree/main/skills/tbm/tbm-newsletter
Command: npx skills add https://github.com/OrionArchitekton/cosmocrat-core --skill tbm-newsletter

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation and distribution of a weekly newsletter, streamlining the process from data fetching to Slack approval and final sending.

Core Features & Use Cases

  • Automated Content Curation: Fetches top-performing content from ClickHouse.
  • Newsletter Generation: Creates HTML newsletters.
  • Approval Workflow: Saves drafts to Supabase and notifies stakeholders on Slack for approval.
  • Automated Sending: Triggers sending via Vercel API upon approval.
  • Use Case: A marketing team can use this to automatically compile their weekly performance highlights into a newsletter draft, get quick approval from their manager via Slack, and have it sent out on schedule.

Quick Start

Run the tbm-newsletter skill to generate the weekly newsletter draft.

Frequently Asked Questions about tbm-newsletter

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

FAQPage Schema
How do I automate a weekly newsletter with a Slack approval workflow?▼

Automating a weekly newsletter with a Slack approval workflow involves fetching top-performing content from ClickHouse, generating an HTML draft, saving it to Supabase, and notifying stakeholders on Slack to approve and trigger sending via the Vercel API.

Can I generate an HTML newsletter draft from top-performing content in ClickHouse?▼

Yes, you can generate an HTML newsletter draft from top-performing content in ClickHouse. The process extracts your performance data, compiles it into an HTML format, and stores the pending draft in Supabase for review.

How does Slack integration work for newsletter approval and sending via Vercel API?▼

Slack integration for newsletter approval works by sending a notification with a Slack command. Once a stakeholder approves the draft, the command triggers the Vercel API to automatically send the finalized HTML newsletter.

Do I need ClickHouse and Supabase to automate content curation for marketing newsletters?▼

Yes, you need ClickHouse and Supabase to automate content curation for marketing newsletters. ClickHouse provides the top-performing content data, while Supabase stores the pending HTML drafts awaiting Slack approval.

What is the best way to streamline marketing reporting into an automated newsletter?▼

The best way to streamline marketing reporting into an automated newsletter is to fetch top-performing content from ClickHouse, generate an HTML draft, and use a Slack command for approval, which then triggers automated sending via the Vercel API.

Related Skills

Explore More Marketing & Sales Skills→
vZulinvZulin

supabase-automation

Orchestrates Supabase database, storage, and edge function operations via Composio's MCP.

Community
Advanced
adbertramadbertram
3

buttondown-cli

Manage Buttondown newsletter subscribers, emails, RSS feeds, and automations via CLI.

Community
Intermediate
adriannoesadriannoes
46

slack-bot-creator

Automate Slack bot creation, setup, and management workflows.

Community
Intermediate
matteotittamatteotitta
29

outbound-send-orchestrator

Create Gmail drafts and schedule Slack reminders for outbound campaigns.

Community
Advanced