Monitor customer risk and AI feedback using PostgreSQL, Gmail and Discord

Description

How it works
This workflow monitors customer health by combining payment behavior, complaint signals, and AI-driven feedback analysis. It runs on daily and weekly schedules to evaluate risk levels, escalate high-risk customers, and generate structured product insights. High-risk cases are notified instantly, while detailed feedback and audit logs are stored for long-term analysis.

Step-by-step
Step 1: Triggers & mode selection**
Daily Risk Check Trigger – Starts the workflow on a daily schedule.
Weekly schedule1 – Triggers the workflow for weekly summary runs.
Edit Fields3 – Sets flags for daily execution.
Edit Fields2 – Sets flags for weekly execution.
Switch1 – Routes execution based on daily or weekly mode.

Step 2: Risk evaluation & escalation**
Fetch Customer Risk Data – Pulls customer, payment, product, and complaint data from PostgreSQL.
Is High Risk Customer? – Evaluates payment status and complaint count.
Prepare Escalation Summary For Low Risk User – Assigns low-risk status and no-action details.
Prepare Escalation Summary For High Risk User – Assigns high-risk status and escalation actions.
Merge Risk Result – Combines low-risk and high-risk customer records.
Send a message4 – Sends the customer risk summary via Gmail.
Send a message5 – Sends the same risk summary to Discord.
Code in JavaScript3 – Appends notification status and timestamps.
Append or update row in sheet3 – Logs risk evaluations and notification status in Google Sheets.

Step 3: AI feedback & reporting**
Get row(s) in sheet1 – Fetches customer records for feedback analysis.
Loop Over Items1 – Processes customers one by one.
Prompt For Model1 – Builds a structured prompt for product feedback analysis.
HTTP Request1 – Sends data to the AI model for insight generation.
Code in JavaScript – Merges AI feedback with original customer data.
Append or update row in sheet – Stores AI-generated feedback in Google Sheets.
Wait1 – Controls execution pacing between records.
Merge1 – Prepares consolidated feedback data.
Send a message1 – Emails the final AI-powered feedback report.

Why use this?
Detect customer churn risk early using payment and complaint signals
Automatically escalate high-risk customers without manual monitoring
Convert raw customer issues into executive-ready product insights
Keep a complete audit trail of risk, feedback, and notifications
Align support, product, and leadership teams with shared visibility