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
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
