A weekly pipeline email built from live Salesforce data: total open pipeline, pipeline by stage and each rep's own deals, fresh on every send, with no report to export.
Most pipeline updates are a screenshot of a report, out of date by the time it's read. With Salesforce connected, the figures in your email come from Salesforce each time it's sent, so Monday's email shows Monday's pipeline.
How the connection works
MailInApp
Signs in with your Connected App's certificate
Salesforce
Runs your SOQL query and returns the rows
Your email
KPI scorecard and charts drawn from the rows
Each reader
Sees this week's figures, filtered to their own deals
Each send reads Salesforce afresh. MailInApp signs in with a certificate, so there's no password to share and nothing to renew by hand.
MailInApp connects as a Salesforce Connected App with a certificate, the way Salesforce recommends for server-to-server access. The Salesforce guide walks through the setup field by field.
Choose the data with a query
A SOQL query decides the rows the email gets:
SELECT Name, Amount, StageName, CloseDate, Account.Name, Owner.Email FROM Opportunity WHERE IsClosed = false
Related fields such as Account.Name and Owner.Email come through as fields of their own. See Querying with SOQL.
What to build
Add the connection from the studio's Data panel, then bind the blocks to it in their own settings:
- KPI scorecard: the sum of
Amount, as total open pipeline. - Bar chart: pipeline by stage, grouped by
StageName. - A repeat block: one line per deal closing this month, each with a Button to its Salesforce record.
Every reader sees the figures and the charts, whatever app they read your email in.
Each rep sees their own deals
A chart's filter and a repeat block's Filter rows compare a Salesforce field with the reader's own data. With Owner.Email equals {{email}}, one shared query shows each rep only their own opportunities. See A different slice for each recipient.
Send it every Monday
Schedule a weekly recurring send and tick Send to everyone who matches on every run. Each run reads Salesforce again and mails the whole team that week's numbers.
Bring your Salesforce contacts too
Your readers can come from Salesforce as well: with a Contact query, Contacts → Import contacts → API connection maps the Salesforce fields to your list and flags contacts who opted out in Salesforce, so you can leave them out. Run it again to bring in new contacts. See Import your Salesforce contacts.
Getting started
Create a Connected App with a certificate in Salesforce, add it in MailInApp as an API connection, and bind a KPI scorecard and a Bar chart to your Opportunity query. The Salesforce guide has every field.
