Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Sending Daily Update Email or Text Based on Googlesheet Data

  • May 14, 2020
  • 1 reply
  • 957 views
F

I was reading this article found here: https://zapier.com/learn/how-to/graph-gmail-unread-count/

One area that stuck was how Storage by Zapier could be used with Schedule by Zapier and send out a daily count of for example emails, and it resests each day and starts the count over. 

With this info my goal is to monitor my Googlesheet as emails come in for the day, and at the end of the day send an email or text that will show the number of emails that came for the day. And have this notifcation system repeat daily, counting up each day’s amount of emails and sending it out at the end of the day, and then resets to start again. 

The article discussed lightly how this could be done with Storage and Schedule, but I’m not sure how to set it up exactly, still messing with it. Any input would be greatly appreciated. Thank you. 

Best answer by Liz_RobertsBest answer by Liz_Roberts

Hi @frankininfo ,

Thanks for reaching out- happy to help!

You will need to set up two Zaps for this workflow:

  1. Add Google Sheets step “add row”
  2. Add a Storage step with “Increment Value”
  3. Create a second Zap, triggered by Schedule at whatever time you want the notification
  4. Add a Storage step with “Get Value, send notification (whichever app that is)
  5. Add Storage step to “Remove Value” 

Give the above configuration a go and if you have any questions along the way, just let us know! 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Liz_Roberts
Forum|alt.badge.img+8
  • Liz_RobertsZapier Staff
  • Zapier Staff
  • 1366 replies
  • Answer
  • May 15, 2020

Hi @frankininfo ,

Thanks for reaching out- happy to help!

You will need to set up two Zaps for this workflow:

  1. Add Google Sheets step “add row”
  2. Add a Storage step with “Increment Value”
  3. Create a second Zap, triggered by Schedule at whatever time you want the notification
  4. Add a Storage step with “Get Value, send notification (whichever app that is)
  5. Add Storage step to “Remove Value” 

Give the above configuration a go and if you have any questions along the way, just let us know! 

Terms & Conditions