Integrate with Google Sheets
Overview
Google Sheets, a calculation engine for a value model (Visualizer Types), is an alternative to Blockly and Excel import. Discovery Wizard, powered by Google Sheets, helps model developers build and deploy their value models much faster.
Step-by-Step Guide
Follow the steps to Convert the Excel Model into Google Sheets.
- Follow the steps to Access the Visualizer Types Page.
- Click Create New Visualizer Type. The Create Visualizer Type pop-up box appears.
Enter a name for the Visualizer Type in the Name field.
Click to select Yes from the Google Sheets drop-down list.
- Click Create.
Paste the copied link in the Google Sheets Link field.
- Click Create.
- You can see the Visualizer Type created. Click Google Sheets.
- The Google spreadsheet that you have uploaded appears with the name of the Visualizer Type as the file name.
- 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.