/google-sheets-add-on-dependency-graph

Insert a dependency graph in Google Sheets (custom formula)

Primary LanguageJavaScript

Insert a dependency graph in Google Sheets (custom formula)

Codecov branch CircleCI branch

What is is?

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

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

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