DataboxDatabox Databox
Google Sheets KPI Dashboard Software

Google Sheets
Dashboard and Reporting Software

Connect now

Google Sheets is a web-based spreadsheet program offered by Google, providing a collaborative platform for creating, editing, and sharing sheets. It allows data entry, calculations, charts, and can be accessed with ease on multiple devices.

Turn your Google spreadsheets into powerful dashboards.

Google Sheets allows users to edit, organize, update, and analyze business data from a wide variety of sources. Like any spreadsheet, it allows you to use built-in formulas, pivot tables, and conditional formatting to gain new insights and share them instantly with your team. Google Sheets also has built-in charts you can use to visualize your data, but there is no way to easily combine charts into a cross-functional dashboard or report. That’s where Databox shines.

You can use Databox with Google Sheets to create beautiful and insightful visualizations of your data. One of the key benefits of Databox is its ability to combine multiple data sources in one place. You can pull data from multiple Google sheets or ranges within them to create custom dashboards showing the most important KPIs for each segment of your business or each initiative you undertake. The Google Sheets integrations with Databox makes it easy to select the data you want from multiple sheets and ranges, choose the right way to visualize the data, and design your dashboard with just a few clicks. You can size and arrange each dashboard metric to tell your data story in the most compelling way.

Category: CRM & Sales Vendor URL: google.com/sheets/about

  • Tech details
  • Behaviour & usage
  • Handling errors
  • Help Articles

metrics

    Show more...

    dashboard templates

      Show more...

      report templates

        Show more...

        Basics

        • Category
          Spreadsheets
        • Description
          Google Sheets is a web-based spreadsheet program offered by Google, providing a collaborative platform for creating, editing, and sharing sheets. It allows data entry, calculations, charts, and can be accessed with ease on multiple devices.
        • Status
          stable

        API Details

        Metric Builder

        • Metric builder available
          Yes
        • Tabs
          Spreadsheets
        • What is the size and cell limitation for Google Sheets?

          For Google Sheets, Databox does not enforce file size or number of cells limits. However, Google does have limits in place for their API. Google allows 10 MB file downloads and the files themselves have a 10 million cell limit. A Google Sheets file exceeding either one of those limits will not work in Databox.

        • Vertical (columns) and Horizontal (rows) orientation in sheets

          In a spreadsheet, vertical orientation means organizing data into columns, where each column represents a specific category or attribute, and individual entries or records are placed in rows within these columns.
          In horizontal orientation, data is organized across columns, with each column representing a unique entry or category. Specific information within those entries is then arranged vertically, with different rows containing various attributes or details for each entry.

          In Databox:

          • Vertical orientation is required for the Metric Builder Wizard.
          • Horizontal orientation is supported only for manual metric setup (without the Wizard option).
        • Values for cells with #DIV/0 returned as number 7

          Databox requires that the value in a cell is defined as a number and when a cell displays #DIV/0 (divide by zero) error, the value assigned to this in Databox is number 7.

          We advise users to handle division by 0 in their sheet directly. There are multiple ways to do this, here is an example:
          How to Remove #DIV/0! in Google Sheets

        • Requirements regarding date formatting

          We strongly recommend ensuring that all dates in your spreadsheet are recognized as dates—either automatically, based on locale settings, or manually by applying custom date formats that override locale settings. This approach greatly reduces the likelihood of encountering issues later on.

          If a date string is not recognized by the document, Databox will attempt to validate it against common standards like ISO 8601 and RFC 2822.

          We recommend adopting popular date formats, such as:

          YYYY-MM-DD
          MM/DD/YYYY
          DD/MM/YYYY
          December 4, 2023
          4 December, 2023

          In this help article, you can learn how to check if a date format is properly set for the usage in Databox.

        • Long loading times in Metric Builder

          Google Sheets files large in size and by number of cells and using additional styles/formatting/images in worksheets can cause longer loading times in the Metric Builder. In such cases, users are advised to:

          – Remove all images from file.
          – Split the file into several smaller files and connect them separately to Databox.
          – Remove any custom cell formatting (fonts, styles, alignment, colors).
          – Deduplicate and aggregate values wherever possible.
          – Remove any unused sheets/ data.

        • Google accounts limitations for connected data sources

          Google imposes a limitation where a single user can have a maximum of 100 active Google data sources at any given time. This includes all types of sources combined, such as Google Sheets, Google Ads, Google Analytics 4, and others.

          If this limit is exceeded, the oldest connected data sources will automatically disconnect when new ones are added.

          Recommendations to Avoid Hitting the Limit:

          1) Create Additional Google Users:

            • To manage more data sources, Databox recommends creating additional Google accounts and using these accounts to connect new data sources.
            • For example, create a new Google user after every 85 data sources connected to provide a buffer and avoid reaching the limit.

          2) Establish New Connections:

          By distributing data sources across multiple Google accounts, you can effectively bypass the 100-source limitation while maintaining uninterrupted service.

        • Empty file sheet/tab is displayed in Metric Builder preview

          Check if the sheet/tab contains a Pivot table. Pivot Tables are not currently supported and cannot be synced with Databox, hence they will appear empty in Metric Builder.

        • Duplicated dimensions with the same name appear on datablock

          Sometimes, spreadsheet entries contain extra spaces, which can create duplicates. For example, you might have two dimensions: ‘Closed Won’ (without a space after the ‘n’) and ‘Closed Won ‘ (with a space after the ‘n’). Although they may look identical in Databox, they will appear as two separate dimensions because the system treats spaces as characters, recognizing them as distinct entries.

          Users can use the ‘Find and Replace’ feature in their spreadsheet to correct dimension names. For example, they can replace ‘Closed Won ‘ (with a space) with ‘Closed Won’ (without the space).

        • ‘This is not a valid A1 notation’ error message in Metric Builder – custom metric can not be previewed and saved

          If the special characters ‘!’ and ‘:’ are used in the sheet tab name of the Google Sheets file, custom metric can not be saved or viewed because those are characters reserved for A1 notation.

          This can be resolved in two ways:

          1) rename the sheet tab, so that the tab name will not use any of the two characters (!, : ), or

          2) if the data from the same tab is also used in formulas in other tabs or other Google Sheets files, duplicate / replicate the same tab as a new worksheet tab with a different name (one that does not use any of the two characters). Replication can be done by using: =, arrayformula(), importrange() or copy/paste if no new data will be added/updated.

        Track all of your key business metrics from one screen

        GET STARTED
        Databox app preview