Integrations

Track and Visualize Data from Google Sheets Easily with New Setup Wizard

Creating Custom Google Sheets Metrics Made Easy with Databox

Marija Hladni Marija Hladni on April 5, 2022 • 3 minute read

Most teams, in some form or another, are tracking something in Google Sheets. But, when it comes time to visualize all of those columns and rows of data so that it can be distilled down so that others can understand? That’s when things get complicated.

When we introduced the Google Sheets integration with Databox a few years back, it quickly became an easy and compelling way to visualize spreadsheet data, allowing quick access to teammates, executives, and clients alike.

Well, we’ve kicked it up a notch this time, and are excited to announce the brand new Google Sheets Wizard—making the creation of Google Sheets metrics possible in just a few quick steps. With all the properties of the Databox Google Sheets Query Builder, on top of an even more friendly user experience, creating metrics for your Google spreadsheets is now easier than ever.

Get to Know the New Databox Google Sheets Wizard

If you have Google Sheets connected in Databox, you are familiar with our Google Sheets Query Builder and all the options it offers. After helping hundreds of customers set up their own Databoards and gathering feedback, our goal to create an even more seamless experience for our users was finally realized with the addition of the Google Sheets Wizard.

Here’s how it works.

If you are an existing user, the first step is to select “Use Wizard” instead of “Start blank” in the Databoards section when creating a new dashboard.

After that, you have the option to select an existing data source or connect a new Google Sheets data source.
 

Next, choose the specific Sheet you want to pull data from and press Continue. 

Connect your data with Google Sheets Wizard in Databox

Once you have selected your sheet, the data will appear on your screen with each column defined. Once you’ve determined that everything looks correct, press Continue to begin creating a custom metric.

NOTE: Not into the guided metric creation? You can always switch to a manual setup in the top right corner. This will take you to the more familiar Query Builder form for Google Sheets. 
Verify your data in Google Sheets Wizard in Databox

Now it’s time to add some more information to create the custom metric that we want. Begin by selecting a metric value. From there, you will have the option to further segment it by a dimension. Simply select the data you want the value to be shown for.

Select your metric in Google Sheets Wizard in Databox

Finally, we add our finishing touches. Start with naming your metric, then choose the data aggregation option that works best for the values chosen. Don’t forget to select the favorable trend (in other words, your trending preferences) and the number format. After that, all that is left is to add this metric to your dashboard. 

Name your metric in Google Sheets Wizard in Databox

And you’re done! From a spreadsheet with cells full of data to a striking visualization of the very same data that’s as easy to read as it is to report on. Need more information on how to create a custom metric using the Google Sheet wizard? Check out our detailed help doc.

Need Help Pulling All of Your Spreadsheet data?

Creating Google Sheets custom metrics may be easier than ever now with our Google Sheets Wizard, but if you’re still unsure how to connect your data or format your Google Sheets, our team of experts is here to help.

Getting started with our free Google Sheets Setup Service is as simple as completing this questionnaire. Once submitted, one of our Google Sheets experts will get in touch and help you create powerful visualizations of your data.

Start Creating Custom Metrics using Google Sheets Wizard in Databox

The Google Sheets Wizard is available with all plans that include our Query Builder functionality

If your plan has access to Query Builder, you can log in and start using the Google Sheets Wizard now.

On a free plan? Take the new Google Sheets Wizard for a test drive by requesting a trial of Query Builder.

New to Databox? Create a free account here.

About the author
Marija Hladni
Marija Hladni Senior Marketing Strategist at Databox
You may also like...
Read more

Turn Your Excel Spreadsheets into Beautiful, Custom Dashboards in Databox

Visualize and share the insights that matter from your Excel data, now powered by Databox

Integrations   |  Apr 7

Read more

New Integration: Connect Freshdesk with Databox

By connecting Freshdesk in Databox, you get access to 85 basic metrics, the ability to create custom ones in the Freshdesk Query Builder, and more.

Integrations   |  Dec 1 2021

Read more

New Integration: Track App Analytics from Your Mobile Apps with Appfigures

By connecting Appfigures in Databox, you can track and visualize 150+ metrics from your mobile apps from App Store Connect, Google Play, Amazon Appstore, and more.

Integrations   |  Nov 8 2021