Pinnacle Odds Google Sheets Integration

I already hold a valid Pinnacle soccer API key and have a blank Google Sheet waiting for data. I need the key installed and a script set up so the sheet automatically pulls two data sets—match odds and upcoming fixtures—for UK soccer markets.

The sync has to run hourly without manual intervention. A lightweight Google Apps Script (or another native method you prefer) that parses the JSON feed, writes the fields to clearly labeled columns, and respects API rate limits is perfect.

Deliverables
• A ready-to-use Google Sheet with live match-odds and fixture data refreshing every hour
• Source script embedded in the sheet, commented for easy tweaking
• Brief one-page walkthrough so I can edit endpoints, columns, or update frequency if needed

Once the sheet starts updating reliably on the schedule, the project is complete.