20 lines
626 B
Python
20 lines
626 B
Python
import sys, json
|
|
sys.path.insert(0, "/app")
|
|
import sync_server as m
|
|
|
|
TAB = "Parastoo|Graphic"
|
|
all_rows = []
|
|
# paginate 100 rows at a time
|
|
for start in range(1, 1100, 100):
|
|
try:
|
|
r = m.composio_execute("GOOGLESHEETS_VALUES_GET", {
|
|
"spreadsheet_id": m.SHEET_ID,
|
|
"range": f"'{TAB}'!A{start}:N{start+99}"})
|
|
except Exception as e:
|
|
break
|
|
vals = (r or {}).get("values") or []
|
|
if not vals:
|
|
break
|
|
for i, row in enumerate(vals):
|
|
all_rows.append({"row": start + i, "cells": row})
|
|
print(json.dumps({"total": len(all_rows), "rows": all_rows}, ensure_ascii=False))
|