← back to Rentv Sheet Enrich Refine
__pycache__/enrich.cpython-314.pyc
51 lines
+
|~j0 � �d � R t ^ RIt^ RIt^ RIt^ RIt]P
P
^ ]P
P ]4 4 ^ RI t 0 Rmt
R] ! R^ ^^^^
R7 R] ! R^^^^^ R7 R] ! R^^^^^ R7 R ] ! R
^ ^^^^R7 /t . ROt
R tR tR
tR tR tR t]R8X d
]! 4 R# R# )u�
enrich.py — RENTV CRE-sheet enrichment engine.
LAYER 1 (this file, $0, deterministic): derive each company's Website from its
existing corporate email domain, and add a Website/LinkedIn/Marketing-VP column set.
Only EMPTY target cells are filled; existing data is never overwritten. Every filled
cell is stamped light-green by lib.batch_fill.
Modes:
--dry-run read local data/tab_<gid>.csv, report projected fills, write NOTHING
--apply read the LIVE tab via the Sheets API and write fills (needs connect.py)
LinkedIn + Marketing/VP contact enrichment is LAYER 2 (research) — added next,
after Layer 1 is verified on the live sheet.
Ni��[zSponsor & Speaker Companies)�name�
header_row�
data_start�company�email�basei�le|zStrong Prospectsi�:szEvent Sponsorsi W: zUnique Contacts (all tabs)c �Z � V R , p\ W^, V^, V^, R7 # )r )� new_website�new_li_company�new_li_contact�new_mvp)�dict)�cfg�bs & �7/Users/macstudio3/Projects/rentv-sheet-enrich/enrich.py�colsr / s' � � �F� �A� �A��c�!�A�#�q�QR�s� S�S� c �R � V\ V 4 8 d W, P 4 # R # )� )�len�strip)�row�is &&r �cellr 3 s � � ��S��\�3�6�<�<�>�1�r�1r c � � \ P ! RT ;' g R4 F1 pVP 4 P R4 pV\ 9 g K/ Vu # R# )zPPick the first corporate (non-freemail) domain from a possibly multi-email cell.z[\w.+-]+@([\w-]+\.[\w.-]+)r �.)�re�findall�lowerr �FREEMAIL)� emailcell�m�ds & r �domain_from_emailsr# 6 sE � �
�Z�Z�5�y���B�
G��
�G�G�I�O�O�C� �� �H� ��H� H� r c �r � \ V , p\ V4 p. \ ^ ^ ^ ^ ^ R7 rTVR, pV\ V4 8 d W, M. p\ \
4 F> w r�VR, V, p
\
Wz4 R8X g K' VP RVRV
RV /4 K@ \ VR, \ V4 4 F� p W, p \
W�R , 4 p
V
' g K' VR
;;, ^,
uu& \
W�R , 4 p\
W�R , 4 R8w d Kg \ V4 pV' dK VR
;;, ^,
uu& VR;;, ^,
uu& VP RV RVR , RV/4 K� V' d VR;;, ^,
uu& K� VR;;, ^,
uu& K� WE3# )z9Return (fills, stats). fills = list of {row0,col0,value}.)�rows� has_email� website_fill�
freemail_only�no_emailr r r �row0�col0�valuer r r% r r r& r' r( r) )
�TABSr r
r � enumerate�
NEW_LABELSr �append�ranger# )�gidr% r �nc�fills�stats�hr�hdrr �label�col�rr �comp�emailc�doms && r �plan_tabr> > sg � �
�s�)�C�$�s�)�R��t��a�a�q�[\�]�5� �\� �B��3�t�9�n�$�(�"�C� �j�)����&�k�A�o�� ��>�R� � �L�L�&�"�f�c�7�E�B� C� *� �3�|�$�c�$�i�
0���g���C�Y� �(��� �
�f�
���
��c�w�<�(�� ��
�&� '�2� -� � ��(�� � �+� �!� #� �U�>�%:�a�%?�%:� �L�L�&�!�V�R�
�->���M� N�
� �/� "�a� '� "� �*� �� "� �# 1�$ �<�r c �8 � \ P P \ P P \ 4 R RV R24 p\ VRRRR7 ;_uu_ 4 p\
\ P ! V4 4 uuRRR4 # + ' g i R# ; i)�data�tab_z.csvr zutf-8�ignore)�newline�encoding�errorsN) �os�path�join�dirname�__file__�open�list�csv�reader)r2 rG �fs & r �load_csvrP ] sa � �
�7�7�<�<�������1�6�T�#��d�;K� L�D�
�d�B��� B� B�a��C�J�J�q�M�"�
C� B� B� B�s � B� B c � � R \ P 9 d RMR p V R 8X d \ P ! 4 MRpV' d \ P ! V4 MRp/ pV' d1 VR, F# pVR, R, W4R, R, & K% RpR\ P 9 dE \ \ P \ P P
R4 ^, , 4 p\ P 4 EFz w rgVe We8w d K V R 8X d \ P ! WV, 4 pM \ V4 p\ Wh4 w r�V U u. uF q�R, VR , 8w g K V NK p p \ R
VR , R V R
24 \ RV
R, RV
R, RV
R, RV
R, 24 \ R\ V 4 R\ V 4 R24 V R, FG p \ RV R, ^, R\ P ! V R , 4 R V R , 24 KI V R 8X g EKD \ P ! WV 4 p
\ R V
P! R R!4 R"24 EK} R# u up i )#z--applyz --dry-runN�sheets�
properties�title�sheetIdz--onlyr* r z
=== r z (gid=z) ===z
companies: r% z | website derivable now: r' z | freemail-only (Layer2): r( z | no-email (Layer2): r) z cells to fill this run: z (z websites + headers):N� Nz -> R�Cr+ z: r, z APPLIED: �totalUpdatedCells�?z cells written (light-green).)�sys�argv�lib� access_token�get_meta�int�indexr- �items�read_tabrP r> �printr �
col_letter�
batch_fill�get)�mode�tok�meta� title_by_gid�s�onlyr2 r r% r4 r5 rO �
data_fills�ress r �mainro b s � �#�3�8�8�3�;��D� $� � 1�#�
�
�
�t�C� #�3�<�<�� ��D��L� ��h� � �A�78� ��w�7O�L�<� ��3� 4� � �D��3�8�8���3�8�8�C�H�H�N�N�8� 4�Q� 6�7�8���J�J�L��� � �� � � �9� ��<�<��#�%6�7�D��C�=�D� ��*� ��!&�I��A�F�)�s�<�7H�*H�a�a��
�I�
��s�6�{�m�6�#��e�4�5�
�
�e�F�m�_�,F�u�^�G\�F]�+�E�/�,B�+C�CY�Z_�`j�Zk�Yl�n� o�
�*�3�u�:�,�b��Z� �8I�I]�^�_��B� � �A� �H�Q�v�Y�q�[�M��3�>�>�!�F�)�+D�*E�R��'�
�|�T� U� � �9� ��.�.��5�1�C� �K����(;�C� @� A�A^�_� `�# !�� Js �J�/J�__main__> �me.com�aol.com�att.net�cox.net�mac.com�msn.com�live.com� gmail.com� yahoo.com� ymail.com�
icloud.com� comcast.net� hotmail.com� outlook.com� verizon.net�
sbcglobal.net�protonmail.com)�WebsitezLinkedIn (Company)zLinkedIn (Contact)zMarketing/VP ContactzUpdated Email (found))�__doc__rZ rF rM r rG �insertrI rJ r\ r r
r- r/ r r r# r> rP ro �__name__� r r �<module>r� s� ��� � � ������2�7�7�?�?�8�,� -�
� 8�� ��7���A�Q�R�A���,���A�Q�R�A���*���A�Q�Q�@� �T�3���A�Q�R�A� ��?�
�T�2�� �>#�
a�> �z���F� r