317 字
2 分鐘
瀏覽次數
Stuck Publishing Google App Script? A Complete Guide to the Process and OAuth Setup
2025-07-25
2026-04-14

Introduction#

If you’ve written a Google App Script and want to turn it into an Add-on for the Google Workspace Marketplace, the biggest hurdles aren’t the code itself, but rather OAuth, deployment IDs, and the review process.

These settings are scattered and complex, and a single oversight can lead to rejection.

This post compiles the complete Google App Script publishing process and OAuth setup, guiding you through it all so you won’t get stuck again.

🎯 Objectives#

This post will guide you through:

  • Creating an App Script project
  • Configuring the OAuth consent screen
  • Testing the Add-on
  • Publishing to the Google Workspace Marketplace

Core Process (Step-by-Step Breakdown)#

Step One: Create and Deploy App Script#

  1. Create App Script image

  2. Open appscript.json & Specify GCP Project Number image

  3. Deploy → New deployment image

  4. Deploy → Test deployments (Development testing) image

Step Two: Configure OAuth Permissions#

Required fields:

  • App Name: Must match the Add-On package
  • App domain: Requires a promotional website containing privacy policy and terms of service (can use your own domain / host on github.io)
  • Authorized domains: The domain used by the App domain image

Underlying Principle

  • Google verifies application trustworthiness via the OAuth screen
  • This is where the review focuses

Step Three: Marketplace Publishing Settings#

  1. Enable the “Google Workspace Marketplace SDK” service image

  2. Both tabs require filling in: App Script’s Deployment ID, developer information, and product information image

  3. Store Listing → Browse MARKETPLACE: Pre-publishing test. Fill in the “Draft testers” email on this page. image

  4. To test, you also need to configure OAuth testing: OAuth consent screen → Users → Test users + Add image

  5. After testing, return to “Store Listing”: Submit for review image

  6. Switch OAuth to Production image

  7. Finally, just await Google’s review results.

⚠️ Common Issues / Pitfalls#

OAuth Rejection#

  • No privacy policy
  • Inconsistent domain

Unable to Test Add-on#

  • Test users not added

Publishing Failure#

  • Incorrect Deployment ID
  • OAuth not yet in Production
  • Text using Google products requires ™ (e.g. Google Sheets™, Google Workspace™)

Summary#

This post guided you through:

  • App Script creation and deployment
  • OAuth configuration
  • Marketplace publishing process Key takeaways:
  1. OAuth configuration is the most critical step
  2. The testing process cannot be skipped
  3. Marketplace information must be complete
Stuck Publishing Google App Script? A Complete Guide to the Process and OAuth Setup
https://joyceowo.github.io/posts/en/23ba78ea09fa8197a481f7c38016388e/
作者
JoyceOwO
發佈於
2025-07-25
許可協議
CC BY-NC-SA 4.0