The Scenario
Your competitive intelligence team just kicked off a one-time catalog scrape. The brief: load all 1,200 competitor TCINs into a RedCircle collection so the team can run pricing and availability checks across the full set. The TCINs are split across two worksheets — 800 in "Batch1" and 400 in "Batch2." RedCircle accepts up to 1,000 items per add call.
The team lead assigned this to you at 4 PM on a Tuesday. The collection needs to be ready to run by end of day.
The bad version:
- Read the RedCircle API documentation for the collections endpoint to understand the request format for bulk adds
- Write a script to read from both worksheets, combine the lists, split them into chunks of 1,000, and make the API calls in sequence
- Hit an authentication error on the second batch because the session token expired between calls, debug for 45 minutes, restart
You are supposed to be the competitive intelligence analyst, not the API integration engineer. End of day is in three hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads both worksheets in your Excel workbook and handles the batching logic for you. You tell it what to build — it handles how.
Create a new RedCircle collection named "Competitor Catalog Q2" and add all TCINs from column A across worksheets "Batch1" and "Batch2" as product requests in batches of 1000
What You Get
- A named RedCircle collection created via the API
- All 1,200 TCINs added in two sequential batches (1,000 + 200)
- The collection ID written into cell A1 of the active worksheet for reference
- A confirmation of total items added written into cell B1
What If the Data Is Not Quite Ready
You want to add to an existing collection rather than create a new one
The collection was already created last week with a different set of TCINs and you're extending it.
Add all TCINs from column A in worksheets "Batch1" and "Batch2" to RedCircle collection ID col_456 in sequential batches of 1000 and write the total request count confirmed into cell B1
Some TCINs across the two worksheets are duplicates from when the lists were assembled
The combined list has an unknown number of duplicates. You want to deduplicate before loading.
Combine all TCINs from column A in worksheets "Batch1" and "Batch2", remove duplicates, and add the unique TCINs to RedCircle collection col_456 in batches of 1000 — write the unique count into cell A1 and duplicate count removed into cell B1
You want to validate TCIN format before adding to the collection
Some TCINs may have been entered incorrectly — wrong length or non-numeric characters — and those will fail silently in the collection run.
Check all TCINs in column A across worksheets "Batch1" and "Batch2" — flag any that are not exactly 8 numeric digits in a separate worksheet named "Invalid", then add the valid TCINs to RedCircle collection col_456 in batches of 1000 and write the valid count and invalid count into cells A1 and B1
You want the full pipeline — validate, deduplicate, load, and confirm — in one shot
End of day is close. You need to hand off a collection ID and a count with confidence.
Combine TCINs from column A in worksheets "Batch1" and "Batch2", remove duplicates, validate that each is an 8-digit numeric string, add the valid unique TCINs to a new RedCircle collection named "Competitor Catalog Q2" in batches of 1000, write the collection ID into cell A1, total valid TCINs into B1, duplicates removed into C1, and invalid TCINs into D1
Collection loaded, counts documented, collection ID ready to hand off.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of Target TCINs, then ask it to build and populate a RedCircle collection for your next catalog run. See also the spoke on building and running batch collections or the hub overview on connecting RedCircle API to Excel.