SUMMARIZATION

Turn a Closed Lost opportunity into a root-cause loss memo in Coda

When a Salesforce opportunity flips to Closed Lost, it analyzes the deal's full objection history and writes a single root-cause loss memo to Coda for the product and competitive…

CategorySummarization
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerOpportunity moved to Closed LostSalesforce
  • ActionRead objection history and close reasonSalesforce
  • LogicBranch on objection signal depth
  • ActionSynthesize root-cause loss memoOpenAI
  • OutputAppend memo to Coda Loss LibraryCodaCoda

What it does

The moment a deal is marked Closed Lost, this workflow reviews everything the prospect objected to across the deal's lifecycle and produces a one-page root-cause memo: the primary reason the deal died, the contributing factors, the competitor named (if any), and what would have had to be true to win it.

When to use it

Use it when you want a disciplined post-mortem on every lost deal without asking reps to write one. It is most valuable for teams tracking competitive losses and feature-gap losses that product should act on.

How it works

  1. 1A Salesforce trigger fires when an opportunity's stage changes to Closed Lost.
  2. 2The workflow reads the opportunity's objection notes, close reason, and competitor field.
  3. 3A logic step branches on whether enough objection signal exists; thin deals get a short stub instead of a full memo.
  4. 4OpenAI synthesizes a root-cause memo naming the primary loss driver and the win conditions that were missing.
  5. 5The memo is appended to a 'Loss Library' table in Coda, tagged by account and competitor.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SalesforceAccounts, opportunities, cases.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect CodaDocs, packs, automations.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.