Auto daily lead counter for typeform/google sheet

Question

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??

Troy Tessalone · Accepted Answer

Hi@robschmidtAnother option to what@robschmidt suggested is to use Storage by Zapier:https://zapier.com/apps/storage/helpYou’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.

robschmidt · Answer

Hi @dai-tokyo,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:Trigger: Schedule by Zapier (You can set this every night at 10 PM)Google sheet: Lookup spreadsheet row (Find the ‘Count’ row )Slack: Send message

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded