Guanyuan Data Fetcher
CommunityExport Guanyuan dashboard cards to CSV or Excel
AuthorOliverOuyang
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Many teams must manually extract card-level data from Guanyuan dashboards, rebuild filter payloads, and stitch multiple card results into report files; this Skill automates those repetitive steps to produce ready-to-use CSV or multi-sheet Excel exports and structured metadata.
Core Features & Use Cases
- Config-driven extraction: Load dashboard and card definitions from JSON to support arbitrary Guanyuan pages and card sets.
- Filter templates & validation: Build and validate MCP get_card_data filter payloads (Template A / Template B) and allow CLI overrides for date ranges and page IDs.
- Flexible outputs: Save each card as UTF-8 CSV or combine multiple cards into a single multi-sheet Excel workbook with metadata and error reporting.
- Use Case: Produce a monthly multi-sheet Excel report from the "1.2 核心指标" dashboard by running a single command and ingest the resulting file into downstream analysis or reporting pipelines.
Quick Start
Call the Guanyuan Data Fetcher with a JSON config and date range to export dashboard cards into a multi-sheet Excel or individual CSV files.
Dependency Matrix
Required Modules
openpyxlpandas
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: Guanyuan Data Fetcher Download link: https://github.com/OliverOuyang/shuhe-work-skills/archive/main.zip#guanyuan-data-fetcher Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.