Detect scope creep in client emails with Gmail, OpenAI and Google Sheets

by Samruddhi Mokal · 0 views · created 2026-10-13 · Ticket Management, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs on Gmail events. Along the way it connects Gmail, Google Docs, OpenAI Chat Model and Google Sheets and 1 more.

How it runs

Trigger: On Gmail events.

1. Configure settings (Edit Fields (Set)): sets 6 fields: client_sow_map, sheet_id, hourly_rate…
2. Match client SOW (Code): runs custom JavaScript code
3. Get client SOW (Google Docs): get
4. Check request against SOW (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
5. Drop non-requests (Filter): keeps only the items that match a condition
6. Prepare scope record (Code): runs custom JavaScript code
7. Log to Scope Log (Google Sheets): append
8. Needs attention? (If): checks a condition and branches into true / false
9. Alert team in Slack (Slack): uses Slack
10. Save change-order draft (Gmail): create (draft)

Services it uses

GmailGoogle DocsOpenAI Chat ModelGoogle SheetsSlack

Before you upgrade to n8n 3.0

Nodes used (13)

• Gmail Triggern8n-nodes-base.gmailTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Google Docsn8n-nodes-base.googleDocs
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Filtern8n-nodes-base.filter
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Slackn8n-nodes-base.slack
• Gmailn8n-nodes-base.gmail
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Quick Overview This workflow monitors a Gmail inbox for client emails, looks up the client’s statement of work in Google Docs, uses OpenAI to classify requests as in-scope or scope creep, logs each request to Google Sheets, and notifies your team in Slack…

View the original on n8n.io → Check your own copy