The Scenario
The product team is preparing a competitive review for the quarterly business update. Someone pulled a list of 15 competitor SaaS products from the CRM and dropped the names into column A of a Google Sheet titled "Q2 Competitive Intel." The ask: G2 rating, total review count, pricing tier, and category for each — formatted as a comparison table.
You got the request Wednesday afternoon. The deck goes to leadership Friday morning.
The bad version:
- Open G2, search for the first competitor name, navigate to their profile, locate the rating, review count, pricing section, and category label — write each into the sheet manually
- Repeat for all 15 products — some have ambiguous names that return multiple G2 listings, so you have to pick the right one each time
- Discover on competitor 11 that G2's pricing section says "contact sales" for two products, which means your pricing column has inconsistent values that will confuse the slide deck
There is no faster way to do this if you're working manually. Fifteen products with four fields each is sixty individual data points to locate, read, and transcribe without errors.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data, understands what you're looking at, and through its built-in Piloterr integration it can fetch G2 product data for a full column of names and write the results back inline.
For each product name in column A (15 rows), call Piloterr G2 product info and write the overall rating, review count, pricing, and category into columns B, C, D, and E
What You Get
- Column B: G2 overall star rating (e.g., 4.6)
- Column C: total review count as of the fetch date
- Column D: pricing tier label from G2 (or "contact sales" where G2 shows no public pricing — consistent across all rows)
- Column E: primary G2 category
- Rows where the product name returns no G2 match get flagged in column F so you can check the spelling or try an alternate name
What If the Data Is Not Quite Ready
Some names in column A are ambiguous and might match the wrong G2 listing
For each product name in column A, fetch G2 product info via Piloterr — where multiple matches exist, prefer the listing with the highest review count, and note the chosen match name in column F so I can verify
You want the data sorted by review count before it lands in the sheet
Read 15 product names from column A on the Competitors tab, fetch G2 data via Piloterr for each, write rating into column B and review count into column C, then sort the results by column C descending before writing
The list includes both established products and newer ones with under 50 reviews
For each product in column A, fetch G2 rating and review count via Piloterr — mark any product with fewer than 50 reviews with "low sample" in column D so the leadership deck footnote can call it out
You need the full enrichment, a review-count sort, and a low-sample flag in one shot
Read column A (15 competitor names), fetch G2 rating, review count, pricing, and category via Piloterr for each, write into columns B through E, flag products with fewer than 50 reviews as "low sample" in column F, then sort all rows by review count descending
One instruction. The competitive table arrives formatted and annotated.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your competitor list lives — then ask SheetXAI to fetch G2 data for each row via Piloterr and write the results into adjacent columns. You can also look at pulling Auchan product data with Piloterr or the full Piloterr hub for more ways to pull external data into your sheet.