The Scenario
Three weeks ago, someone on your team handed off a contacts workbook when they left. It has 40 rows: contact name in column A, company name in column B. That's it. No context, no notes, no indication of what any of these companies actually do.
You're a sales researcher covering for that account now. Reps are opening calls next week, and they've asked for a one-sentence company summary for each contact so they're not walking in cold.
You've been sitting with the sheet for twenty minutes trying to decide the fastest path to column C.
The bad version:
- You Google the first company, scan the homepage or a Crunchbase entry, write a rough summary sentence, and paste it into column C.
- Four rows in, you realize the summaries aren't consistent — some are product descriptions, some are tagline rewrites, some are just industries. A rep is going to open a call with "B2B SaaS platform for SMBs" and get nothing useful from it.
- You start over with a template sentence structure, which means re-doing the first four rows, and now you're twenty minutes in for five companies and you still have 35 to go.
You were given this task on top of everything else you're already managing. The reps need it by Friday. Friday is tomorrow.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands the column structure, and uses its Onepage integration to pull company context for each row and write it back — consistently, in one pass.
Here's the prompt for this task:
Search Onepage for the company name in column B of each row and write a one-sentence context summary into column C. The sentence should describe what the company does in plain language a sales rep can use to open a call.
What You Get
- Column C fills with a one-sentence company summary for every row, formatted consistently across all 40 contacts.
- The phrasing is grounded in what Onepage returns for each company — not a generic "B2B SaaS" filler, but what that specific company actually does.
- Rows where Onepage returns no result for the company name get a visible marker in column C so you know which ones need manual attention before Friday.
What If the Data Is Not Quite Ready
Column B has company names and job titles mixed into the same cell
For each row, extract the company name from column B (ignore anything after a comma or pipe that looks like a job title). Search Onepage for the extracted company name and write the one-sentence summary into column C.
Some contacts share the same company — don't query Onepage twice for the same name
Group the rows by company name in column B. For each unique company, run one Onepage search and write the returned summary into column C for every row with that company name. This avoids duplicate API calls for contacts at the same organization.
Column A has full names but Onepage returns better results with just the last name omitted — try both
For each row, first search Onepage with the company name in column B. If the result confidence is low or no result is returned, retry the search combining the contact name from column A with the company name. Write the best result into column C and note which rows used the combined query in column D.
Deduplicate the contacts, enrich, and flag accounts with no context in one shot
Remove duplicate rows where both column A and column B match exactly. For each remaining row, search Onepage using the company name in column B and write a one-sentence summary into column C. Flag any row where no Onepage result was found by writing "needs review" into column D. Return the cleaned, enriched sheet.
The pattern: handle data quality and enrichment in a single prompt, so the sheet is ready to hand to the reps without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with a contact list — even a messy one — then ask SheetXAI to pull company context from Onepage into a new column. For bulk prospect enrichment instead of per-contact context, see how to bulk-enrich a company prospect list, or go back to the Onepage integration overview.