Integrate with Google Sheets

Overview

This article explains how Google Sheets acts as a powerful calculation engine for creating value models, specifically focusing on "Visualizer Types." It presents Google Sheets as an alternative to tools like Blockly and Excel import, offering a more flexible and efficient platform for model development. With its user-friendly interface and real-time collaboration features, Google Sheets speeds up the process of building and deploying value models. The Discovery Wizard, powered by Google Sheets, simplifies model development by guiding users through the creation process, allowing them to build complex models quickly and efficiently. This makes it easier for developers to visualize, test, and deploy value models, saving time and effort while maintaining accuracy and flexibility.

Step-by-Step Guide

1. Follow the steps to Convert the Excel Model into Google Sheets.

   
   
2. Follow the steps to Access the Visualizer Types Page.

3. Click Create New Visualizer Type. The Create Visualizer Type pop-up box appears.

4. Enter a name for the Visualizer Type in the Name field.

   
   

5. Click to select Yes from the Google Sheets drop-down list.

   
   
6. Click Create.

7. Paste the copied link in the Google Sheets Link field.

   
   
8. Click Create.

9. You can see the Visualizer Type created. Click Google Sheets.

10. The Google spreadsheet that you have uploaded appears with the name of the Visualizer Type as the file name.

11. You can directly make edits on the Google spreadsheet. However, additional variables could not be added in between the rows but at the end only.