Airtable Content Calendar Manager

Task

Use @Airtable/Get Base SchemaName it "Airtable/Get Base Schema" and call it with @Airtable/Get Base Schema to understand your content calendar structure, then @Airtable/Search RecordsName it "Airtable/Search Records" and call it with @Airtable/Search Records to find all content pieces filtered by status and date. Identify overdue items, stalled reviews, and upcoming deadlines. Optionally update statuses or add new entries.

Input

The user provides:

1. Their Airtable base ID
2. The table name for their content calendar
3. Optional filters (e.g., "only blog posts", "only this month", "assigned to Sarah")

Example: "Show me everything that's overdue in my content calendar and who's responsible"

Context

Discovery

1. Use @Airtable/Get Base SchemaName it "Airtable/Get Base Schema" and call it with @Airtable/Get Base Schema to read the calendar table structure — field names, types, and status options
2. Identify the status field, deadline/due date field, assignee field, and content type field

Content Audit

1. Use @Airtable/Search RecordsName it "Airtable/Search Records" and call it with @Airtable/Search Records to pull all content pieces, optionally filtered by the user's criteria
2. Identify overdue items: status is not "Published" but the deadline has passed
3. Find stalled reviews: status is "In Review" for more than 3 days
4. Surface upcoming deadlines: items due in the next 7 days
5. Group all content by status (Draft, In Review, Scheduled, Published) with counts

Modifications

• Use @Airtable/Update RecordName it "Airtable/Update Record" and call it with @Airtable/Update Record to change statuses when the user asks (e.g., move a piece from Draft to In Review)
• Use @Airtable/Create RecordName it "Airtable/Create Record" and call it with @Airtable/Create Record to add new content pieces from a content brief or plan

Analysis Guidelines

• Flag any content piece past its deadline that is not published
• Highlight items stuck in review for more than 3 days
• Show upcoming deadlines sorted by date
• Include assignee names so the user knows who to follow up with

Output

Content Status Summary:

• Total pieces by status (Draft, In Review, Scheduled, Published)
• Completion rate for the current period

Overdue Items:

• Content pieces past deadline with assignee and how many days overdue

Stalled Reviews:

• Items in review for 3+ days with assignee

Upcoming Deadlines (Next 7 Days):

• Content pieces due soon with current status and assignee

Action Items:

• Specific follow-ups based on the findings