n8n SOP Training Checklist & Quiz Automation: Drive, Gemini, Gmail

Turn new SOPs into training checklists & quizzes automatically—then route them for approval

This n8n SOP Training Checklist & Quiz Automation workflow watches your Google Drive folder for new Google Docs SOPs, uses Google Gemini to draft a checklist and multiple-choice quiz, and sends the results to a reviewer via Gmail—while tracking every approval decision in Google Sheets.

What this workflow does

• Monitors Google Drive for newly created SOP Google Docs files in a specified folder.
• Extracts and validates SOP text from Google Docs, checking that content exists and meets a minimum length. If invalid, it emails the reviewer via Gmail.
• Generates a draft with Google Gemini, producing a training checklist and a multiple-choice quiz in the configured language.
• Validates Gemini’s JSON output, including checklist length, question structure, and evidence quotes that must exist verbatim in the SOP. If validation fails, it emails the reviewer requesting corrections.
• Prevents duplicate reviews by checking Google Sheets for an existing record for the same document ID (including prior decisions or pending review).
• Saves valid drafts to a review tab (e.g., “Training Reviews”) and emails a formatted approval request with Approve/Reject actions via Gmail.
• Updates review status in the same sheet row as Approved, Rejected, or Timed out after 7 days.

Use cases

• Convert each new SOP Google Doc into a ready-to-review training checklist and quiz for onboarding.
• Standardize quiz quality by enforcing Gemini JSON validation with SOP verbatim evidence quotes.
• Streamline review workflows for SaaS operators and automation engineers with an auditable Google Sheets history.

Technical details

• Triggers/Logic: Google Drive file-created trigger, if, set, code
• Integrations: Google Drive, Google Docs, Google Sheets, Gmail, Google Gemini
• Workflow notes: uses a Sticky Note for setup guidance
• Core behavior: data validation, Gemini JSON parsing/validation, deduplication by document ID, and 7-day timeout updates

Setup tip: Connect Google Drive, Google Docs, Google Sheets, Gmail, and Google Gemini credentials, then set the Drive folder ID that contains SOP Google Docs and configure your review tab columns (e.g., “Training Reviews”).