AIRTABLE + N8N
Workforce Hub – Case Study
A single-source-of-truth connecting People, Projects, and Delivery. Static showcase with structured screenshots.
01 — Client Need
Fragmented data and low visibility
Hiring pipeline, delivery metrics, and executive KPIs lived in separate tools, causing blind spots and manual reporting.
- Disparate HR, Dev, and Management views
- Manual status sync and inconsistent reports
- No automated guardrails for data quality
02 — Solution Proposal
Unified Airtable base + n8n sync
Single base for Candidates, People, Projects, Repos/PRs, and Objectives. n8n orchestrates API sync and notifications.
03 — Data Model
Entity–Relationship (ER) overview
Core entities and links: Candidates ↔ People, People ↔ Projects, Projects ↔ Repos/PRs/Issues, Objectives with KRs.
04 — Automation
n8n orchestrations & API sync
Timed jobs fetch GitHub PRs/issues, enrich candidates, and post status back to Airtable with error handling & retries.
05 — Dev View & Permissions
Release readiness & PR aging
Open PRs by age, P1 bugs, and release timeline. Editors can update status; sensitive HR fields hidden.
06 — Manager View & Permissions
KPIs, OKRs, budget vs. spend
Read-only executive metrics with drill-downs. Budget health via formulas; no write access to operational tables.
07 — HR View & Permissions
Hiring pipeline & onboarding
Kanban by stage, time-to-hire metrics, and onboarding checklist. PII masked outside HR.