Social Publisher — Ai Endpoint Template for Automation
AI Endpoint
Auto-publish from Notion to social media. Poll approved posts, adapt per platform, and schedule via Ocoya.
Template Social Publisher bundles a ready-to-deploy workspace for automation workflows.
Install in one click from the Aerostack dashboard or via aerostack init --template=social-publisher.
What It Does
Connect your Notion content database to social media. The agent polls Notion for posts marked "Approved," adapts the content for each target platform (Twitter, LinkedIn, Instagram), schedules publication via Ocoya, and updates the Notion status to "Published."
Set it on a 30-minute cron and your content pipeline runs itself.
How It Works
- Agent reads your Notion database for rows where Status = "Approved"
- For each post, adapts the content per platform — shorter for Twitter, professional for LinkedIn, visual-first for Instagram
- Schedules via Ocoya MCP at the specified date/time
- Updates the Notion row: Status → "Published", adds the live URL
When To Use This
- Content teams — write once in Notion, publish everywhere automatically
- Founders — maintain a social presence without context-switching to 4 different platforms
- Marketing ops — build an approval workflow in Notion and let the agent handle everything after "Approved"
psychology System Prompt
The instructions that define how this ai endpoint behaves. It ships pre-configured — edit it anytime in your workspace.
You are a social media publishing agent. Query Notion for approved pages, adapt content per platform, schedule via Ocoya, mark as published.
checklist Setup Guide
Setup: 1) Connect Notion MCP. 2) Connect Ocoya MCP. 3) Create Notion DB with Title, Body, Status, Platforms, Scheduled At, Published columns. 4) Set 30-min schedule.
Metadata
What's Included
Required MCPs
MCP servers this template connects to.
Deploy this ai endpoint in minutes
Auto-publish from Notion to social media. Poll approved posts, adapt per platform, and schedule via Ocoya.
More Automation Templates
Browse Automation Templates →Payment Failed Handler
by @aerostack
Stripe payment fails — AI alerts your billing team on Slack and creates a support ticket automatically.
PR Merged Notifier
by @aerostack
PR merges to main — AI checks if critical files changed and notifies your engineering team on Slack.
New Order Processor
by @aerostack
New Shopify order arrives — AI checks inventory levels and alerts your ops team when stock runs low.
Shopify New Order
by @aerostack
New Shopify order — AI checks inventory, flags VIP orders over $500, and logs everything to your database.
Scheduled Data Sync
by @aerostack
Sync data between any two systems on a schedule. CRM to Sheets, API to database, Notion to Linear.
Blog Auto-Share
by @aerostack
New blog post published? AI crafts platform-specific social posts and shares them automatically.
Frequently asked questions
What does the Social Publisher ai-endpoint automate in a content workflow? +
It polls a Notion database for approved posts, rewrites each one for the target platform's tone and length, then schedules publication through Ocoya — no manual copy-paste between tools.
Which MCPs are wired into the Social Publisher template? +
The notion MCP reads from your content database and mcp-ocoya handles scheduling and multi-channel publishing. Both must be connected before the first run.
How do I add a new social channel or Notion status filter to the Social Publisher? +
Add the target channel in your Ocoya account and update the Notion filter in the workspace to match the status tag you use for approved content. Changes apply on the next poll cycle.
Who is the Social Publisher designed for and how frequently does it run? +
Content and marketing teams managing multi-platform publishing from a single Notion CMS. The polling interval is configurable; most teams set it to 15 or 30 minutes.