# Score inspection defects and draft repair packets with OpenAI: n8n workflow

> Started by another system calling it, and works across Gmail, Google Drive and n8n data table. It hands the judgement calls to OpenAI.

Source: https://millionrounds.com/workflow/score-inspection-defects-and-draft-repair-packets-with-opena (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [AI assistants](https://millionrounds.com/workflows?category=AI+assistants#library)

# Score inspection defects and draft repair packets with OpenAI

Started by another system calling it, and works across Gmail, Google Drive and n8n data table. It hands the judgement calls to OpenAI. 19 steps, 2 branches: a working afternoon to understand properly.

Medium Calls a model: OpenAI

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fscore-inspection-defects-and-draft-repair-packets-with-opena)

**19 steps** Medium: a working afternoon

**2** Branches: places the flow splits

**0** Loops or waits

**3** Services it connects to

## The flow

Starts it 1 Model 4 Logic 9 Service 5

The steps in the order they run, from what starts it.

- 1 **Receive Finalized Inspection Report** Webhook *Starts it*
- 2 **GPT-4o Mini Inspection Model** Lm Chat Open Ai *Model*
- 3 **Normalize Report Payload** Set *Logic*
- 4 **Extract Defect Items From Report Text** Information Extractor *Model*
- 5 **Draft Aggressive Repair Negotiation Packet** Chain Llm *Model*
- 6 **Draft Standard Repair Request Packet** Chain Llm *Model*
- 7 **Compute Weighted Severity Score & Escalation Threshold** Code *Logic*
- 8 **Consolidate Drafted Packets** Merge *Logic*
- 9 **Severity Score Exceeds Major Threshold** If *Logic*
- 10 **Tag Packet For Approval** Set *Logic*
- 11 **Request Lead Inspector Approval** Gmail *Service*
- 12 **Approved By Lead Inspector** If *Logic*
- 13 **Save Approved Negotiation Packet** Google Drive *Service*
- 14 **Tag Rejected** Set *Logic*
- 15 **Tag Approved With Drive Link** Set *Logic*
- 16 **Notify Inspector Packet Rejected** Gmail *Service*
- 17 **Consolidate Final Outcomes** Merge *Logic*
- 18 **Send Negotiation Packet to Client** Gmail *Service*
- 19 **Log Negotiation Packet Outcome** Data Table *Service*

## How it's built

- **Starts on:** Another system calling it
- **Steps:** 19, with 2 branches
- **Size:** Medium: a working afternoon
- **Connects to:** Gmail, Google Drive, n8n data table
- **Model:** OpenAI

## Questions

What does it need to run?

An n8n account, plus your own Gmail and Google Drive accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on another system calling it.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Plan an afternoon. 19 steps is enough that you should read each one before running it.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

**Before you run it**

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 19 steps before you point it at anything that matters.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fscore-inspection-defects-and-draft-repair-packets-with-opena)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Gmail](https://millionrounds.com/workflows?service=Gmail#library)[Google Drive](https://millionrounds.com/workflows?service=Google+Drive#library)[n8n data table](https://millionrounds.com/workflows?service=n8n+data+table#library)

## Workflows like it

Also ai assistants, with the same services where possible, closest in size first.

- [**Find and log GDPR request evidence with Groq and Data Tables** 19 steps · calls a model · n8n data table](https://millionrounds.com/workflow/find-and-log-gdpr-request-evidence-with-groq-and-data-tables)
- [**Generate 100+ ad variations from one image** 19 steps · calls a model · Google Drive](https://millionrounds.com/workflow/generate-100-ad-variations-from-one-image)
- [**Generate Instagram news carousels from RSS feeds with OpenAI** 19 steps · calls a model · Google Drive, RSS](https://millionrounds.com/workflow/generate-instagram-news-carousels-from-rss-feeds-with-openai)
- [**Music Producer Chatbot with Gemini and Suno** 19 steps · calls a model · Google Drive](https://millionrounds.com/workflow/music-producer-chatbot-with-gemini-and-suno)
- [**Run Bunker Guard NPC chat and RAG lore checks with Gemini** 19 steps · calls a model · Google Drive, in-memory vectors](https://millionrounds.com/workflow/run-bunker-guard-npc-chat-and-rag-lore-checks-with-gemini)
- [**Triage and reply to email threads with OpenAI and IMAP** 19 steps · calls a model · Email, Gmail](https://millionrounds.com/workflow/triage-and-reply-to-email-threads-with-openai-and-imap)