Detect procurement workflow gaps with Google Sheets, OpenAI, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on Google Sheets events. Along the way it connects Google Sheets, OpenAI and Gmail.
How it runs
Trigger: On Google Sheets events.
- Normalize Procurement Event Data (Code): runs custom JavaScript code
- Validate Required Procurement Fields (If): checks a condition and branches into true / false
- Retrieve Procurement Workflow State (Google Sheets): uses Google Sheets
- Record Invalid Event Result (Google Sheets): append or update
- Load Required Procurement Lifecycle Steps (Google Sheets): uses Google Sheets
- Assemble Procurement Context and Detect Workflow Gaps (Code): runs custom JavaScript code
- Check for Workflow Gap (If): checks a condition and branches into true / false
- Log Detected Procurement Gap (Google Sheets): append
- Update Procurement Workflow State (Google Sheets): append
- Generate Recovery Recommendation (OpenAI): uses OpenAI
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow watches procurement events in Google Sheets, validates and normalizes each entry, checks the procurement’s lifecycle state to detect missing required steps, and then uses OpenAI to recommend a recovery action, logs results back to…