Summarize portfolio reviews, flag compliance risk with GPT-4o and Google Sheets

Description

Quick overview This workflow receives advisor portfolio review meeting notes via a webhook, uses OpenAI GPT-4o to generate a structured summary and compliance-risk flags, logs the results to Google Sheets, and then notifies the advisor via Gmail, escalating high-risk items to Telegram. How it works Receives a POST request on a webhook containing client/advisor details, risk tolerance on file, and raw meeting notes. Normalizes the incoming fields and adds a submission timestamp. Sends the notes to OpenAI GPT-4o to produce a structured output with a summary, flagged issues, recommended follow-up, and a high/medium/low complianceRisk rating. Logs the structured review record to a Google Sheets compliance tracker tab. Routes the result by complianceRisk, sending high-risk cases to Gmail for immediate review and also posting a high-risk alert to Telegram. Sends medium- and low-risk cases to the advisor via Gmail with the summary and recommended follow-up. Setup Add an OpenAI API credential for the GPT-4o chat model used to summarize and classify compliance risk. Add a Google Sheets credential, create (or select) a spreadsheet tab named “Portfolio Reviews,” and replace REPLACE_WITH_YOUR_SHEET_ID with your document ID. Add a Gmail OAuth2 credential and ensure the workflow receives a valid advisorEmail value to use as the notification recipient. Add a Telegram credential, replace REPLACE_WITH_YOUR_CHAT_ID with your compliance channel chat ID, and ensure a bot is present in that chat. Copy the production webhook URL for /portfolio-review-intake and configure your meeting-notes form or CRM to POST the expected fields (clientName, advisorName, advisorEmail, meetingNotes, riskToleranceOnFile). An n8n automation workflow template by Swapnil Mandloi.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• telegram
• gmail
• ai-agent
• openai-chat-model
• structured-output-parser

Capabilities

• 6 nodes

Information