The Scenario
You got a Slack message at 8 AM from the brand manager: "Can you pull the latest Target reviews for our top 20 products? We need to run sentiment scoring before the strategy session Thursday."
You have 20 TCINs in a Google Sheet. You need reviewer rating, review title, and review text for each — flattened into a table that can be fed into a scoring model.
The bad version:
- Open the RedCircle API docs, find the reviews endpoint, write a test call for the first TCIN, parse the response structure
- Write a loop for all 20 TCINs, realize the reviews endpoint paginates and your first pass only got 10 reviews per product instead of 25
- Get all the data into a Python dataframe, export to CSV, import into the sheet — and discover the review text column has line breaks that break the CSV parsing
Thursday is two days away and sentiment scoring takes time. You can't spend Wednesday morning debugging an import pipeline.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to the RedCircle API from inside your Google Sheet. It can pull reviews for a list of TCINs and build the flat table you need — without you touching the endpoint or the response schema.
For each TCIN in column A, fetch the Target product reviews via RedCircle and write reviewer rating, review title, and body text into new rows in columns B, C, and D — include the source TCIN in column A of each review row
What You Get
- One row per review (not one row per product)
- Column A: source TCIN repeated on each review row for join-back
- Column B: star rating (integer 1-5)
- Column C: review title text
- Column D: review body text (line breaks removed for downstream processing)
All 20 products processed in sequence. If a product has fewer reviews than requested, all available reviews are included.
What If the Data Is Not Quite Ready
You want to limit to the 25 most recent reviews per product, not all available
The sentiment model performs better on recent signal, and pulling thousands of old reviews would slow things down.
For each TCIN in column A, fetch the 25 most recent Target product reviews via the RedCircle API and write TCIN, star rating, review title, and body text as separate rows starting at row 2 in columns A through D
Some TCINs in column A have duplicates from a prior import
The sheet was assembled from two sources and has 4 duplicate TCINs that would cause double-fetched reviews.
Deduplicate the TCINs in column A, then for each unique TCIN fetch the 25 most recent Target reviews via RedCircle and write TCIN, rating, review title, and review body into flat rows in columns A through D
You want to filter to only negative reviews before building the table
The brand manager specifically wants to understand what's driving low ratings — only 1- and 2-star reviews are in scope.
For each TCIN in column A, fetch Target product reviews via RedCircle and write only reviews with a star rating of 1 or 2 into the flat table — include TCIN in column A, rating in column B, title in column C, and body in column D
You want to pull reviews, flag them by sentiment bucket, and build the table in one shot
You want the raw review data plus a rough sentiment label (positive, neutral, negative based on star rating) so the scoring model has a baseline to validate against.
For each TCIN in column A, fetch the 25 most recent Target reviews via RedCircle, write TCIN, rating, title, and body into columns A through D as flat rows, and add a "sentiment bucket" label in column E — "positive" for 4-5 stars, "neutral" for 3, "negative" for 1-2
One prompt handles the fetch, the classification, and the table structure.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Target TCINs, then ask it to pull review data through RedCircle and build the flat table your analysis needs. See also the spoke on enriching TCINs with product details or the hub overview on connecting RedCircle API to Google Sheets.