The Scenario
You are a sales enablement lead. The new product line launches in three weeks. Reps need to start quoting immediately after launch, which means every product needs to be in HubSpot's product library before the kickoff call.
You have a Google Sheet with 50 products: name in column A, description in column B, unit price in column C, SKU in column D.
The slow version:
- You open HubSpot's product library and click "Create product"
- You fill in the four fields, save, and move to the next one
- At ten products per hour, this takes five hours
- By the time you are done, the pricing team has updated six of them
- You go back through and correct the six manually.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your pricing sheet and creates every HubSpot product in one pass, with product IDs written back per row.
Open the SheetXAI sidebar and type:
Create a HubSpot product for every row in this sheet using the name in column A, description in column B, unit price in column C, and SKU in column D. Write the created product ID to column E.
SheetXAI reads all 50 rows, calls the HubSpot product API for each, and writes the product ID back into column E. When pricing changes, you update the sheet and run a targeted update prompt.
What You Get
A sheet with column E populated and 50 products live in HubSpot's product library:
- Product records — name, description, price, and SKU set per row
- Product IDs in column E — so you can use them in follow-up line item operations
- No manual data entry in HubSpot's product UI
The product IDs in column E unlock the next step. Once you have the product IDs, you can create line items on deals from the same sheet: "For each deal ID in column A, create a line item using the product ID in column B and quantity in column C."
What If the Data Is Not Quite Ready
Pricing sheets assembled for launch are rarely in the exact format HubSpot expects.
When unit prices have currency symbols or commas
Column C has values like "$1,299.00" and HubSpot expects a plain number.
Clean the unit price values in column C: remove dollar signs and commas. Then create HubSpot products from all rows and write product IDs to column E.
When SKUs are missing for some rows
A few products do not have SKUs assigned yet. You want to create them anyway and flag the gap.
Create HubSpot products for all rows. If column D is blank, create the product without a SKU and write "NO SKU" in column F alongside the product ID in column E.
When some products already exist and you want to update them, not duplicate
The sheet is a full catalog refresh, not a new set. Some products are already in HubSpot.
For each row, check if a HubSpot product with the SKU in column D already exists. If it does, update the name, description, and unit price. If it does not, create it. Write the product ID to column E and "UPDATED" or "CREATED" to column F.
When you need products created and line items added to a deal in one pass
The sales team wants their first quote ready the moment the products are live. You have a deal ID waiting.
Create HubSpot products for every row in this sheet using columns A through D. Write product IDs to column E. Then add each product as a line item on deal ID [DEAL_ID] with quantity 1. Write the line item ID to column F.
The pattern: the pricing sheet is both the source of truth and the audit trail. Product IDs in column E mean you can chain into quoting operations without ever leaving the sheet.
Try It
Get the 7-day free trial of SheetXAI and open any pricing sheet, then ask it to load the products into HubSpot. The HubSpot integration is included in every SheetXAI plan. For related workflows, see how to bulk-create HubSpot deals from a pipeline sheet or the HubSpot in Google Sheets overview.