Create Dataset from Google Sheets | Working with Google Services (2024)

Enter the basics:

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.

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 an MIQL 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

Note!

1. Entire field names that contain special characters, aggregation and commas must be enclosed in quotes (single or double).
2. It is acceptable to enclose all fields and values in quotes.

[…] + Notationis used to signify that the MIQL parts of a statement are optional/can be repeated.

1. If the command is validated successfully, the Report columnsandData Previeware going to be shown below.
2. At the upper right corner of the screen clickEnable & publish.

Create a Dataset Report