Create Content Calendars From Transcripts
Transform media transcripts into a 30-day content calendar including SEO blogs, newsletters, and social media posts, then save to Google Docs and share via Slack.
The Omni Channel Director
This workflow transforms a podcast or media URL into a rich, multi-platform content calendar. By extracting the transcript and leveraging an AI agent, it generates an SEO blog post, a weekly newsletter, LinkedIn carousels, and Twitter threads. Everything is seamlessly organized into a Google Doc and shared with your team via a Slack notification.
It performs 6 primary steps:
- Listens for a media URL and test mode flag via a webhook.
- Determines if it is running in test mode or production.
- Fetches the media transcript from a transcription API (unless in test mode).
- Sends the transcript to a powerful AI model to generate multiple marketing content types.
- Creates a Google Doc with all generated content neatly formatted.
- Posts a Slack message linking to the newly created document.
What You Need
- An account with a transcription API provider (such as Apify or RapidAPI) and an API endpoint URL.
- An OpenAI or Needle AI key to access advanced AI models.
- A Google account with Google Docs API access and a Google Drive folder ID where documents will be saved.
- A Slack workspace and channel ID to receive notifications.
- The Needle platform to build and run this workflow.
How The Flow Works
| Step | Node | Description |
|---|---|---|
| 1 | Webhook Trigger | Starts the flow when you send your media URL and test mode flag as a POST request. |
| 2 | The Gatekeeper (Code Node) | Checks if Test Mode is enabled. If enabled, it skips costly API calls and returns mock content to ensure everything routes correctly. |
| 3 | HTTP Request Node | Fetches the transcript from the transcription API using the media URL, unless running in mock mode where the URL is empty to induce a controlled error. |
| 4 | Router Code Node | Detects if the HTTP request succeeded or failed. On failure, it injects mock transcript data for test runs. On success, it passes the transcript forward. |
| 5 | Needle AI Node | Analyzes the transcript to create four core marketing assets: a 1000-word SEO blog post, a 500-word executive newsletter, three LinkedIn carousel sets, and five Twitter/X threads. |
| 6 | Google Docs Node | Creates a new Google Doc inside a specified Drive folder, titled based on the generated document title, and inserts all the formatted content. |
| 7 | Slack Notification Node | Sends a message to your chosen Slack channel with a link to the Google Doc so your team can access the newly generated content. |
Output
At the end, you get a beautifully formatted Google Document containing a complete 30-day content calendar. This document includes a detailed SEO blog, an executive newsletter, LinkedIn carousel frameworks, and Twitter thread ideas — all derived from your media source.
You also receive a Slack message linking directly to this document for easy sharing and review.
Important Notes
- Run your first tests with Test Mode set to true to avoid unnecessary API costs and to verify document creation.
- Ensure your transcription API allows for secure and authorized access with proper headers.
- The AI node uses a sophisticated prompt to produce well-structured multi-format content. Modifying the prompt can change the output style.
- Update your Google Drive folder ID and Slack channel ID placeholders before running for real.
- Be mindful of token limits in AI calls. Set max tokens high enough and avoid truncating long transcripts.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
