Create balanced quiz videos and answer packs with Google Sheets and Zvid
UnknownWhat this workflow does
This workflow has 39 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Google Sheets and Zvid (community).
How it runs
Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).
- Set quiz episode and rotation rules (Edit Fields (Set)): sets or maps fields
- Read the approved question bank (Google Sheets): uses Google Sheets
- Read Quiz Episodes recovery log (Google Sheets): read (sheet)
- Select an easy medium and hard question (Code): runs custom JavaScript code
- Eligible source content or saved render exists? (If): checks a condition and branches into true / false
- Resume the accepted render job? (If): checks a condition and branches into true / false
- Explain skipped content or recovery needs (Code): runs custom JavaScript code
- Restore the saved result and handoff context (Code): runs custom JavaScript code
- A background music URL is configured? (If): checks a condition and branches into true / false
- Track the saved job and its source context (Code): runs custom JavaScript code
…plus 27 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @zvid/n8n-nodes-zvid is verified or supports 3.0 (used in Validate the video and request its credit quote, Submit this approved video to Zvid, Wait for this accepted Zvid render).
Nodes used (9)
- Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Zvid
@zvid/n8n-nodes-zvid.zvid - Wait
n8n-nodes-base.wait
From the author
Quick overview Create balanced three-round quiz videos from a reviewed Google Sheets question bank. Rotate topics and answer positions, prevent question reuse, and deliver a Zvid video with a source-backed answer CSV for editorial review. How it works 1.…