Hi! I am running ads for this landing page
[redacted by moderator]
I am getting lead emails everyday. I use Typeform + Google Sheet integration everyday.
Hopefully I want to setup auto daily lead counter email + Slack notification with Zapier.
How can I set it up??
Best answer by Troy Tessalone
Hi
Another option to what
You’d have 1 Zap that increments the value saved in Storage by +1 for each new lead. (Storage Increment Value)
You’d have 1 Zap that resets the Storage value back to 0 at midnight for each day.
+9Hi
Here’s the flow for that:
At first, you are going to have to create a reporting system (daily lead count) within Google sheet, probably in a new worksheet. Where you have to write a formula that counts all the today’s lead like this:
+14Hi
Another option to what
You’d have 1 Zap that increments the value saved in Storage by +1 for each new lead. (Storage Increment Value)
You’d have 1 Zap that resets the Storage value back to 0 at midnight for each day.
Hi
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
