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

Created by

isaWOW

Last update

Last update 20 hours ago

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

Get your WayinVideo API key
Log in at WayinVideo, go to your account settings or developer section, and copy your API key.
Paste the API key into node "2. WayinVideo — Submit Find Moments"
Open this node, find the Authorization header value, and replace YOUR_WAYIN_API_KEY with your actual key.
Paste the API key into node "4. WayinVideo — Get Clips Result"
Open this node, find the same Authorization header, and replace YOUR_WAYIN_API_KEY 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.
Set your Google Drive folder ID in node "9. Google Drive — Upload Clip"
Open this node and replace YOUR_GDRIVE_FOLDER_ID 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.
Set your Google Sheet ID in node "10. Google Sheets — Save to Library"
Open this node and replace YOUR_GOOGLE_SHEET_ID 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.
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.
Activate the workflow
Toggle the workflow to Active. Open the form URL generated by node "1. Form — Interview URL + Details" and submit a test interview URL to confirm the full workflow runs end to end.

How It Works (Step by Step)

Step 1 — Form Trigger (Web Form)
The workflow starts when someone fills in the web form. You enter five things: the interview recording URL (Zoom, YouTube, or any direct link), the guest's name, the interview topic or category, a plain-English description of what moments to find, and the email address for the summary. The form includes query tips to help users write better searches — the form description gives examples like "career advice and turning point moments" to guide them.

Step 2 — Submit to WayinVideo Find Moments
The recording URL, search query, and project name (built from the guest name and topic) are sent to WayinVideo's Find Moments endpoint. The request asks for up to 5 matching clips at HD 720p quality with original-language captions. WayinVideo scans the video and returns a task ID to track the job.

Step 3 — Wait 90 Seconds
The workflow pauses for 90 seconds to give WayinVideo time to scan the recording before checking for results. This prevents the workflow from requesting results before they are ready.

Step 4 — Poll WayinVideo for Results
The workflow calls WayinVideo's results endpoint using the task ID from Step 2. It checks whether the clips have been found and exported yet, and receives either a completed clips list or a status showing the job is still running.

Step 5 — Check: Status SUCCEEDED? (YES / NO branch)

YES — If the status equals SUCCEEDED, the workflow moves forward to split and process each clip.
NO — If the job is still running, the workflow routes to a 30-second wait and then loops back to Step 4 to check again. This repeats automatically until the clips are ready.

⚠️ Infinite Loop Risk: If WayinVideo never returns SUCCEEDED — due to an invalid URL, private video, or API error — this loop runs forever. Add a retry counter to stop after 8–10 attempts and send an error notification instead.

Step 6 — Wait 30 Seconds (Retry)
When clips are not ready yet, the workflow pauses 30 seconds before checking again. This gap prevents too many requests hitting the WayinVideo API in quick succession.

Step 7 — Split Each Clip (Code)
Once clips are ready, this step reads the full clips list and splits it into individual results — one per clip. Each result carries the clip title, download link, relevance score, description, tags, start time, end time, and clip index number.

Step 8 — Download Each Clip File
For each clip, the workflow fetches the video file from WayinVideo's export link and downloads it as a binary file — ready to be uploaded to Google Drive.

Step 9 — Upload to Google Drive
Each downloaded clip is uploaded to your specified Google Drive folder. The filename is built automatically using the guest name, clip number, and relevance score — for example: Raj_Sharma_Clip_1_Score_87.mp4. This keeps your Drive folder organised and sortable by score.

Step 10 — Save to Google Sheets Library
After each clip is uploaded, the workflow adds a new row to your Interview Clip Library sheet. It records the guest name, topic, query used, clip title, description, timestamp range, relevance score, tags, a direct Google Drive view link, the Drive file ID, the original interview URL, and the date. This creates a searchable, permanent library your whole team can use.

Step 11 — Gmail Sends Summary Email
After all clips are saved to the sheet, a summary email is sent to the address you entered in the form. The email confirms that clips have been uploaded to Google Drive and saved to the library, and reminds you to open the Interview Clip Library sheet to access all the Drive links.

The final result is a set of clips in Google Drive, a fully logged library row per clip in Google Sheets, and a confirmation email — all from one form submission.

Key Features

✅ Plain-English search queries — Describe moments in normal language — "failure and comeback story" or "key career turning point" — and WayinVideo finds them
✅ Score-based file naming — Every clip filename includes the guest name and relevance score — so your Drive folder is self-sorting and instantly readable
✅ Permanent clip archive — Clips are saved to Google Drive immediately — no 24-hour expiry risk because the file is stored before the export link dies
✅ Full metadata in Google Sheets — Every clip's title, description, timestamp, score, tags, and Drive link are logged — your team can search and reuse clips without rewatching recordings
✅ Auto-retry polling — The workflow keeps checking until clips are ready — no manual monitoring needed
✅ Guest + topic project naming — WayinVideo jobs are named using the guest name and topic you enter — so your WayinVideo project dashboard stays organised too
✅ Captions on every clip — Original-language captions are embedded in each exported clip — useful for accessibility and silent viewing
✅ One summary email per run — A single confirmation email is sent after all clips are saved — clean and non-spammy

Customisation Options

Extract more clips per search
In node "2. WayinVideo — Submit Find Moments", change "limit": 5 to a higher number — use 10 to get a broader set of matching moments from longer recordings.

Upgrade to Full HD resolution
In node "2. WayinVideo — Submit Find Moments", change "resolution": "HD_720" to "FULL_HD_1080" for higher quality exports — useful for client-facing or broadcast use.

Generate vertical clips for social media
In node "2. WayinVideo — Submit Find Moments", add "enable_ai_reframe": true and "ratio": "RATIO_9_16" to automatically reframe clips to 9:16 vertical format — ready for Reels, Shorts, or TikTok.

Add a Slack notification when the library is updated
Insert a Slack node after "11. Gmail — Send Summary Email" to post a channel message with the guest name, topic, and number of clips saved — so your team gets notified without checking email.

Sort clips into guest-specific Drive subfolders
In node "9. Google Drive — Upload Clip", change the folder ID to a dynamic expression using the guest name field from the form — so each guest's clips automatically go into their own subfolder.

Add a retry limit to stop infinite loops
Add a Set step before "6. Wait — 30 Seconds Retry" to track a retry counter, then add a second IF check to stop after 10 attempts and route to "11. Gmail — Send Summary Email" with a failure message instead of looping forever.

Troubleshooting

WayinVideo API key not working:

Check that you replaced YOUR_WAYIN_API_KEY in both "2. WayinVideo — Submit Find Moments" and "4. WayinVideo — Get Clips Result" — missing either one causes the workflow to fail
Confirm your WayinVideo account is active and the key has not expired or been revoked
Make sure there are no extra spaces before or after the key when pasting

Workflow stuck in the retry loop:

Check that the interview recording URL is publicly accessible — private, password-protected, or region-blocked videos will not be processed by WayinVideo
Open the output of "4. WayinVideo — Get Clips Result" and inspect the raw response — WayinVideo may have returned an error message explaining the failure
If the status never reaches SUCCEEDED, deactivate and reactivate the workflow, fix the video URL, and resubmit the form

Google Drive upload failing:

Open node "9. Google Drive — Upload Clip" and confirm the Google Drive OAuth2 credential is connected and not expired — reconnect it if needed
Confirm YOUR_GDRIVE_FOLDER_ID was replaced with just the folder ID string (e.g. 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs), not the full URL
Check that your Google account has write permission for the target folder

Google Sheets not saving rows:

Confirm your Google Sheet has a tab named exactly Interview Clip Library — the name must match character-for-character, including capitalisation
Open node "10. Google Sheets — Save to Library" and check that YOUR_GOOGLE_SHEET_ID was replaced with just the Sheet ID (the string between /d/ and /edit in the Sheet URL)
Check that the Google Sheets OAuth2 credential is connected and not expired — reconnect it in n8n credentials if needed

No clips found (empty results):

Your query may be too short or too vague — WayinVideo needs descriptive phrases to find relevant moments; try "career advice and lessons learned" instead of just "advice"
Confirm the recording has clear spoken audio — low-quality audio or heavy background noise reduces accuracy
Check that the recording URL is a direct video link and not a login-required viewer or landing page

Support

Need help setting this up or want a custom version built for your team or agency?

📧 Email:[email protected]
🌐 Website:https://isawow.com