n8n Google Sheets Quiz Generator: Zvid Quiz Shorts & Answer CSV

Generate Zvid Quiz Shorts from Your Google Sheets—With Balanced Questions & an Answer CSV

This n8n workflow reads your reviewed Google Sheets question bank, automatically builds three-round quiz shorts for Zvid, rotates topics and answer positions, avoids question reuse, and outputs a completed MP4 plus a source-backed answer CSV for editorial review.

What this workflow does

Using your quiz rules, episode history, and question bank, the workflow runs (manually or on a schedule) to produce consistent, balanced quiz videos:

• Selects approved questions from your Google Sheets for one easy, one medium, and one hard round.
• Prevents reuse by rejecting duplicate text and excluding questions already used in prior episodes, while preferring less-used topics.
• Rotates answer positions reproducibly so the correct answer stays correct while the display order changes.
• Builds quiz scenes (question, countdown, and reveal) and validates design output within the Zvid credit ceiling.
• Resumes smartly: if you already have a saved job, it resumes without spending credits again; it can also skip a completed episode.
• Runs in live mode by reserving an episode key, submitting one render, saving the job ID, polling for the accepted job outcome, and delivering the final MP4 plus a CSV answer and a source pack for review.

Use cases

• Turn an existing Google Sheets quiz repository into recurring n8n automation for Zvid quiz shorts.
• Editorial teams review the generated answer CSV before publishing.
• SaaS operators manage high-volume quiz production while controlling render capacity and credits.

Technical details

• Integrations: Google Sheets question-bank tab + Zvid rendering.
• Zvid setup: install @zvid/n8n-nodes-zvid, create Zvid API credential (Base URL: https://api.zvid.io), and select it on all Zvid nodes.
• n8n nodes/workflow logic: if, set, code, wait, zvidn8n-nodes-zvid, and sticky note for configuration guidance.