Guide: Using Google Sheets with Databox

HOW TO

How to connect a Google Sheet

IN THIS SECTION

How to connect a Google Sheet

    The ability to connect Google Sheets and access Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have the ability to connect Google Sheets and access Query Builder in the Agency Account only. 

Navigate to  Data Sources > Query Builder to access the Query Builder for Google Sheets. Click the green + Create Custom Metric button and select your connected Google Sheet from the Data Source drop-down list.

When you connect a Google Sheet in Databox, the connection is dependent on the location of the Google Sheet, the access level of the user who connected the Google Sheet, name of Google Sheet and the name of the Worksheets. If any of these are changed, the Data Source will disconnect in Databox.

How to import data sets and spreadsheets to a Google Sheet

Learn how to import data sets and spreadsheets to a Google Sheet here.

How to import JSON data to a Google Sheet

Learn how to import JSON data to a Google Sheet here.

What is the maximum file size for Google Sheets in Databox?

The maximum file size allowed is set to 10MB without images included in the Google Sheet.

What is the maximum number of cells that can be synced with Databox?

Google Sheets connected to Databox can contain a maximum of 2,000,000 cells of data. 

How often does Google Sheets data sync with Databox?

The "Last synced" date and time will only update for Google Sheets Data Sources if the new data is added to columns or cells used in Custom Metrics.

If new data is added outside these columns or cells, the "Last synced" date and time will not change. In order to access this new data in Databox, you must create a new Custom Metric using the Query Builder for Google Sheets. 

How to create a Databoard using data from Google Sheets

The Google Sheets integration is completely custom, so there are no Basic Metrics available. All Custom Metrics must be built using the Query Builder for Google Sheets. Learn more about creating Custom Google Sheets Metrics here

Additional information

  • One user can only connect up to 50 Google Accounts in Databox. This includes all Google Data Sources, such as Google Sheets, Google Analytics, and Google Ads. When a single user connects a 51st Google Data Source, the 1st Google Data Source that they connected will disconnect.
  • When you connect a Google Sheet in Databox, the connection is dependent on the location of the Google Sheet, the access level of the user who connected the Google Sheet, name of Google Sheet and the name of the Worksheets. If any of these are changed, the Data Source will disconnect in Databox. 
  • In the Data Preview, you will only see the first 1,000 rows from your Google Sheet. Additional rows are still included in the Custom Metric, they just are not visible in the Data Preview.  
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us