Automation library · Alerts and monitoring

Monitor supplier risk daily with Groq and Google Sheets

Started by a clock, and works across Gmail, Google Sheets and Slack. It hands the judgement calls to Groq. 24 steps, 1 branch, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Groq

Download free
24 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
1Loop or waits
3Services it connects to

The flow

Starts it 1Model 6Logic 7Service 10

The steps in the order they run, from what starts it.

  1. 1Groq Chat Model1Lm Chat GroqModel
  2. 2Groq Chat Model2Lm Chat GroqModel
  3. 3Groq Chat ModelLm Chat GroqModel
  4. 4Daily 9AM SyncSchedule triggerStarts it
  5. 5Analyze Sentiment & RiskAgentModel
  6. 6Generate Mitigation StrategyAgentModel
  7. 7Generate Executive BriefingAgentModel
  8. 8Fetch Supplier Master ListGoogle SheetsService
  9. 9Calculate Final Risk ScoreCodeLogic
  10. 10Slack High-Risk AlertSlackService
  11. 11Email Procurement LeadGmailService
  12. 12Send Final Daily ReportGmailService
  13. 13Process Each SupplierSplit In BatchesLogic
  14. 14Route by Risk LevelSwitchLogic
  15. 15Log Result to Audit DBGoogle SheetsService
  16. 16Fetch Today's Logged ResultsGoogle SheetsService
  17. 17Fetch Supplier NewsHttp RequestService
  18. 18Fetch Industry BenchmarksHttp RequestService
  19. 19Get Currency Exchange RatesHttp RequestService
  20. 20Watchlist NotificationGmailService
  21. 21Deduplicate & Slim DataCodeLogic
  22. 22Combine Research DataMergeLogic
  23. 23Pre-AI Data FormattingCodeLogic
  24. 24Edit FieldsSetLogic

How it's built

Starts on
A clock
Steps
24, with 1 branch, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, Slack
Model
Groq

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Sheets and Slack accounts, and a key for Groq. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Groq. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 24 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 24 steps before you point it at anything that matters.