Answer · Google Sheets · IMPORTDATA
Pinnacle odds in Google Sheets with IMPORTDATA
Answer: IMPORTDATA / IMPORTJSON cannot set x-api-key. Put the key in Apps Script (UrlFetchApp) or behind your own signed proxy URL that IMPORTDATA can call without exposing the secret. Full walkthrough: Sheets guide and Sheets+Excel answer.
Recommended pattern#
- Script property
PINNFEED_KEY. UrlFetchApp.fetch('https://pinnfeed.io/v1/odds?sport=soccer&main=true', {headers:{'x-api-key': key}}).- Write rows into a sheet; time-driven trigger every 15 minutes on Free.
IMPORTDATA trap#
A URL like https://pinnfeed.io/v1/odds?key=... in a cell leaks the key to anyone with view access. Prefer Script properties.
Trial CTA#
Builder (€99/mo) for WebSocket and closing history. 3-day trial; card required, charged after day 3 unless cancelled. Free REST: signup. Related: answers hub, docs.
Questions people ask#
Can IMPORTDATA work at all?#
Only if you front the API with a proxy that does not need a secret in the sheet cell.
Free plan enough?#
Yes for a delayed board (~30 s) inside 1,000 req/day.
Is this educational content for adults?#
Yes (18+).