I would like to at 9am every morning have zapier check a google employee sheet and loop through everyone who has a birthday that day and send an email. My payrol systems syncs with sheets so I don’t have to worry about it.
Best answer
Send a birthday email based on a Google Sheet
- Beginner
- 1 reply
Best answer by Troy Tessalone
Hi
Try these Zap steps:
- Trigger: Schedule
- Daily @ 9 AM
- https://zapier.com/apps/schedule/integrations#help
- Action: GSheets - Lookup Rows
- Action: Filter
- Make sure record are found to process
- https://zapier.com/apps/filter/integrations#help
- Action: Looping - Create Loop from Line Items
- Action: Gmail - Send Email
If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- 34001 replies
- Answer
Hi
Try these Zap steps:
- Trigger: Schedule
- Daily @ 9 AM
- https://zapier.com/apps/schedule/integrations#help
- Action: GSheets - Lookup Rows
- Action: Filter
- Make sure record are found to process
- https://zapier.com/apps/filter/integrations#help
- Action: Looping - Create Loop from Line Items
- Action: Gmail - Send Email
If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory
- Beginner
- 1 reply
Thanks Troy, I’ll take a look at it if I can’t I’ll look you up in the directory for help!
Terry
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.