The Scenario
A vendor meeting is in six days. You're preparing a Target line review for 80 products and every one of them needs to be mapped to the correct Target category node — with the category ID, not just the name, because the submission portal requires it.
The person who knew the Target category hierarchy left the company in February. Their notes say "check the RedCircle API" and nothing else.
The bad version:
- Open the RedCircle docs, find the categories endpoint, run a test call, get a JSON blob back that has nested objects two levels deep
- Flatten the hierarchy into a workbook manually — copy parent category name, copy subcategory name, copy the ID for each subcategory, repeat for every node
- Realize the IDs in the response are in a different format than what the submission portal expects and spend an hour cross-referencing
The line review template is due Friday. This is the foundation everything else is built on, and right now it doesn't exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Excel workbook and connects to the RedCircle API. It can fetch the full Target category hierarchy and build the two-level structure directly in your worksheet.
Use the RedCircle API to list all Target top-level categories and write category name and ID into columns A and B of this sheet
What You Get
- Column A: top-level category name (e.g. "Grocery", "Health", "Electronics")
- Column B: category ID as returned by the RedCircle API
Every top-level category in the response populated in rows, one per row. No nested JSON to parse.
What If the Data Is Not Quite Ready
You need both levels — parent and subcategory — in a flat table
The submission portal wants parent category name, subcategory name, and subcategory ID on the same row.
Fetch Target category data from the RedCircle API and build a two-level hierarchy in this workbook — parent category name in column A, subcategory name in column B, and subcategory ID in column C
You only need the categories relevant to grocery and health
Your 80 products are all in those two sections — pulling the full hierarchy adds noise you don't need.
Fetch Target category data from the RedCircle API and write only subcategories under "Grocery" and "Health" into this sheet — parent category name in column A, subcategory name in column B, subcategory ID in column C
Your product list is already in the workbook and you want to map each one to a category
Column A has product names. You want a best-guess category mapping in column B based on the Target category tree.
Fetch the full Target category hierarchy from the RedCircle API, then for each product name in column A suggest the most likely Target category and write the category name and ID into columns B and C
You want the hierarchy plus a VLOOKUP-ready lookup table on a second worksheet
You need the flat hierarchy on Sheet1 and a clean lookup table on Sheet2 that your line review template can reference with a formula.
Fetch the full Target category hierarchy from the RedCircle API, write the two-level flat table on the worksheet named "Categories" with columns for parent name, subcategory name, and subcategory ID, then on the worksheet named "Lookup" write just subcategory name and ID as a clean two-column reference table
One prompt, two worksheets structured and ready.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're building product-to-category mappings, then ask it to pull the Target category hierarchy from RedCircle and structure it however your workflow needs. See also the spoke on searching Target keyword results or the hub overview on connecting RedCircle API to Excel.