Templates / Recommend supplier consolidation with Google Sheets, Groq, Slack and Gmail

Recommend supplier consolidation with Google Sheets, Groq, Slack and Gmail

Ready for 3.0

by WeblineIndia ✓ · 17 views · created 2026-07-14 · Document Extraction, AI Summarization

Ready 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 11 nodes and runs on a schedule (every week at 09:00). Along the way it connects Google Sheets, Groq Chat Model, Slack and Gmail.

How it runs

Trigger: On a schedule (every week at 09:00).

  1. Fetch Supplier Data (Google Sheets): uses Google Sheets
  2. Clean & Structure Supplier Data (Edit Fields (Set)): sets 8 fields: Name, Department, Category…
  3. Identify Overlaps & Calculate Savings (Code): runs custom JavaScript code
  4. Evaluate Risk vs Savings (AI Agent): runs an AI agent, with model: Chat Model
  5. Combine Supplier & AI Data (Merge): merges the data from its input branches
  6. Extract AI Insights (Code): runs custom JavaScript code
  7. Prepare Final Recommendation (Edit Fields (Set)): sets 11 fields: Supplier, departments, department_count…
  8. Send Slack Alert (Slack): uses Slack
  9. Send Email Report (Gmail): uses Gmail

Services it uses

Google SheetsGroq Chat ModelSlackGmail

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 (9)

From the author

Quick overview This workflow runs weekly to read supplier spend data from Google Sheets, detect overlapping suppliers across departments, estimate potential consolidation savings, and use Groq-hosted LLM analysis to assess risk and produce recommendations…

Excerpt from WeblineIndia's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.