Answer · Sheets · No-code

No-code Pinnacle odds in Google Sheets

Updated 10 November 2026 · PinnFeed · 1 min read

Answer: use Apps Script UrlFetchApp with x-api-key from Script Properties. Do not use IMPORTDATA for authenticated calls.

Minimal script#

function fetchOdds() {
  const key = PropertiesService.getScriptProperties().getProperty('PINNFEED_KEY');
  const res = UrlFetchApp.fetch(
    'https://pinnfeed.io/v1/odds?sport=soccer&main=true&limit=20',
    { headers: { 'x-api-key': key } }
  );
  const data = JSON.parse(res.getContentText());
  // map data.events into a sheet range
  return data.events.length;
}

Deep dive: IMPORTDATA answer · Sheets/Excel.

Trial CTA#

Builder (€99/mo) for WebSocket and closing history. 3-day trial; card required, charged after day 3 unless cancelled. Free key: signup. Related: vibe coding, quickstart, answers.

Questions people ask#

Why not IMPORTDATA?#

It cannot send x-api-key.

Zapier instead?#

Yes — HTTP module with the header. Zapier answer.

Is this educational content for adults?#

Yes (18+).