Update HR Contacts

Find LinkedIn recruiter profiles for a company and add them to column E of

List.xlsx

.

Step 1 — Search LinkedIn

Use WebSearch with this query:

"{company}" recruiter OR "talent acquisition" OR "hiring manager" OR "HR manager" OR "people partner" Paris OR France OR EMEA site:linkedin.com/in

Location priority: Paris first, then France, then EMEA as a fallback. Only use EMEA-level contacts when no Paris or France-specific person is found. Ignore contacts based in India, US, or APAC unless the company has no EU presence at all.

Step 2 — Add to the HR_CONTACTS dict

Open

update_hr_contacts.py

and add or extend the company entry in the

HR_CONTACTS

dictionary. Use the company name exactly as it appears in column A of

List.xlsx

. If the company is already in the dict, append the new contacts to its list — don't replace existing ones.

Step 3 — Run the script

Run

update_hr_contacts.py

from the project root. The script reads existing cell content first and only appends contacts whose names aren't already there. Running it twice produces zero changes the second time.

Step 4 — Verify

The script reports how many rows were updated. Check that the count matches expectations.

Rules

• Never overwrite manually entered contacts — the script is append-only.
• Write names directly, no [UNVERIFIED] prefix.
• To remove a contact: delete it from Excel AND remove it from the

  HR_CONTACTS

  dict. That's the only case requiring both steps.
• Don't drag the fill handle in Excel after running — it creates ghost rows with duplicated formulas.