update-hr

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.