Client portfolio update emails, with adviser approval built in

The scenario spots a change in Google Sheets, drafts a client-specific email and sends it for approval in Telegram. Once approved, it goes out to the client via Gmail.

  • Drafts are tuned to each client's risk profile
  • Nothing reaches a client without a human yes
  • Email status updates itself in the sheet
  • Rejected drafts go back for rework instead of vanishing