The Scenario
You maintain the pricing tracker. Every Monday it needs fresh data — 200 competitor TCINs, columns B through D populated with current price, availability, and average rating. The TCINs are already in column A. They've been there for three months.
The third time you sat down to refresh this sheet manually was the last time you told yourself it would only take an hour.
The bad version:
- Open the RedCircle dashboard, start a manual lookup for TCIN 1, copy the price and availability into row 2 of the sheet
- Get through 30 rows in 45 minutes, realize you misread the availability status on rows 12 and 18, go back and fix them
- Hit TCIN 74 and get an error — the product was discontinued — and now you have to decide whether to delete the row or leave it blank, which breaks the formula downstream
You're supposed to be doing pricing analysis, not data entry. This is the wrong use of your Monday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that reads your Google Sheet and connects to the RedCircle API directly. You tell it what the columns mean and what to fetch — it does the 200 lookups.
For each TCIN in column A, fetch Target product details from the RedCircle API and write title, current price, and in-stock status into columns B, C, and D
What You Get
- Column B: product title from the RedCircle product detail response
- Column C: current price (numeric, no currency symbol)
- Column D: availability status (e.g. "In Stock", "Out of Stock", "Limited Availability")
Discontinued TCINs get a note in column E rather than breaking the row. All 200 rows processed in one pass.
What If the Data Is Not Quite Ready
Some TCINs in column A have leading zeros stripped by Excel
The TCINs were imported from a CSV and the leading zeros are gone. RedCircle lookups will fail on malformed TCINs.
For each TCIN in column A, pad the value to 8 digits with leading zeros, fetch the Target product details from the RedCircle API, and write title, price, and availability into columns B, C, and D
You only want to refresh rows where the price in column C is more than 7 days old
Column E holds the last-refresh timestamp. You want a targeted update, not a full overwrite.
For each row where column E contains a date older than 7 days ago, re-fetch Target product details for the TCIN in column A and overwrite price in column C and availability in column D with the current values
You need average rating added as a fourth enrichment column
The tracker evolved and now needs a rating column that wasn't in the original setup.
For each TCIN in column A, fetch Target product details from the RedCircle API and write title in column B, price in column C, availability in column D, and average rating in column E — leave existing data in other columns untouched
You want a full cleanup-and-refresh in one pass
The sheet has some blank rows, some TCINs with stale data, and column A has a few typos where someone entered an 8-digit TCIN with a space.
Strip any whitespace from TCINs in column A, skip rows where column A is blank, fetch Target product details for all valid TCINs via RedCircle, and write title, price, availability, and rating into columns B through E — flag any TCIN that returns an error in column F
One prompt, one pass. The cleanup and the enrichment happen together.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Target TCINs, then tell it which columns to fill and what data to fetch. See also the spoke on building batch RedCircle collections or the hub overview on connecting RedCircle API to Google Sheets.