Web application built with Node.js that displays a sankey diagram from Google Sheets data. For each sheet in a spreadsheet, there is a separate diagram accessible through a dropdown.

• Fill (potentially multiple) google sheets with data in the following format (leave first row for column names):

  • Column A: Source

  • Column B: Target

  • Column C: Value

    

• Create a sheet called allowed_google_users with emails of users who should have access to the application.

  

1. Install dependencies using npm install
2. Register the app with google (follow this tutorial for example). You will also obtain values for GOOGLE_CLIENT_ID and GOOGLE_CLIENT_SECRET env variables
3. Enable google sheets API and obtain GOOGLE_SHEETS_API_KEY key tutorial
4. Set the following environment variables:
   • PORT=80
   • GOOGLE_CLIENT_ID=your_google_client_id
   • GOOGLE_CLIENT_SECRET=your_google_client_secret
   • GOOGLE_SHEETS_API_KEY=your_google_sheets_api_key
   • EXPRESS_SESSION_SECRET=your_session_secret (anything)
   • SPREADSHEET_ID=your_spreadsheet_id (get it by visiting the spreadsheet and copying it from URL: https://docs.google.com/spreadsheets/d/<SPREADSHEET_ID>)
5. Run the application using npm start

Follow the gcloud documentation, don't forget to set env variables.

• Access the application at localhost
• Authenticate using your Google account
• Upon successful authentication, you will be able to view the sankey diagram from the Google Sheets data