# Airtable Content Calendar Manager

> Stop manually checking your content calendar for overdue drafts and missed deadlines. An agent reads your Airtable base, tracks every piece of content by status, and delivers a weekly summary with action items.

Source: https://cotera.co/solutions/marketing/airtable-content-calendar-manager

---

- **Team:** Marketing
- **Tools:** Airtable
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 1-2 hrs/week

## How it works
1. **Read Schema** — Discovers your content calendar structure, fields, and statuses automatically
2. **Find Overdue** — Searches for content pieces past their deadline that aren't published
3. **Status Report** — Groups content by status (draft, review, scheduled, published) with counts
4. **Create Entries** — Adds new content pieces from a plan or brief directly into the calendar

## Example requests
- Show me everything that's overdue in my content calendar and who's responsible
- What content is scheduled to publish this week? Is it all in review or still in draft?
- Add these 5 blog post ideas to the content calendar with a draft deadline of next Friday

## Prompt

```markdown
## Task

Use @Airtable/Get Base Schema to understand your content calendar structure, then @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 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 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 Record to change statuses when the user asks (e.g., move a piece from Draft to In Review)
- Use @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
```

## Related reading
- [Airtable Just Launched AI Features. We've Been Using AI Agents for Months.](https://cotera.co/articles/airtable-ai-agent-guide.md)
- [Airtable vs Notion: We Use Both. Here's What Each Does Better.](https://cotera.co/articles/airtable-vs-notion-comparison.md)