Google Sheets / Apps Script Calendar Sync

import datetime as dt
import requests

API_KEY = "YOUR_API_KEY"
BASE_URL = "https://api.earningsapi.com"

def fetch_calendar(day):
    response = requests.get(
        f"{BASE_URL}/v1/calendar/earnings",
        params={"date": day.isoformat(), "apikey": API_KEY},
        timeout=30,
    )
    response.raise_for_status()
    return response.json()

start = dt.date.today() - dt.timedelta(days=90)
for offset in range(121):
    day = start + dt.timedelta(days=offset)
    calendar = fetch_calendar(day)
    print(day, len(calendar.get("pre", [])), len(calendar.get("after", [])))