← back to Rentv Sheet Enrich
__pycache__/infer_emails.cpython-314.pyc
59 lines
+
�Mj � � � R t ^ RIt^ RIt^ RItRt0 R mtR tR tRR RR R R
R R R
R RR RR RR RR RR /
tR t R t
] R8X d
]
! 4 R# R# ) uo
infer_emails.py — GENERATIVE email inference (Steve 2026-08-13). For each named contact
missing a real email, generate the LIKELY email by LEARNING that company's actual naming
convention from its known emails (e.g. if 'blake.thompson@nmrk.com' exists, Newmark uses
first.last -> infer 'jane.doe@nmrk.com'). Falls back to first.last@domain when a company
has a domain but no detectable pattern. Written to a clearly-labeled "Likely Email
(inferred)" column, GREEN + flagged — never the real Email column, so guesses are never
mistaken for verified. ADD-only; skips contacts that already have a real or inferred email.
Ni W: c �b � \ P ! R RT ;' g RP 4 4 # )z[^a-z]� )�re�sub�lower)�ss &�infer_emails.py�alphar s! � �R�V�V�I�r�A�G�G��?�?�+<�=�=� c �t � \ P ! R V P 4 4 Uu. uF- q' g K V^ , P 4 ' g K+ VNK/ ppV' g R# \ V^ , 4 p\ V4 ^8� d \ VR, 4 MRpT;' g RT;' g R3# u upi )z[\s,]+Nr )NN�����)r �split�strip�isalphar �len)�name�t�toks�first�lasts & r �partsr s� � ��x�x� �4�:�:�<�8� Q�8�!�A�A�!�A�$�,�,�.�A�A�8�D� Q� �
�"� �$�q�'�N�E�c�$�i�!�m�5��b��?��D� �=�=�D�$�,�,�$� &�&�� Rs � B5�B5�B5z
first.lastc � � V R V 2# ��.� ��f�ls &&r �<lambda>r � � �!��A�a�S�zr
� firstlastc � � V V 2# �Nr r s &&r r r s � �!��Q�C�yr
�flastc � � V ^ , V 2# �� r r s &&r r r s � �!�A�$���s�|r
zf.lastc � � V ^ , RV 2# )r& r r r s &&r r r s � �!�A�$��q���}r
�
first_lastc � � V R V 2# )�_r r s &&r r r r r
�firstlc � � V V^ , 2# r% r r s &&r r r � � �!��Q�q�T�F�|r
�lastfc � � V V ^ , 2# r% r r s &&r r r r- r
z
last.firstc � � V R V 2# r r r s &&r r r r r
r c � � V # r" r r s &&r r r � � �qr
r c � � V# r" r r s &&r r r ! r2 r
c � � \ V4 p. pV ' g V# \ P 4 FJ w rE V' g VR9 d6 \ T! Y;' g T 4 4 V8X d VP V4 KH KJ KL V# \ d K^ i ; i)z8Which template(s) produce this local-part for this name.)r )r � TEMPLATES�items�append� Exception)r r �local�outr �fns &&& r �detectr< # s� � � �%�L�E��#� ��*� �O�O�%��� ���
�*��b��
�
��6N�0O�SX�0X��
�
�4� � 1Y�*� &� �J�� � � � �s � A<�!A<�< B �
B c
� � \ P ! 4 p R p\ P ! W4 q"^ , Uu. uF q3P 4 NK pp\ V4 UUu/ uF w rVV' g K WebK pppR pVR, q�R, q�R, q�R, p VP R4 p
V
fD \
VP 4 4 ^, p
\ P ! V \ R^ R V
R
R/.4 / p/ pVR , EF pV! VV
4 P 4 pV! VV 4 P 4 pV! VV 4 p\ P ! R V4 pV' d V' g Kd VP ^4 VP ^4 P 4 ppV\ 9 d K� VP VV4 \! V4 w pp\# VVV4 FA pVP V/ 4 P V^ 4 VV, V;;, ^,
uu& KC EK VP% 4 UUu/ uF* w ppV\
VP% 4 R
R7 ^ , bK, ppp. p^ p ^ p \ VR , ^R7 EF; w p pV! VV 4 pV' d V^ , P' 4 ' g K7 V! VV
4 ' g V! VV 4 ' g V! VV
4 ' d Kf V! VV 4 P 4 pVP V4 pV' g K� \! V4 w ppV' d V' g K� VV9 d/ \) \* VV, , ! VV4 4 pV ^,
p MV RV 2pV ^,
p V RV 2p \, P. ! VV 4 ' g EK$ VP1 RV R V
R
V /4 EK> \ P ! V \ V4 \3 R\5 V4 24 \3 R\5 V4 RV RV R24 VR, F- p \3 RV! VV R, , V 4 RV R
, 4 K/ R# u upi u uppi u uppi )zUnique Contacts (all tabs)c �v � Ve' V\ V 4 8 d W, P 4 # RP 4 # )Nr )r r )�r�is &&r �g�main.<locals>.g4 s. � �� �1�s�1�v�:���L�L�N�N�2�L�L�N�Nr
z Contact Name�Emailz
Company/VenuezUpdated Email (found)zLikely Email (inferred)N�row0�col0�value:� NNz([^@\s]+)@([\w.-]+)c � � V ^, # )rG r )�xs &r r �main.<locals>.<lambda>J s � �A�a�Dr
)�key)�startr �@z)companies with a detected email pattern: zinferred emails written: z (z from company pattern, z from first.last default):N� Nz z->)�lib� access_token�read_tabr � enumerate�get�max�values�
batch_fill�GIDr r �search�group�FREE�
setdefaultr r< r6 r r r5 �guards�ok_emailr7 �printr )!�tok�title�rows�h�hdr�j�v�crA �NAME�EMAIL�CO�UEM�INF�dom�votesr? �e�co�nm�mr9 �dr r r �pat�cells�n_pat� n_default�ri�email�cells! r �mainrz / s� � �
�
�
�
�C� (�E� �<�<�� #�D�A�w�+G�w�!�G�G�I�w�S�+G�#�C�.�.�.�$�!�A����.�A�.�N� �^� �D��j�e� �7I�"�Sj�Qk�3�
�%�%�)�
*�C�
�{��!�(�(�*�o��!�� ���s�C�6�1�f�c�7�D]�"^�!_�`�
�C�b�e�
�"�X�X��
�a��K� � � ��a��2�h�n�n�&6��Q�q�$�Z�� �I�I�,�a� 0����H��7�7�1�:�q�w�w�q�z� /� /� 1�q�� ��9�h� ���r�1� ��R�y���1���1�e�$�A� � � �R�� $� /� /��1� 5� �"�I�a�L�A� �L� %� � CH�+�+�-�
P�-���Q�2�s�1�7�7�9�.�1�!�4� 4�-�C�
P�
�E���q�9��4��8�1�-�-���A�
�q�$�Z����A�� � � � �(� �Q��;�;�!�A�s�)�)�q��C�y�y�(�
�q�"�X�^�^�
��3�7�7�2�;�q��(��R�y���1���8�
��9��)�C��G�,�Q��2�3�E�U�a�Z�U��c��1�#�J�E� �Q�� ��'��1�#������r�5�)�)� �
� � �f�b�&�#�w��>�?� .� �N�N�3��U�#� � 5�c�#�h�Z�
@�A� � %�c�%�j�\��U�G�;R�S\�R]�]v�
w�x��b� � ��
�e�Q�t�D��L�)�4�0�$��W�
�F� ��a ,H��.��. Qs �Q� Q
�1Q
�.0Q�__main__> �me.com�aol.com�att.net�mac.com�msn.com�live.com� gmail.com� yahoo.com� ymail.com�
icloud.com� comcast.net� hotmail.com� outlook.com�
sbcglobal.net) �__doc__rO r r\ rW rZ r r r5 r< rz �__name__r r
r �<module>r� s� ��� � �
��\�� =�'� �)��(� �+� �,��)� �+� �+��)� �=�
�=�
� �
�4G�l �z���F� r