A technical data tracking and automated report generation tool to monitor Xiaohongshu follower growth rankings across 25 categories.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install rednote-ranking-data
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install rednote-ranking-data using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Xiaohongshu Rankings?
Xiaohongshu Rankings is a dedicated digital analytics and visualization tool designed for MCNs, brand marketers, and content creators to track creator growth metrics on RED (Xiaohongshu). Unlike automated scraper tools that are prone to platform blocks or analytical errors, this tool utilizes manually verified and cross-referenced datasets spanning 25 distinct categories—ranging from beauty and lifestyle to parenting and technology. It enables users to fetch comprehensive daily, weekly, or monthly follower growth metrics and render high-quality ranking tables directly from their workspace.
As a highly customizable tool among Openclaw Skills, this workflow allows you to automate notifications, export raw tabular data into Excel formats, and render content-ready ranking charts. By integrating this capability into your AI agents or local CLI workflows, you can rapidly compile reports, execute competitor benchmarking, and streamline content generation with highly accurate, human-verified insights.
Xiaohongshu Rankings Use Cases
- Daily Trending Account Discovery: Retrieve daily leaderboards to catch breakout trends and rapidly growing creators across RED.
- MCN Talent and Competitor Benchmarking: Analyze weekly growth curves across specific categories to identify potential brand partnership opportunities or track competitor performance.
- Automated Performance Reporting: Directly export growth metrics to Excel spreadsheets to support standard business intelligence pipelines and internal corporate reports.
- Content Generation for Social Sharing: Create ready-to-publish styled ranking graphics to distribute across platforms like WeChat Moments or Xiaohongshu itself, establishing niche authority.
How Xiaohongshu Rankings Works
- Execution Request: The user or AI agent triggers a query using category and interval parameters via the
query_rankings.pyscript. - Secure Transmission: The tool communicates securely via native Socket and SSL (bypassing SNI headers) to extract the curated, manually checked growth records without needing API keys.
- Tabular Processing: The extracted JSON dataset can be processed directly or transformed into formatted spreadsheets through
export_to_excel.py. - Graphic Compilation: The metrics are ingested by the rendering module (
generate_chart.pyandgenerate_ranking_image.py), combining matplotlib and Pillow with local fonts to build polished PNG visual assets. - Subscription & Dispatch: The
subscription_manager.pychecks cron triggers and delivers the updated weekly/monthly ranking charts automatically to configured delivery channels.
Xiaohongshu Rankings Setup
Prerequisites
Make sure your environment is configured with Python 3.8+.
1. Installation
Clone or navigate to the skill directory, then install the pinned project dependencies:
cd ~/.workbuddy/skills/xiaohongshu-rankings
pip install Pillow==10.0.0 requests==2.31.0 matplotlib==3.7.0 numpy==1.24.0 pandas==2.0.0 openpyxl==3.1.0
2. Standard CLI Operations
Execute the main automation scripts to fetch growth rankings and compile output assets:
# Generate a standard daily ranking image for all combined categories (Top 20)
python3 scripts/generate_ranking_image.py --category 综合全部 --limit 20
# Retrieve rankings from a specific niche like beauty/cosmetics
python3 scripts/generate_ranking_image.py --category 化妆美容 --limit 20
# Query weekly data cycles instead of daily
python3 scripts/generate_ranking_image.py --category 综合全部 --type weekly --limit 20
# Export raw analytical details directly into an Excel sheet
python3 scripts/query_rankings.py --category 综合全部 --type daily --limit 20 --output /tmp/rankings.json
python3 scripts/export_to_excel.py --data /tmp/rankings.json --output ~/Desktop/FollowerGrowth.xlsx
Xiaohongshu Rankings Data Schema & Taxonomy
Folder Architecture
The skill follows a clean modular configuration:
SKILL.md: Skill capabilities documentation.scripts/:query_rankings.py: Entry point for data fetching and JSON output.generate_ranking_image.py: Script to generate styled image tables directly.export_to_excel.py: Formatting engine transforming JSON to spreadsheet rows.generate_chart.py: PIL and matplotlib drawing processor.subscription_manager.py: Controls subscription parameters and schedulers.delivery_service.py: Distributes content assets to end users.
references/: Reference documentation files.
Parameters Reference
| Parameter | Description | Supported Configuration / Constraints |
|---|---|---|
--category |
Target content vertical | 综合全部 (default), or any of the 24 distinct sub-niches (e.g., 宠物天地, 数码科技) |
--type |
Timeframe interval | daily (1-day data delay), weekly, monthly |
--limit |
Amount of records to return | Maximum of 100 rows. Default is 20. |
--date |
Custom historical date | YYYY-MM-DD. Max limit of 30 days for daily, 8 weeks for weekly, 3 months for monthly queries. |
Xiaohongshu Rankings Advanced Features
- Socket-Level Secure Ingestion: Employs low-level Socket + SSL routines bypassing SNI blocks, securing consistent access to external data feeds in restricted runtime environments.
- Dynamic Font Mapping: Provides direct font path override parameters (
--font) to ensure reliable Chinese rendering on headless Linux servers or macOS systems. - Multi-Platform Integration Ready: Highly optimized for AI execution agents such as Coze, Skillhub, and Clawhub, supporting headless chatbot workflows.
- Automated Scheduling Engines: Includes programmatic logic to manage and list multiple automated subscription configs for proactive, cron-style distribution of graphics.
SKILL.md
Loading
Related Openclaw Skills
Letters to a Young Poet (Rilke Wisdom)
An AI-powered philosophical guide translating Rainer Maria Rilke's timeless wisdom on creativity, solitude, and love into actionable personal growth insights.
Letter to a Christian Nation
An AI agent skill based on Sam Harris's seminal book, designed to route queries, synthesize secular philosophical arguments, and address questions about faith, morality, and science.
Lifelong Kindergarten: Cultivating Creativity through Projects, Passion, Peers, and Play
An educational AI skill based on Mitchel Resnick's Lifelong Kindergarten framework, promoting creative learning through Projects, Passion, Peers, and Play.
LikeWar: The Weaponization of Social Media
A specialized AI agent skill designed to analyze and explain the strategies, algorithms, and weaponization of social media based on the groundbreaking book LikeWar.
Learn Like a Pro - Science-Based Learning Companion
An AI-powered cognitive companion skill based on the neuroscience-backed learning frameworks of Barbara Oakley and Olav Schewe.
Lessons in Stoicism
An interactive, practical AI agent skill designed to guide users through the timeless wisdom and daily mental exercises of Stoic philosophy based on John Sellars' book.
Featured*
