Best answer

Auto daily lead counter for typeform/google sheet

  • 30 April 2021
  • 3 replies
  • 158 views

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

icon

Best answer by Troy Tessalone 30 April 2021, 16:32

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +9

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
Userlevel 7
Badge +14

Hi @robschmidt 

Another option to what @robschmidt suggested is to use Storage by Zapierhttps://zapier.com/apps/storage/help

 

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.
 

Userlevel 2
Badge

Hi @robschmidt were you able to get this workflow setup with either of the suggestions above? Let us know!