Workflow
Omnichannel Content Campaign Generator
Transform any video or podcast URL into a ready-to-publish content campaign including a newsletter, LinkedIn posts, and a Twitter thread delivered straight to Notion.
Tags
Content CreationSocial MediaWeb ScrapingMarketing Automation
Overview
This workflow turns a single video or podcast URL into a set of ready-to-publish content pieces across multiple platforms. Starting from just a URL, it automatically scrapes the full transcript, crafts a newsletter, LinkedIn posts, and a Twitter thread, then delivers everything directly to your Notion content calendar with a Slack notification.
It accomplishes this through a precise sequence of steps:
- Listens for an incoming webhook with the content URL and an optional test mode.
- Extracts the URL and test mode settings or defaults to a sample video if none provided.
- Uses an AI agent to browse the webpage and extract the full, unedited transcript or article text.
- Sends the transcript to a specialized AI writer to produce four polished content assets.
- Standardizes the content output and adds a timestamp.
- Creates a new page in a Notion database containing all the generated content.
- Sends a Slack message notifying the team that the new content is ready.
What you need
- A Needle account to run this workflow.
- Access to the Needle AI v2 connectors.
- A Notion account with a configured database to receive content pages.
- Authorization for the Notion connector with write access to your content database.
- A Slack workspace and channel where notifications will be sent.
- The Slack connector authorized to post messages.
How the flow works
| Node | Function |
|---|---|
| Webhook Trigger | Begins the workflow when it receives a payload containing a Content URL and optional Test Mode flag. |
| Triage Gate (Code) | Reads the URL and test mode. If Test Mode is on, it returns mock content to verify system routing. |
| Webpage Extractor (AI Agent) | Visits the URL and extracts every word of the spoken transcript or article body text without summarizing. |
| Content Multiplier (AI Agent) | Takes the raw transcript and generates four unique content assets based on specific prompts. |
| Output Router (Code) | Standardizes the final output shapes, ensuring all assets and metadata are correctly formatted. |
| Notion Page Creator | Creates a new page inside your Notion database, inserting the content under appropriate headings. |
| Slack Notification Sender | Sends a message to your Slack channel informing you that the content is live in Notion. |
Content Outputs Generated
- Newsletter: A 500-word formatted piece with a clear hook and actionable takeaway.
- LinkedIn Post 1: A story-driven post designed to spark engagement.
- LinkedIn Post 2: An actionable listicle extracting key points from the transcript.
- Twitter Thread: A five-part thread with a compelling hook, core points, and a clear call to action.
Notes
- Test mode is highly useful for verifying the workflow setup without invoking live URL scraping or AI content generation.
- The scraper extracts the full transcript or article text exactly, meaning the source material quality directly impacts the output quality.
- The AI writing prompt is configured to sound natural and human, avoiding common corporate jargon.
- Ensure your Notion database schema allows for page creation via API and that your Slack channel ID is correct.
- You can modify the system prompts to tweak the style, tone, or length of the generated content.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
