# Airtable Project Status Reporter

> Pull tasks from your Airtable project tracker, summarize progress, flag blockers, and post it to Slack. Skip the status meeting.

Source: https://cotera.co/solutions/ops/airtable-project-tracker

---

- **Team:** Operations
- **Tools:** Airtable, Slack
- **Difficulty:** easy
- **Setup time:** 5 min
- **Time saved:** 30 min/update

## How it works
1. **Read Schema** — Discover table structure and field types automatically
2. **Pull Tasks** — Search and filter records from your project table
3. **Analyze Progress** — Group by status, calculate completion, flag blockers
4. **Post to Slack** — Send a formatted status update to your team channel

## Example requests
- Post a status update for the Product Roadmap base to #team-updates
- What is the completion rate on the Q1 Launch table? Post it to #engineering
- Summarize blocked items in my Sprint Board and send to #standup

## Prompt

```markdown
## Task

Read project tasks from an Airtable base, summarize progress by status, flag blockers, and post a formatted update to a Slack channel.

## Input

The user provides:
- Airtable base ID (or base name to look up)
- Table name containing tasks/projects
- Slack channel to post the update to
- Optional: filter (e.g., "only the Q1 Launch project", "tasks assigned to the engineering team")

**Example:** "Give me a status update on everything in my 'Product Roadmap' table and post it to #team-updates"

## Context

### How to Build the Report

1. Use @Airtable/Get Base Schema to understand the table structure (field names, types)
2. Use @Airtable/Search Records to pull all tasks, optionally filtered
3. Group tasks by status (e.g., Not Started, In Progress, Done, Blocked)
4. Calculate completion percentage and identify overdue items
5. Use @Slack/Send Message to post a formatted summary

### What to Include

- Total tasks and completion rate
- Breakdown by status (count per status)
- Blocked or overdue items (call these out explicitly)
- Recently completed items (last 7 days if dates are available)
- Next up: items marked as high priority that haven't started

### Slack Message Format

Use Slack markdown:
- Bold headers with *text*
- Bullet lists for task names
- Use emoji for status: ✅ Done, 🔄 In Progress, 🚫 Blocked, ⏳ Not Started

## Output

A Slack message posted to the specified channel with:
- Project name and date
- Status breakdown with counts
- Blocked items highlighted
- Completion percentage

Also show the user a preview of the message before posting.
```

## Related reading
- [I Automated 90% of My Airtable Workflows. The Other 10% Needed an Agent.](https://cotera.co/articles/automate-airtable-workflows-guide.md)
- [7 Airtable Automations We Actually Use (and 3 We Replaced with Agents)](https://cotera.co/articles/airtable-automation-examples.md)