WorkflowDBGet Quote
sourcingn8nintermediate50 minutes

Supplier Evaluation Scorecard Workflow

Systematic supplier performance evaluation using weighted scoring across quality, delivery, price, and communication metrics. Automates data collection from multiple sources and generates quarterly supplier rankings.

Flow Diagram

graph TD\n    A[Quarterly Trigger] --> B[Collect Data]\n    B --> C[Calculate Scores]\n    C --> D[Generate Scorecards]\n    D --> E{Score >= 60?}\n    E -->|Yes| F[Preferred Status]\n    E -->|No| G[Improvement Notice]\n    F --> H[Distribute Reports]\n    G --> H

Steps

  1. 1

    Quarterly Evaluation Trigger

    Scheduled trigger at end of each quarter. Pulls list of active suppliers and their transaction history for the period.

    Cron trigger: 0 9 1 1,4,7,10 * (first day of each quarter at 9am)
  2. 2

    Collect Performance Data

    Aggregate data from multiple sources: on-time delivery rate from shipping records, defect rate from QA inspections, price competitiveness from market data, communication responsiveness from email logs.

    SQL queries across orders, inspections, and communications tables. Calculate: OTD%, defect_ppm, price_index, response_time_avg
  3. 3

    Calculate Weighted Scores

    Apply weighted scoring model: Quality 35%, Delivery 30%, Price 20%, Communication 15%. Each metric normalized to 0-100 scale. Generate overall supplier score.

    Score = (quality*0.35 + delivery*0.30 + price*0.20 + communication*0.15). Normalize each metric against best-in-class
  4. 4

    Generate Scorecard Report

    Create visual scorecard PDF for each supplier showing scores, trends vs previous quarter, and specific improvement areas. Flag suppliers below 60 threshold for review.

    Generate PDF with charts using template, include quarter-over-quarter trend arrows
  5. 5

    Distribute and Action

    Email scorecards to procurement team. Suppliers below threshold get improvement notice. Top performers get preferred status update. Update supplier tier in database.

    Send internal report to procurement, send supplier feedback email, update supplier_tier field in suppliers table

Tools Required

n8nFreeGoogle SheetsFreePDF Generator5/month

Estimated Monthly Cost

5/month (PDF generation)

Download This Workflow

Enter your email to get the n8n-compatible JSON file. One-time unlock for all workflows.

Need This Workflow Customized?

We can match this automation to your specific equipment and process.

Get a Quote