Workspace AddOn for Google which allows for easy collection of Supporter Feedback.
- Create a Spreadsheet, take note its Id
- Create a Sheet within that Spreadsheet, note its name
- Create a Apps Script Project
- Paste Code.js your Apps Script Project
- Set the
TARGET_SHEET_ID
(line 46) to your note from step 1 - Set the
SHEET_NAME
(line 48) to your note from step 2
- Set the
- Paste and Modify appsscript.json (the manifest file) into your appsscript.json
- Change the
name
- Change the
logoUrl
- Change the
openLink
to step 1 - Change colors if you like
- Change the
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.
See this link for the official resource
- Create a new Project on GCP, note its
Id
(Project Number) - Enter the
Id
into the Apps Script Project > Gear Icon (Settings) > GCP Project - In the GCP, go to
Marketplace
and search forGoogle Workspace Marketplace SDK
. Enable it. Manage it. - Click on
App Configuratio
- Enable
Google Workspace AddOn
- Enable
Deploy using Apps Script deployment Id
- If you have a deployment, use its
Id
otherwise create a new deployment first in the Apps Script Project and enter it here
- Enable
- Scroll down to
oAuthScopes
and copy the values in there from theappsscript.json
- Scroll down and add the Developer Links
- 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. - Save and celebrate (I hope, otherwise troubleshoot until you go cray)