See which Attio contacts are in your Mailchimp audience

**Objective:** Reconcile the Attio people at company `{company}` with the Mailchimp audience named `{list-name}`, and report who is in both, who is only in Attio, and who is unsubscribed or cleaned in Mailchimp. Look at up to `{max-records}` people (default 50).

**Step 1: Read the people from Attio**

Call `attio-get-record-people` (Attio) with `company.contains` set to `{company}` and `max-records` set to `{max-records}`. Keep `name`, `job-title`, `company` and `email-addresses` for each person. If no one comes back, say so and stop. Set aside people with no email address and list them separately.

**Step 2: Look each email up in Mailchimp**

For each email, call `mailchimp-get-list-member` (Mailchimp) with `email` set to that address and `list-name` set to `{list-name}`. If more than one audience matches the name, list the audiences and stop. Keep `status`, `tags`, `rating`, `vip` and `sign-up-date`.

**Step 3: Report**

Give three tables: in both (name, email, Mailchimp status, tags, rating), only in Attio (name, email, job title), and in Mailchimp as unsubscribed or cleaned (name, email, unsubscribe reason). End with counts and one line on the largest gap.

**Rules & Guidelines:**

* Tools whose names start with attio are on the Attio server. Tools whose names start with mailchimp are on the Mailchimp server. Both servers must be connected; if a tool from either is missing, say which server is not connected and stop.
* The join key between the two systems is the email address. Compare it case-insensitively and trimmed. Attio people can hold several emails, so match against any of them.
* Do not call any write tool on either server: `attio-add-company`, `attio-add-person`, `attio-add-deal`, `attio-update-company`, `attio-update-person`, `attio-update-deal`, `attio-upsert-company`, `attio-upsert-person`, `attio-delete-company`, `attio-delete-person`, `attio-delete-deal` (Attio), `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-add-segment-member`, `mailchimp-update-order`, `mailchimp-update-product`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign` (Mailchimp).

**Validation:**

* If `mailchimp-get-list-member` returns nothing for an email, report the person as present in Attio and absent from Mailchimp and continue.
* If the Attio person has several emails with different Mailchimp statuses, report each one rather than picking one.