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 a Google Sheet, 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 can't find 11 of them — leaving 11 blank rows that need a separate verification pass.
- Three hours in, you've enriched 35 journalists and your 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 Google Sheet. It connects to Perigon's journalist profile database and writes enrichment data — Twitter handle, bio, location — back into your sheet row by row.
For each journalist name in column A and outlet in column B, look them up in Perigon and write their Twitter handle, bio, and location into columns C, D, and E.
What You Get
- Columns C, D, and E populated for every journalist Perigon can match.
- Rows where Perigon finds no match are left blank in those columns — no errors, no false positives.
- The sheet stays in place — no new tabs, no reformatting required.
- 60-row enrichment run in seconds, not an afternoon.
What If the Data Is Not Quite Ready
Journalist names in the sheet have inconsistent formatting
For each row in the Press List sheet, 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 column C is currently empty
For each row in the Press List sheet 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 up any stale enrichment data, re-enrich, and flag coverage beats in one pass
In the Press List sheet, 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 in one prompt — no need to run separate steps.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet 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 sheet.