# Google Sheet Deployment v0.7

Live spreadsheet:

```text
https://docs.google.com/spreadsheets/d/1nxyOVnQ6f2jxaNbygWJjaPtDZFAVCDMSyaCphRa1W8E
```

Spreadsheet ID:

```text
1nxyOVnQ6f2jxaNbygWJjaPtDZFAVCDMSyaCphRa1W8E
```

Bound Apps Script project:

```text
1iJhJvrL0lbr53wyEgZVy8w5URWIchrpq1xV5AEF8ECD21rA8TNTc5zyj
```

Deployment status:

- Native Google Sheet created from `output/v0.7/Google_Sheets/Epione_Google_Sheets_Import_v0.7.xlsx`.
- Verified the live workbook has 144 tabs.
- Verified `Product_Library` includes v0.7 verification columns.
- Verified `Product_Approval_Dashboard` imports and reports current candidate/default status.
- Pushed `Code.gs`, `Sidebar.html`, and `appsscript.json` to the bound Apps Script project with `clasp`.
- Updated the existing live spreadsheet in place after the recommended-next-procedure build, preserving the same spreadsheet URL and bound Apps Script project.
- Live spreadsheet now has 145 tabs, including `Physician_Review_Dashboard`.
- Verified `Knee_Steroid_US` includes `Recommended next procedure` rows for date, medication choice, dose, technique, patient position, premedication, and pre-/intra-/post-procedure comments.
- Verified `Genicular_RFA` uses the same `Recommended next procedure` section and carries the yearly nerve ablation/RFA repeat-interval default.
- Verified `Form_Templates` includes the `Recommended next procedure` narrative section.
- Updated the existing live spreadsheet in place after the fast-fill build.
- Verified `Knee_Steroid_US` includes `Quick text templates` and `History/exam context sources` columns; `clinical_indication` now has preset text plus mapped sources from history and physical exam fields.

Current limitation:

- The custom menu still needs a browser-side reload/smoke test in the live Google Sheets UI.
- Local Playwright screenshot smoke testing is blocked in this sandbox by Chromium `MachPortRendezvousServer` permission denial; generated JavaScript and workbook/live-sheet structure were verified instead.
- One mistaken exploratory `clasp create --type sheets` produced an extra empty spreadsheet/script pair before the correct bound script was created. The script delete attempt returned `Bad Request`; this does not affect the live v0.7 spreadsheet above.
