Supplier price negotiations — by email, automatically

You add a supplier to Google Sheets — the AI drafts and sends the price email from Gmail, waits for a reply, follows up on silence, scores the outcome and records it in Notion and Google Sheets.

  • The email is drafted in several versions and polished
  • A silent supplier gets a follow-up
  • The reply is scored: agreed, haggling or refused
  • Outcomes are recorded in Google Sheets and Notion
Set it up for yourselfScriptera

How it works

To move data from Google Sheets to Gmail automatically, use a ready-made scenario — no manual exports.

  1. Starts when: 📋 Trigger — New Supplier Row1
  2. Then: 🔍 Validate & Prepare Supplier Data1
  3. Then: 🧠 MCTS — Generate 3 Negotiation Drafts1
  4. Then: 🏆 Pick Best Draft1
  5. Then: 🔁 Self-Critique Round 1 — Refine Draft1
  6. Then: 📝 Parse Final Critique Output1
  7. Then: 📧 Send Negotiation Email to Supplier1
  8. Then: ✅ Mark Email Sent in Sheet1
  9. Then: ⏳ Wait 24 Hours for Reply1
  10. Then: 📬 Check Supplier Reply (Gmail)1
  11. Check: ❓ Reply Received?1
  12. If yes: ⚙️ Process & Score Supplier Reply1
  13. Then: 📒 Log Negotiation Result in Notion1
  14. Then: 📊 Final Update in Google Sheets1
  15. Then: 🔔 Slack — Alert Procurement Team1
  16. If no: 🔁 Self-Critique Round 2 — Final Polish1
  17. Then: 🔄 Build DPO Retry Prompt1
  18. Then: 📧 Send Follow-Up Retry Email1
  19. Then: ✅ Mark Retry Sent in Sheet1
  20. Then: 🔔 Slack — Retry Alert to Team1
  21. Then: ⚡ LLM — Draft Generator (GPT-4o)1
  22. Then: ⚡ LLM — Critique Model (GPT-4o)1
  23. Then: ⚡ LLM — Final Polish Model (GPT-4o)1

You can launch this Google Sheets + Gmail integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios