跳到主内容
智客 ZICQ

技能库 智客分类:Agent 工作流 sheets-automation

Sheets Automation

Google Sheets 自动化工作流程 - 数据同步,任务管理,报告仪表板,多平台集成

4612 安装量

官方网址:skills.sh

技能介绍

先看中文介绍;官方 description 原文单独保留,不改写 SKILL.md。

做什么

Google Sheets 自动化工作流程 - 数据同步,任务管理,报告仪表板,多平台集成

何时用

官方 description 未单独写出 Use when。按规范,代理会在用户任务与这段 description 的关键词匹配时激活本技能。

代理如何加载

按 Agent Skills 渐进披露:启动时只加载 name 与 description(约 100 token);任务匹配后才读入整份 SKILL.md 正文;scripts/、references/、assets/ 仅在需要时再读。 本文件正文结构:Google Sheets Automation、Overview、Core Workflows、1. Multi-Source Data Aggregation、2. Task Management with Reminders、3. Automated Report Generation。 其中含规范建议的小节:分步指令。

文件分析

文件分析:这是一份仅含 SKILL.md 的指令型技能,代理激活后整份正文进入上下文。

官方 description(原文)

Google Sheets automation workflows - data sync, task management, reporting dashboards, and multi-platform integrations

Google Sheets AutomationOverviewCore Workflows1. Multi-Source Data Aggregation2. Task Management with Reminders3. Automated Report Generation4. Inventory/Stock Tracker5. Form Responses → CRM + SlackSheet TemplatesSales DashboardMarketing TrackerFormulas Reference

· 许可:MIT

来源分类:skills.sh agent-skill

SKILL.md 与 Agent 调用

官方规范 ↗
name
sheets-automation
description
Google Sheets automation workflows - data sync, task management, reporting dashboards, and multi-platform integrations
许可
MIT
  1. 发现技能客户端向 Agent 提供名称与描述目录。
  2. 匹配与调用用户指定或任务匹配后,载入 SKILL.md 指令。
  3. 按需加载按步骤读取参考文档、使用脚本与素材。

具体调用语法与可用工具以目标 Agent 客户端为准。 查看调用机制说明 ↗

安装这个技能

Skills CLI ↗

先选择目标 Agent 和安装范围,保留技能包的附属文件,安装后检查客户端能否发现该技能。

交给 Agent 安装

复制安装指令给支持 Agent Skills 的代理,确认其中的目标目录与客户端匹配。

把 Agent Skill「sheets-automation」安装到我的项目:SKILL.md 原文与官方 description 见 https://zicq.com/zh/skills/skl-5aa61f5e7548f1b6-%E5%B7%A5%E4%BD%9C%E8%A1%A8%E8%87%AA%E5%8A%A8%E5%8C%96.html
请存为 .cursor/skills/sheets-automation/SKILL.md 或 .claude/skills/sheets-automation/SKILL.md,frontmatter 的 name 与 description 保持原样,不要改写。

GitHub 完整包 ↗

终端安装 · Skills CLI

需要 Node.js 与 npx。先查看仓库技能列表,确认实际名称。

npx skills add 'https://github.com/claude-office-skills/skills' --list

npx skills add 'https://github.com/claude-office-skills/skills' --skill 'sheets-automation'

CLI 会交互选择目标 Agent,默认安装到项目;用户级安装使用 -g。先通过查看命令核对仓库内容,再用 npx skills list 检查已安装技能。

阅读排版
--- name: sheets-automation description: "Google Sheets automation workflows - data sync, task management, reporting dashboards, and multi-platform integrations" version: "1.0.0" author: claude-office-skills license: MIT category: productivity tags: - google-sheets - automation - data-sync - reporting - n8n department: Operations models: recommended: - claude-sonnet-4 mcp: server: google-workspace-mcp tools: - sheets_read - sheets_write - sheets_append - sheets_format capabilities: - data_synchronization - automated_reporting - task_tracking - dashboard_creation - multi_source_aggregation languages: - en - zh related_skills: - data-analysis - gmail-workflows - crm-automation --- # Google Sheets Automation Automate Google Sheets workflows for data synchronization, task management, reporting dashboards, and multi-platform integrations. Based on n8n's 7,800+ workflow templates. ## Overview This skill covers: - Automated data sync from multiple sources - Task management with Slack reminders - Real-time reporting dashboards - CRM/Marketing data aggregation - Scheduled report generation --- ## Core Workflows ### 1. Multi-Source Data Aggregation ``` ┌─────────────┐ ┌─────────────┐ ┌─────────────┐ │ HubSpot │ │ Stripe │ │ Google │ │ (CRM) │ │ (Payments) │ │ Analytics │ └──────┬──────┘ └──────┬──────┘ └──────┬──────┘ │ │ │ └─────────────────┼─────────────────┘ │ ▼ ┌──────────────────┐ │ Google Sheets │ │ (Master Dashboard)│ └──────────────────┘ │ ▼ ┌──────────────────┐ │ Slack/Email │ │ (Daily Report) │ └──────────────────┘ ``` **n8n Configuration**: ```yaml workflow: "Daily Business Metrics Sync" schedule: "6:00 AM daily" steps: 1. fetch_crm_data: source: hubspot data: - new_leads_today - deals_closed - pipeline_value 2. fetch_revenue_data: source: stripe data: - mrr - new_subscriptions - churn 3. fetch_traffic_data: source: google_analytics data: - sessions - conversions - bounce_rate 4. update_sheets: spreadsheet: "Business Dashboard" sheet: "Daily Metrics" action: append_row data: - date: today - leads: "{hubspot.new_leads}" - deals: "{hubspot.deals_closed}" - mrr: "{stripe.mrr}" - sessions: "{ga.sessions}" 5. update_charts: refresh: automatic (Sheets built-in) 6. send_summary: slack: channel: "#daily-metrics" message: | 📊 Daily Metrics - {date} 💰 Revenue: ${mrr} MRR 👥 New Leads: {leads} 🎯 Deals Closed: {deals} 📈 Website Sessions: {sessions} ``` --- ### 2. Task Management with Reminders ```yaml workflow: "Sheets Task Tracker" trigger: type: schedule frequency: every_15_minutes sheet_structure: columns: - A: Task - B: Assignee - C: Due Date - D: Priority (High/Medium/Low) - E: Status (Todo/In Progress/Done) - F: Slack ID steps: 1. read_tasks: filter: | Status != "Done" AND Due Date <= TODAY() + 1 2. categorize_urgency: overdue: Due Date < TODAY() due_today: Due Date == TODAY() due_tomorrow: Due Date == TODAY() + 1 3. send_reminders: for_each: task overdue: slack_dm: to: "{assignee_slack_id}" message: | 🚨 *OVERDUE*: {task_name} Due: {due_date} ({days_overdue} days ago) Priority: {priority} due_today: slack_dm: to: "{assignee_slack_id}" message: | ⏰ *Due Today*: {task_name} Priority: {priority} 4. daily_recap: schedule: "6:00 PM" slack_channel: "#team" message: | 📋 *Daily Task Recap* ✅ Completed: {completed_count} ⏳ In Progress: {in_progress_count} 🚨 Overdue: {overdue_count} Top priorities for tomorrow: {tomorrow_tasks} ``` --- ### 3. Automated Report Generation ```yaml workflow: "Weekly Report Generator" schedule: "Friday 5:00 PM" steps: 1. collect_data: sheets: - "Sales Data" - "Marketing Metrics" - "Support Tickets" 2. calculate_metrics: sales: - total_revenue: SUM(revenue_column) - deals_closed: COUNT(won_deals) - avg_deal_size: AVG(deal_value) - win_rate: won / (won + lost) marketing: - leads_generated: COUNT(new_leads) - cost_per_lead: spend / leads - conversion_rate: conversions / visitors support: - tickets_resolved: COUNT(resolved) - avg_response_time: AVG(first_response) - csat_score: AVG(satisfaction) 3. generate_report: format: google_doc template: "Weekly Report Template" sections: - executive_summary - sales_performance - marketing_metrics - customer_support - next_week_priorities 4. create_charts: google_sheets: - revenue_trend: line_chart - deal_funnel: bar_chart - lead_sources: pie_chart 5. distribute: email: to: leadership_team subject: "Weekly Business Report - Week {week_number}" attach: [report_doc, charts_pdf] slack: channel: "#leadership" message: "📊 Weekly report ready: {doc_link}" ``` --- ### 4. Inventory/Stock Tracker ```yaml workflow: "Inventory Alert System" trigger: type: sheets_change sheet: "Inventory" sheet_structure: columns: - Product - SKU - Current Stock - Reorder Level - Supplier - Lead Time (days) steps: 1. check_stock_levels: condition: Current Stock <= Reorder Level 2. generate_alerts: for_each: low_stock_item actions: - update_cell: column: "Status" value: "REORDER NEEDED" format: red_background - slack_alert: channel: "#inventory" message: | ⚠️ *Low Stock Alert* Product: {product_name} SKU: {sku} Current: {current_stock} Reorder Level: {reorder_level} Supplier: {supplier} - email_supplier: if: auto_reorder == true template: "reorder_request" 3. daily_summary: schedule: "9:00 AM" report: - total_skus: count - low_stock_items: count - out_of_stock: count - pending_orders: list ``` --- ### 5. Form Responses → CRM + Slack ```yaml workflow: "Google Form Lead Capture" trigger: type: google_forms form: "Contact Us Form" steps: 1. capture_response: fields: [name, email, company, message, source] 2. append_to_sheet: spreadsheet: "Lead Tracker" data: - timestamp: NOW() - name: "{name}" - email: "{email}" - company: "{company}" - message: "{message}" - status: "New" 3. enrich_lead: clearbit: lookup_by: email append: [company_size, industry, linkedin] 4. create_in_crm: hubspot: object: contact properties: email: "{email}" firstname: "{name}" company: "{company}" lead_source: "Website Form" 5. notify_sales: slack: channel: "#new-leads" message: | 🎉 *New Lead!* 👤 {name} 🏢 {company} ({company_size} employees) 📧 {email} 💬 "{message}" [View in HubSpot]({hubspot_link}) 6. auto_respond: email: to: "{email}" template: "thank_you_for_contacting" ``` --- ## Sheet Templates ### Sales Dashboard ``` ┌────────────────────────────────────────────────────────────────┐ │ SALES DASHBOARD - {Month} │ ├────────────────────────────────────────────────────────────────┤ │ │ │ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ │ │ │ Revenue │ │ Deals │ │ Avg Deal│ │ Win Rate│ │ │ │ $125K │ │ 23 │ │ $5,400 │ │ 34% │ │ │ │ ▲ 15% │ │ ▲ 8% │ │ ▲ 12% │ │ ▼ 2% │ │ │ └─────────┘ └─────────┘ └─────────┘ └─────────┘ │ │ │ │ [Revenue Trend Chart - Line] │ │ [Pipeline by Stage - Funnel] │ │ [Top Sales Reps - Bar] │ │ │ ├────────────────────────────────────────────────────────────────┤ │ Date │ Deal │ Value │ Rep │ Stage │ Prob │ │ 1/30 │ Acme Corp │ $15,000 │ Alice │ Proposal │ 60% │ │ 1/29 │ Tech Inc │ $8,500 │ Bob │ Demo │ 40% │ │ ... │ ... │ ... │ ... │ ... │ ... │ └────────────────────────────────────────────────────────────────┘ ``` ### Marketing Tracker ``` ┌────────────────────────────────────────────────────────────────┐ │ MARKETING METRICS │ ├────────────────────────────────────────────────────────────────┤ │ Channel │ Spend │ Leads │ CPL │ Conv % │ Revenue │ ├─────────────┼──────────┼───────┼────────┼────────┼───────────┤ │ Google Ads │ $5,000 │ 150 │ $33 │ 3.2% │ $45,000 │ │ Facebook │ $3,000 │ 200 │ $15 │ 1.8% │ $28,000 │ │ LinkedIn │ $2,500 │ 50 │ $50 │ 5.5% │ $35,000 │ │ Organic │ $0 │ 300 │ $0 │ 2.1% │ $52,000 │ ├─────────────┼──────────┼───────┼────────┼────────┼───────────┤ │ TOTAL │ $10,500 │ 700 │ $15 │ 2.8% │ $160,000 │ └────────────────────────────────────────────────────────────────┘ ROAS: 15.2x Best Channel: LinkedIn (highest conversion) Action: Increase LinkedIn budget by 20% ``` --- ## Formulas Reference ### Common Automation Formulas ``` # Auto-status based on date =IF(C2

相关技能

Agent 工作流

Skill Creator

创造有效技能指南。 当用户想创造出新的技能(或更新现有的技能),以专业知识,工作流程,或工具集成来扩展克洛德的能力时,应该使用这种技能.

Agent 工作流

Clawdhub

使用ClawdHub CLI搜索,安装,更新并发布从taladhub.com的代理技能. 需要获取苍蝇上的新技能时使用,将安装的技能同步到最新版本或特定版本,或者发布 npm-instainddhub CLI 的新/更新的技能文件夹.

Agent 工作流

Agent Team Orchestration

管弦乐团多代理团队,任务设定周期,交接协议,审查工作流程. 使用时间: (1)建立2+特派员队伍,具有不同专业,(2)确定任务路线和生命周期(收录框_ spec_建设_审查_完成),(3)在特派员之间制定交接协议,(4)建立审查和质量关口,(5)管理特派员之间的交流和文物共享.

Agent 工作流

Superpowers

Spec-first,TDD,子代理驱动的软件开发工作流程. 当:(1)构建任何新功能或应用——触发脑暴_计划_子代理执行回路,(2)调试出一个bug或测试失败——触发系统性的根起过程,(3)用户说"让我们构建","帮助我计划","我想添加X",或"这个被打破",(4)完成一个功…