القائمة
Create charts and visualizations in Google Sheets — detect data structure, select chart type, format for clarity, present insights
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
| name | googlesheets-charts-graphs |
| description | Create charts and visualizations in Google Sheets — detect data structure, select chart type, format for clarity, present insights |
| target | google_sheets_agent |
User wants to visualize data, create charts, build dashboards, or add graphs to a spreadsheet.
Before creating any chart, read the data:
GOOGLESHEETS_SEARCH_SPREADSHEETS(query="<name>") → spreadsheet_id
GOOGLESHEETS_GET_SHEET_NAMES(spreadsheetId=spreadsheet_id) → sheets list
GOOGLESHEETS_VALUES_GET(spreadsheetId, range="Sheet1!A1:Z5") → peek at structure
Identify:
| Data Pattern | Best Chart | Why |
|---|---|---|
| Categories + values | BAR or COLUMN | Compare quantities across categories |
| Time series | LINE or AREA | Show trends over time |
| Parts of whole | PIE | Show proportions (≤7 categories) |
| Two numeric variables | SCATTER | Show correlation/distribution |
| Multiple metrics over time | COMBO | Lines + bars together |
| Distribution | HISTOGRAM | Show frequency distribution |
| Hierarchical | TREEMAP | Show nested proportions |
Rules:
GOOGLESHEETS_GET_SPREADSHEET_INFO(spreadsheetId) → get sheet_id (numeric, NOT sheet name)
Range rules:
'Sheet1!A1:C20'GOOGLESHEETS_CREATE_CHART(
spreadsheet_id="...",
sheet_id=0, # Numeric sheet ID, NOT name
chart_type="BAR",
data_range="Sheet1!A1:C10",
title="Sales by Region",
x_axis_title="Region",
y_axis_title="Revenue ($)",
legend_position="BOTTOM_LEGEND"
)
Chart type options: BAR, LINE, PIE, COLUMN, AREA, SCATTER, COMBO, STEPPED_AREA, HISTOGRAM, BUBBLE, CANDLESTICK, TREEMAP, WATERFALL, ORG, SCORECARD
Don't just create the chart — tell the user what it shows:
Created: "Sales by Region" (Bar Chart)
Key insights:
- West region leads with $450K (38% of total)
- East region grew 22% vs last quarter
- South region underperforming at $120K
Analyze spreadsheet data intelligently - understand structure, choose right analysis tool (SQL/pivot/chart), apply formatting, present insights.
Generate an editable Microsoft Word (.docx) document — reports, letters, memos, structured docs. Use when the user wants a Word file. Built with docx-js (Node) for high fidelity.
Generate a polished, printable PDF — reports, letters, invoices, resumes, one-pagers. Use when the user wants a PDF document. Typst is the primary engine; LaTeX (tectonic) is the fallback for niche packages or specific academic/journal templates.
Generate a PowerPoint (.pptx) slide deck — pitch decks, reviews, summaries. Use when the user wants slides. Built with pptxgenjs (Node) for native, editable slides and charts.
Generate an Excel (.xlsx) workbook or a CSV file — tables, financial models, data exports, formatted reports with charts. Use when the user wants a spreadsheet or CSV. Built with openpyxl + pandas (Python).
Complete guide for GAIA tracked todos — philosophy, two modes (immediate/long-running), canvas activity logging, scheduling/recurrence, and institutional memory.