skills.rest
clenisa
clenisaCOMMUNITY
Explore all skills by this author →
GitHub

generate-newsletter

Generate branded newsletters with news summaries, property listings, and market commentary.

Updated Mar 1, 2026
Search Tags:#newsletter#ai#excel#groq#html-email#strapi#newsapi
One-click install
npx skills add https://github.com/clenisa/optimal-cli --skill generate-newsletter
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: generate-newsletter
Source: https://github.com/clenisa/optimal-cli/tree/main/skills/generate-newsletter
Command: npx skills add https://github.com/clenisa/optimal-cli --skill generate-newsletter

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually compiling news, property listings, market commentary, and branded HTML for recurring newsletters is time consuming and error prone; this Skill automates the end-to-end pipeline so teams can produce consistent, on-brand editions quickly.

Core Features & Use Cases

  • News aggregation: Fetches the latest articles from NewsAPI using brand-specific queries and summarizes them.
  • AI content generation: Uses Groq (Llama 3.3 70B) to generate market overviews, property analyses, and structured news summaries.
  • Excel property parsing (CRE only): Reads columnar Excel sheets to include property listings for the CRE-11TRUST brand.
  • Email-safe HTML assembly: Builds responsive, branded HTML newsletters and ensures slug uniqueness with timestamps.
  • CMS integration & safe preview: Posts a draft to Strapi CMS with authentication and supports a dry-run mode for previews.
  • Use Case: Produce a branded CRE investor newsletter that combines market commentary, curated news, and property listings, then publish a draft to Strapi for editorial review.

Quick Start

Generate a CRE-11TRUST newsletter for today using properties from /path/to/properties.xlsx and run a dry-run preview before pushing to Strapi.

Frequently Asked Questions about generate-newsletter

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

FAQPage Schema
How do I automate generating HTML newsletters from NewsAPI articles and Excel data?▼

Automate HTML newsletters by fetching NewsAPI articles, parsing Excel property columns, and using Groq AI to generate market commentary before assembling responsive HTML payloads. This pipeline eliminates manual compilation by generating branded email content and publishing drafts to Strapi CMS.

Can I preview a Strapi CMS newsletter draft before publishing it live?▼

Yes, you can preview a Strapi CMS newsletter draft using the built-in dry-run mode. Dry-run support allows you to review the assembled responsive HTML payload and AI-generated content without posting the final newsletter directly to your live CMS.

Does the newsletter generation pipeline support parsing Excel property listings for commercial real estate?▼

Yes, the newsletter generation pipeline supports parsing Excel property listings specifically for the CRE-11TRUST brand. It reads columnar Excel sheets to extract property data and integrates those listings into the AI-generated commercial real estate newsletter.

What is the best way to use Groq AI for generating branded market commentary in email campaigns?▼

The best way to use Groq AI for branded market commentary is leveraging Llama 3.3 70B within an automated newsletter pipeline. The model generates structured news summaries and property analyses, ensuring consistent on-brand voice across recurring email campaigns.

Do I need NewsAPI and Groq API access to generate and publish these HTML newsletters?▼

Yes, you need both NewsAPI and Groq API access to generate and publish these HTML newsletters. NewsAPI fetches the latest brand-specific articles while Groq provides the Llama 3.3 70B model required for AI content generation and market commentary.

Why does my automated newsletter pipeline require slug uniqueness with timestamps for Strapi?▼

Your automated newsletter pipeline requires slug uniqueness with timestamps to prevent routing conflicts when posting multiple drafts to Strapi CMS. Appending timestamps ensures each generated HTML newsletter payload maintains a unique identifier for editorial review.

Related Skills

Explore More Content & Communication Skills→
clenisaclenisa

generate-social-posts

Generate weekly social post drafts from competitor ads and Unsplash images.

Community
Advanced
clenisaclenisa

distribute-newsletter

Send published Strapi newsletters to GoHighLevel via an n8n webhook.

Community
Intermediate
nowork-studionowork-studio
3.3k

setup-cms

A CMS with built-in intelligence for todays modern businesses.

Official
Advanced
clenisaclenisa

generate-newsletter-insurance

Generates branded HTML newsletters for specified insurance topics and audiences.

Community
Advanced