The Scenario
Your sales engineering team is launching a new product line next week. Thirty new SKUs need to exist in Pipedrive's product catalog before the first demo goes out — each with a name, a product code, a unit price in USD, and a tax rate. The SKUs are in a Google Sheet. Someone built it from the product specs doc over the weekend.
The last time you added products to Pipedrive, you clicked through the Add Product form for each one. Name. Code. Price. Currency. Tax. Save. For 30 products that's about 150 field interactions. It's not hard. It's just the kind of work that feels like it should not require a human.
The bad version:
- You start adding products one by one through the Pipedrive UI
- On product 14 you notice someone named the SKU slightly differently in column A than in the original spec — instead of stopping, you keep going and leave a naming inconsistency in the catalog
- You finish all 30 and realize you forgot to fill in the tax rate for 8 of them because the column was easy to miss
Audit takes another 20 minutes. Three products need to be fixed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the SKU table and creates each Pipedrive product with all the fields populated — no form-clicking, no fields missed.
Create a Pipedrive product for each row in the NewSKUs sheet (columns: name, code, price, currency, tax_rate) and write the returned product_id into column F.
What You Get
- A Pipedrive product created for every row with name, code, price, currency, and tax rate populated
- The returned product_id written into column F so you have a record of what was created and can reference these products when attaching to deals
- Any row where creation fails — a duplicate product code, a missing required field — surfaces ERROR in column F rather than silently skipping
What If the Data Is Not Quite Ready
The price column has inconsistent formatting — some cells have dollar signs, some don't
Clean the price values in column C by removing any currency symbols or commas, then create a Pipedrive product for each row using the cleaned numeric price with currency from column D and tax from column E. Write the product_id into column F.
Some products in the sheet already exist in Pipedrive and should be updated rather than duplicated
For each row in NewSKUs, check if a Pipedrive product with the code in column B already exists. If it does, update its price and tax rate and write UPDATED into column F. If it doesn't exist, create it and write the new product_id into column F.
You need to add custom pricing units along with the base price
Create a Pipedrive product for each row in NewSKUs with name, code, and base price from columns A, B, and C. After creating each product, add a pricing unit with the unit name from column F and price from column G. Write the product_id into column H.
You need to create the products, link them to deals, and schedule a demo activity all in one pass
For each row in NewSKUs (columns: name, code, price, currency, tax_rate, deal_id): create the Pipedrive product, then attach it to the deal in column F using quantity 1 and the price from column C, then create a demo activity on that deal due in 3 business days. Write the product_id into column G, the attachment ID into column H, and the activity_id into column I.
The full launch sequence — product creation, deal attachment, demo scheduling — in one prompt rather than three separate operations.
Try It
If you have a SKU sheet waiting to be loaded into Pipedrive, Get the 7-day free trial of SheetXAI and ask it to run the import with IDs written back to the sheet. See the spoke on bulk adding products to deals if you want to attach these new products to existing quotes right after.