Personal Investor Lab: User Deployed Web App

Personal Investor Lab can run as a library, allowing users to create a simple Apps Script project that uses the library. Once the script is deployed as a web app, its URL can be entered in the Personal Investor Lab configuration.

With the user's authorization to access Spreadsheets and Drive, the user's web app can copy charts to alert reports, save the reports to the folder where the spreadsheet running the add-on is located and can be used to resume at timeout in addition to the trigger.

How to Set Up the User Script

1. In your spreadsheet, click Extensions > Apps Script.
2. In the left-hand menu, click Libraries +.
3. In the Script ID field, enter:
   1SW3WAwmf9-4WGn0VNGx_2RBMjsU9J3a_B6Edp9Gat8R0sH3pHLgW04Lr
4. Click Look up.
5. Click Add.
6. Replace the existing code with the following:

function doGet(e) {
  return SPCsoftGateway.doGet(e);
}

function doPost(e) {
  return SPCsoftGateway.doPost(e);
}

7. Click the blue Deploy button in the upper-right corner.
8. Click New deployment.
9. Click Select type > Web app > Execute as: Me (user) Who has access: Only myself
10. Click Deploy.
11. Under Web app URL, click the Copy icon, then paste the URL into the Personal Investor Lab configuration.