Complete staged Google Console drafts for five Sheets add-ons

[karlwaldman]

Bottom line up front, this has been verified.

Verification basis (2026-08-04): The requested capability remains incomplete, has explicit acceptance criteria, and no merged implementation or successor was found.

---

Outcome

After the original OilPriceAPI listing clears OAuth and Marketplace review, apply any reviewer feedback and prepare the five follow-on products for staged submission without submitting them in parallel.

Source of truth

• Readiness matrix: PORTFOLIO_SUBMISSION_READINESS.md in PR Prepare Marketplace playbook and five Sheets add-on candidates #23
• Reusable launch sequence: GOOGLE_MARKETPLACE_PLAYBOOK.md
• Per-product listing/reviewer/checklist packages: portfolio/dist/<product-id>/

Rollout order

1. Crack Spread Lab
2. Fuel Surcharge Studio
3. Energy Curve Builder
4. Bunker Voyage Planner
5. Gas Spread Monitor

Remaining account-bound work for each product

• Apply all policy/runtime feedback from the preceding approved listing
• Create the recorded separate standard Google Cloud project
• Enable Apps Script API and Google Workspace Marketplace SDK
• Link the recorded standalone Apps Script project to the standard Cloud project
• Configure exact-name External OAuth branding and only the three manifest scopes
• Configure a Public Editor add-on Marketplace draft using the recorded immutable version
• Install the Marketplace draft, select Use in this document, refresh, and run the product reviewer guide
• Inspect Apps Script executions and cover missing, revoked, unentitled, quota, timeout, and malformed-response recovery
• Capture a unique full-bleed 1280×800 screenshot from the exact immutable installed build
• Record the exact-name, exact-scope OAuth demonstration video
• Move OAuth to In production only when the product reaches its rollout slot
• Stop for approval before submitting OAuth or Marketplace review

Measurement gate

For each released product, record Marketplace listing views/installs, UTM-attributed signups, first API activation, and activated workbooks per 100 listing views before advancing the next listing.

Current state

All five code packages, live API smokes, listings, reviewer guides, unique graphics, and immutable Apps Script candidates are complete in PR #23. No follow-on Marketplace listing has been submitted.

[karlwaldman]

Closing as not planned. The five derivative add-ons are prebuilt candidates, but there is no evidence or commitment supporting five additional Google Cloud/Marketplace submissions. Keep the packages as reusable source material; reopen only after the core OilPriceAPI Sheets listing demonstrates conversion and one named follow-on earns a separate launch decision.