cotera

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.

Content trackingDeadline monitoringStatus updatesWeekly summaries

The Challenge

Your content calendar lives in Airtable but nobody checks it consistently. Deadlines slip because the writer forgot, the reviewer didn't see the status change, and you only find out when the publish date passes with nothing ready. You open the base, filter by status, cross-reference with deadlines, and ping people in Slack. Every week.

What This Prompt Does

Read Schema

Discovers your content calendar structure, fields, and statuses automatically

Find Overdue

Searches for content pieces past their deadline that aren’t published

Status Report

Groups content by status (draft, review, scheduled, published) with counts

Create Entries

Adds new content pieces from a plan or brief directly into the calendar

The Prompt

The Prompt

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

Example Usage

Try asking:

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