Google spreadsheet

Overview

Creates a Table for demo purposes based on the demo publicly shared google spreadsheet at https://docs.google.com/spreadsheets/d/1Fl8TqeZigVHGuAFxXTgGgra_DSUq0nXTMbWQOZCRNdA/edit?usp=sharing.

As you can see in the descriptor, it requests the Google Spreadsheets api and processes cells to form an array based on the headers.

Features

• Load from a simple shared Google spreadsheet datasource unneeded.

• Render a table.

• Customize a cell to render a total calculation based on existing cell data

Setup

Add the Custom Reports gadget

1. Navigate to your Dashboard Hub app.

2. If you have not created a dashboard,

   1. Click the dashboard dropdown in the left corner or in the action menu in the right corner, and select Create dashboard.

   2. Name your dashboard, and click Create.

   3. Click Add Gadget.

3. If you already have a dashboard created, click Edit.

4. Click Add Gadget.

5. Navigate to the Custom Reports section in the left side navigation panel.

6. Locate the Google Spreadsheet gadget, click Add, and click Open Editor.

Configure

• No datasource or variables are needed.