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
Page 1 / 1
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 E-mail address. We'll send you an e-mail with instructions to reset your password.