/
/
Get Salesforce campaign members onto your Constant Contact list
For marketing teams who send from Constant Contact and want Salesforce campaign members on the list without duplicates or revived unsubscribes, by asking their AI assistant.
On this page
Connector
Connect Salesforce, pick your AI tool and paste the prompt.
The problem
Campaign members never quite make it onto the email list
Your Salesforce campaign holds the members, but the email goes out from Constant Contact, so someone copies people across by hand. Unsubscribed people slip back in, existing contacts get duplicated and consent is assumed rather than recorded.
Without PopdockAI
- Export the campaign members from Salesforce
- Check each address against the Constant Contact list by hand
- Guess who already exists and who unsubscribed
- Duplicates and opted out people end up on the list
With PopdockAI
- Campaign members with an email are compared with the list for you
- New people and existing contacts are split out clearly
- Anyone who unsubscribed is excluded
- Nothing is added until you confirm, and consent stays unset unless you say so
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Make sure every member of the Salesforce campaign `{salesforce-campaign-name}` who has an email address is on the Constant Contact contact list `{list-name}`, adding the missing ones after confirmation.
**Step 1: Read the Salesforce campaign members**
Call `salesforce-get-campaign` with `name.contains` = `{salesforce-campaign-name}`. If more than one matches, list them and stop. Then call `salesforce-get-campaign-member` with `campaign-id` = its `campaign-id`. Keep members with an `email`, with their name, company, title and phone.
**Step 2: Identify the Constant Contact list**
Call `constant-contact-get-contact-list` with `name.contains` = `{list-name}`. If more than one matches, list them and stop. If none match, say so and stop; do not create a list.
**Step 3: Find who is missing**
Call `constant-contact-get-contact-list-member` with the list's `list-id` and keep distinct `email-address` values. A Salesforce member is missing if their email is not among them. For each missing member, call `constant-contact-get-contact` with `email-address` to see whether they already exist in Constant Contact on another list, and note their `permission-to-send`.
**Step 4: Confirm before writing**
Show two tables: missing people who are new to Constant Contact (will be created on the list), and missing people who already exist in Constant Contact (cannot be added to the list by this prompt; list them for manual action). Exclude anyone whose existing Constant Contact `permission-to-send` shows they unsubscribed. Ask the user to confirm. Do not continue without an explicit yes.
**Step 5: Add the new contacts**
For each confirmed new person, call `constant-contact-add-contact` with `email`, `first-name`, `last-name`, `company-name`, `job-title`, `phone` and `list-id`. Leave `permission-to-send` unset unless the user states in this conversation that these people gave express consent.
**Step 6: Report**
A table: email, name, result (added, already exists, unsubscribed and skipped, or error). Then counts for each result.
**Rules & Guidelines:**
* Tools named `salesforce-*` are on the salesforce server; tools named `constant-contact-*` are on the constant-contact server.
* The only write tool this prompt may call is `constant-contact-add-contact`, on the constant-contact server, and only after the user confirms in Step 4.
* Do NOT call `constant-contact-update-contact`, `constant-contact-add-contact-list`, `constant-contact-update-contact-list`, `constant-contact-add-campaign` or any Salesforce add or update tool.
**Validation:**
* Compare email addresses case-insensitively and ignore surrounding spaces.
* Never re-add someone who unsubscribed in Constant Contact.
* If the campaign has no members with an email, say so and stop.Who it's for
One answer, three teams that use it
Email marketers
Send to the full campaign audience
Get every Salesforce campaign member onto the right Constant Contact list before a send, without an export and import round trip.
Add the members of the Salesforce campaign Northwind Roadshow to the Roadshow Invites list in Constant Contact.
Event marketers
Follow up with event attendees quickly
Move the people from an event campaign onto a follow up list the same day, with unsubscribes kept off it.
Put everyone from the Salesforce campaign Contoso User Day on our User Day Follow-up list in Constant Contact.
Marketing operations
Keep consent and contacts clean
Every new contact is checked against the list first and permission is never assumed, so the account stays tidy and compliant.
Which members of the Salesforce campaign Fabrikam Webinar are missing from the Webinar Leads list in Constant Contact? Add the new ones.
How it works
What PopdockAI does when you ask
You name the Salesforce campaign and the Constant Contact list, and your AI assistant works out who is missing. Nobody is added until you have seen the split and said yes.
01
Ask
You name the Salesforce campaign and the Constant Contact list.
02
Compare
It reads campaign members with an email and checks who is missing from the list.
03
Confirm
You see new people to create and existing contacts to add by hand, and say yes.
04
Add
It creates the new contacts on the list and reports a result for each person.
What PopdockAI provides
The tools behind the answer
Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.
salesforce-get-campaign
salesforce-get-campaign-member
constant-contact-get-contact-list
constant-contact-get-contact-list-member
constant-contact-get-contact
constant-contact-add-contact
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
One audience across Salesforce and Constant Contact
Related use cases
More ways to put this data to work
Flag Salesforce contacts who unsubscribed or bounced in Constant Contact
Ask your AI which Salesforce contacts unsubscribed or bounced in Constant Contact and it matches each address to a contact or lead and owner, with live deals first.
Learn More
Rank Salesforce leads by Constant Contact engagement
Ask your AI to rank Salesforce leads by Constant Contact engagement and it scores each open lead's opens and clicks and suggests follow-ups for the top five.
Learn More
Salesforce campaign performance report
Ask your AI for a Salesforce campaign performance report and it calculates response rate, cost per response, return and results against budget, and lists senior responders to call.
Learn More
Add Salesforce campaign members to a Mailchimp audience
Ask your AI to add Salesforce campaign members to a Mailchimp audience and it adds new people as pending for double opt-in, skips anyone already there, and writes only after you confirm.
Learn More
Advance a Salesforce opportunity
Ask your AI to advance a Salesforce opportunity and it sanity checks the stage change and close date, updates only changed fields after you confirm, and offers a follow-up task.
Learn More
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.