I want to send wedding anniversary emails to list of people on the date of their wedding anniversary.
I have the records in Google sheets and have also imported them into my Google Contacts, using a custom field for the wedding anniversary date and placed them all under a label named “Anniversaries”
Is there a way using zapier that I could send emails via gmail to these people either from the Google sheets file or from google contacts on the date of their wedding anniversaries?
Thanks
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Yes, you’d need to create new recurring events for existing GContacts using the desired data points.
Alternatively, you could consider creating an event when a GContact is created/updated.
Steps
You can export your GContacts to a GSheet: https://support.google.com/contacts/answer/7199294?co=GENIE.Platform%3DDesktop&hl=en
Then you could configure a Zap that creates a GCal Event by looping thru the rows.
+14Hi
Consider adding a repeating Event in GCal and using GCal Event Start as the Zap trigger.
Action: Gmail Send Email
+8Hi there
You can read more about it here: https://zapier.com/help/doc/common-problems-with-gmail#my-gmail-zap-has-an-error-about-connecting-to-google-approved-or-not-approved-apps - Let me know if you have any further questions!
Troy, would that mean that the contacts and dates would need to be added to Google Calendar first?
I’m not sure how to do that.
I can see how to add birthdays to Google Calendar, but haven’t been able to find a way to add dates that are in a custom field?
Steph.n
Hi, I have a custom email address and a Google business account, so that shouldn’t be an issue.
Thank you
+8Hi there
What I think Troy is saying is that you’ll need to add each calendar event into Google Calendar. Don’t forget to set the “Repeat event once a year on the same date” within each event with makes a recurring event. So for example, you need to add March 30th as a calendar event plus add repeat once a year. From there, the Zap should trigger on the Start Date once a year like Troy outlined. You don’t need a custom field, it is based on the calendar event start date.
The Description in the calendar field is a good place if you want to add a custom message (or still need a custom field).
+14Hi
Yes, you’d need to create new recurring events for existing GContacts using the desired data points.
Alternatively, you could consider creating an event when a GContact is created/updated.
Steps
You can export your GContacts to a GSheet: https://support.google.com/contacts/answer/7199294?co=GENIE.Platform%3DDesktop&hl=en
Then you could configure a Zap that creates a GCal Event by looping thru the rows.
Thank you
I already have all of the data in a Google sheet, so I’ll play around with the webhook idea and see if I can get that to work.
There are a few hundred wedding anniversaries and so to add all of those into Google calendar one at a time (which is what seems to be the only option) would take far too long.
+14The looping webhook method as outlined in the video will work.
I suggest testing on a smaller subset of data first to ensure the Zap works as expected.
Because once it’s turned ON, it will processes pretty quickly.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
