DataAutomationAiVercel

AstrolGuru Content Machine

Cron-driven publishing. Plans 20 days ahead, writes, illustrates, ships. ~60h saved monthly.

Role
Solo build
Year
2025
Practice
Data
Link
astrolguru.com
MTWTF1234567891011121314151617181920Daily cron0 6 * * *PlanWriteIllustratePublish

At a glance

Starting point
Astrology platforms need daily content for SEO growth, posts aligned with planetary events, structured planning, relevant visuals, and consistent publishing discipline.
What we built
Cron-driven publishing. Plans 20 days ahead, writes, illustrates, ships. ~60h saved monthly.
Stack
Node.js + TypeScript, Vercel serverless + cron, Database-backed planning
Outcome
~60+ hours/month saved.

A self-sustaining content engine. Plans 20 days ahead, writes, illustrates, ships. ~60h saved monthly.

Problem

Astrology platforms need daily content for SEO growth, posts aligned with planetary events, structured planning, relevant visuals, and consistent publishing discipline. Manual workflows lead to inconsistency, missed opportunities, and operational overhead.

How it works

  • Generates a rolling 20-day content roadmap with topic diversity and de-duplication.
  • Scores and selects the most relevant topic each day, prioritizing trending or time-bound astrology events.
  • Tracks every planned topic through Planned to In Progress to Published in a database.
  • For the chosen topic: generates an SEO-optimized blog with title, meta description, headings, FAQs, plus an astrology-themed hero image.
  • Auto-generates slug + metadata, uploads images, and publishes via cron-triggered serverless functions on Vercel.

Stack

  • RUNTIME: Node.js + TypeScript
  • DEPLOY: Vercel serverless + cron
  • DATA: Database-backed planning

Impact

  • Daily publishing without fail.
  • Zero manual content operations.
  • Compounding SEO growth and long-tail keyword coverage.
  • ~60+ hours/month saved.