部署Google Sheets私用扩展后无法在表格内搜索到的技术问题

Hey Lee, let's break down why your private Google Sheets add-on isn't showing up in searches and why that "ADD TO CHROME" button is grayed out—these are super common hiccups when deploying personal-only add-ons, so let's fix this step by step:

This almost always boils down to your Chrome Web Store publishing settings. Since you're making a private add-on for personal use, public publishing rules don't apply here:

• Head back to the Chrome Web Store Developer Console and open your add-on project.
• Go to the Package tab, and double-check the Publish type is set to Private (not Public). If you accidentally chose Public, the button stays gray until your add-on passes Google's review (which you don't need for private use).
• For private publishing, make sure you've added your own Google account to the list of allowed users (under "Private publishing" settings). Save these changes, then re-publish the add-on—give it 10-15 minutes for the changes to propagate.

Private add-ons don't show up in public search results—this is intentional! But there are a few other checks to make sure Sheets recognizes it once installed:

• Verify your manifest.json has the correct Sheets configuration. You need to explicitly declare the add-on works with Sheets, like this:

  "addOns": {
    "sheets": {
      "homepageTrigger": {
        "runFunction": "onHomepageOpen",
        "enabled": true
      }
    }
  }
  

• Also confirm your oauthScopes include the necessary permissions for Sheets, such as https://www.googleapis.com/auth/spreadsheets. Missing scopes can prevent the add-on from linking properly to Sheets.
• Double-check that when you deployed the add-on via the "Deploy as Sheets Web Add-on" wizard, you correctly linked it to your Chrome Web Store project ID. A mismatched ID will break the connection.

Since private add-ons don't show up in searches, you'll need to install it directly:

• In the Chrome Web Store Developer Console, open your project and click the Share button. Copy the unique installation link provided (only accounts you've authorized can access this).
• Paste the link into Chrome—you'll now see the "ADD TO CHROME" button is active (no longer gray). Install it from here.
• Open Google Sheets, refresh the page (use Ctrl+Shift+R to clear cache), and your add-on should appear in the Add-ons menu.

• Make sure you're logged into Chrome and Google Sheets with the same Google account you used to develop and publish the add-on.
• Clear Chrome's cache and cookies if the add-on still doesn't show up—sometimes old cached data blocks it.
• If you're using a Google Workspace account, double-check that your admin hasn't restricted private add-on installations (though this is rare for personal accounts).

内容的提问来源于stack exchange，提问作者Lee