← back to Rentv Sheet Enrich
__pycache__/snapshot.cpython-314.pyc
46 lines
+
&k~j� � �v � R t ^ RIt^ RIt^ RIt^ RIt^ RIt^ RItR tR t RR lt
R t]R8X d
]! 4 R# R# )u^
snapshot.py — pull the ENTIRE workbook into OUR OWN local copy (data/snapshot.json) in
just a few batch reads, so the viewer never live-reads the Google Sheet per tab-switch
(that was the 60-reads/min quota that blanked tabs). One values.batchGet for all tab
values + one includeGridData get for all green (enriched) cell maps. Re-run to refresh.
Nc � � \ P P V R RV 2/R7 p\ P ! \ P P V4 4 # )�
AuthorizationzBearer )�headers)�urllib�request�Request�json�load�urlopen)�url�tok�rs && �9/Users/macstudio3/Projects/rentv-sheet-enrich/snapshot.py�apir
sD � ������s�_���u�o�,N��O�A��9�9�V�^�^�+�+�A�.�/�/� c � � R \ P P RV P RR4 , R, RR7 , # )zranges=�'z''� )�safe)r �parse�quote�replace)�titles &r �rngr s7 � ��v�|�|�)�)�#��
�
�c�4�0H�*H�3�*N�UW�)�X�X�Xr c �x a.a/� T ;'