<jupyter_start><jupyter_text>Import Contact & Deals from Excel (at the same time)   Step 1. Install pip package<jupyter_code>#!pip install requests<jupyter_output><empty_output><jupyter_text>Step 2. Import hubspot connector<jupyter_code>import hubspot_connector<jupyter_output><empty_output><jupyter_text>Step 3. set variable - token - token for hubspot api- excel_file - path to excel file- sheet_name - name of sheetNote : the excel file should located on the same drive as your notebook and be structured with following columns : DEAL 	PIPELINE	DEAL_STAGE	CLOSED_DATE	COMPANY	FIRSTNAME	LASTNAME	JOB_TITLE	EMAIL<jupyter_code>token = "------"
excel_file = "Deal+contact_creation.xlsx"
sheet_name = "Feuil1"<jupyter_output><empty_output><jupyter_text>Step 3. Run the script for bulk import<jupyter_code>hubspot_connector.connect(token, excel_file, sheet_name)<jupyter_output>creating  <EMAIL><jupyter_text>Step 3. Run the script for bulk delete<jupyter_code>hubspot_connector.delete(token, excel_file, sheet_name)<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.08341323106423777, 'fraction_numerical': 0.005752636625119847, 'mean_word_length': 7.487804878048781, 'pattern_counts': {'":': 0, '<': 21, '<?xml version=': 0, '>': 21, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '5', 'dir': 'jupyter-structured-clean-dedup', 'id': '513600', 'license': 'BSD-3-Clause', 'n_tokens_mistral': 373, 'n_tokens_neox': 355, 'n_words': 88, 'path': 'CRM/Hubpsot/_Workflows/Import Contact & Deals from Excel/Import Contact & Deals from Excel.ipynb', 'repo_name': 'arimbr/awesome-notebooks', 'size': '1061'}