The Scenario
A product manager at a consumer electronics brand needs to pull the 50 most recent customer reviews for 5 competing SKUs from Best Buy into a Google Sheet. It's Thursday morning. The competitive sentiment analysis deck is due to the VP of Product by end of day. She needs review title, star rating, review body, reviewer name, and submission date — one review per row — so she can run a keyword frequency analysis in the adjacent columns.
The bad version:
- Open bestbuy.com for SKU 1, scroll the reviews tab, copy the title and body of review 1, paste into row 2
- Repeat for 50 reviews across 5 SKUs — 250 manual copy-paste operations
- Realize Best Buy shows only 8 reviews per page and the date sort is inconsistent
- Send the partial data to the VP because you ran out of time at review 120
You don't have time for that.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads your data and talks to Best Buy for you. No pagination, no manual copying, no reformatting.
Open the SheetXAI sidebar and type:
Fetch the 20 most recent Best Buy customer reviews for each SKU in column A of my sheet and write SKU, review title, rating, review text, reviewer name, and submission date into rows — one review per row
What You Get
- One row per review — SKU, review title, star rating, full review text, reviewer name, and submission date
- Reviews sorted by date descending so the most recent appear first within each SKU group
- All 5 SKUs processed in sequence, with each SKU's reviews grouped together in consecutive rows
What If the Data Is Not Quite Ready
When you want only reviews with 3 stars or fewer for negative sentiment analysis
Fetch the 30 most recent Best Buy customer reviews for each SKU in column A, filter to reviews with 3 stars or fewer, and write SKU, review title, rating, review text, and submission date — one review per row
When you need to join review data with product names from column B
Fetch the 20 most recent Best Buy reviews for each SKU in column A, and write product name (from column B), SKU, review title, star rating, review body, and date — one review per row — into sheet "Reviews"
When you only want reviews from the last 90 days
Fetch Best Buy customer reviews for each SKU in column A, filter to reviews submitted in the last 90 days, sorted by date descending, and write SKU, review title, rating, review text, and date into rows
When you want it all in one shot
Fetch the 50 most recent Best Buy customer reviews for each SKU in column A, include both positive (4–5 star) and negative (1–2 star) reviews, write product name from column B, SKU, review title, rating, review text, reviewer name, and date — one row per review — into a new sheet called "Raw Reviews", then add a POSITIVE or NEGATIVE label in the last column based on star rating.
The pattern: instead of pulling reviews manually and then labeling them, you ask for both the data and the classification in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Best Buy SKUs. Ask it to pull customer reviews for each one. The Best Buy integration is included in every SheetXAI plan. For related tasks, see Bulk Pull Best Buy Product Details by SKU Into a Google Sheet or the Best Buy in Google Sheets overview.