Create Content Calendars From Media
Transform media URLs into a 30-day content calendar featuring SEO blogs, newsletters, LinkedIn carousels, and Twitter threads, saved to Google Docs and shared via Slack.
Content CreationSocial MediaContent CalendarMarketing Assets
The Omni Channel Director
This workflow transforms a podcast or video URL into a rich, multi platform content calendar. By extracting transcripts and leveraging AI, it produces an SEO blog post, newsletter, LinkedIn carousels, and Twitter threads, then organizes everything into a Google Doc and shares it on Slack.
It performs these core steps:
- Listens for a new media URL and test mode flag via webhook.
- Decides whether to run in test mode or production mode.
- Fetches the transcript from your preferred transcription API when in production mode.
- Uses an advanced AI model to analyze the transcript and generate specific marketing content.
- Creates a new Google Doc in your specified folder with all the generated content neatly formatted.
- Sends a Slack message to notify your team with a link to the created document.
What You Need
- An API key for a transcript provider like Apify or RapidAPI.
- Access to a capable AI model configured in the AI node.
- A Google account with permissions to create documents and a folder ID to save new files.
- Slack workspace access with a channel ID to receive notifications.
- Your environment configured for webhook requests.
How The Flow Works
| Node | Action |
|---|---|
| Webhook Trigger | Listens for an incoming JSON payload containing the media URL and a test mode flag to kick off the flow. |
| The Gatekeeper | Checks the test mode flag. If true, it prepares mock content to avoid using external APIs or AI credits. If false, it sets production status and passes the media URL forward. |
| HTTP Request | When in production mode, calls your transcription API endpoint with the media URL to fetch the transcript text. |
| Router | Detects if transcription succeeded or failed. On failure, it outputs mock transcript data. On success, it extracts the transcript text to pass along. |
| AI Agent | Feeds the transcript or mock data into an expert prompt telling the AI agent to generate four detailed content types. The AI returns a document title and formatted content. |
| Google Docs Creation | Creates a new Google Doc with the AI generated title and content inside your specified folder. |
| Slack Message Sender | Sends a notification to your chosen Slack channel with a friendly message and a direct link to the new Google Doc. |
Output
At the end, you receive a nicely formatted Google Doc containing:
- A full 1000 word SEO optimized blog post.
- A concise weekly newsletter suitable for executives.
- Three distinctive LinkedIn carousel sets with slide by slide content.
- Five engaging Twitter thread starters with detailed follow ups.
Plus, your team gets a Slack alert with the document link for quick access.
Notes
- Start by running in test mode to verify integration and Google Doc routing without consuming AI credits.
- Ensure your transcription API endpoint and keys are correctly set in the HTTP request node before production runs.
- Adjust AI model parameters like temperature and max tokens based on your preferred tone and content length.
- Update your Slack channel ID and Google Drive folder ID for proper notifications and document storage.
- This workflow is ideal for repurposing episodic audio or video content into ready to publish marketing assets quickly.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
