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.
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
Show more...
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.
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:
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
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.
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 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:
2) Establish New Connections:
By distributing data sources across multiple Google accounts, you can effectively bypass the 100-source limitation while maintaining uninterrupted service.
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.
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).
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.