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).