Data Studio lets us visualize data from many sources. At Distilled, we’ve been using Google Sheets to do most of our reporting for years. It works well—but transitioning to Data Studio is so satisfying. It’s easier to manage permissions. And it’s also easier to get Google Analytics data into Data Studio than Sheets.
Here’s the thing: it’s still downright fun to use Sheets as a data source in Data Studio. You can see your data, interact with it, and then chart it. Sheets gives you the power of Data Studio without the bother of managing databases. Anyone can do it.
This post explains how to use Google Sheets as a data source in Data Studio. I recommend opening these documents as you follow along: