Create onboarding video quizzes using WayinVideo, GPT-4o-mini and Google Sheets

Description

Paste any onboarding video URL into a simple form and the workflow handles everything automatically. It transcribes the video, sends the full transcript to an AI that writes the exact number of quiz questions you requested, and saves the complete quiz directly to your Google Sheet. Built for HR teams, L&D managers, and anyone who creates employee training content at scale.

---

What This Workflow Does

- Accepts video input via form — Collects the video URL, department topic, and desired question count from a clean, shareable web form - Transcribes the video automatically — Sends the video to WayinVideo and receives a clean, timestamped transcript with speaker labels - Polls until transcription is ready — Waits 45 seconds then keeps checking until the transcript is fully complete before moving forward - Generates accurate MCQ questions — An AI agent reads the full transcript and creates exactly the number of questions requested, each with four options and a correct answer - Anchors every question to the transcript — Each question includes a speaker reference and timestamp so you can verify answers directly in the video - Saves the quiz to Google Sheets — Appends all questions, metadata, and generation timestamp to your Quiz Bank tab automatically

---

Setup Requirements

Tools you'll need