All ideasMore in Work

Review my Salesforce pipeline and flag the deals going stale

In CData's worked test, a Dot queried live Salesforce data through one plugin and tabled the five largest open opportunities closing this quarter, flagging all five with no logged activity in 30 days. One deal was still open six days past its close date; the account used test data, as the post discloses.

How it works

  1. Query the Salesforce connection read-only
  2. Rank the five largest open opportunities closing this quarter
  3. Check each for activity in the last 30 days
  4. Flag all five as inactive, including one past its close date

Why it’s worth knowing

One question replaced a CRM export-and-review ritual, with staleness flagged automatically.

Where it’s from

Summarized from a public post on cdata.com. See the original ↗

Upgraded prompt

A ready-to-use prompt for this idea, built from research on what makes AI agents do the job right: who the AI should be, the exact steps, and a check to make sure it was done the way you wanted.

1Who the AI should be
2The prompt, with the steps
3The check when it’s done
Upgraded prompts are coming soon.

Try next

Every idea is a real post from someone who tried it, summarized in our words, with a link to the original. App names are swapped for plain words.