The Scenario
You're a business development rep at a growth-stage SaaS company. Your sheet has 60 target companies in column A — names you've gathered from a conference list, a LinkedIn export, and two rounds of manual research. The prospecting session is tomorrow morning. Your manager has asked everyone to show up with context on each company: what they do, what vertical they're in, anything useful.
Right now column B and column C are empty.
The bad version:
- You open a browser tab, type the first company name into Onepage's docs interface or a REST client, read through the JSON response, and copy the description into column B by hand.
- For companies that return ambiguous results — the name matches three different entities — you pick one and hope it's right, then move on because you don't have time to validate.
- By company 20, you've been doing this for 45 minutes and your paste formatting is already inconsistent: some descriptions have trailing newlines, some are all-caps, some are truncated mid-sentence.
The meeting is in 14 hours and there are 40 companies left. The enrichment itself is fast — Onepage returns results in milliseconds. The bottleneck is you, doing a human relay between an API and a spreadsheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data, understands the structure of the sheet, and talks to Onepage on your behalf — no scripts, no automation builder, no copy-paste loop.
Here's the prompt for this task:
For each company name in column A, search Onepage and write the returned description into column B and the top 2-3 data points into column C. If no result is found, mark column B with "no result" and leave column C blank.
What You Get
- Column B fills with the plain-text company description from Onepage — one cell per company, consistent formatting, no trailing newlines.
- Column C gets the top 2-3 data points returned by Onepage for that company (industry, founding date, employee range, or whatever the API surfaces as the top fields).
- Any company that returns no result gets "no result" in column B, so you can see at a glance which rows need manual follow-up.
- The run completes across all 60 rows in a single pass — not row by row in sequence, but as a batch.
What If the Data Is Not Quite Ready
Company names have inconsistent formatting (extra spaces, abbreviations, all-caps)
Before running the Onepage enrichment, normalize the company names in column A: trim leading and trailing spaces, convert ALL-CAPS entries to title case, and expand common abbreviations (Corp → Corporation, LLC → LLC, Inc → Inc). Then search Onepage for each cleaned name and write the description into column B.
Some rows already have descriptions in column B — skip those
For every row in column A where column B is blank, search Onepage and write the returned description into column B and the top 2-3 data points into column C. Leave already-filled rows untouched.
Company names in column A include the country in parentheses — strip it before querying
For each row in column A, remove any text in parentheses (e.g., "(UK)", "(Germany)") before searching Onepage. Write the cleaned name into column D, then write the Onepage description into column B and the top data points into column C.
Clean the names, enrich, and flag low-confidence matches in one shot
Trim and normalize every company name in column A. Search Onepage for each one. Write the description into column B and the top 2-3 data points into column C. If the Onepage response returns a low relevance score or no result, write "low confidence" into column D so these rows can be reviewed before the prospecting session.
The underlying pattern: ask for the cleanup and the enrichment together, so the data that lands in your sheet is already ready to use.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with a column of company names — even a rough one — then ask SheetXAI to enrich it using Onepage. For a different angle on enrichment, see how to enrich a contact list with company context, or go back to the Onepage integration overview.