How to collect data from Google Sheets

A Metric Insights' Dataset or element can be populated automatically based on data fetched from Google Sheets  

PREREQUISITE:

You must have already established connectivity to Google Sheets via the respective plugin connection profile.

This article describes how to create a Dataset from the Plugin Data Sources Editor.

1. Plugin Data Sources Editor > Datasets tab

  1. Access Plugin Data Sources Editor > Datasets tab
  2. Click [New Dataset]

You will be redirected to the Dataset Editor

2. Dataset Editor > Info tab

  1. Measured: select the measurement interval that applies to the level of aggregation that you want in your result set.
  2. Collecting: new Datasets are always disabled by default to make sure that you can take time to configure them properly before enabling. This setting is duplicated at the top of the screen.
  3. Name: provide a unique name for your Dataset. Preferably, the Dataset name should explain what kind of data it contains.
  4. Description: optionally, provide any additional information about your Dataset.
  5. Category: specify the Category where you Dataset will be placed.

Move to the Data tab to define the source of data and how often it should be updated.

3. Define the Settings for Data Collection

  1. Data Source: select the connection profile you have created for Google Sheets
  2. Data collection trigger: specify the Trigger that will be used to collect data for your Dataset
  3. Spreadsheet: select a Google Spreadsheet that should serve as a basis of your Dataset
  4. Input a Plugin Command listing all the data you would like to fetch from Google Sheets. Alternatively, use the Visual Editor.
  5. Once you are ready with you command, click Validate

3.1. Example using the Visual Editor

The Google Sheets Query Builder allows constructing commands without the need to learn the plugin syntax and avoiding typos/mistakes.

  1. Select the fields for your Dataset
  2. Optionally, add Derived fields and/or Count of duplicate rows

Save your settings. Plugin command validation will start automatically.

4. Plug-in command will be validated and Data Collected on Save

  1. If the command is validated successfully, the  Report columns and Data Preview are going to be shown below.
  2. At the upper right corner of the screen click Enable & publish.

5. Dataset will be displayed in Viewer

0 Comments

Add your comment

E-Mail me when someone replies to this comment