For teams that run on Mailchimp
Mailchimp last appointment: check in after
A booking system knows when each client last came in. Mailchimp can send an email a set number of days before a date, while the check-in you want goes out a set time after the last visit, and only to clients who have not booked again.
How it goes today
- Export the clients with their last appointment date from the booking system.
- Filter the ones whose last visit is longer ago than your interval.
- Remove the clients who already have a new appointment.
- Tag the rest in Mailchimp so your check-in email goes out.
How it can go
Check in with clients when it has been a while since their last visit.
Each week the date of the last appointment for each client comes over from your booking system. Clients who have not been in for the time you choose, and have nothing booked, get the tag your check-in flow in Mailchimp starts on. Only the date goes to Mailchimp, not what the visit was for. A month later you see who booked again.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Mailchimp key in the portal, never in the chat.
With Hypamoon, every week, take the last appointment date of each client from our booking system. Clients who have not been in for twelve weeks and have no new appointment get the tag our check-in email in Mailchimp starts on. Send only the date to Mailchimp, not what the appointment was for. A month later, tell me who booked again.
You create the Mailchimp API key yourself under your profile, Extras, API keys. A key made since June 2026 works for a year, after which you create a new one. It stays yours.
More for teams on Mailchimp
- I want to archive contacts who stopped opening, so I stop paying for them.
- Bots keep signing up to my list and I delete them one by one.
- I want people who stop opening to get my re-engagement emails without tagging them by hand.
- My sponsors want their numbers and I make screenshots of each report.
- I download my campaign reports one by one to make a monthly overview.
- I export my list and import it into Mailchimp by hand every time something changes.
- I want a copy of my contacts, campaigns and images outside Mailchimp.
- I want our past newsletters on a page on our own website.
- I want to be notified when a tag is added, not send an email to the contact.
- I want the unsubscribe reasons over a whole year, not per campaign.
- I want to remove a tag from a pasted list of contacts at once.
- I segment my audience by language and make a campaign for each one, and it takes ages.
- I have a list of 500 unique codes and each new subscriber needs the next one.
- My renewal series pulls in people who do not expire for another year.
- Someone asks for proof of consent and I dig through export columns to find it.
- Our webshop has no Mailchimp connection, so abandoned cart emails do nothing.
- I want the birthday email on the first day of the birthday month, and I can only pick the birthday itself.
- I need to see per contact which emails were sent, when, and whether they opened.
- I want to ask for a review after a customer has had three services, without counting gift cards.
- I want to keep track of which events people attended, so I can write to them in context later.
- Someone wants to be forgotten and I have to check every audience one by one.
- Do I have to archive a subscriber once their implied consent window has passed?
- Siblings share an email address, so I can only target one of the children.
- I tag subscribers by source and cannot report on how that group performs.
- The tracking number is not sent with the shipping confirmation.
- Timewarp relies on geolocation and I keep a country field of my own.
- I manage about 30 client accounts and need their numbers in one place.
- The client says the email looks good, then disputes it after the send.
- I want last gift date and amount in Mailchimp so I can write to lapsed donors.
- People change their RSVP and I cannot keep the list up to date.
- I want every contact tagged with the company they work for, based on the domain.
- The address is stored as a single field and I need it split for mailing labels.
- Everything for Mailchimp