Skip to content
ToolDeck

Marketing & Content

Content Pipeline Tracker

Ideas to drafts to published — a Notion board that moves cards when you do.

Saves about ~2 hrs per week

What it does

  • Gives you a ready-made Notion board for idea → draft → published
  • Moves a card's status automatically when the linked doc changes
  • Pings you when something's sat in Draft for too long
  • Rolls up a weekly summary of what shipped

How it works

  1. New idea added to the board
  2. Card links to a draft doc
  3. Status syncs as the doc moves through review
  4. Weekly review summary posted automatically

What's included

  • Notion template
  • Status automation
  • Weekly review summary

Set it up yourself

Follow these 4 steps in order. You will need accounts for: Notion.

Step 1: Duplicate the template

  1. Open the guide's Notion template link (it is a public duplicate link on the page).
  2. Click Duplicate, pick your workspace, and note the resulting page's URL.
  3. The board has four statuses: Idea, Drafting, In Review, Published.
  4. Set your properties: Status (select), Type (post/newsletter/video), Published URL, Last Moved.
  5. No code needed yet — just get comfortable with the board.

Watch out: Do not rename the Status property — the automation reads it by exact name.

Step 2: Connect your draft tool

  1. Decide the draft source: Google Docs or Notion pages.
  2. Create an internal Notion integration at https://www.notion.so/my-integrations (name it content-sync, give it read/write).
  3. Copy the integration's internal token.
  4. In Notion, open the board page → ⋯ → Connections → add your content-sync integration.
  5. Test: via a tool like Postman or n8n, list your pages to confirm the integration can read them.

Watch out: The integration must be added to the page (Connections) or it returns 404 — the most common setup error.

Step 3: Turn on status sync

  1. Choose the sync method: n8n (Schedule node → Notion 'Query Database' + 'Update Page') is easiest on the free tier.
  2. Add the schedule to run every 15-30 minutes.
  3. Query pages whose linked doc was edited since the card's Last Moved.
  4. Update the Status accordingly (Drafting if the doc changed, or flip to In Review when the doc's review field is set).
  5. Test by editing a draft doc and confirming the board status moves.

Watch out: Store 'Last Moved' in a property — otherwise the sync re-triggers every run and flips statuses forever.

Step 4: Set your weekly summary day

  1. Add a second scheduled run (e.g. Friday 5pm) that queries published and draft counts.
  2. Build a summary message: shipped this week, stuck in Draft 7+ days, idea queue size.
  3. Post it to your content Slack channel or email.
  4. Use the 'stuck in Draft' list as your Sunday planning input.
  5. Adjust the cadence after two weeks of use.

Watch out: The stuck-in-draft flag is the part that saves time — without it the board is just a pretty list.

Frequently asked questions

What does the Content Pipeline Tracker automation do?

Ideas to drafts to published — a Notion board that moves cards when you do. Gives you a ready-made Notion board for idea → draft → published

How much time does Content Pipeline Tracker save?

It is estimated to save ~2 hrs per week. Actual savings depend on your volume.

Which tools does Content Pipeline Tracker use?

It works with Notion.

What does Content Pipeline Tracker include?

Notion template, Status automation, Weekly review summary.

Can I set up Content Pipeline Tracker myself?

Yes. The do-it-yourself guide on this page walks through 4 steps, from getting access to testing the finished automation.