Hey n8n community!
Sharing a workflow I built using WayinVideo API + GPT-4o-mini that automatically converts any onboarding or training video into multiple choice quiz questions — saved straight to Google Sheets.
What It Does
Paste a training video URL into a form, pick your topic and how many questions you want — the workflow transcribes the video, generates MCQs from the actual content, and saves everything to your Google Sheets Quiz Bank.
Each question comes with 4 options, the correct answer, and a reference to the speaker and timestamp it came from.
How It Works
- Form — video URL, department/topic, number of questions
- WayinVideo API — transcribes the full video with speaker labels and timestamps
- Polling loop — waits until transcription is complete
- GPT-4o-mini — generates exact number of MCQs based only on what was said in the video
- Google Sheets — saves quiz to Quiz Bank tab
Setup
- Add your WayinVideo API key in the two HTTP Request nodes — Video Transcription API - WayinVideo API Docs
- Add OpenAI API key in the Chat Model node
- Connect Google Sheets OAuth2
- Set your Sheet ID and make sure the tab is named Quiz Bank
Works with YouTube, Zoom, Loom, Vimeo — any public video URL.
Drop a comment if you want the workflow JSON — happy to share!