The Scenario
Your team is running a one-time competitive catalog scrape. You have 500 private-label competitor TCINs sitting in a Google Sheet, and you need current price, stock status, and product title for all of them. Running 500 individual API calls is a non-starter. RedCircle supports batch collection jobs for exactly this — but someone has to set that up.
A colleague started a ticket about this three weeks ago. It hasn't moved.
The bad version:
- Look up the RedCircle API documentation for the collections endpoint, try to figure out the request format for adding 500 items
- Write a script, test it locally, hit a rate limit error on the first batch of 50, start debugging
- Get the collection created, wait for it to run, download the result CSV, realize the column names in the output don't match what your sheet expects, and spend an hour renaming headers
Nobody hired you to be the person who writes batch API scripts. There's a quarterly review in two weeks and this data was supposed to be ready last Friday.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet. It can read the TCINs in your column, create a RedCircle collection, run it, and write the results back — treating the whole sequence as one job.
Create a RedCircle collection from all TCINs in column A, run it, and when complete write product title, current price, and stock status into columns B, C, and D
What You Get
- Column B: product title from the collection result
- Column C: current price (numeric)
- Column D: stock status ("In Stock", "Out of Stock")
Collection created and run in one operation. Results written back into the originating rows. Any TCINs that returned errors are noted in column E.
What If the Data Is Not Quite Ready
The collection has a 1,000-TCIN-per-batch limit and you have 500 — but you want to confirm the batching logic before running
You want to see what batches would be created before committing.
Read the TCINs in column A and show me how they would be split into RedCircle collection batches of 1000 — list the batch count and the row ranges for each batch in column F without creating the collection yet
You want to add a collection name and check status before importing results
Your team tracks collection IDs in a separate log and you need the name to match your naming convention.
Create a RedCircle collection named "Private Label Catalog Q2 2026" from all TCINs in column A, add all items, run it, and write the collection ID into cell F1 — then check status and write it into F2
The result set is large and you only want to import the in-stock items
500 TCINs is a lot. If half are out of stock, you want to filter before pasting into the tracker.
Fetch the completed result set from RedCircle collection ID col_123, filter to only rows where availability is in-stock, and write title, price, and stock status for those rows into columns B, C, and D
You want the full scrape plus a summary in one shot
After importing the results, you want a count of in-stock vs. out-of-stock items and an average price written to a summary row.
Create a RedCircle collection from TCINs in column A, run it, write title, price, and stock status into columns B, C, and D, then write a summary row at the bottom with the count of in-stock products, count of out-of-stock, and average price across all in-stock rows
The cleanup, the collection, the import, and the summary — one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of Target TCINs, then ask it to build and run a RedCircle collection and import the results. See also the spoke on bulk-adding TCINs to an existing collection, or the hub overview on connecting RedCircle API to Google Sheets.