跳到主内容
智客 ZICQ

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

Airtable Automation

Airtable数据库自动化 - 视图、自动化、集成和工作流程触发器

5551 安装量

官方网址:skills.sh

技能介绍

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

做什么

Airtable数据库自动化 - 视图、自动化、集成和工作流程触发器

何时用

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

代理如何加载

按 Agent Skills 渐进披露:启动时只加载 name 与 description(约 100 token);任务匹配后才读入整份 SKILL.md 正文;scripts/、references/、assets/ 仅在需要时再读。 本文件正文结构:Airtable Automation、Overview、Database Design、Base Structure Template、Views Configuration、Automations。 其中含规范建议的小节:分步指令、输入输出示例。

文件分析

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

官方 description(原文)

Airtable database automation - views, automations, integrations, and workflow triggers

Airtable AutomationOverviewDatabase DesignBase Structure TemplateViews ConfigurationAutomationsBuilt-in Airtable Automationsn8n Integration WorkflowsFormula ReferenceCommon FormulasRollup ExamplesIntegration Patterns

· 许可:MIT

来源分类:skills.sh agent-skill

SKILL.md 与 Agent 调用

官方规范 ↗
name
airtable-automation
description
Airtable database automation - views, automations, integrations, and workflow triggers
许可
MIT
  1. 发现技能客户端向 Agent 提供名称与描述目录。
  2. 匹配与调用用户指定或任务匹配后,载入 SKILL.md 指令。
  3. 按需加载按步骤读取参考文档、使用脚本与素材。

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

安装这个技能

Skills CLI ↗

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

交给 Agent 安装

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

把 Agent Skill「airtable-automation」安装到我的项目:SKILL.md 原文与官方 description 见 https://zicq.com/zh/skills/skl-d5899f846e255072-%E6%B0%94%E8%A1%A8%E8%87%AA%E5%8A%A8%E5%8C%96.html
请存为 .cursor/skills/airtable-automation/SKILL.md 或 .claude/skills/airtable-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 'airtable-automation'

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

阅读排版
--- name: airtable-automation description: "Airtable database automation - views, automations, integrations, and workflow triggers" version: "1.0.0" author: claude-office-skills license: MIT category: productivity tags: - airtable - automation - database - workflow - n8n department: Operations models: recommended: - claude-sonnet-4 mcp: server: airtable-mcp tools: - airtable_create_record - airtable_update_record - airtable_query capabilities: - database_automation - view_creation - integration_workflows - formula_design - reporting languages: - en - zh related_skills: - notion-automation - sheets-automation - crm-automation --- # Airtable Automation Automate Airtable bases with views, automations, integrations, and cross-platform workflows. Based on n8n's Airtable integration templates. ## Overview This skill covers: - Database design and views - Built-in automations - n8n integration workflows - Formula and rollup design - Reporting and dashboards --- ## Database Design ### Base Structure Template ```yaml base: "Project Management" tables: Projects: fields: - Name: single_line_text (primary) - Status: single_select [Planning, Active, On Hold, Complete] - Priority: single_select [P0, P1, P2, P3] - Owner: collaborator - Start Date: date - Due Date: date - Budget: currency - Tasks: link_to_records (Tasks) - Progress: rollup (Tasks.Status, COUNTIF(Done)/COUNT) - Days Remaining: formula (DATETIME_DIFF(Due Date, TODAY(), 'days')) Tasks: fields: - Task Name: single_line_text (primary) - Project: link_to_records (Projects) - Status: single_select [To Do, In Progress, Review, Done] - Assignee: collaborator - Due Date: date - Hours Estimated: number - Hours Actual: number - Attachments: attachment Team: fields: - Name: single_line_text (primary) - Email: email - Role: single_select [PM, Developer, Designer, QA] - Current Projects: link_to_records (Projects) - Capacity: number (hours/week) - Utilization: rollup (calculate from Tasks) ``` ### Views Configuration ```yaml views: Projects: - Grid: All Projects fields: [Name, Status, Owner, Due Date, Progress] sort: Due Date (ascending) - Kanban: By Status group_by: Status card_fields: [Name, Owner, Due Date] - Calendar: Timeline date_field: Due Date - Gallery: Project Cards cover: Attachments Tasks: - Grid: My Tasks filter: Assignee = {Current User} sort: Due Date - Kanban: Sprint Board group_by: Status - Calendar: Task Calendar date_field: Due Date ``` --- ## Automations ### Built-in Airtable Automations ```yaml automation_1: name: "New Task Notification" trigger: when: record_created table: Tasks actions: - send_slack: channel: "#project-updates" message: | 📋 New task created! Task: {Task Name} Project: {Project} Assignee: {Assignee} Due: {Due Date} automation_2: name: "Overdue Task Alert" trigger: when: record_matches_conditions table: Tasks conditions: - Status: not "Done" - Due Date: before today actions: - send_email: to: "{Assignee.email}" subject: "⚠️ Overdue Task: {Task Name}" body: "Your task '{Task Name}' was due on {Due Date}." - update_record: field: Status value: "Overdue" automation_3: name: "Project Complete" trigger: when: record_updated table: Projects field: Progress condition: equals 100% actions: - update_record: field: Status value: "Complete" - send_slack: channel: "#wins" message: "🎉 Project '{Name}' completed!" ``` ### n8n Integration Workflows ```yaml workflow: "Form to Airtable to CRM" trigger: typeform_submission steps: 1. create_airtable_record: base: "Leads" table: "Contacts" fields: Name: "{form.name}" Email: "{form.email}" Company: "{form.company}" Source: "Website Form" Created: "{timestamp}" 2. enrich_data: clearbit: lookup_email update_record: Company Size: "{clearbit.company_size}" Industry: "{clearbit.industry}" 3. sync_to_hubspot: create_contact: email: "{email}" properties: from_airtable 4. notify_sales: slack: channel: "#new-leads" message: "New lead: {Name} from {Company}" ``` --- ## Formula Reference ### Common Formulas ```yaml formulas: days_until_due: formula: "DATETIME_DIFF({Due Date}, TODAY(), 'days')" output: number is_overdue: formula: "IF(AND({Status}!='Done', {Due Date} daily_digest: schedule: "9am weekdays" query: records_due_today action: post_summary slash_command: command: /airtable-add action: create_record_from_slack ``` ### Airtable + Calendar ```yaml calendar_sync: airtable_to_google: trigger: record_with_date_created action: create_calendar_event mapping: title: "{Name}" start: "{Date}" description: "{Notes}" google_to_airtable: trigger: calendar_event_created action: create_airtable_record mapping: Name: "{event.title}" Date: "{event.start}" Type: "Meeting" ``` ### Airtable + Zapier/n8n ```yaml multi_step_workflow: name: "Lead Processing Pipeline" trigger: platform: airtable event: new_record table: Raw Leads steps: - enrich: service: clearbit input: email output: company_data - score: service: ai_scoring criteria: [company_size, industry, title] output: lead_score - route: condition: lead_score high: assign_to_sales medium: add_to_nurture low: mark_as_cold - update_airtable: table: Qualified Leads fields: [enriched_data, score, assignment] - notify: if: high_score slack: dm_sales_rep ``` --- ## Reporting Templates ### Weekly Status Report ```yaml report_automation: schedule: "Friday 5pm" queries: completed_this_week: table: Tasks filter: - Status: Done - Completed Date: this_week in_progress: table: Tasks filter: - Status: In Progress overdue: table: Tasks filter: - Status: not Done - Due Date: before today output: format: markdown destination: [slack, email] template: | # Weekly Status Report - {week} ## Completed ({completed_count}) {completed_list} ## In Progress ({in_progress_count}) {in_progress_list} ## Overdue ({overdue_count}) ⚠️ {overdue_list} ## Metrics - Completion rate: {rate}% - On-time delivery: {on_time}% ``` ### Dashboard View ```yaml dashboard: name: "Project Dashboard" widgets: - summary_bar: metrics: - Total Projects: COUNT(Projects) - Active: COUNT(Status='Active') - At Risk: COUNT(Days Remaining < 7) - progress_chart: type: bar data: Projects grouped by Status - upcoming_deadlines: type: list query: Projects where Due Date in next 14 days sort: Due Date ascending limit: 10 - team_utilization: type: horizontal_bar data: Team members by task count ``` --- ## Output Example **Request**: "Design an Airtable base for content marketing" **Output**: ```markdown # Content Marketing Base ## Tables ### 1. Content Calendar | Field | Type | Purpose | |-------|------|---------| | Title | Text | Content title | | Status | Select | Idea → Draft → Review → Published | | Type | Select | Blog, Video, Social, Email | | Author | Collaborator | Assigned writer | | Publish Date | Date | Target publish date | | Platform | Multi-select | Blog, LinkedIn, Twitter | | Keywords | Multi-select | SEO keywords | | Performance | Link | → Analytics | ### 2. Analytics | Field | Type | Purpose | |-------|------|---------| | Content | Link | → Content Calendar | | Views | Number | Page views | | Engagement | Number | Likes + comments | | Conversions | Number | CTAs clicked | | Date | Date | Measurement date | ## Automations **1. New Content Idea** ``` Trigger: Record created Action: Slack to #content-ideas ``` **2. Ready for Review** ``` Trigger: Status → Review Action: Email editor + set due date ``` **3. Published** ``` Trigger: Status → Published Action: - Post to social scheduler - Add analytics tracking row - Celebrate in Slack 🎉 ``` ## Views - 📅 Calendar View (by Publish Date) - 📊 Kanban (by Status) - 👤 My Content (filtered by Author) - 📈 Performance Dashboard ``` --- *Airtable Automation Skill - Part of Claude Office Skills*

相关技能

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)完成一个功…