Match your Constant Contact list to Pipedrive people you can trust

**Objective:** Compare the members of the Constant Contact contact list `{list-name}` with the people in Pipedrive and report who is in both systems, who is missing from Pipedrive, and where the two records disagree. Check at most `{max-records}` members (default 200).

**Step 1: Find the list (Constant Contact)**

Call `constant-contact-get-contact-list` with `name` set to `{list-name}`. If nothing comes back, call it again with `name.contains`. If more than one list matches, list their names and member counts and stop.

**Step 2: Read the members (Constant Contact)**

Call `constant-contact-get-contact-list-member` with the `list-id` from Step 1 and `max-records` set to `{max-records}` (default 200). Keep each member's `email-address`, `first-name`, `last-name` and `permission-to-send`.

**Step 3: Match each member in Pipedrive**

For each member, call `pipedrive-get-person` with `email` set to the member's `email-address`. Pipedrive matches on the person's primary email only, so:

* If one person comes back, it is a match.
* If none comes back, call `pipedrive-get-person` with `name` set to the member's first and last name. A single hit is a "name match only" and must be shown separately, never treated as confirmed.
* If still nothing, the member is in Constant Contact only.

**Step 4: Compare matched records**

For each confirmed match, call `constant-contact-get-contact` with `email-address` to get `company-name`, `job-title` and `phone-number`, and compare them with the Pipedrive person's `organization-name`, `job-title` and `phone`. Flag a difference only when both sides have a value and they differ after ignoring case, punctuation and suffixes such as Inc or Ltd.

**Step 5: Report**

1. Totals: members checked, matched by email, name match only, Constant Contact only.
2. A table of mismatches: email, field, Constant Contact value, Pipedrive value.
3. A table of members missing from Pipedrive: email, name, permission-to-send.
4. The name-only matches, with both email addresses side by side.

**Rules & Guidelines:**

* `constant-contact-get-contact-list`, `constant-contact-get-contact-list-member` and `constant-contact-get-contact` are on the constant-contact server. `pipedrive-get-person` is on the pipedrive server.
* This prompt is read-only. Do NOT call `constant-contact-add-contact`, `constant-contact-update-contact`, `pipedrive-add-person` or `pipedrive-update-person`, or any other add or update tool, even to fix a mismatch you found.

**Validation:**

* If the list has no members, say so and stop.
* If a Pipedrive tool fails or is not available, report that the pipedrive server is not connected rather than reporting every member as missing.
* Compare emails case-insensitively and trim spaces before matching.