acurtis517 · October 13, 2025 14:40 · Jun 9, 2020 · Jun 9, 2020 · Jun 9, 2020 · Jun 9, 2020
diff --git a/README.MD b/README.MD
@@ -11,7 +11,7 @@
 - create the two files `code.gs` and `index.html`
 - insert the document ID from the URL on line 10, `code.gs`
 - select which sheet is the base for the sankey diagram
-- the layout of the table should be
+- the layout of the table should be as shown in the [Example Spreadsheet](https://docs.google.com/spreadsheets/d/1IUmvhYuuBvfYEu8OfDczmW6LQW-xaeh5c6rklOg3x-o/)
 
 ## Usage
 - Open the same document

diff --git a/README.MD b/README.MD
@@ -18,4 +18,4 @@
 - Click "Zusatzfunktionen" -> "SankeyDiagram"
 
 ## Example Spreadsheet
-https://docs.google.com/spreadsheets/d/1IUmvhYuuBvfYEu8OfDczmW6LQW-xaeh5c6rklOg3x-o/edit?usp=sharing
+https://docs.google.com/spreadsheets/d/1IUmvhYuuBvfYEu8OfDczmW6LQW-xaeh5c6rklOg3x-o/
diff --git a/README.MD b/README.MD
@@ -17,4 +17,5 @@
 - Open the same document
 - Click "Zusatzfunktionen" -> "SankeyDiagram"
 
-  source | destination | value
+## Example Spreadsheet
+https://docs.google.com/spreadsheets/d/1IUmvhYuuBvfYEu8OfDczmW6LQW-xaeh5c6rklOg3x-o/edit?usp=sharing
diff --git a/README.MD b/README.MD
@@ -12,4 +12,9 @@
 - insert the document ID from the URL on line 10, `code.gs`
 - select which sheet is the base for the sankey diagram
 - the layout of the table should be
+
+## Usage
+- Open the same document
+- Click "Zusatzfunktionen" -> "SankeyDiagram"
+
   source | destination | value
diff --git a/README.MD b/README.MD
@@ -0,0 +1,15 @@
+<!-- [![njoerd114](https://avatars1.githubusercontent.com/u/3825200?v=3&s=200)](http://niklasbeinghaus.com) -->
+
+# Sankey Diagrams within Google Spreadsheets  
+
+> This Gist is there to help you creating a Sankey Diagram from your Google Spreadsheets.
+
+## Installation
+
+- Open a spreadsheet
+- Click "Tools" -> "Scripts"
+- create the two files `code.gs` and `index.html`
+- insert the document ID from the URL on line 10, `code.gs`
+- select which sheet is the base for the sankey diagram
+- the layout of the table should be
+  source | destination | value
diff --git a/code.gs b/code.gs
@@ -0,0 +1,23 @@
+function onOpen() {
+    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
+        .createMenu('Zusatzfunktionen')
+        .addItem('SankeyDiagram', 'openDialog')
+        .addToUi();
+}
+
+function getSpreadsheetData() {
+    // ID of your Document, take from URL
+    var ssID = "",
+        // which Sheet? [0] is the first and so on...
+        sheet = SpreadsheetApp.openById(ssID).getSheets()[0],
+        data = sheet.getDataRange().getValues();
+    return data;
+}
+
+function openDialog() {
+    var html = HtmlService.createHtmlOutputFromFile('index')
+        .setHeight(300)
+        .setWidth(1000);
+    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
+        .showModalDialog(html, 'Sankey Diagram');
+}
diff --git a/index.html b/index.html
@@ -0,0 +1,28 @@
+
+
+<!DOCTYPE html>
+<html>
+   <head>
+      <base target="_top">
+      <script src="https://www.google.com/jsapi"></script>
+   </head>
+   <body>
+      <div id="main"></div>
+      <script type="text/javascript">
+         google.load('visualization', '1', {
+           packages: ['corechart', 'sankey']
+         });      google.setOnLoadCallback(initialize);
+
+           function initialize() {
+            google.script.run.withSuccessHandler(drawChart).getSpreadsheetData();
+           }
+
+           function drawChart(rows) {
+             console.log(rows);
+             var data = google.visualization.arrayToDataTable(rows);
+             var chart = new google.visualization.Sankey(document.getElementById('main'));
+             chart.draw(data, {width: 900, sankey: {iterations: 64}});
+           }
+      </script>
+   </body>
+</html>