Skip to main content

dependency graph

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​