Build a content calendar from campaign milestones

Gemini: drafts the table and calendar

Gemini drafts the dependency table, then the calendar, with your check between. Capacity conflicts stay listed, not resolved.

You
Collect planning documents
Gemini
Draft dependency table
You
Correct the table
Gemini
Draft the calendar
You
Review, decide

Collect the planning documents
Use: You
Collect approved milestones, content backlog, owner capacity and review lead times as documents with dates and source names.
Check
These are the approved versions.
Draft the dependency table
Use: Gemini
Upload the inputs and ask for a content dependency table with milestone, purpose, owner and readiness.
Details
What to paste into the tool
From the attached files only, list each content item with its milestone, purpose, owner, readiness and dependencies. Mark items that are not stated as not stated.
Correct the table
Use: You
Correct the table against the inputs and confirm readiness and owners.
Check
Every item supports a milestone.
Draft the calendar
Use: Gemini
Ask Gemini to order items into a draft editorial calendar with review gates and list capacity conflicts without resolving them.
Details
What to paste into the tool
Order the items by milestone, owner capacity and review lead time. Show a proposed window per item and review gates. List capacity conflicts as unresolved. Do not mark anything as scheduled or published.
Read the calendar and decide
Use: You
Check each dependency comes before its proposed window; review conflicts and decide approval.
Check
Publishing is a separate decision.

Notion AI: fills properties, you place items

Each backlog item becomes a Notion page; Basic Autofill pulls owner and readiness. You order items against milestones and capacity.

You
Create backlog pages
Notion AI
Set up autofill
You
Check, set dependencies
You
Place in order
You
Review, decide

Create a page per backlog item
Use: You
Create one Notion page per backlog item: milestone, purpose, owner note, readiness note, review lead time, with source name, date and dependency note beside each.
Check
Only permitted campaign information is included. Mark absent fields as not stated.
Set up autofill
Use: Notion AI
Set up Basic Autofill for owner, readiness and dependency note properties.
Details
What to paste into the tool
From this page extract the named owner, the readiness status and any dependency mentioned. If absent write "not stated".
Check values and set dependencies
Use: You
Check autofilled values against each page, then set cross-item dependencies and mark readiness gaps.
Check
Every item supports a milestone and dependencies are explicit.
Place items in calendar order
Use: You
Place items in calendar order against milestones, owner capacity and review gates; list unresolved capacity conflicts.
Check
Each dependency precedes the proposed publication window.
Decide approval
Use: You
Go over the calendar and conflicts and decide approval; publishing is separate.
Check
The calendar is complete with conflicts listed.

You build the table; Claude builds the workbook

You write the dependency table from planning knowledge. Claude creates a calendar workbook with date checks you test.

You
Build dependency table
Claude
Create calendar workbook
You
Test and approve or hold

Build the dependency table by hand
Use: You
Build the table: item, milestone, purpose, owner, readiness, dependencies, review lead time, with source name and date beside each.
Check
Mark absent fields as not stated.
Create the calendar workbook
Use: Claude
Upload the table and ask for a workbook with proposed windows, review gate columns and a formula check that dependencies come before windows.
Details
What to paste into the tool
Create an Excel workbook from the attached table. Add proposed publication window and review gate columns, an owner load summary and a check column that flags any item scheduled before its dependency. Do not mark items as published.
Test the workbook and approve or hold
Use: You
Adjust windows by hand, confirm flags, and list unresolved capacity conflicts. Approve or hold the calendar; publishing is separate.
Check
Dependencies precede windows; conflicts listed. The workbook's flags are all confirmed or dismissed.

Compare the three approaches

No path is ranked. Choose by who should do the reading or arithmetic, how much traceability to source passages is needed, and which tool the team already uses.

Option A: Gemini: drafts the table and calendar

Best when: You want a calendar draft from a modest backlog

What it does: Gemini drafts table and calendar; you gate

Strong at: Chats by text, voice, photo or camera

Limit: Capacity conflicts are listed, not solved; you resolve them

Free plan: Yes

Option B: Notion AI: fills properties, you place items

Best when: You want to do the ordering yourself in Notion

What it does: Notion AI fills properties; you place items

Strong at: Drafts, edits and translates content in your workspace

Limit: Autofill guesses from page text; check every value

Free plan: Paid plan needed (Free and Plus get a trial)

Option C: You build the table; Claude builds the workbook

Best when: You want an editable workbook owners can adjust

What it does: You build the table; Claude builds the workbook

Strong at: Drafts and edits text in many formats

Limit: Formula checks catch order errors; you confirm each flag

Free plan: Yes

Build a content calendar from campaign milestones

An editorial calendar with review gates and a list of unresolved capacity conflicts.

Gemini: drafts the table and calendar

Collect the planning documents

Draft the dependency table

Correct the table

Draft the calendar

Read the calendar and decide

Notion AI: fills properties, you place items

Create a page per backlog item

Set up autofill

Check values and set dependencies

Place items in calendar order

Decide approval

You build the table; Claude builds the workbook

Build the dependency table by hand

Create the calendar workbook

Test the workbook and approve or hold

Compare the three approaches

Option A: Gemini: drafts the table and calendar

Option B: Notion AI: fills properties, you place items

Option C: You build the table; Claude builds the workbook

Tools in this workflow

Final check

Build a content calendar from campaign milestones

An editorial calendar with review gates and a list of unresolved capacity conflicts.

Gemini: drafts the table and calendar

Collect the planning documents

Draft the dependency table

Correct the table

Draft the calendar

Read the calendar and decide

Notion AI: fills properties, you place items

Create a page per backlog item

Set up autofill

Check values and set dependencies

Place items in calendar order

Decide approval

You build the table; Claude builds the workbook

Build the dependency table by hand

Create the calendar workbook

Test the workbook and approve or hold

Compare the three approaches

Option A: Gemini: drafts the table and calendar

Option B: Notion AI: fills properties, you place items

Option C: You build the table; Claude builds the workbook

Tools in this workflow

Final check

Share this page