Notify clients of delayed trade settlements with Google Sheets, Gemini, Slack and Gmail

Description

Quick overview
This workflow runs daily to check trade settlements stored in Google Sheets, identifies overdue trades, uses Google Gemini to classify delay reasons and severity, and notifies each affected client via Slack and a formatted Gmail report.

How it works
Runs daily on a schedule trigger.
Reads all trade records from a Google Sheets spreadsheet and normalizes key fields like trade ID, settlement date, status, client email, and Slack member ID.
Validates and reformats settlement dates, then flags trades as delayed when the settlement date is before today and the status is not "settled".
Filters to delayed trades only and groups them by client email so each client is processed as a batch.
Sends each client’s delayed trades to Google Gemini to generate per-trade delay reasons, a severity level (HIGH/MEDIUM/LOW), and a recommended action.
Routes trades by severity, then sends a Slack DM summary to the client and emails a detailed HTML report via Gmail.

Setup
Connect your Google Sheets credentials and update the spreadsheet ID and sheet tab used to read the trade portfolio.
Add Google Gemini (LangChain) credentials and confirm the selected Gemini model is available in your project.
Connect your Slack OAuth2 credential and ensure each row in the sheet contains a valid Slack member ID for the recipient.
Connect your Gmail account (or Google OAuth credentials for Gmail) and verify the workflow is allowed to send emails to client addresses.
Ensure the Google Sheet includes the required columns (trade id, stock name, settlement date, quantity, price, status, client email, client name, slack member id) and adjust the schedule time if needed.

Additional info
How To Customize Nodes

Schedule Trigger**
Change frequency (hourly, weekly, etc.)

Google Sheets Node**
Replace with another data source if needed

AI Prompt**
Modify prompt to include more insights like risk score, expected delay duration

Slack Message Builder**
Customize tone, format, or add emojis

Email Template**
Adjust branding, colors, or content structure

Add-Ons (Enhancements)

Add SMS alerts for HIGH severity trades
Store AI analysis results back into Google Sheets
Add dashboard reporting (e.g., via Notion or Airtable)
Integrate with CRM systems for ticket creation
Add retry logic for failed notifications

Use Case Examples

Brokerage Firms
Monitor settlement delays across multiple client portfolios

Trade Operations Teams
Get proactive alerts before clients raise concerns

Wealth Managers
Keep clients informed with automated updates

Fintech Platforms
Enhance transparency in trade lifecycle tracking

Compliance Monitoring
Track delays that may impact regulatory reporting

These are just a few examples—this workflow can be adapted for many other trade monitoring scenarios.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|------|--------------|---------|
| No data fetched | Incorrect Sheet ID or permissions | Verify Google Sheets credentials and access |
| Dates not detected properly | Invalid date format in sheet | Ensure proper date format (YYYY-MM-DD recommended) |
| No delayed trades found | All trades are settled or future dated | Check dataset and logic |
| Slack message not sent | Invalid Slack member ID | Verify Slack user ID format |
| Email not delivered | Gmail credentials issue | Reconnect Gmail OAuth |
| AI node not working | Missing Gemini API credentials | Configure API key properly |

Need Help?

If you need assistance setting up this workflow, customizing nodes or building advanced add-ons, our n8n workflow development team at WeblineIndia is happy to help.

We specialize in:
n8n workflow automation
AI-powered business processes
Custom integrations and dashboards

👉 Reach out to us for:
Workflow setup & deployment
Custom enhancements
End-to-end automation solutions
Hire n8n workflow developers

Let us help you turn your operations into a fully automated system.