Create short social video clips from webinars with WayinVideo, Google Sheets and Gmail

Description Submit any YouTube, Vimeo, or Zoom webinar URL using a simple form and the workflow handles everything from there. It runs a two-phase pipeline: first identifying the top viral moments in your video without rendering anything, then exporting only the best clips as ready-to-post 9:16 vertical videos with animated captions, an AI hook, and AI subject reframing. Every clip is logged to Google Sheets and a Gmail digest with direct download links arrives in your inbox when all clips are ready. Built for content marketers and social media teams who want to turn a 1–2 hour webinar into short video content without any manual editing. --- What This Workflow Does - Identifies viral moments first, renders second — Phase 1 scans the entire video and ranks all potential clips by viral score before any rendering happens, so you only pay to export the best ones - Exports clips as 9:16 vertical video — Renders each selected clip in portrait format with animated captions, an AI-generated hook, and AI subject reframing — ready to post on TikTok, Reels, or Shorts - Runs two independent polling loops — Waits patiently for both the identification phase (up to 25 minutes) and the rendering phase (up to 20 minutes) with hard timeouts to prevent indefinite hanging - Sorts clips by viral score — Picks only the highest-scoring clips up to your chosen maximum so the best content always gets exported first - Logs every clip to Google Sheets — Appends one row per clip with title, duration, viral score, tags, description, and download link for your content library - Sends a Gmail digest with download links — Delivers all clip details and direct download links in one email after all clips are logged — with a 24-hour expiry warning so you download immediately --- Setup Requirements Tools Needed - n8n instance (self-hosted or cloud) - WayinVideo account with API access - Google Sheets (one sheet with a tab named Social Media Clips) - Gmail account (the account you want to receive the digest) Credentials Required - WayinVideo API key (pasted into 2. Set — Config Values) - Google Sheets OAuth2 - Gmail OAuth2 Estimated Setup Time: 10–15 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import 2. Get your WayinVideo API key — Log in to your WayinVideo account → go to your account or API settings dashboard → copy your API key 3. Fill in Config Values — Open node 2. Set — Config Values → replace all placeholders: | Field | What to enter | |---|---| | YOURWAYINVIDEOAPIKEY | Your WayinVideo API key from step 2 | | YOURGOOGLESHEETID | The ID from your Google Sheet URL (the string between /d/ and /edit) | | Social Media Clips | Leave as-is, or change to match your sheet tab name exactly | | [email protected] | The email address where the Gmail digest should be sent | | YOUR NAME | Your name for the email sign-off | | targetDuration | Leave as DURATION3060 for 30–60 second clips, or change to match WayinVideo's supported duration options | | exportRatio | Leave as RATIO916 for vertical video, or change if you want a different aspect ratio | | exportResolution | Leave as HD720 or change to a higher resolution if your WayinVideo plan supports it | 4. Create your Google Sheet tab — Open your Google Sheet → add a tab named exactly Social Media Clips → add these 10 column headers in row 1: Date, Video Title, Clip , Clip Title, Duration (sec), Viral Score, Tags, Description, Export Link, Logged At 5. Connect Google Sheets — Open node 19. Google Sheets — Log Clips → click the credential dropdown → add Google Sheets OAuth2 → sign in with your Google account → authorize access 6. Connect Gmail — Open node 22. Gmail — Send Clips Digest → click the credential dropdown → add Gmail OAuth2 → sign in with the Gmail account that matches recipientEmail → authorize access 7. Activate the workflow — Toggle the workflow to Active → copy the Form URL from node 1. Form — Enter Video URL → open it in