QA CAPA Workflow Automation: n8n + Google Sheets, Gmail, Gemini

Automate QA Findings to CAPA Tracking—With n8n, Google Sheets, Gmail & Gemini

This n8n workflow captures QA/QC audit findings from an n8n form, uses Google Gemini to assess severity and determine whether a CAPA is required, then manages the full CAPA lifecycle in Google Sheets—including assignment, QA verification, closure, and rework notifications via Gmail.

What this workflow does

• Receives a QA/QC finding through an n8n form trigger.
• Generates a unique Finding ID, normalizes submitted fields, and sends finding details to Google Gemini to determine: category, risk level, severity score, CAPA requirement, and recommended actions.
• Audit trail when no CAPA is needed: if Gemini determines CAPA is not required, the workflow appends the decision and rationale to the Google Sheets “No_CAPA_Log” tab.
• Creates and assigns CAPAs when required: when CAPA is required, it creates a CAPA record in “CAPA_Log”, assigns an owner based on the department, calculates a due date based on assessed risk, and updates the record to “Assigned.”
• Sends assignment via Gmail: looks up the owner’s email from “Owner_Directory”, emails the assignment using Gmail, and logs the send status back to the CAPA record.
• Captures owner completion evidence: a second n8n form collects completion notes/evidence, updates the CAPA to “Awaiting QA Verification,” and emails the QA team to review.
• QA verification & outcomes: a third n8n form updates the CAPA to “Closed” (with a closure email) or “Rework Required” (with a rework request email and notification logging).

Use cases

• QA/QC teams needing automated CAPA workflow automation from audit findings to closure.
• SaaS operators standardizing severity-based due dates and ownership routing.
• Automation engineers building repeatable, auditable CAPA processes using n8n + Google Sheets.

Technical details

• n8n workflow with nodes: form trigger, if, set, switch, sticky note, gmail.
• Google Sheets tabs: CAPA_Log, No_CAPA_Log, Owner_Directory.
• Google Gemini for severity scoring, CAPA determination, and recommended actions.