Automate Your Video Clipping and Content Strategy
detail.loadingPreview
Streamline your video content workflow by automating the scraping of new videos, sending them to Vizard for clipping, and organizing the results into a Google Sheet. This solution helps you efficiently repurpose video content for maximum reach.
About This Workflow
This n8n workflow automates the process of discovering, processing, and organizing video content. It begins by scraping new videos from a specified channel and sending them to Vizard for advanced clipping and analysis. The workflow then retrieves detailed project information from Vizard, splits out individual video assets, and appends key data like titles, URLs, transcripts, and even viral scores to a Google Sheet. This comprehensive automation saves significant manual effort, allowing you to focus on content strategy and distribution. The included sticky notes provide clear guidance on customization, ensuring you can easily adapt the workflow to your specific needs and integrate it with your existing tools.
Key Features
- Automated Video Scraping: Automatically identify and ingest new videos from your chosen YouTube channel.
- Vizard Integration: Seamlessly send videos to Vizard for intelligent clipping and analysis.
- Data Extraction & Organization: Retrieve detailed project information and organize extracted video data into a Google Sheet.
- Customizable Workflow: Easily adjust settings for Vizard credentials, Google Sheets integration, and other parameters.
- Efficient Content Repurposing: Streamline the process of turning long-form videos into shareable clips.
How To Use
- Scrape & Send Section:
- RSS Feed Node: Configure the YouTube channel URL you want to scrape for new videos.
- Vizard Credentials: Update the
VIZARDAI_API_KEYin the 'Send Longform to Vizard' HTTP Request node with your actual Vizard API key. - Limit Node (Optional): Deactivate this node if you want to process all scraped videos, or keep it enabled to limit the number of videos sent to Vizard per run (e.g., for testing).
- Retrieve & Generate Section:
- Webhook Node: This node is configured to receive data from Vizard upon project creation. Ensure your Vizard setup is correctly pointing to this webhook endpoint.
- Vizard Credentials: Update the
VIZARDAI_API_KEYin the 'Retrieve Vizard Project' HTTP Request node. - Retrieve Vizard Project Node: This node uses
{{$json.projectId}}which is expected to be provided by the incoming webhook data. - Split Out Node: This node is configured to split out items from the
videosarray returned by the Vizard API. - Loop Over Items Node: This node helps manage the processed items before appending to the sheet.
- Google Sheets Node ('Append row in sheet'):
- Connect your Google Account: Authenticate with your Google account to access your spreadsheets.
- Spreadsheet ID & Sheet Name: Specify the ID of your Google Sheet and the name of the sheet where you want to append data. You can find a template linked in the sticky note.
- Column Mapping: Ensure the
columnssection correctly maps the data from previous nodes (e.g.,title,videoId,videoUrl,generatedCaption) to your desired Google Sheet columns. The provided structure shows an example mapping.
- Testing and Activation:
- Click 'Execute workflow' in the 'When clicking ‘Execute workflow’' node to manually trigger the initial scraping and sending process.
- Monitor the workflow execution in n8n to identify any errors and ensure data is flowing correctly between nodes.
- Once confirmed, you can set up a scheduler in n8n to run the workflow automatically at your desired intervals.
Apps Used
Workflow JSON
{
"id": "1ce078f9-3981-46a9-88a8-b37bf5b893e3",
"name": "Automate Your Video Clipping and Content Strategy",
"nodes": 11,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 1ce078f9-3981...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.