Publication status
Google Workspace Marketplace publication is pending. The Editor add-on was submitted on July 26, 2026 and rejected on July 27 pending trademark attribution and OAuth verification remediation. Do not claim public availability until Google approves and publishes the listing.
First formula
=OILPRICE_PRICE("WTI_USD")
=OILPRICE_INFO("WTI_USD")
=OILPRICE_STATUS("WTI_USD")
=OILPRICE_UNIT("WTI_USD")The price formula returns the numeric value from the latest available API record. Companion formulas expose its currency, unit, source, source timestamp, and freshness without changing the numeric contract.
Runtime behavior
| Surface | Behavior |
|---|---|
| Latest price | Five-minute user cache; strict price, currency, unit, and timestamp validation. |
| Excel parity | PRICE, GET, CODES, STATUS, UNIT, and INFO equivalents using Sheets-compatible underscore names. |
| Generic API table | Reviewed endpoint catalog, credential-query rejection, and shape-aware table rendering. |
| History | Versioned lookback endpoint; source timestamp and price rows; one-hour user cache. |
| Access errors | Actionable recovery for missing/invalid keys, locked datasets, quota limits, and timeouts. |
| Successful response drift | Empty or malformed records fail instead of producing defaults. |
Product facts
Dataset access, limits, catalog coverage, freshness, and data rights can change independently of this source release. Use the versioned contract and current documentation.