Generate vendor negotiation strategies from pricing data with GPT-4 and SendGrid
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Generate Negotiation Strategy (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - HTTP Request
n8n-nodes-base.httpRequest - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Wait
n8n-nodes-base.wait
What it does
Quick overview This workflow ingests vendor pricing via a webhook or a weekly schedule, analyzes variance against historical and market benchmarks, uses OpenAI to draft negotiation strategies for high-priority cases, then emails recommendations through SendGrid and appends the analysis to a Google Sheets tracker. How it works 1. Receives vendor pricing data from a POST webhook endpoint or runs every Monday at 8:00 to process a scheduled input. 2. Normalizes incoming fields (vendor, pricing, benchmarks, volume, currency, renewal date, and notes) into a consistent schema. 3. Calculates price variance versus historical and market benchmarks, estimates potential savings, derives a confidence score, and flags whether the opportunity is high priority. 4. Filters to only high-priority opportunities and waits briefly to help manage API rate limits. 5. Uses OpenAI to generate a structured, under-300-word negotiation strategy including tactics, target and walk-away prices, projected savings range, and risk flags. 6. Formats the AI output into a report, emails it via the SendGrid API, and appends the analyzed record to a Google Sheets tab for tracking. Setup 1. Add an OpenAI API credential for the OpenAI Chat Model used to generate negotiation strategies. 2. Create a SendGrid API key and configure the HTTP request with an Authorization header (Bearer token), then replace the sender and recipient email addresses. 3. Enable the Google Sheets API and provide OAuth/access configuration, then replace YOURSHEETID and ensure the spreadsheet has a VendorNegotiations sheet with matching columns. 4. If using the webhook trigger, copy the production webhook URL for vendor-pricing-inbound and configure your source system to POST the expected fields (for example vendorName, currentUnitPrice, historicalAvgPrice, marketBenchmarkPrice, contractVolume, and renewalDate).