happines-rating

Workspace AddOn for Google which allows for easy collection of Supporter Feedback.

Setup

1. Create a Spreadsheet, take note its Id
2. Create a Sheet within that Spreadsheet, note its name
3. Create a Apps Script Project
4. Paste Code.js your Apps Script Project
   1. Set the TARGET_SHEET_ID (line 46) to your note from step 1
   2. Set the SHEET_NAME (line 48) to your note from step 2
5. Paste and Modify appsscript.json (the manifest file) into your appsscript.json
   1. Change the name
   2. Change the logoUrl
   3. Change the openLink to step 1
   4. Change colors if you like

In regard to 5: You may need to go to the gear icon (settings) in your Apps Script Project > Show "appsscript.json" manifest file in editor to see this file.

Publishing a Workspace AddOn

See this link for the official resource

1. Create a new Project on GCP, note its Id (Project Number)
2. Enter the Id into the Apps Script Project > Gear Icon (Settings) > GCP Project
3. In the GCP, go to Marketplaceand search for Google Workspace Marketplace SDK. Enable it. Manage it.
4. Click on App Configuratio
   1. Enable Google Workspace AddOn
   2. Enable Deploy using Apps Script deployment Id
   3. If you have a deployment, use its Id otherwise create a new deployment first in the Apps Script Project and enter it here
5. Scroll down to oAuthScopesand copy the values in there from the appsscript.json
6. Scroll down and add the Developer Links
7. Click on the Store Listings menu item (in the Google Workspace Marketplace SDK) and fill it out. This part sucks, but you only have to do it once.
8. Save and celebrate (I hope, otherwise troubleshoot until you go cray)