Reports, Charts and Dashboards

By Zapier

You are reading: Chapter 11 of 17

"What gets measured, gets managed." - Peter Drucker

If you want to improve on something, the best thing to do is start measuring it's performance. This set of Zaps will easily let you track, measure and improve anything you'd like.

Push Spreadsheet Data to a Dashboard tool

A relatively popular way to collect and store data is via a Google Spreadsheet. But viewing data in a chart isn't the most friendly. That's where a handy dashboard tool comes in.

You can easily use a Zap like the Google Docs to Ducksboard Zaps to track new rows or cells in a Google Docs spreadsheet in a Ducksboard chart so you can see how data changes over time.

Similar Zaps
1. Update Geckoboard number from Google Spreadsheet
2. Increment Leftronic chart from new rows in Google Spreadsheet

Post Company Activity to a Dashboard Timeline

Even in a small company there are a lot of things going on. Across sales, marketing, and operations you'll have multiple people working on different projects at the same time and it can be tough to get even a bird's eye view of what is happening.

That's where it can come in handy to funnel company activity to a dashboard timeline. A great example would be posting GitHub commits to Ducksboard, but you could easily add other items to the timeline to get a more holistic view of the company.

Similar Zaps
1. Add Sprintly items to a Leftronic timeline text feed
2. Add Desk cases to Geckoboard text feed
3. Track PayPal sales in a Ducksboard timeline

Chart Sales in a Dashboard

Visualizing sales is fun. A chart that shows how much money you are making that's going up and to the right gives you that dopamine hit to keep you excited about the day.

With this zap you can easily track all your Stripe charges in Ducksboard and see a complete history of your company revenue.

Similar Zaps
1. Add PayPal transactions to Ducksboard
2. Track Chargify subscriptions in Ducksboard

Track Custom Data in a Dashboard

Want to track custom data in a Dashboard easily? Zapier makes it pretty simple to do either through a Google Spreadsheet or through a webhook for more complicated Zaps.

Check out the Google Spreadsheet to Geckoboard zap as a great example of how you can track custom data using Zapier.

Similar Zaps
1. Increment Leftronic dashboard using Google Spreadsheet data
2. Update Geckoboard number via webhook
3. Track Google Spreadsheet data in Ducksboard


In the next chapter, learn how to automate common ecommerce tasks.

Go to Part XII!


Take the Work out of Workflow

Zapier is the easiest way to automate powerful workflows with more than 2,000 apps.