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.

I want to automate the process of tracking conversions week-to-week using Zapier, but I’m not really sure how to pull it off. I really just want to be able to see the running trends of how many new free trials our saas app gets on a weekly basis, without having to bug my dev team to build it out for me.

The end result I’m looking for is the number of new free trials that start each week gets stored in a column in Google Sheets. I’d like to base this off of a custom event that is fired in Drip.

So I think the general idea is that every time the “New Free Trial Signup” event occurs in drip, I need to increment the number of free trials started in Google Sheets, but I also need to be able to tell Google Sheets when to create a new column at the end of the week and to start over from 0.

Or I suppose I could use Schedule by Zapier to just pull all of the conversion data from Drip once a week and cram it into a Google Sheets cell. But how do I get it to only count the number of times that event occurred within the trailing 7 days?

This doesn’t seem like a new problem to solve; is there already a solution out there that I’ve not come across?

I’d be incredibly grateful if anyone has some suggestions for me!

Chris

Hi @chrisgscott 

You can achieve this in various ways, the easiest method in my mind is would be:

  • Every single time the event (or events) in Drip occurs
  • Save all the events to google sheet (in Sheet A) via Zapier
  • Setup Sheet B with =Query formula that aggregates the data from past 7 days on specific event
  • Use another Zap to send out the metrics at the end of the week
Terms & Conditions