Automation Recipe: Automated Anniversary and Client Re-Engagement Outreach

What This Builds

An automation that monitors your client CRM for upcoming anniversaries and birthdays, then automatically drafts a personalized re-engagement email using AI and places it in your Gmail drafts — ready for your final review and send. You never miss a milestone outreach again, and each email arrives pre-written so sending takes 60 seconds instead of 10 minutes.

Prerequisites

• A Zapier account — Starter plan (~$20/month) needed for multi-step Zaps with delays
• A CRM that Zapier can connect to — TravelJoy, Airtable, or a Google Sheet with client anniversaries works; some CRMs (ClientBase) may require a workaround
• A ChatGPT account with OpenAI API access (separate from your regular ChatGPT login — see Step 2)
• A Gmail account
• Comfortable with ChatGPT for email drafting (Level 3 guide)

The Concept

Your CRM holds a goldmine: every past client, where they traveled, when they celebrated milestones. The problem is that acting on this information requires manually checking the CRM, remembering to write the email, and finding time in your day. This automation does the monitoring for you — and AI does the drafting. You just approve and send.

Think of it as a personal assistant who reviews your client database every morning, identifies who has an upcoming anniversary in 60 days, pulls their travel history from your notes, drafts a personalized reach-out, and puts it in your Gmail drafts labeled "Review and Send."

Build It Step by Step

Part 1: Prepare your client anniversary tracking

If your CRM supports Zapier integration (TravelJoy, Airtable, HubSpot): great — proceed to Part 2.

If your CRM (ClientBase, Tern) doesn't have direct Zapier integration:

1. Create a Google Sheet titled "Client Anniversary Tracker"
2. Columns: Client Names, Email, Anniversary Date, Past Trip, Travel Style Notes, Date Last Contacted
3. Add your past clients with anniversary dates — focus on the top 30 who are most likely to travel again
4. This Google Sheet becomes your Zapier trigger source

Part 2: Set up your OpenAI API account

1. Go to platform.openai.com (separate from your regular ChatGPT account)
2. Create an account → click your profile → API keys → Create new secret key
3. Save the key: sk-abc123... (you won't see it again)
4. Add a credit card at platform.openai.com/account/billing (cost per email draft: ~$0.02)

Part 3: Create your Zapier workflow

Step 1 — Set up the Trigger:

1. Log into zapier.com → click Create Zap
2. Click Trigger → search "Google Sheets" → select New or Updated Row
3. Connect your Google account → select your "Client Anniversary Tracker" sheet
4. In the filter, set it to fire when: Anniversary Date is within 60 days of today

Note: Zapier doesn't natively do "date within X days" filtering. The workaround: add a formula column to your Google Sheet that calculates days until anniversary:

=DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(C2),DAY(C2)),"D")

Then in Zapier, add a Filter step: only continue if this column value is between 55 and 65 (the 60-day window, with buffer).

Step 2 — Add a ChatGPT draft step:

1. Click + → search "OpenAI" → select Send Prompt
2. Connect with your API key
3. In the Prompt field, write:

You are a travel advisor writing a personal re-engagement email. Write a warm,
personal email to [map: client names field from the sheet] at [map: email field].

Context:
- They traveled to [map: past trip field] with me previously
- Their travel style: [map: travel style notes field]
- Their anniversary is coming up in approximately 60 days

Write a warm, personal email (under 150 words):
1. Acknowledge their upcoming anniversary warmly
2. Reference their past trip briefly (e.g., "I still think about the truffle
   dinner we arranged for you in Tuscany")
3. Suggest one specific new destination that connects to what they loved
4. End with a low-pressure invitation: "I'd love to start dreaming up your
   next adventure — reply and we'll set up a call"
Tone: personal friend with expert knowledge. NOT a sales email. No subject line needed.

1. Map the dynamic fields from your Google Sheet to the prompt brackets

Step 3 — Create a Gmail draft:

1. Click + → search "Gmail" → select Create Draft
2. To: map the client email field from your sheet
3. Subject: type: [Anniversary idea] Your [anniversary number]th — I have a trip in mind
4. Body: map the OpenAI output (the generated email)
5. Labels: add a label "Anniversary Outreach — Review Before Send"

Step 4 — Turn it on:

1. Click Publish Zap
2. Test with your own row in the sheet (set a test anniversary date to today + 60 days)
3. Check Gmail Drafts for the AI-generated email

Part 4: Build a review habit

1. Every Monday morning: open Gmail → filter by label "Anniversary Outreach — Review Before Send"
2. For each draft: read it, add one genuinely personal sentence that only you would know, and click Send
3. The whole process: 2 minutes per email vs. 10–15 minutes if done manually

Real Example: The $12,000 Email

Setup: Your Google Sheet includes David and Maria, who traveled to Italy with you 4 years ago. Their 20th anniversary is in 60 days.

What happens automatically:

• Zapier detects that their anniversary column shows 60 days remaining
• OpenAI generates: "David and Maria — I've been thinking about your 20th coming up, and I can't help but wonder if this is the year to finally do Portugal. You mentioned after Italy that you'd love somewhere equally food-forward but less crowded. The Alentejo wine region has everything you loved about Tuscany — but without another American in sight. I'd love to start dreaming up your 20th anniversary trip. Reply and we'll set up a call."
• Draft lands in Gmail labeled "Anniversary Outreach — Review Before Send"

What you do: Read it Monday morning. Add one personal sentence: "I still hear you talking about that truffle dinner in Montalcino." Click send.

What happens next: David and Maria reply. A $12,000 Portugal trip is booked.

Time spent: 90 seconds. Time that automation saved: 15 minutes of email writing + the missed opportunity if you'd forgotten.

What to Do When It Breaks

• Zapier trigger not firing → Check your Google Sheet filter formula — dates can be tricky; add a "Days Until Anniversary" column using a formula and filter on that number instead
• AI email feels too generic → Improve the prompt: add more client context fields to your sheet (specific trip highlight, favorite restaurant from their trip, something they said afterward) and map these into the prompt
• Emails going to wrong addresses → Double-check the email field mapping in the Gmail step — test with your own email before going live
• OpenAI API errors → Check your billing at platform.openai.com; if you've hit your credit limit, add funds; typical monthly cost for 20–30 drafts is under $2

Variations

• Simpler version: Set a recurring Google Calendar reminder to check your anniversary client list monthly; use ChatGPT manually to draft the emails. Less automated but zero technical setup.
• Extended version: Add a second Zap that fires 30 days before birthdays with a different, shorter check-in message ("Thinking of you as your birthday approaches — any travel dreams for the year ahead?")

What to Do Next

• This week: Set up the Google Sheet tracker and populate with your top 30 past clients' anniversaries and travel notes
• This month: Build the Zap; test it; run it for 60 days and track how many conversations it generates
• Advanced: Add a third Zap: if a client's anniversary draft is sent but no reply comes within 2 weeks, automatically generate a shorter follow-up ("Just checking if you received my note about Portugal…")

Advanced guide for travel agent professionals. These techniques use more sophisticated AI features that may require paid subscriptions.