pipeline
Here is
the complete automated pipeline in pure steps only, from
AI-generated SBQs → human review → automatic Blogger upload.
FULL AUTOMATED SBQ PIPELINE
(AI → Human → Blogger)
1. AI generates SBQ set
- Scenario
- Image link
- 5 questions
- 5 options
- Correct answer
- Explanation for each option
- Cluster ID
- Domain ID
- Output in a structured
Google Sheet / Doc
2. Human reviews the content
- Edits text
- Replaces or approves images
- Approves explanations
- Approves tags
3. Human clicks “Approve” in a Google Sheet column
- This marks the scenario as
final
- Approved data is sent to a
“Ready” sheet
4. Apps Script converts approved SBQs to VIGNETTES JSON automatically
- Script converts each row
into correct JS structure
- Produces final JSON block
used by your exam engine
5. Apps Script inserts JSON automatically into a
Blogger post template
- Uses Blogger API
- Inserts the JSON block
inside Part 2 of your exam code
- Fills the title and metadata
- Assembles complete HTML
(Part 1 + Part 2 + Part 3)
- Formats it correctly
6. Script posts the exam to Blogger automatically
- Draft mode or Published mode
(choice available)
- Post URL returned to you
immediately
7. Final test paper goes live on Blogger with zero
manual coding
If you
want, I can now generate:
- The Google Sheet template
- The Apps Script to
convert reviewed SBQs into JSON
- The Apps Script to
auto-publish to Blogger