📊 Google Sheets

Get Diesel Prices in Google Sheets

Use Apps Script to get real-time diesel prices. Works on desktop, mobile, and tablet.

Setup with Apps Script

Step 1: Open Apps Script Editor

In Google Sheets, click Extensions → Apps Script
Delete any existing code
Paste the code below

function DIESEL_PRICE(stateCode) {
  const API_KEY = 'YOUR_API_KEY';
  const url = `https://api.oilpriceapi.com/v1/diesel-prices?state=${stateCode}`;

  const options = {
    'method': 'GET',
    'headers': {
      'Authorization': 'Bearer ' + API_KEY
    }
  };

  try {
    const response = UrlFetchApp.fetch(url, options);
    const data = JSON.parse(response.getContentText());
    return data.data.regional_average.price;
  } catch (error) {
    return 'Error: ' + error.message;
  }
}