"Deploy > Test deployments" is not working for me.

7 views
Skip to first unread message

George Hill

unread,
3:46 AM (4 hours ago) 3:46 AM
to Google Apps Script Community

To the Group:

I'm writing a Google Sheets add-on.

I think that I've configured it correctly and have correctly linked it to a Google Cloud Platform project.

When I go to "Deploy > Test deployments", I can click "Install" for "Application(s): Sheets".

However, when I go to a Google Sheet, reload the page, and look under "Extensions > Add-ons > Manage add-ons", it says: "You have no Google Workspace Marketplace apps installed."

Is this feature broken, or am I doing something wrong?

Here's my `appsscript.json` file:

```
{
  "timeZone": "America/New_York",
  "dependencies": {
    "enabledAdvancedServices": [
      {
        "userSymbol": "Sheets",
        "version": "v4",
        "serviceId": "sheets"
      }
    ]
  },
  "exceptionLogging": "STACKDRIVER",
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.external_request",
    "https://www.googleapis.com/auth/script.container.ui",
    "https://www.googleapis.com/auth/script.scriptapp",
    "https://www.googleapis.com/auth/drive",
    "https://www.googleapis.com/auth/gmail.send",
    "openid"
  ],
  "runtimeVersion": "V8",
  "addOns": {
    "common": {
      "name": "Name Goes Here",
      "logoUrl": "https://www.gstatic.com/script/apps_script_1x_24dp.png",
      "layoutProperties": {
        "primaryColor": "#4285F4",
        "secondaryColor": "#34A853"
      },
      "useLocaleFromApp": true,
      "universalActions": [
        {
          "label": "Do Something",
          "runFunction": "doSomething"
        },
        {
          "label": "Do Something Else",
          "runFunction": "doSomethingElse"
        }
      ]
    },
    "sheets": {
      "homepageTrigger": {
        "runFunction": "onOpen"
      }
    }
  },
  "urlFetchWhitelist": [
    "https://api.stripe.com/",
    "https://script.google.com/"
  ]
}
```

I would be grateful for any guidance.

Thank you.

Yours,

George Hill
Boston, Mass.

Reply all
Reply to author
Forward
0 new messages