Skip to main content

Automate B2B supplier price negotiations with Google Sheets, Gmail, GPT-4o, Notion and Slack

Workflow preview

Workflow preview
100%
Automate B2B supplier price negotiations with Google Sheets, Gmail, GPT-4o, Notion and Slack preview
Open on n8n.io

1. Workflow Overview

Description: Automate your entire supplier negotiation process with this AI driven workflow that intelligently drafts, refines, and sends negotiation emails . Using advanced LLM reasoning and ...

Best for

  • Lead Nurturing automation workflows
  • AI Chatbot automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.googlesheetstrigger, n8n-nodes-base.code, n8n-nodes-base.gmail, n8n-nodes-base.googlesheets, n8n-nodes-base.wait, n8n-nodes-base.if, n8n-nodes-base.notion

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Rahul Joshi.

Original n8n.io source

1.1 Workflow description

Title
Automate B2B supplier price negotiations with Google Sheets, Gmail, GPT-4o, Notion and Slack
Workflow name
Automate B2B supplier price negotiations with Google Sheets, Gmail, GPT-4o, Notion and Slack

πŸ“Š Description:

Automate your entire supplier negotiation process with this AI-driven workflow that intelligently drafts, refines, and sends negotiation emails πŸ“§. Using advanced LLM reasoning and multi-angle strategies πŸ€–, it generates high-converting negotiation messages tailored to each supplier scenario. The workflow tracks replies, sends smart follow-ups ⏰, and logs outcomes automatically for full visibility. Perfect for procurement teams looking to reduce costs and eliminate manual back-and-forth communication πŸ”.

What This Template Does:

πŸ“‹ Triggers when a new supplier entry is added to Google Sheets. πŸ” Validates and structures supplier, product, and pricing data. 🧠 Generates 3 AI-powered negotiation email drafts using different strategies. πŸ† Selects the best-performing draft based on scoring logic. πŸ” Refines the draft using AI self-critique for better tone and clarity. πŸ“§ Sends the final negotiation email to the supplier via Gmail. ⏳ Waits 24 hours and checks for supplier replies automatically. ❓ Detects whether a reply is received and routes the workflow accordingly. πŸ”„ Sends an optimized follow-up email if no response is received. πŸ“’ Logs negotiation details and outcomes in Notion. πŸ“Š Updates Google Sheets with final status, pricing, and savings. πŸ”” Notifies the procurement team via Slack with results or retry alerts.

Key Benefits:

βœ… Fully autonomous negotiation process with zero manual effort βœ… AI-optimized messaging increases chances of better pricing βœ… Smart follow-ups ensure no supplier opportunity is missed βœ… Centralized tracking across Sheets, Notion, and Slack βœ… Data-driven decision making with scoring and insights βœ… Scalable procurement operations for high-volume supplier outreach

Features:

  • Google Sheets trigger-based workflow
  • AI-powered negotiation using GPT-4o (multi-angle + self-critique)
  • Automated email sending and reply detection via Gmail
  • Intelligent retry logic using DPO-style optimization
  • Notion logging for audit trails and reporting
  • Slack alerts for real-time team notifications
  • Built-in validation and structured data processing

Requirements:

  • Google Sheets account (for supplier data tracking)
  • Gmail account (for sending and receiving emails)
  • OpenAI API key (for AI-generated negotiation logic)
  • Notion account (for logging negotiation outcomes)
  • Slack account (for team notifications)

Target Audience:

🏒 Procurement and sourcing teams πŸ›’ E-commerce and retail businesses managing suppliers πŸš€ Startups scaling vendor negotiations πŸ€– Automation agencies building AI-driven business workflows

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Sticky Note β€” Workflow Overview

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 2 - Sticky Note β€” Trigger

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Sticky Note β€” Validation

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 4 - Sticky Note β€” MCTS Draft Generation

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 5 - Sticky Note β€” Pick Best Draft

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Sticky Note β€” Self-Critique Rounds

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - Sticky Note β€” Email Dispatch

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Sticky Note β€” Reply Monitoring

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Sticky Note β€” Reply Decision

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 10 - Sticky Note β€” Outcome Logging

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Sticky Note β€” Slack Notifications

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 12 - Sticky Note β€” DPO Retry Path

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - πŸ“‹ Trigger β€” New Supplier Row1

Type / Role
n8n-nodes-base.googleSheetsTrigger - googleSheetsTrigger
Config choices
Version 1

Block 14 - πŸ” Validate & Prepare Supplier Data1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 15 - πŸ† Pick Best Draft1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - πŸ“ Parse Final Critique Output1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 17 - πŸ“§ Send Negotiation Email to Supplier1

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 18 - βœ… Mark Email Sent in Sheet1

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 19 - ⏳ Wait 24 Hours for Reply1

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 20 - πŸ“¬ Check Supplier Reply (Gmail)1

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 21 - ❓ Reply Received?1

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2

Block 22 - πŸ”„ Build DPO Retry Prompt1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 23 - πŸ“§ Send Follow-Up Retry Email1

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 24 - βœ… Mark Retry Sent in Sheet1

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Showing the first 24 of 35 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Automate B2B supplier price negotiations with Google Sheets, Gmail, GPT-4o, Notion and Slack
Complexity advanced
Nodes 35
Categories Lead Nurturing, AI Chatbot
Author Rahul Joshi
Published 13 May 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/15686/15686.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Automate B2B supplier price negotiations with Google Sheets, Gmail, GPT-4o, Notion and Slack do?

Description: Automate your entire supplier negotiation process with this AI driven workflow that intelligently drafts, refines, and sends negotiation emails . Using advanced LLM reasoning and ...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Nurturing, AI Chatbot use case.