About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Birthday email to clients triggered by Google Sheet or Wealthbox?

  • 7 November 2022
  • 6 replies
  • 342 views
A

I’ve got client birthday + email in both Wealthbox and Google Sheets. 

 

Is there a way to trigger an automatic email, preferably through Outlook, using either one of these sources?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @armueller2001 

Good question.

Perhaps you can clarify what would be the Zap trigger event.

Are you trying to send an email when the Birthday value is Today?

If yes, then I’d suggest using Airtable.

Airtable have Views.

Views have Filters. (e.g. Birthday = Today)

Views can be used to trigger Zaps.

Airtable also has Automations.

Outlook is a native app that can be used in Airtable Automations.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

Hi @armueller2001 

Good question.

Perhaps you can clarify what would be the Zap trigger event.

Are you trying to send an email when the Birthday value is Today?

 

Thanks for your reply. Yes, that’s exactly what I’d like. I was thinking use 

-New row added to google sheets

Triggers

-New event in Outlook on Birthdays calendar (but it needs to be added to *this year* and recurring)

 

And then use events on the Birthdays calendar to drive an automated email. Maybe? 

Troy Tessalone
Userlevel 7
Badge +14

@armueller2001 

The Zap action for Outlook Create Event has no option to set a recurring event.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

That sucks. I’ll have to explore some other solutions. 

Troy Tessalone
Userlevel 7
Badge +14

@armueller2001 

Airtable has Formula fields.

You can use Formula fields to compare the MMDD of the Birthday to the MMDD of Today.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
nicksimard
Userlevel 7
Badge +11

Hi @armueller2001!

As Troy pointed out, you can use Airtable with a view that will display records when “today” matches the birthday. Then that’s your trigger.

Here’s how I approached the formula. 

  • A field for the birthday (including year, assuming you have that)
  • Format that to be MM/DD
  • Format “today” to be MM/DD
  • Compare the two to see if they match
  • Then I combine it all into one formula field.

There may be better formulas, but here’s what I used above and it works:

IF(DATETIME_FORMAT(Birthday, 'MM/DD')=DATETIME_FORMAT(NOW(),'MM/DD'),'yes','no')

Then you have a view that only displays the records that match:

 

Then this is your trigger:

 

It’s not the MOST straightforward way of doing it, but it works. And can work for a lot of use cases, combining Airtable’s views (powered by filters) with Zapier.

Hope that helps!

Terms & Conditions