Interactive Email Powered by Live Salesforce Data

Most pipeline updates are a screenshot of a report, out of date by the time it's read. Connect Salesforce once, and the scorecard and charts in your email read Salesforce each time it's sent, so Monday's email shows Monday's pipeline.

Subject

Your pipeline this week

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.

Watch: live Salesforce data in your emails

An outdoor gear wholesaler connects a public weather API with one header, then Salesforce through a JWT login with no password. Its store buyers become the audience, its price book a live catalog, and each store sees only its own open orders, in an email and a web version that stay in sync with Salesforce. Then a poll, and a weekly pipeline digest for the sales team.

A typical build-and-send sequence

  1. 1

    Connect Salesforce

    Create a Connected App with a certificate in Salesforce, then add it as an API connection in MailInApp. The Salesforce guide covers each field.

  2. 2

    Choose the data with a query

    A SOQL query such as SELECT Name, Amount, StageName, CloseDate FROM Opportunity WHERE IsClosed = false decides the rows.

  3. 3

    Bind the blocks

    Add the connection from the studio's Data panel, then bind a KPI scorecard to the sum of Amount and a bar chart to StageName.

  4. 4

    Send it every week

    Schedule a weekly recurring send with Send to everyone who matches on every run, so each reader gets each week's numbers.

Frequently asked questions

Does the connection need renewing by hand?

It renews itself. MailInApp signs in with your Connected App's certificate each time a fresh token is needed, so the email keeps running week after week.

Does my Salesforce password reach MailInApp?

MailInApp signs in with a certificate, the way Salesforce recommends for server-to-server access, and stores only the private key you paste, masked after you save it.

Can each sales rep see only their own opportunities?

Yes. Select Owner.Email in the query and give the chart a filter where Owner.Email equals {{email}}. One shared query then shows each rep their own deals.

Can I import my Salesforce contacts too?

Yes. Under Contacts, Import contacts → API connection reads a Contact query, maps the Salesforce fields to your list and flags contacts who opted out in Salesforce so you can leave them out.

What Salesforce edition do I need?

One with REST API access: Enterprise, Unlimited, Performance and Developer Edition include it, and Professional and Essentials add it with Salesforce's API add-on. The integration user needs API Enabled on their profile.

Does it work with a sandbox?

Yes. Use https://test.salesforce.com as the token URL host and the Audience, and point the endpoint at your sandbox's My Domain address.

Build this in the studio

Start on the free plan — every interactive block and the full fallback engine are included on every tier.