cotera

Airtable Project Status Reporter

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

Status reportsProject trackingTeam updates

The Challenge

Every Monday you open Airtable, scan through dozens of tasks across multiple views, mentally tally what is done, what is blocked, and what is behind schedule. Then you type up a summary in Slack. It takes 30 minutes and nobody reads half of it.

What This Prompt Does

Read Schema

Discover table structure and field types automatically

Pull Tasks

Search and filter records from your project table

Analyze Progress

Group by status, calculate completion, flag blockers

Post to Slack

Send a formatted status update to your team channel

The Prompt

The Prompt

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.

Example Usage

Try asking:

  • →"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"