E-commerce & Dropshipping · n8n

Score Suppliers Monthly on Delivery, Quality and Price

Manage suppliers with data — compile monthly scorecards on on-time delivery, defect rate and price stability to guide sourcing decisions.

difficulty Advancedsetup 45 minresult You get an objective monthly scorecard per supplier, making sourcing decisions data-driven.
  1. 1

    Schedule Monthly

    Add a Schedule Trigger running at month-end.

  2. 2

    Gather Performance Data

    Add a Google Sheets node pulling each supplier's delivery times, defects and price changes.

  3. 3

    Compute the Scores

    Add a Code node scoring each supplier across the key dimensions with your weightings.

  4. 4

    Summarize and Post

    Add an OpenAI node writing a short commentary and a Slack node posting the scorecards.

  5. 5

    Activate and Test

    Activate the workflow and run it for a test month. Confirm the scores reflect the data.

Frequently asked questions

How do I use low scores?

Use them in supplier reviews and to shift volume toward better performers or renegotiate terms.

Can I track trends?

Store each month's scores so you can see whether a supplier is improving or slipping over time.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.