[July 2019 Update] Top Google Sheets Add-ons

It’s been a while since I did this, so this is an updated look at the top Google Sheets add-ons. I scraped this data from the Google Sheets add-on store. Earlier posts in this series: Top Google Sheets Add-Ons for Spreadsheets (+User Counts) [Oct 2018 Update] Top Google Sheets Add-Ons for Spreadsheets [Jan 2019 Update] … Read more

[JAN 2019 UPDATE] Top Google Sheets Add-Ons for Spreadsheets

Here we are again with another look at the top Google Sheets Add-Ons for spreadsheets. Other posts in this series: Top Google Sheets Add-Ons for Spreadsheets (+User Counts) [Oct 2018 Update] Top Google Sheets Add-Ons for Spreadsheets [July 2019 Update] Top Google Sheets Add-ons I scraped this data with a little script from the Google … Read more

Extend Google Analytics: Use Transaction Data to Create a Revenue Histogram

A histogram is a type of chart that visually shows the distribution of data. It’s useful when looking at the average or median of a data set, to understand whether that data point is common or not. For example, an ecommerce dashboard will typically include an Average Order Value metric. Say this metric is $50. … Read more

Top Google Sheets Add-Ons for Spreadsheets (+User Counts)

Google’s online spreadsheet service, Google Sheets, allows users to install add-ons (aka plugins or extensions) for additional functionality. After making a little Google Sheets add-on of my own, Archive Data, I became curious about what add-ons are most popular. Through some web scraping I extracted a comprehensive list of all Google Sheets add-ons from the Sheets … Read more

Archive Data Add-On for Google Sheets

The free Google Sheets add-on Archive Data helps store historical data from your Google Sheets reports and dashboards before it gets refreshed. It allows you to set a schedule to paste from row or column X to Y, automatically creating a record of your original data. Example:You have a monthly dashboard that uses the “Google Analytics … Read more