← back to Rentv Sheet Enrich
__pycache__/write_by_contact.cpython-314.pyc
47 lines
+
��j4 � � � R t ^ RIt^ RIt^ RIt^ RIt^ RIt]P P ^ ]P P ] 4 4 ^ RI
t
] ! ]P ^, 4 t
]P ! ]! ]P ^, 4 4 t]P" P% 4 P' 4 tR t]
P, ! 4 t]
P0 ! ]4 R, U u/ uF" p V R, R, V R, R, bK$ up ]
, t]
P4 ! ]]4 t] ! R ] ! ] ! ^] ! ]4 4 4 4 ^ 4 t ]] , t!R t"]"! R 4 t#]"! R
4 t$]"! R 4 t%]"! R 4 t&]"! R
4 t'](! R ])! ]!4 4 ^ R7 t*]*^, t+. t,]%f# ]+t%],P[ R] R]+RR /4 ]+^,
t+]&f# ]+t&],P[ R] R]+RR /4 ]+^,
t+]'f# ]+t'],P[ R] R]+RR
/4 ]+^,
t+],' d ]
P\ ! ]]
],4 R t// t0] ! ] ^, ] ! ]4 4 Fb t1]! ]/! ]1]$4 4 ]! ]/! ]1]#4 4 3t2]2^ , ' g ]2^, ' g KA ]0Pg ]2. 4 P[ ]14 Kd R t4. t5^ t6. t7. t8] EF� t9]! ]9Pu RR4 4 ]! ]9Pu RR4 4 3t;]0Pu ];4 t<]<' g~ ]0P{ 4 UUUUu. uF\ w w rpV' g K V];^, 8X g K" ];^ , ' g K3 ];^ , V9 g V];^ , 9 g KQ V F pVNK K^ uppppt<]<' gC ]7P[ ]9Pu RR4 R, ]9Pu RR4 , 4 EK ]6^,
t6]4! ]94 t>]>' go ]9Pu R4 ;' g RP 4 ' d@ ]8P[ ]9Pu RR4 R, ]9Pu RR4 , 4 ]< F� t@]>' d* ]9Pu R4 ;' g RP 4 MRtA]9Pu R4 ;' g RP 4 tB]A' df ]/! ]@]%4 ' gW ]5P[ R]@R]%RR]AP� R R4 , R R /4 ]/! ]@]'4 ' g ]5P[ R]@R]'R]/4 ]B' g K� ]/! ]@]&4 ' d K� ]5P[ R]@R]&R]B/4 EK EK� ]
P\ ! ]]
]54 tD]E! ]P� ! R ]
R ]6R!] ! ]74 R"] ! ]84 R#]DPu R$^ 4 /4 4 R# u up i u uppppi )%u�
write_by_contact.py <gid> <results.json>
PER-CONTACT writer — row-shift immune, matched on (company + contact-name) so each
person's data lands on THEIR row (not smeared across every contact at the company like
the company-only write_by_name.py). Each result item = {company, name, contact_li?, email?}.
Only fills empty cells; contact_li becomes =HYPERLINK; email -> "Updated Email (found)".
Reports matched / unmatched / cells.
Nc �b � \ P ! R RT ;' g RP 4 4 # )z [^a-z0-9]� )�re�sub�lower)�ss &�write_by_contact.py�normr s! � �B�F�F�<��a�g�g�2�_�_�->�?�
?� �sheets�
properties�sheetId�titlec # � " � T F= p\ \ V, 4 F w r#VP 4 R 8X g K Vx � K" K? R# 5i)� Contact NameN)� enumerate�rows�strip)�.0�i�j�vs & r � <genexpr>r s? � � � J�.�� ��a��)�t�q�Q�W�W�Y�.�-H�
�1�)�
�.�s
�2A�Ac �\ a � \ V 3R l\ \ \ 4 4 4 R4 # )c 3 � <" � T F> q\ \ 4 8 d \ V, MR P 4 S8X g K: Vx � K@ R# 5i)r N)�len�hdrr )r r �labels & �r r �hidx.<locals>.<genexpr> s3 �� � � n� �A�3�s�8�|�S��V�Y[�<b�<b�<d�hm�<m�a�a� �s
�7A �
A N)�next�ranger r )r s fr �hidxr! s �� �� n��s�3�x� � n�pt�u�ur
r z
Company/VenuezLinkedIn (Contact)zUpdated Email (found)u LinkedIn (Contact) — foundc # �Z " � T F! w rVP 4 ' g K Vx � K# R # 5i)N)r )r r r s & r r r " s � � �;�~�t�q�������~�s �+�
+)�default�row0�col0�valuec �� � VeR V \ \ 4 8 d> V\ \ V , 4 8 d# \ V , V, P 4 # RP 4 # )Nr )r r r )�rr s &&r �cellr) ( sG � �a�m��C��I�
�!�c�RV�WX�RY�l�JZ��Q���
�i�i�k�k�`b�i�i�k�kr
c � � V P R 4 ;' g RP 4 P 4 pVR8X d R# R# )� slug_sourcer �inferredFT)�getr r )�it�srcs & r �_li_okr0 8 s8 � �
�6�6�-� � &� &�B�
-�
-�
/�
5�
5�
7�C�
�j��� r
�companyr �namez @ �
contact_li�emailz=HYPERLINK("%s")�"�formulaT�gid�matched� unmatched�rejected_inferred�
cells_written�totalUpdatedCells)G�__doc__�sys�os�jsonr �datetime�path�insert�dirname�__file__�lib�int�argv�GID�load�open�results�date�today� isoformat�TODAYr � access_token�tok�get_metar �read_tabr r r �minr �hrr r! �NAME�CO�LIC�EM�FND�maxr � rightmost�nxt�newh�append�
batch_fillr) �idxr( �k�
setdefaultr0 �cellsr8 r9 r: r. r- �key�targets�items�
li_allowedr �r0�li�em�replace�res�print�dumps)r �co�nm�rsr( s 00000r �<module>rt s3 ��� #� "� "� ������2�7�7�?�?�8�,� -�
� �#�(�(�1�+���$�)�)�D����!��,=�">���
�
��� �'�'�)�� ?� ������,�,�s�#�H�-� /�-�Q�
�<� �� #�Q�|�_�W�%=� =�-� /�/2� 4��
�|�|�C�� �� � J�e�C��3�t�9� -�.� J�KL�N��
�2�h�� u� �N���$��"7�R�
� � ��t�,C�'D�"� � )�*��
�;�y��~�;�Q� G� �y�[\�}�� ���;�c��4�;�;���F�C��J^�'_�`�be�ij�bj�be��;�c��4�;�;���F�C��Ja�'b�c�eh�lm�em�eh��;�c��4�;�;���F�C��Jh�'i�j�lo�st�lt�lo��� � ��S�$� '� k� �� �r�A�v�s�4�y� !�A�
�d�1�b�k� �D��a�� � /�0�A���t�t�q��t�t� ���q�"� �$�$�Q�'�
"�� ��a�G�R��R�):�
�B� ����y�"�%� &��R�V�V�F�B�-?�(@�
A�C��g�g�c�l�G� �),���� e�� ��"�2�� � �3�q�6�\� �.1�!�f�f� �:=�a�&�B�,�"�PS�TU�PV�,� �ac�\]� �ac� �� e�� ���������+�e�3�b�f�f�Y��6K�K�L�h� �q�L�G����J� �2�6�6�,�/�5�5�2�<�<�>�>�� � ������!3�e�!;�b�f�f�Y�PR�>S�!S�T���5?�b�f�f�\�"�(�(�b�
/�
/�
1�R���f�f�W�o�#�#��
*�
*�
,��
�d�2�s�m�m� �L�L�&�"�f�c�7�<N�QS�Q[�Q[�\_�ac�Qd�<d�fo�qu�v� w���C�=�=�� � �f�b�&�#�w�� F�G�
�2�d�2�r�l�l� �L�L�&�"�f�b�'�2�>� ?� � �*
�n�n�S�#�u�%�� �d�j�j�%��i��+�s�9�~�%�s�+<�'=�!�3�7�7�+>��#B�D� E� F��E /��`es$ �)(V<�%W �9 W � W �W �8W