Create an interview clip library using WayinVideo, Google Drive and Sheets

Paste your interview recording URL into a simple form, describe the moments you want to find, and the workflow takes care of everything else. WayinVideo AI scans the full recording and extracts only the clips that match your search — then downloads each one, uploads it to Google Drive, and logs every detail into a Google Sheet library. You receive a summary email with a direct link to your library the moment all clips are saved. Built for podcast producers, content teams, and agencies who want to build a searchable clip archive from interview recordings without any manual editing. --- What This Workflow Does - AI moment extraction — Sends your interview URL and a plain-English query to WayinVideo, which finds and exports only the clips matching your description - Smart file naming — Each clip is saved to Google Drive with a filename that includes the guest name, clip number, and relevance score — so your folder stays organised from day one - Searchable clip library — Saves every clip's title, description, timestamp, score, tags, and Drive link to a Google Sheet — so your whole team can search and reuse clips later - Auto-polling with retry — Waits 90 seconds, then checks if clips are ready, and loops back every 30 seconds automatically until processing is complete - Permanent Drive storage — Clips are uploaded to Google Drive immediately — no risk of losing them when WayinVideo export links expire after 24 hours - Summary email on completion — Sends a confirmation email with a link to your Google Sheet library as soon as all clips are saved - Form-based input — Anyone on your team can submit an interview and query through a web form — no access to n8n required --- Setup Requirements Tools you'll need: - Active n8n instance (self-hosted or n8n Cloud) - WayinVideo account + API key - Google account connected to n8n via Google Drive OAuth2 - Google account connected to n8n via Google Sheets OAuth2 - Google account connected to n8n via Gmail OAuth2 - A Google Sheet with a tab named exactly: Interview Clip Library Estimated Setup Time: 15–20 minutes --- Step-by-Step Setup 1. Get your WayinVideo API key Log in at WayinVideo, go to your account settings or developer section, and copy your API key. 2. Paste the API key into node "2. WayinVideo — Submit Find Moments" Open this node, find the Authorization header value, and replace YOURWAYINAPIKEY with your actual key. 3. Paste the API key into node "4. WayinVideo — Get Clips Result" Open this node, find the same Authorization header, and replace YOURWAYINAPIKEY again. > ⚠️ This key appears in 2 nodes — you must replace it in both "2. WayinVideo — Submit Find Moments" and "4. WayinVideo — Get Clips Result". Missing either one will cause the workflow to fail. 4. Set your Google Drive folder ID in node "9. Google Drive — Upload Clip" Open this node and replace YOURGDRIVEFOLDERID with your actual folder ID. To find it: open your target Google Drive folder in a browser — the folder ID is the string of letters and numbers at the end of the URL after /folders/. Then connect your Google Drive credential via OAuth2 in the same node. 5. Set your Google Sheet ID in node "10. Google Sheets — Save to Library" Open this node and replace YOURGOOGLESHEETID with your actual Sheet ID. To find it: open your Google Sheet in a browser — the Sheet ID is the long string in the URL between /d/ and /edit. Then connect your Google Sheets credential via OAuth2 in the same node. > ⚠️ Before running the workflow, make sure your Google Sheet has a tab named exactly Interview Clip Library — the sheet name must match this exactly or the workflow will fail to save rows. 6. Connect your Gmail account in node "11. Gmail — Send Summary Email" Open this node, click the credential field, and connect your Google account via Gmail OAuth2. Follow the on-screen prompts to authorise n8n. 7. Activate the workflow Toggle the workflow to Active. Open the form URL generated by node "1. Form — Interview URL + Details" and subm