The Scenario
You are a digital agency account manager. A new e-commerce client signed on Monday. Their HighLevel store needs to be ready before the site goes live next Friday.
You have an Excel workbook with 80 products on the Catalog tab — name, price, description, and SKU in columns A through D. Each product needs to be created in the client's HighLevel location. Once created, the product IDs need to go back into the workbook so the developer can reference them for checkout integration.
The slow version:
- Open HighLevel's product catalog
- Click "Add Product" for the first item
- Fill in name, price, description, SKU
- Save, copy the product ID, paste it into the workbook
- Close the product, go back, click "Add Product" for the next one
- Repeat 80 times
- By Thursday you have created 43 products and your wrist hurts.
The fast version is one prompt before Tuesday standup.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the Catalog tab, creates each product in HighLevel via the API, and writes the product ID back to column E, row by row.
Open the SheetXAI sidebar and type:
For each row in the Catalog tab, create a HighLevel product using the name in column A, price in column B, description in column C, and SKU in column D under location ID in cell F1. Write the created product ID back to column E when done.
SheetXAI iterates through all 80 rows, posts each product to the HighLevel catalog API, and writes the returned product ID to column E.
What You Get
An 80-row Catalog tab with column E fully populated:
- Product ID — HighLevel's identifier for every created product, ready for the developer
You created 80 products without opening HighLevel's product form once. The developer gets every ID without a separate handoff conversation.
The product IDs in column E also serve as a creation log. If the checkout integration breaks on a specific product, you trace it straight back to the row.
What If the Data Is Not Quite Ready
Client catalog workbooks are rarely formatted for immediate API use.
When prices are stored as text with currency symbols
The client exported from Shopify and prices came out as "$49.99" with dollar signs and commas.
Strip dollar signs and commas from column B in the Catalog tab and convert to a numeric price. Then create a HighLevel product for each row using name in column A, cleaned price in column B, description in column C, and SKU in column D under location ID in cell F1. Write the product ID to column E.
When some products have pricing variants that need separate entries
Column F has a "Variants" column with entries like "S/M/L" or "Red/Blue."
For each row in the Catalog tab, create a HighLevel product using name in column A, base price in column B, description in column C, and SKU in column D under location ID in cell F1. If column F is not empty, parse the variant values and create a pricing variant for each one at the base price. Write the product ID to column E.
When you added more rows after a partial run and need to pick up where you left off
You created products for rows 1 through 40 yesterday. Column E already has IDs for those rows.
For every row in the Catalog tab where column E is empty, create a HighLevel product using name in column A, price in column B, description in column C, and SKU in column D under location ID in cell F1. Write the product ID to column E. Skip any row that already has a product ID in column E.
When the descriptions have leftover HTML tags from an old platform
The client's copy was exported from a platform that stored descriptions with HTML markup.
Strip HTML tags from column C in the Catalog tab and apply title case to all product names in column A. Then create a HighLevel product for each row using the cleaned name in column A, price in column B, cleaned description in column C, and SKU in column D under location ID in cell F1. Write the product ID to column E.
The pattern: describe the cleanup and the creation in one instruction. SheetXAI handles both without you touching the workbook manually first.
Try It
Get the 7-day free trial of SheetXAI and open any product catalog workbook, then ask it to create the products in your HighLevel location and write the IDs back. The HighLevel integration is included in every SheetXAI plan. For related workflows, see how to export a HighLevel product catalog with pricing variants or the HighLevel in Excel overview.