Workflow Templates

B2B Supplier Price Negotiation Automation (n8n + GPT-4o + Gmail + Notion + Slack)

A new supplier row in Google Sheets triggers GPT-4o to draft three negotiation emails using different strategies, score and refine the best one, send it via Gmail, follow up after 24 hours, log to Notion, and notify Slack.

Visit site
Difficulty
Intermediate
Pricing
Freemium
Platform
n8n
Tools involved
n8n OpenAI GPT-4oGoogle SheetsGmailNotionSlack

An n8n workflow that automates the entire supplier negotiation email pipeline. Google Sheets is the trigger: add a supplier row and the workflow validates and organizes the data, then has GPT-4o draft three negotiation emails using different strategies, scores them to pick the strongest, runs one round of AI self-critique to refine it, and sends the result through Gmail. Twenty-four hours later it checks whether the supplier replied and, if not, sends an optimized follow-up. Every step is logged to Notion as an audit trail, results and retry alerts go to Slack, and final status, price, and savings are written back to Google Sheets.

Worth noting: the author positions this as a “fully autonomous negotiation process with zero human intervention” — and that is exactly what deserves caution. Technically it runs. The risk is not in the workflow but in whether you accept an unreviewed email negotiating commercial terms on behalf of your company. See the notes below.

Template page stats: author Rahul Joshi (rahul08), last updated roughly 2 months ago, about 34 views (collected 2026-08-02), categorized under Lead Nurturing / AI Chatbot.

What it does

  • Triggers on a new Google Sheets row, so adding supplier data starts the process
  • Has GPT-4o generate three negotiation drafts with different strategies, then selects the best by score
  • Runs one round of AI self-critique and rewriting on the selected draft
  • Sends via Gmail and automatically checks for a reply after 24 hours
  • Sends an optimized follow-up email when there is no response
  • Logs the full negotiation history to Notion as an audit trail
  • Notifies the procurement team in Slack with results or retry alerts
  • Writes final status, price, and savings back to Google Sheets

Prerequisites

  • An n8n instance (cloud or self-hosted — this template has no community nodes)
  • An OpenAI API key with GPT-4o access
  • Google Sheets OAuth credentials and a structured supplier sheet
  • Gmail OAuth credentials (for sending and reading replies)
  • Notion credentials and a database for the audit log
  • Slack credentials and a notification channel

Install / configure

1. Download the workflow JSON from the template page
2. n8n → Workflows → Import from File
3. Configure five credential sets: OpenAI / Google Sheets / Gmail / Notion / Slack
4. Create the Sheets supplier table and Notion log database, matching the field mappings in the nodes

How to use

  1. Import the workflow JSON and fill in all five credential sets.
  2. Build the Google Sheets supplier table with column names matching what the trigger node reads (supplier, contact email, current quote, target price).
  3. Create a Notion negotiation log database and map the fields on the write node.
  4. Point the Slack node at your notification channel.
  5. Change the Gmail send node to your own or an internal test address first, then run one fake supplier row end to end and inspect all three drafts plus the final version.
  6. Check wording, quoted figures, and any commitments in the generated emails before switching to real supplier addresses.
  7. Keep a human approval step in front of the send node long term rather than running it fully autonomously.

Use cases

  • Procurement teams handling routine negotiation and renewals across long-tail suppliers
  • E-commerce and retail comparing and countering quotes across many SKUs
  • Startups without a dedicated procurement function standardizing the negotiation process
  • Situations that require a complete negotiation record for audit — the Notion log is one of the more practical parts here

Notes

  • Do not enable full autonomy on day one. The template advertises zero human intervention, but AI-drafted negotiation emails can commit to terms you did not intend, misquote figures, or strike the wrong tone. Add an approval step before the Gmail node and only loosen it after dozens of clean runs.
  • Outbound commercial email carries reputational and potential contractual-offer risk. Confirm your legal position, and keep key suppliers and large purchases out of the automated path.
  • Cap the 24-hour follow-up. Repeated chasing reads as harassment and can trip Gmail sending limits.
  • All five credential sets must be configured or the chain breaks mid-run; first-time setup is not quick.
  • GPT-4o produces three drafts plus a self-critique pass plus follow-ups per supplier, so per-record cost is noticeably higher than a simple email workflow. Model the token cost before scaling.
  • OpenAI, Gmail, Notion, and Slack are overseas services; mainland China access typically requires an international network.
  • View count is low (around 34), so this is a newer, lightly validated template. Run it fully in a test environment before production.

Last updated: August 2, 2026

Related solutions