skills.rest
OliverOuyang
OliverOuyangCOMMUNITY
Explore all skills by this author →
GitHub

Guanyuan Data Fetcher

Fetch Guanyuan dashboard card data into CSV or multi-sheet Excel exports.

1|Updated Apr 1, 2026
Search Tags:#automation#dashboards#mcp#excel#csv#data-fetch#guanyuan
One-click install
npx skills add https://github.com/OliverOuyang/shuhe-work-skills --skill guanyuan-data-fetcher
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Guanyuan Data Fetcher
Source: https://github.com/OliverOuyang/shuhe-work-skills/tree/main/skills/guanyuan-data-fetcher
Command: npx skills add https://github.com/OliverOuyang/shuhe-work-skills --skill guanyuan-data-fetcher

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, and includes scripts (resource) components.

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.

Frequently Asked Questions about Guanyuan Data Fetcher

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

FAQPage Schema
How do I automate exporting Guanyuan dashboard data to Excel or CSV?▼

To automate Guanyuan dashboard exports to Excel or CSV, use a config-driven script that builds validated MCP filter payloads and processes responses into ready-to-use files. This automates repetitive manual extraction and stitching of card-level data for scheduled reporting.

What is the best way to extract multiple dashboard cards into a single multi-sheet Excel file?▼

The best way to combine multiple Guanyuan dashboard cards into a single multi-sheet Excel file is using a Skill that aggregates card-level data and writes it with openpyxl. It processes each card as a separate sheet along with metadata and error summaries.

Can I use a JSON configuration to fetch specific Guanyuan dashboard cards?▼

Yes, you can load dashboard and card definitions from a JSON configuration to fetch specific Guanyuan dashboard cards. This config-driven extraction supports arbitrary pages and card sets while allowing CLI overrides for date ranges and page IDs.

How do I build and validate MCP get_card_data filter payloads for Guanyuan?▼

To build and validate MCP get_card_data filter payloads for Guanyuan, apply Template A or Template B formats within the extraction script. The process validates the constructed payloads before fetching data, ensuring accurate card-level responses.

Do I need Python packages like pandas and openpyxl to export Guanyuan data?▼

Yes, you need Python packages like pandas and openpyxl to process and export Guanyuan data. Pandas structures the fetched MCP responses, while openpyxl writes the data into multi-sheet Excel workbooks with per-run metadata and error reporting.

Related Skills

Explore More Data & Analytics Skills→
arisngarisng
5

copilot-cli-mcp-config

Configure GitHub Copilot CLI MCP servers in mcp-config.json.

Community
Basic
aiyinluyaaiyinluya
2

multi-file-excel-parquet-analysis

Count rows across Excel sheets and generate categorical statistics with Parquet.

Community
Intermediate
The-AIOSThe-AIOS
15

data-presentation

Transform raw data into narratives and KPI dashboards.

Official
Intermediate
hschnehschne
1

jq

Query, filter, validate, and transform JSON data using jq.

Community
Intermediate