Back

Build a company org chart in Google Sheets from LinkedIn

A sheet mapping a company's team with titles, reporting lines, and likely champions

SalesAnalystsEAs
Prompt

Build an org chart of [company, e.g. a mid-size logistics software company], focused on [department, e.g. sales and revenue operations]. Start from what I already have: [known contacts or an internal org chart link, e.g. two people from my last call]. Then search LinkedIn and the company website for current people there. Browse at a human pace and stop if LinkedIn shows a warning, limit, or captcha. For each person, infer who they report to from titles, seniority, and public mentions. Skip former employees and anyone you can't confirm is still there. Write it into a new Google Sheet titled "[company] org chart" with columns: Name, Title, Team, Reports To, Level, Location, Profile URL, Source, Confidence (confirmed or inferred). Send me a short summary: the reporting tree in outline form, gaps you couldn't fill, and the likeliest champion or decision-maker for [call context, e.g. a pitch for a sales analytics tool]. Don't message anyone.

Works withlinkedin.comdocs.google.com