The Scenario
You are a commercial photography studio launching a new service menu for the upcoming season. You have 40 new products — commercial session packages, licensing tiers, and delivery add-ons — in a Google Sheet with product names, types, prices, and SKUs. You need them all in Tave before the first new inquiry comes in.
Tave's product management interface lets you add one product at a time.
The bad version:
- You open Tave, go to the Products section, and click "Add Product"
- You type the name, select the type, enter the price, and enter the SKU
- You save and click "Add Product" again
- Forty products means forty forms
- By product twenty-two you have entered the wrong price on three products and have to go back and edit them.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads each row and calls the Tave API to create the product.
Open the SheetXAI sidebar and type:
Create a product in Tave for each row in this sheet — column A is product name, B is product type, C is price, D is SKU. Write the result status into column E.
SheetXAI reads each row, creates the Tave product, and logs the result in column E. Forty products created. Done.
What You Get
Forty new Tave products, each with:
- Product name — from column A
- Product type — from column B
- Price — from column C
- SKU — from column D
- Status column — column E confirms success or surfaces an error with detail
If a SKU already exists in Tave, column E tells you which row conflicted so you can update the SKU and rerun just that row.
What If the Data Is Not Quite Ready
New service menus are drafted in a hurry. SheetXAI handles the messiness inline.
When product type values do not match Tave's accepted types
Your sheet has "Package" but Tave expects a specific product type ID or string.
For each row in this sheet, map the product type in column B to Tave's accepted product types — "Package" maps to "package", "Print" to "print", "Add-On" to "addon". Then create a Tave product using column A for name, the mapped type, column C for price, and column D for SKU. Write the result status into column E.
When some products are missing a SKU
A few rows have no SKU yet — you want them created with an auto-generated SKU based on name.
For rows where column D is blank, generate a SKU from the product name in column A — use the first three letters of each word, joined by a dash, in uppercase. Then create a Tave product for each row using column A for name, B for type, C for price, and the filled SKU. Write the result status and the generated SKU into columns E and F.
When prices include currency symbols that need stripping
Some cells have "$450.00" instead of "450.00."
Strip any currency symbols or commas from the values in column C before creating the Tave products. Then create one product per row using column A for name, B for type, cleaned price for price, and D for SKU. Write the result status into column E.
When you want to verify the product list matches what was approved before creating anything
You want a confirmation step before any products go live in Tave.
Read all rows in this sheet and write a summary below the data — count of products by type, total price range, and a list of any rows missing a price or SKU. I will review and confirm before you create any Tave products.
The pattern: instead of forty product forms, you describe the batch once and SheetXAI runs it across all rows.
Try It
Get the 7-day free trial of SheetXAI and open your price list, then ask it to create Tave products from every row. The Tave integration is included in every SheetXAI plan. For related workflows, see how to export the Tave product catalog for pricing review or the Tave in Google Sheets overview.