1. All Collections
  2. Integrations
  3. How to use the Google Sheets integration?
Image

How to use the Google Sheets integration?

Some details about Metrics Watch’s Google Sheets integration: requirements, limitations, etc

Avatar

By Jon

August 30, 2023

This document will help you (1) configure the integration and (2) set up your Google Sheets spreadsheet for compatibility with the Metrics Watch reporting tool.

How to use the Google Sheets integration in Metrics Watch?

To use the Google Sheets integration, you need to:

  1. Connect your Google Sheets account.
  2. Once that's done, you can add any Google Sheets widgets in your reports.
  3. In the widget configuration, you will be able to select which sheet to use, and you will see the detected metrics & dimensions to build your widget with.

Spreadsheet Requirements

For Metrics Watch to pull data from your Google Sheet, your spreadsheet will need to meet the following requirements:

  • You need a header line: only one line at the top of each column

  • You need at least one column of type “Date” or “Date Hour”

    • We will use the first Date or Date Hour column we find

    • We will not use the time part of the date

    • Supported date formats:

      Date format: "mm-dd-yy", example_date: "01-01-22"Date format: "m/d/yy", example_date: "1/1/22"Date format: "yy-mm-dd", example_date: "22-01-01"Date format: "mm/dd/yy", example_date: "01/01/22"Date format: "d-mm-yy", example_date: "1-01-22"Date format: "dd-mm-yy", example_date: "1-01-22"Date format: "yyyy-mm-dd", example_date: "2022-01-01"Date format: "m/d/yyyy", example_date: "1/1/2022"Date format: "yyyy/m/d", example_date: "2022/1/1"Date format: "yyyy-m-d", example_date: "2022-1-1"Date format: "M/d/yyyy H:mm:ss", example_date: "1/1/2022 9:11:00"Date format: "yyyy/mm/dd", example_date: "2022/01/01"

  • The metrics column must have a number format (percent, currency or number)

    • Any cell that doesn’t have such a type will be ignored
    • We use the second line of the sheet to validate if a column is a metric (number format)
  • All columns that are not metrics will be considered dimensions

  • The maximum cell range supported is A1:ZZ40000

Example Spreadsheet

Here is an example of a valid Google Sheet: https://docs.google.com/spreadsheets/d/11oHT2elgRtleoA5K0NBLDwR7b1P92VWM8mHFFD2Bvbc/edit?usp=sharing

Feel free to save a copy to your own Google Drive to edit or use as a reference.

IMAGE