Google verification in progress · Not yet publicly installable

OilPriceAPI for Google Sheets™

Add source-aware oil, gas, refined-product, futures, marine-fuel, and drilling data to the spreadsheet where you work—without copying an API key into a cell or URL.

Create an OilPriceAPI keyRead API documentation

What the add-on does

Requested data, with its source context

Return price, currency, unit, source timestamp, and freshness fields without fabricating missing values.
Build current-spreadsheet tables for reviewed OilPriceAPI datasets and selected market identifiers.
Store the OilPriceAPI key in Apps Script document properties for the current spreadsheet, never in a cell.
Show actionable recovery for missing or revoked keys, unavailable datasets, rate limits, timeouts, and malformed responses.

OAuth permissions

Three narrow permissions, each tied to a visible feature

spreadsheets.currentonly

Current spreadsheet only

Read user-selected inputs needed for an invoked feature and write formulas, requested market-data tables, and conversion outputs only in the spreadsheet where the add-on is open.

script.external_request

OilPriceAPI requests

Send HTTPS GET requests to api.oilpriceapi.com for market data the user explicitly requests. Requests use the user's OilPriceAPI key and reviewed identifiers or filters.

script.container.ui

Sidebar and dialogs

Display the add-on menu, API-key sidebar, price-selection dialog, help messages, and recovery actions inside the current spreadsheet.

Google may display default email and profile identity scopes in the Cloud configuration. OilPriceAPI for Google Sheets™ does not use those identity scopes for product behavior and does not read or store a user's Google email or profile.

Formula quickstart

Stable, source-aware worksheet functions

=OILPRICE_PRICE("WTI_USD")=OILPRICE_INFO("WTI_USD")=OILPRICE_STATUS("WTI_USD")=OILPRICE_UNIT("WTI_USD")=OILPRICE_CODES()=OILPRICE_GET("/v1/prices/latest","by_code=WTI_USD")

Storage and deletion

  • The API key is stored in document properties associated with the current spreadsheet and is never returned to the sidebar.
  • Short-lived user cache entries hold requested market responses to reduce duplicate API calls.
  • A minimal diagnostic stores endpoint path, result code, status, duration, and timestamp—never the API key or query string.
  • “Delete API Key” removes the stored key and diagnostic. Generated spreadsheet cells remain under the user's control until the user clears or deletes them.

Google user-data commitment

OilPriceAPI's use of information received from Google Workspace APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.

Review and support

The add-on will not be described as publicly available until Google completes OAuth verification and publishes the Workspace Marketplace listing. Questions about permissions, data handling, or installation can be sent to [email protected].

Contact supportReview source and release statusReview current plans and dataset access

Google Sheets™ is a trademark of Google LLC.