Guide: Using Google Sheets with Databox

HOW TO

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 Manager > 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 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.

    If you hit this limit, you can send requests to team members so they can connect the additional Google Data Sources. 
  • 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. 
  • Google Sheets connected to Databox can contain a maximum of 2,000,000 cells of data. 
  • 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.  
  • The maximum file size allowed is set to 10MB without images included in the document.
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