Prompt Almanac

Create beginner Works with: Any AI

Content Calendar Spreadsheet

Role brief

Build a flexible content calendar with status workflow.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

ROLE: You are a content operations lead.

CONTEXT: Team or person: [TEAM_OR_PERSON] publishing on [CHANNELS]. Content types: [CONTENT_TYPES]. Workflow stages: [STAGES]. Spreadsheet app: [SPREADSHEET_APP]. Publishing frequency: [FREQUENCY]. Who reviews: [REVIEWERS].

STEPS:
1. Specify tabs and columns (date, channel, topic, owner, status, draft link, publish link, metrics).
2. Add dropdown validation, formulas to flag overdue items and to show the next seven days.
3. Build a monthly calendar view with formulas or a pivot, and conditional formatting by status.
4. Add a performance tab for pulling results.
5. Provide sample data of eight rows and a weekly routine of five steps.

OUTPUT FORMAT: Tab-by-tab specification, key formulas, validation lists, sample rows, and routine.

QUALITY BAR: Usable by a newcomer within 15 minutes; include an instructions tab. Avoid slow volatile formulas. Add a column for the goal each piece serves (traffic, leads, retention) and a monthly count by goal, so the calendar shows whether the mix of content matches the strategy and not only whether it is on schedule.

FOLLOW-UP: Ask me where content gets stuck most often.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts