Zingtree Tags: google sheets decision tree

The Most Simple Ways to Build an Interactive Decision Tree

Zingtree’s decision tree platform makes it easy to offer your end-users an interactive way to find answers, optimize workflows, and a whole lot more. Below, we’ll walk you through how to make a basic decision tree using our most popular methods of creation in order to help you get a closer, step-by-step look at how it’s all done.

How to Use the Wizard

The Wizard is our most-used creation tool, offering simple prompts to build your tree, question by question (and answer by answer). It’s one of the easiest ways to work through an accurate flow for your customers or users.

1. Log in to your Zingtree account, go to My Trees and select Create New Tree. Choose the option to fill out forms with the Zingtree Wizard.

2. After naming your decision tree, choosing your ideal display style and providing a description, just click the Create Tree button to move on to the next step.

3. Once you start the Wizard, you’ll see an entry screen that will prompt your first question and answer options, along with some body content to give users context.

You’ll also be able to see a live preview of what the decision tree will look like, off to the right:

When you’re finished setting up your first question, click Save and Continue.

4. You’ll next be asked to fill out an unfinished part of your decision tree. Click to Offer a Solution, and fill out the form presented to you. Since this is a solution node, you won’t need to ask any other questions.

Click Save and Continue again when you’re finished.

5. Next, you’ll continue to fill out more questions and answers to reach the end paths of your decision tree. For a greater selection, try providing more answer choices.

6, Next, you’ll see a page with an overview of the sequence you’re building. In this case, choose to Offer a Solution. This will be the end of one of the paths in your decision tree for your end-user.

7. Continue to complete the rest of the forms that the Wizard prompts. When you’re all done with the interactive building process, the Overview page will appear to show you every node and path in an easy-to-digest way.

Watch our tutorial video for more information about the Zingtree Wizard. 

How to Use the Designer

The Designer tool is another great way to create decision trees in a more visual way. Presented in a whiteboard-style screen, you can easily build out every node, connection, and pathway while being able to see a high-level overview the whole time.

1. Log in to your Zingtree account, go to My Trees and select Create New Tree. Choose the option to visually draw out your decision tree with the Zingtree Designer.

2. Once you start Designer, you’ll see the white board-style screen like the one shown below. Click on the green box for Node #1. This will be your starting node – the very first page your end-users will see.

2. Next, you’ll see an edit window appear on the right-hand side. Change the Title, Question and Content areas to fit your tree needs.

Next, add another question by dragging a New Question node into the drawing area. Click the green box for the new question node, and edit it like the first time.

3. Drag a Final Answer node answer node into the drawing area, and edit it.

After adding your first questions and a Final Answer node, the Designer area will show everything like this:

You can drag as many question and Final Answer nodes into the Designer drawing area as it makes sense for your needs, and label them respectively.

5. After adding the question and answer nodes to your decision tree, it’s time to link them together. Hover over node #1 until you see a large dot appear, then drag it over to its connecting node.

After finishing linking all of your nodes correctly, it’ll look something like this:

6. The next step is to create the buttons your end-users will click, by editing the connecting arrows. Click the connector – in our example, titled “Check the Weather” – and an edit form will appear. Change it to look like the form below:

After you connect the rest of the choices in your tree, and relabel the connecting arrows, your decision tree will look something like this one:

Watch our tutorial video for more information about the Zingtree Designer. 

No matter the route you take to get there, you’ll end up with the same stunning, super-powerful decision tree. Click through our demo trees within the Gallery to check out even more.

How to Import from Spreadsheets

You can also use Google Sheets or Excel to begin building your decision tree in a spreadsheet format, then importing it into your Zingtree account to customize, clean up, and publish. You’ll need to first learn more about the specific rules in place for starting the formation of your decision tree in a spreadsheet. 

Here’s how our example tree used in the tutorials appears in Google Sheets:

Here’s how our example tree used in the tutorials appears in Excel:

Once your decision tree content is looking and feeling well fleshed-out, you can easily import the file from Google Sheets or Excel into Zingtree to refine further before making it live. Here’s how it’s done:

  1. In your spreadsheet, select the entire range of cells for your tree, and copy to the clipboard (Ctrl+C or Cmd+C).
  2. In Zingtree, go to the Import via Copy and Paste tool

  3. Choose Microsoft Excel or Google Sheets as the source, depending on what you used to set up.
  4. Enter a name for your decision tree.
  5. Paste the data copied from step 1 into the data area. (Use Ctrl+V or Cmd+V).
  6. Click Import and Create Tree.

Have any questions about getting started with Zingtree decision trees? We’d love to speak with you anytime!

This article was originally published on September 14, 2016, and has been updated to include new creation methods. 

Updates: Spreadsheet Import Enhancements and More

updates-blog

When we launched our new feature that allows you to create decision trees from Excel and Google Sheets, we had no idea this feature would be as popular as it has become. Some of our bigger clients, in particular, have really run with this and suggested a lot of great improvements.

Here’s what’s new with spreadsheet decision tree imports:

  • Fix: Validates Tree IDs on spreadsheet import for tree nodes.
  • Fix: Importing and replacing a tree keeps the tree’s settings intact (Elliott).
  • Update: Spreadsheet import allows columns in any order (Elliott).
  • Update: Spreadsheet import allows for a Tags column (Jamel).
  • Fix: Errors in spreadsheet import won’t delete a previous tree if we’re replacing a tree.
  • Fix: Importing Excel with line breaks in cells now works properly, retains line breaks (Charlie).
  • Fix: Importing pasted spreadsheet data now saves the first iteration in Snapshots tool.
  • Update: Spreadsheet import can now include TREE and LINK nodes (Elliott).
  • Update: Exporting CSV tree from Overview/Simple now adds TREE and LINK node types into CSV data.
  • Fix: Importing trees with button links to non-existent nodes now sets the link to “unlinked” (Elliott).

We’ve also done some other tweaks outside of spreadsheet imports:

  • Update: Use “send_zendesk_button” as a node tag to send the button text to Zendesk as a tag instead. (Elliott)
  • Fix: Agent Portal now shows merge variables for agent_name (Craig).
  • Update: Added Agent List export to the My Agents page (Gene).
  • Update: Added more error checks to Add Multiple Agents input tool.
  • Update: Made show/hide tree name option more visible in iFrame Advanced Options.
  • Fix: Copying a Gallery tree into a new account works properly.
  • Update: Max attachment size in email nodes increased to 25 Mb (Dan B.).
  • Update: Merge variables now has an option to retain plus characters (Chris).
  • New: API call to delete session data from our servers for a particular session ID (Jay).
  • Fix: email-session-info occasionally failed when data was entered right before sending (Alok, Craig).

Phew!

Got a suggestion to make Zingtree better? Give us a holler.

Update: Import from Excel, Google Sheets

NL-header-updates3

In spite of the fact that Zingtree has some really great ways to build interactive decision trees, we still get a lot of requests for making the process of creating trees even easier.  Many people are particularly comfortable working inside their favorite spreadsheet program, so we’ve created an easy way to use Microsoft Excel or Google Sheets to create new decision trees.

Once imported, the Zingtree editing and management tools can be used to refine and enhance your trees.

Here’s how our tutorial example appears in Google Sheets:

Details on this new feature:

Note that the same process for importing from Excel or Sheets can be used to import any tab delimited CSV file from any other program.

Other Updates

  • Update: Added ##ALL DATA## as a template for showing a summary of all data entry fields collected (h/t Sebastian, Logan). Details here.
  • Update: Added custom date range shortcut option to All Agents report. (h/t Allen J.).
  • Fix: Changing organization in All Agents report works properly now.
  • Fix: Restart function in older Zendesk Agent Scripting app installations now works properly again (Jamel).
  • Fix: Editing nodes from subtrees while using Preview now works properly (Jamel).
  • Update: Preview no longer automatically scrolls to the top of content.
  • Fix: Scoring uses numeric value of variables, not string value (Matt B.).
  • Update: All Agent report link added to My Agents page(Allen J.).
  • Update: Agent report now has quick date links.

Can we make your tree creating experience even easier? Just let us know!