So I have a google form that my managers input attendance events (call outs, tardiness) onto that then totals up all of the events (and the corresponding point value) for the employees on another sheet. I want to create a zap that will send out an email to all of the employees each month with the current point total. I have tried using scheduler > google sheets > gmail but I am having a hard time figuring it out. I know that I could do this without a zap, but I would rather make it automatic so I don’t have to remember to send the emails. TIA
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 23919 replies
-
2 June 2021
Hi
Try using Airtable which has Forms, Formula fields, Automations, and APIs.
Forms: https://support.airtable.com/hc/en-us/articles/206058268-How-to-use-Airtable-forms
Formulas: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference
Automations that can send digest emails: https://support.airtable.com/hc/en-us/articles/360060247433-How-to-create-email-digests-with-automations
API: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.