scratch/debug_sheets_merge.py

import sys
import os
import anyio
import logging
sys.path.insert(0, os.path.abspath("."))
logging.basicConfig(level=logging.INFO)

async def test_merge():
    from server.app import dashboard
    resp = await dashboard(refresh=True)
    html = resp.body.decode()
    if 'sheets' in html.lower():
        print("YES sheets data found")
        lines = html.split("\n")
        for line in lines:
            if "Sheets" in line or "sheets" in line:
                print(line.strip()[:100])
    else:
        print("NO sheets data found")

if __name__ == "__main__":
    anyio.run(test_merge)