The Scenario
You manage media relations for a mid-size SaaS company. Last week your team inherited a press list from an agency that no longer works with you — 60 journalist names and outlet names in an Excel workbook, no contact details, no Twitter handles, no beat information. Just names and publications.
You need to get this list into working shape before your next product launch in three weeks. The enrichment work would normally fall to a junior team member, but they're tied up on the event logistics.
The bad version:
- Search each journalist name in Perigon one at a time. Find the profile. Copy the Twitter handle. Paste into column C. Move to column D for bio. Column E for location.
- Repeat for 60 rows. Realize halfway through that Perigon cannot find 11 of them — leaving 11 blank rows that need a separate verification pass.
- Three hours in, you've enriched 35 journalists and your browser tab count is out of control.
Your time before the launch is measured in days, not afternoons. Manual enrichment at 3 minutes per journalist is not a plan.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Perigon's journalist profile database and writes enrichment data — Twitter handle, bio, location — back into your workbook row by row.
Enrich every journalist in my Excel Press List table by looking up their name column in Perigon and populating the Twitter Handle, Bio, and Location columns.
What You Get
- Twitter Handle, Bio, and Location columns populated for every journalist Perigon can match.
- Rows where Perigon finds no match are left blank — no errors, no false positives.
- The workbook stays in place — no new worksheets, no reformatting required.
- 60-row enrichment run in seconds, not an afternoon.
What If the Data Is Not Quite Ready
Journalist names have inconsistent formatting
For each row in the Press List worksheet, read the journalist name from column A — trim any extra spaces or punctuation — and the outlet from column B. Look up the cleaned name in Perigon. Write Twitter handle, bio, and location into columns C, D, and E. Leave blank if not found.
You only want to enrich rows where the Twitter Handle column is empty
For each row in the Press List worksheet where column C is blank, look up the journalist name from column A and outlet from column B in Perigon. Write Twitter handle, bio, and location into columns C, D, and E.
You want to flag high-follower journalists for priority outreach
Enrich every journalist in column A using Perigon. Write Twitter handle, bio, and location into columns C, D, and E. If the Twitter handle is found and the journalist has more than 10,000 followers according to Perigon, mark column F with "priority".
Clean stale data, re-enrich, and flag coverage beats in one pass
In the Press List worksheet, clear columns C through F for all rows. Re-enrich each journalist by looking up their name in column A and outlet in column B in Perigon. Write Twitter handle, bio, and location into columns C, D, and E. In column F, write their primary coverage beat if Perigon provides one.
Ask for the cleanup and enrichment together — no need for two separate runs.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a journalist list or media contact directory, then ask it to enrich the names using Perigon. See the full Perigon integration overview or explore building a media source audit workbook.