Automating Salesforce Opportunity Updates and Conga Emails Using Record-Triggered Flows

Article Written By:
Created On:

Monday morning. A Sales Manager reviews last week's deals and finds that of eighteen Opportunities moved to the "Proposal Sent" stage; only twelve had the Conga proposal emailed. Six are open — customer waiting, rep already on the next deal, nobody noticed. By Wednesday, two of those customers go silent. By Friday, one signs with a competitor.

This isn't a sales discipline problem. It's an automation gap. Updating an Opportunity and sending the right document shouldn't be two manual steps that depend on a rep remembering both. Record-Triggered Flows on Salesforce, paired with Conga's document generation engine, run the chain automatically: stage changes, Conga template fires, branded email lands in the customer's inbox, audit trail captured on the Opportunity. No rep involvement past the click that moves the stage.

The fix is a Record-Triggered Flow architecture that listens to Opportunity stage changes, calls the right Conga template per stage, sends the personalized document automatically, and writes the send event back to the Opportunity for visibility.

Here's how to automate Salesforce Opportunity updates and Conga emails with Record-Triggered Flows.

1. Why Opportunity-to-email automation breaks in most Salesforce orgs

Five forces fragment Opportunity-to-document automation:

  • Manual email step: Rep moves stage, then must remember to fire Conga separately. Half the time, they don't.
  • Workflow Rule sprawl: Legacy Workflow Rules and Process Builder run in parallel; nobody knows which fires.
  • Wrong template by mistake: Conga library has fifty templates; rep picks the wrong one for the wrong customer segment.
  • No audit trail: Customer says "we never got the proposal"; nobody can prove what was sent when.
  • Conga errors swallowed silently: Template fails to merge a missing field; nothing fires; nobody knows until the customer asks.

Each gap creates one lost deal a month. Combined, they explain why proposal conversion looks worse than it should.

2. Record-Triggered Flows: the right tool for stage-driven automation

Salesforce phased out Workflow Rules and Process Builder. Record-Triggered Flows are the modern automation surface for stage changes on Opportunity, Account, Case, and custom objects.

Trigger on record update with stage entry/exit

The Flow fires when an Opportunity's StageName changes — explicitly on entering or exiting a stage. Granularity that Workflow Rules never supported.

Multiple actions in one transaction

A single Flow can update the Opportunity record, call Conga's REST API to generate the document, send the email, write a log to a custom Audit object, and post to Chatter — all in one transaction.

Sub-flows for reusable logic

Stage-change automation that fires for Proposal Sent, Contract Sent, and Won notifications shares most of the same logic. Sub-flows let one Flow handle multiple stage transitions without duplication.

3. Conga template architecture: per stage, per region, per product line

Three architectural rules keep the Conga template library clean and ensure the right document fires every time.

Templates mapped to stage in metadata

Don't hardcode template IDs in the Flow. Store the mapping in a custom Metadata Type so admins can update templates without changing the Flow.

Region and product variants

A Proposal Sent template for North America differs from the one for EMEA — different legal language, currency, terms. The Flow reads the Account's Territory and product line and picks the matching template.

Versioned templates with effective dating

When legal updates the warranty language, the new template version takes effect from a defined date. Older Opportunities use the version that was active when their Opportunity opened.

4. Manual Email vs Record-Triggered Flow + Conga: the comparison

Automation Surface Manual Email (Legacy Anti-Pattern) Record-Triggered Flow + Conga (Target State)
Trigger Rep remembers to send after stage change Flow fires on Stage Name change
Template selection Rep picks from Conga library by memory Flow reads Account Territory + product line; selects matching template
Document generation Rep clicks Conga, waits, attaches PDF Flow calls Conga REST API; PDF generated in seconds
Email delivery Rep composes email and attaches Branded email auto-sent with PDF attached
Audit trail "Did I send it?" in personal email Send event written to Opportunity activity timeline + custom Audit object
Error handling Silent failure; rep finds out from customer Flow fault path emails admin + logs failure
Template versioning Manual library management Metadata-driven, version-controlled

5. The five Flow patterns every manufacturer needs

Five Record-Triggered Flow patterns that cover most Opportunity-to-Conga automation.

Proposal Sent → Conga Quote PDF

When stage enters "Proposal Sent," generate the branded quote PDF from the Primary Quote and email to the primary Contact. Update Opportunity with Send timestamp.

Contract Sent → Conga Contract PDF

When stage enters "Contract Sent," generate the contract from the Primary Quote and route via Adobe Sign or Docusign for signature.

Won → Internal Notification + Customer Welcome

When stage enters "Closed Won," send a branded welcome to the customer and an internal notification to Finance, Operations, and the Account Manager — all in one Flow.

Lost → Survey + Pipeline Update

When stage enters "Closed Lost," send a short customer survey via Conga and update the rep pipeline coverage dashboard. Loss reasons captured for forecasting.

Stage Stalled → Manager Alert

When an Opportunity sits at any stage past the configured threshold, post a Chatter alert to the Sales Manager and email the rep with the stuck record link.

6. The validation rules that protect the automation

Five validation rules keep the Flow + Conga chain honest under load.

Stage exit criteria enforced

Block stage progression unless the required Opportunity fields are populated. Conga templates can't merge into a NULL field.

Conga template version locked at Opportunity open

Capture the Conga template version active at Opportunity Open. Subsequent template updates don't retroactively change in-flight Opportunities.

Primary Quote required for Proposal Sent

Block stage entry to "Proposal Sent" without a linked Primary Quote. The Flow needs a record to read from.

Customer email present and valid

Block stage entry without a valid email on the primary Contact. Conga can't send to a NULL or malformed address.

Audit logs write atomic with email send

Wire the Audit object write to the same transaction as the Conga API call. No emails were sent without audit.

"A Flow without an audit log is a Flow you'll regret the day a customer asks what you sent."

7. Frequently Asked Questions

What's the difference between Record-Triggered Flows and Workflow Rules in Salesforce?

Record-Triggered Flows replaced Workflow Rules and Process Builder as the modern automation surface. Flows support multiple actions per trigger, sub-flows, complex branching, fault paths, and external API calls — all things Workflow Rules couldn't do. Salesforce no longer recommends creating new Workflow Rules; Record-Triggered Flows are the supported path.

Can a Record-Triggered Flow call Conga to generate a document?

Yes. Conga exposes a REST API that Salesforce Flows invoke through HTTP Callout actions or a dedicated invocable Apex class. The Flow sends the Opportunity ID and template reference; Conga generates the document and returns the file URL, which the Flow attaches to the Opportunity.

How do I handle Conga errors inside a Record-Triggered Flow?

Every external callout in a Record-Triggered Flow should sit inside a fault path. When Conga returns an error — missing template, merge failure, authentication issue — the fault path captures the error, writes it to a custom log object, notifies the admin, and prevents the stage update from silently failing.

How does Salesforce track which document was sent and when?

Wire the Flow to write a record to a custom Audit object every time a Conga document is sent. Include Opportunity ID, template version, recipient email, timestamp, and the file URL Conga returned. The audit becomes the answer when a customer disputes whether a document was sent.

When stage changes, the email sends itself

Manufacturers fix the Monday morning lost-proposal problem by re-architecting the Opportunity-to-document layer - Record-Triggered Flow automation on stage changes, Conga template selection by Territory and product line, fault-path error handling, and audit logging. This isn't a sales discipline issue; it requires Salesforce engineering across the Flow architecture, Conga API integration, and the audit object that captures every send.

Minuscule Technologies is a Trusted Salesforce Engineering Partner with 160+ Salesforce experts and 75+ projects delivered globally — including Nasdaq-listed manufacturers across heavy equipment, HVAC, automotive, and industrial sectors. We engineer Record-Triggered Flow and Conga automation that turns every stage change into a customer touch with full audit trail.

Connect with our enterprise architecture team and we'll review your Flow architecture, Conga template strategy, and audit logging design.

Contact Us for Free Consultation
Thank you! We will get back in touch with you within 48 hours.
Oops! Something went wrong while submitting the form.

Recent Blogs

Ready to Architect Your Salesforce Success?

You've seen what's possible. Now, let's make it happen for your business. Whether you need an end-to-end Salesforce solution, a complex integration, or ongoing managed services, our team is ready to deliver.

Schedule a Free Strategic Call