scratch/test_fetch.py

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

def test_fetch():
    from environments.trace_env.tools.sheets_tool import fetch_and_summarize
    res = fetch_and_summarize()
    print("Total count:", res.get('count'))
    for t in res.get('transactions', []):
        print(t.get('vendor'), t.get('total'), t.get('id'))

test_fetch()