Prepare for Public Marketplace Release

[Jython1415]

Overview

Checklist of tasks needed before submitting to Google Workspace Marketplace for public distribution.

Prerequisites

• Privacy policy finalized (see Research: Privacy Policy Requirements for Google Workspace Add-on #1)
• Icons created (see Design: Create Marketplace Icons #2)
• Tested by multiple users in private deployment
• No critical bugs or issues
• Documentation complete

Google Cloud Project Setup

• Create dedicated Google Cloud Project (separate from default Apps Script project)
• Enable Google Workspace Marketplace SDK
• Configure OAuth consent screen
  • Add app name, logo, support email
  • Add privacy policy URL
  • Add terms of service URL (if required)
  • Verify OAuth scopes

Marketplace Listing

• Write compelling description
• Create screenshots (1280x800px recommended)
  • Show menu in Extensions
  • Show export dialog
  • Show JSON output example
• Add support/contact information
• Define category tags
• Set pricing (free)

Code Quality

• Code review and cleanup
• Add error handling for edge cases
• Test with various data types (formulas, merged cells, empty cells, etc.)
• Performance testing with large ranges
• Ensure all OAuth scopes are minimal and justified

Documentation for Users

• Update README with marketplace install link
• Create user guide (if needed)
• Document known limitations
• FAQ section

Submission Process

• Submit for Google review
• Respond to any feedback/requests from Google
• Address any compliance issues
• Final approval and publication

Post-Release

• Update repository visibility to public
• Monitor for user feedback/issues
• Set up support process (GitHub issues)
• Consider analytics/usage tracking (optional)

Timeline

• Defer until after private testing phase complete
• Estimated: 2-4 weeks after private beta successful

Related Issues

• Research: Privacy Policy Requirements for Google Workspace Add-on #1 Privacy Policy Research
• Design: Create Marketplace Icons #2 Marketplace Icons

[Jython1415]

Went ahead and submitted for release early. We will see how it goes. At worst, we learn what we need to do/modfiy to get it ready for public release.