APPS SCRIPT · SPREADSHEET

Meridian Edge + Google Sheets

Pull live prediction market consensus directly into Google Sheets — auto-refresh on open, with sport filtering and divergence highlighting.

Connect Google Sheets to Meridian Edge to access real-time prediction market consensus from 25+ regulated sources. Use Apps Script to fetch and display live probabilities directly in your spreadsheet.

Requirements

Integration Code

Google Apps Script (paste in Tools > Apps Script)javascript

const API_KEY = "me_live_YOUR_KEY";
const SPORT   = "NBA";

function fetchConsensus() {
  const url = `https://meridianedge.io/api/v1/consensus?sport=${SPORT}&limit=20`;
  const res = UrlFetchApp.fetch(url, {
    headers: {"X-API-Key": API_KEY},
    muteHttpExceptions: true
  });
  const data = JSON.parse(res.getContentText());
  const events = data.events || [];

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clearContents();
  sheet.appendRow(["Event", "Consensus %", "Divergence %", "Markets", "Updated"]);

  const now = new Date().toLocaleString();
  events.forEach(e => {
    sheet.appendRow([
      e.title,
      (e.consensus_prob * 100).toFixed(1) + "%",
      ((e.divergence_pct || 0) * 100).toFixed(1) + "%",
      e.market_count || "",
      now
    ]);
  });
}

// Auto-run on spreadsheet open
function onOpen() { fetchConsensus(); }

Try it — API key in 10 seconds

Paste the Apps Script into your Google Sheets, add your API key, and get live prediction market data auto-populated on open.

View Plans → API Reference

Frequently Asked Questions

How do I get prediction market data in Google Sheets?

Open Google Sheets, go to Extensions > Apps Script, and paste the code above. Replace YOUR_KEY with your Meridian Edge API key. Save and run fetchConsensus() — or set up a trigger to auto-refresh on a schedule.

What does Google Sheets + Meridian Edge cost?

Yes. Google Sheets and Apps Script are included. Meridian Edge starter tier: 100 calls/day. Get a key at meridianedge.io/#pricing.