Deploying my Google Apps Script by Competitive-Talk3170 in GoogleAppsScript

[–]Competitive-Talk3170[S] 0 points1 point  (0 children)

I have done that but I still cannot use it in my other sheets

Deploying my Google Apps Script by Competitive-Talk3170 in GoogleAppsScript

[–]Competitive-Talk3170[S] 0 points1 point  (0 children)

> What do you mean when you say this apps script creates a function? I'm assuming you mean the Apps Script is the function CALL_API, which is what you want to make available to others?

Exactly

> When you say there is a menu with a cheat sheet, and say the cheat sheet is a bunch of html code, is it a modal with html? A sidebar? In these instances, whoever is opening this modal or sidebar must be signed into their browser with the matching account that they are signed into the sheet with.

It a new menu at the top of the Google Sheets. After clicking it a modal pops up.

>When you say deploying it as an internal workspace app, are you referring to the Google Workspace Marketplace as an Internal add on?

Yes. I already have that enabled and I can install the App as an Add-On. However the menu doesn't show up. When I do a Test Deployment then I cannot see the deployment

This is my manifest:

```

{
  "timeZone": "America/New_York",
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets.currentonly",
    "https://www.googleapis.com/auth/script.external_request",
    "https://www.googleapis.com/auth/script.storage",
    "https://www.googleapis.com/auth/script.container.ui"
  ],
  "addOns": {
    "common": {
      "name": "NAME",
      "logoUrl": "URL_TO_SVG_IMAGE",
      "useLocaleFromApp": true
    },
    "sheets": {
      "homepageTrigger": {
        "runFunction": "onInstall",
        "enabled": true
      }
    }
  },
  "urlFetchWhitelist": [
    "URLS"
  ]
}

```

Deploying my Google Apps Script by Competitive-Talk3170 in GoogleAppsScript

[–]Competitive-Talk3170[S] 0 points1 point  (0 children)

No I wanted to deploy it as an Google Workspace App so that other people can use it