# Airtable Automation

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

- Repository: https://github.com/claude-office-skills/skills (556 stars)
- Category: Data and ML
- License: MIT
- Last updated: 2026-01-31
- Runs scripts: no, instructions only

## Install

Claude Code: `npx skills add claude-office-skills/skills --skill airtable-automation -g -a claude-code -y`
Codex: `npx skills add claude-office-skills/skills --skill airtable-automation -g -a codex -y`
Cursor: `npx skills add claude-office-skills/skills --skill airtable-automation -g -a cursor -y`
Gemini CLI: `npx skills add claude-office-skills/skills --skill airtable-automation -g -a gemini-cli -y`

## Description

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

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# 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

The rest: https://github.com/claude-office-skills/skills/blob/HEAD/airtable-automation/SKILL.md