Skip to main content

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.

Hi ​@Terry TruCentive 

Try these Zap steps:

  1. Trigger: Schedule
    1. Daily @ 9 AM
    2. https://zapier.com/apps/schedule/integrations#help
  2. Action: GSheets - Lookup Rows
    1. https://zapier.com/apps/google-sheets/integrations#help
  3. Action: Filter
    1. Make sure record are found to process
    2. https://zapier.com/apps/filter/integrations#help
  4. Action: Looping - Create Loop from Line Items
    1. https://zapier.com/apps/looping/integrations#help
  5. Action: Gmail - Send Email
    1. https://zapier.com/apps/gmail/integrations#help

 

If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory


Thanks Troy, I’ll take a look at it if I can’t I’ll look you up in the directory for help!

 

Terry