Insert a dependency graph in Google Sheets (custom formula)

What is is?

Dependency graph is a Google Apps add-ons for Google Sheet that display beautiful dependency image graphs generated with Image-Charts.

• 🤩 Demo
• 📹 Screencast

Usage

• Open your spreadsheet
• Menu Add-ons > Get add-ons > Find this add-on
• use it (screencast) =image(DEPENDENCY_GRAPH_URL(B2:B23; F2:F23; "ortho"); 2)

The story

We've built a roadmap on google spreadsheet but now we can't find a way to visualize the whole dependency graph 😥

Hold my beer.

Add-on development

Setup

• Enable Apps Script API: https://script.google.com/home/usersettings
• npm install
• npm run first-run to setup clasp

Deploy on Google App Scripts

npm run deploy

• Title: Dependency graph visualization

• Short description: Sheet add-on that display beautiful dependency image graphs to visualize project roadmap or anything else that has dependencies.

• Add-on Type: Sheets

• Help url: https://www.youtube.com/watch?v=2T6oHo7FVdI

• Report issue url: https://stackoverflow.com/questions/tagged/image-charts

• Post-install tip: Create a two column table, 1st column for items, 2nd column for what the item depends on. Then use the formula =IMAGE( DEPENDENCY_GRAPH_URL(A2:A7, B2:B7) ) to display the dependency chart in a cell.

• Detailed description: A Google Sheet add-on that display beautiful dependency image graphs. Perfect for project roadmap, visualizing multiple dependencies, mind-map, etc...

Validate auth

Follow the official tutorial.

Resources

• https://developers.google.com/gsuite/add-ons/overview
• https://developers.google.com/gsuite/add-ons/how-tos/publish-addons
• https://github.com/gsuitedevs/apps-script-samples
• https://stackoverflow.com/a/37056733/745121
• https://github.com/oshliaer/google-apps-script-awesome-list
• https://github.com/fossamagna/gasify