LOW / CODEBlueprints
marketing

Content Calendar Automation

Manage your entire content pipeline in Notion with automated reminders via Slack and Google Calendar events for deadlines. Never miss a publish date again.

Intermediate~20 minn8nMake.com 433 downloads 851 views

Setup Instructions

1. In Notion, create a Content Calendar database with properties: Title (text), Status (select: Idea, Draft Ready, In Review, Approved, Published), Assignee (person), Publish Date (date), and Content Type (select). 2. In n8n/Make, add a Notion trigger that watches for updates to the Content Calendar database. 3. Add a Switch/Router node that branches on the Status property value. 4. For "Draft Ready": add a Slack node that messages the assigned reviewer with the page title and a direct Notion link. Include a 48-hour deadline note. 5. For "Approved": add a Google Calendar node that creates an event on the Publish Date with the content title and a link to the Notion page. 6. For "Published": add a Slack node that posts a celebration message to your content channel with the title and publish link. 7. Test by changing a Notion page's status through each stage and confirming notifications fire correctly. 8. Optional: add an additional branch for "In Review" that sets a Slack reminder for the reviewer after 24 hours.
Troubleshooting
**Notion trigger not detecting changes:** The Notion API polling interval can be slow (up to 5 minutes). For near-real-time, consider using Notion's webhook feature if available, or reduce the polling interval in your automation platform. **Google Calendar event created on wrong date:** Notion dates may include timezone info that differs from your calendar. Explicitly convert the Publish Date to your target timezone before passing it to the Google Calendar node. **Slack messages going to wrong person:** Ensure the Assignee field in Notion maps to a valid Slack user ID or email. You may need a lookup step to convert Notion person names to Slack member IDs. **Duplicate notifications on status change:** Notion triggers can fire multiple times if a page is edited rapidly. Add a deduplication check using the page ID and status combination, or use a cooldown window.

Need a custom version?

We can build a tailored automation workflow for your specific needs.

New blueprints weekly

Get notified when we publish new automation workflows.