The flow
Starts it 2Logic 13Service 8
The steps in the order they run, from what starts it.
- 1Weekly schedule1Schedule triggerStarts it
- 2Daily Risk Check TriggerSchedule triggerStarts it
- 3Edit Fields2SetLogic
- 4Edit Fields3SetLogic
- 5Switch1SwitchLogic
- 6Fetch Customer Risk DataPostgresService
- 7Get row(s) in sheet1Google SheetsService
- 8Is High Risk Customer?IfLogic
- 9Loop Over Items1Split In BatchesLogic
- 10Prepare Escalation Summary For Low Risk UserSetLogic
- 11Prepare Escalation Summary For High Risk UserSetLogic
- 12Merge1MergeLogic
- 13Prompt For Model1CodeLogic
- 14Merge Risk ResultMergeLogic
- 15Send a message1GmailService
- 16HTTP Request1Http RequestService
- 17Send a message4GmailService
- 18Send a message5DiscordService
- 19Code in JavaScriptCodeLogic
- 20Code in JavaScript3CodeLogic
- 21Append or update row in sheetGoogle SheetsService
- 22Append or update row in sheet3Google SheetsService
- 23Wait1WaitLogic
How it's built
- Starts on
- A clock
- Steps
- 23, with 2 branches, 2 loops or waits
- Size
- Large: read it before trusting it with anything live
- Connects to
- Discord, Gmail, Google Sheets, Postgres
- Model
- None. This is plumbing, not judgement
Questions
What does it need to run?
An n8n account, plus your own Discord, Gmail, Google Sheets and Postgres accounts. You connect your own accounts after importing it; none are included.
What starts it?
It starts on a clock.
Does it use AI?
No. Every step is fixed logic or a call to a service, so it does the same thing every time.
How long does it take to set up?
Take your time. At 23 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.
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 23 steps before you point it at anything that matters.