Airtable Project Status Reporter

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 SchemaName it "Airtable/Get Base Schema" and call it with @Airtable/Get Base Schema to understand the table structure (field names, types)
2. Use @Airtable/Search RecordsName it "Airtable/Search Records" and call it with @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 MessageName it "Slack/Send Message" and call it with @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.