Public deployment: https://governance.pfasproject.com/ Test deployment: https://pfas-gov-tracker-test.onrender.com/

To install and run this web tool in a development environment:

• Install node.js
• Install Visual Studio Code
• Install and run GitHub Desktop
• Clone this project
• Open the project in Visual Studio Code
• Get keys.json from Google Drive and place it in this folder
• Open a terminal and type npm install to install dependencies
• In the terminal, type npm run dev to run the web server
• In the web browser, navigate to localhost:9001
• Use CTRL-C to quit

Deployment notes:

• Deploy at Render.com (login required). Be sure to add keys.json as a "secret file."
• @ProfJanetDavis owns the Google Apps Script service account. To create a new service account:
  • Find the spreadsheet and make sure you are logged into the correct Google account.
  • On Google Cloud console, create a new project and select that project.
  • Go to "Enable APIs and Services," search for the Google Sheets API, and enable it.
  • Create new credentials for accessing application data.
  • Open the spreadsheet and share it with the new service account, granting View access only.
  • Create a new key and update the keys.json file on Google Drive. Make sure to add the sheet_id to the end of the generated JSON content.

References:

• How to Deploy Your Node.js Application for Free with Render
• Node.js tutorial in Visual Studio Code
• Video: Google Sheets API - JavaScript NodeJS Tutorial
• Video: Passing Data Between Frontend and Backend | Node.js
• For editing this file: Markdown cheat sheet