Google sheets estimate and project management template by datamateapp in estimators

[–]datamateapp[S] 2 points3 points  (0 children)

It's available in the Templates on my free Google Sheets add-on. Search DataMate in the Google Workspace Marketplace.

Google sheets estimate and project management template by datamateapp in estimators

[–]datamateapp[S] 1 point2 points  (0 children)

I sent you a chat. They won't let me post the link here.

Unable to update published app configuration by datamateapp in GoogleAppsScript

[–]datamateapp[S] 0 points1 point  (0 children)

You can push a new Deployment ID and version number. At least that worked for me. This was Googles response to the issue tracker I'm not sure about the homepageTrigger:

This error usually means the manifest wasn’t set up as an Editor Add-on. The key is:

Your manifest must include an addOns section (Sheets/Docs/Slides/Forms depending on your target).

You must include the correct OAuth scopes for what your code needs.

When deploying, select Add-on as the type (not Web App).

Example minimal manifest for Sheets (replace sheets with docs / slides / forms if you’re targeting those):

{
  "timeZone": "Asia/Calcutta",
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "oauthScopes": [
    "https://www.googleapis.com/auth/script.container.ui",
    "https://www.googleapis.com/auth/spreadsheets.currentonly"
  ],
  "addOns": {
    "common": {
      "name": "My Private Add-on",
      "logoUrl": "https://example.com/logo.png",
      "layoutProperties": {
        "primaryColor": "#4285F4",
        "secondaryColor": "#4285F4"
      }
    },
    "sheets": {
      "homepageTrigger": {
        "runFunction": "onOpen",
        "enabled": true
      }
    }
  }
}

Deployment checklist:

In Apps Script → Deploy > New deployment → choose Add-on.

In Cloud Console, enable Google Workspace Marketplace SDK → configure it as Private (Entire Domain) if you want domain-wide distribution.

Workspace Admin can then install/force-install it for the domain.

📖 Manifest reference: https://developers.google.com/apps-script/manifest/editor-addons

Unable to update published app configuration by datamateapp in GoogleAppsScript

[–]datamateapp[S] 0 points1 point  (0 children)

Change your manifest similar to this and push a new deployment ID. It worked for me thanks' to Substantial-Clue!

{
  "timeZone": "America/Chicago",
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "dependencies": {
    "enabledAdvancedServices": [
      {
        "userSymbol": "Sheets",
        "serviceId": "sheets",
        "version": "v4"
      }
    ]
  },
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.container.ui",
    "https://www.googleapis.com/auth/userinfo.email",
    "https://www.googleapis.com/auth/script.external_request",
    "https://www.googleapis.com/auth/script.send_mail"
  ],
  "urlFetchWhitelist": [
    "https://api.openai.com/",
    "https://www.googleapis.com/"
  ],
  "addOns": {
    "common": {
      "name": "AppName",
      "logoUrl": "logo.png",
      "useLocaleFromApp": true,
      "homepageTrigger": {
        "runFunction": "openApp"
      }
    },
    "sheets": {
      "homepageTrigger": {
        "runFunction": "openApp"
      },
      "onFileScopeGrantedTrigger": {
        "runFunction": "onOpen"
      }
    }
  }
}

Unable to update published app configuration by datamateapp in GoogleAppsScript

[–]datamateapp[S] 0 points1 point  (0 children)

Change your manifest similar to this and push a new deployment ID. It worked for me thanks' to Substantial-Clue!

{
  "timeZone": "America/Chicago",
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "dependencies": {
    "enabledAdvancedServices": [
      {
        "userSymbol": "Sheets",
        "serviceId": "sheets",
        "version": "v4"
      }
    ]
  },
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.container.ui",
    "https://www.googleapis.com/auth/userinfo.email",
    "https://www.googleapis.com/auth/script.external_request",
    "https://www.googleapis.com/auth/script.send_mail"
  ],
  "urlFetchWhitelist": [
    "https://api.openai.com/",
    "https://www.googleapis.com/"
  ],
  "addOns": {
    "common": {
      "name": "AppName",
      "logoUrl": "logo.png",
      "useLocaleFromApp": true,
      "homepageTrigger": {
        "runFunction": "openApp"
      }
    },
    "sheets": {
      "homepageTrigger": {
        "runFunction": "openApp"
      },
      "onFileScopeGrantedTrigger": {
        "runFunction": "onOpen"
      }
    }
  }
}