Salesforce Pipeline Update

Salesforce Pipeline Update

Push opportunity updates into Salesforce via Composio.

Workflow

1. Collect the updates. Ask for the source: CSV, sheet, or inline list. Each row needs Opportunity ID (or name + account) + fields to change.
2. Link Salesforce:

   composio link salesforce
   

3. Confirm the opportunity exists before patching:

   composio execute SALESFORCE_GET_OPPORTUNITY_BY_ID -d '{ "opportunity_id": "006..." }'
   

   If you only have name + account, run:

   composio search "salesforce query opportunity by name" --toolkits salesforce
   

4. Dry-run an update first:

   composio execute SALESFORCE_UPDATE_OPPORTUNITY --dry-run -d '{
     "opportunity_id": "006XYZ",
     "StageName": "Proposal/Price Quote",
     "CloseDate": "2026-06-30",
     "NextStep": "Send MSA for legal review"
   }'
   

5. Execute the batch sequentially (SFDC governor limits punish bursts). Log success/failure to ./sfdc-updates.csv.
6. Summarize at the end: X updated, Y failed, Z skipped; which stages moved.

Common field patterns

• Stage progression: enforce the account's stage model (don't skip stages unless user confirms).
• Close date: never push past the end of the current quarter without a reason in NextStep.
• Amount changes > 20%: require an activity note explaining why.

Guardrails

• Never bulk-close opportunities as Won without explicit user approval (revenue recognition risk).
• If an update fails validation rule, surface the exact rule error — do not retry blindly.
• Ask before running against more than 25 records at a time.