The Scenario
You're launching a new Paystack storefront for your Lagos fashion brand next Monday. The product catalog is ready — 20 items, each with a name, description, price in naira, and stock quantity — sitting in a Google Sheet that your merchandising coordinator built last week. Before the storefront goes live, every one of those products needs to be in Paystack.
Your developer is handling the checkout integration. Loading the catalog is supposed to be your job.
The bad version:
- You open Paystack, navigate to Commerce, click Create Product, and start filling in fields: name, description, price (in kobo — so you multiply by 100 in your head), quantity.
- On product 7 you realize you've been entering prices in naira, not kobo. Three products are priced at 1/100th of what they should be. You go back and fix them.
- On product 14 the description is two sentences and the Paystack form has a character limit you weren't aware of. You shorten the description in Paystack but now it doesn't match your sheet. You update the sheet too, wondering if anyone else has a copy.
20 products at 5 minutes each with two rounds of corrections is the better part of two hours. Your launch timeline has no slack in it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your product catalog and creates each Paystack product through the API — converting amounts, handling the storefront assignment — and writes a confirmation back to the sheet so you know what landed.
Create a new Paystack storefront called 'Lagos Fashion Hub', then for each row in this sheet create a product using columns A through D and add it to the storefront.
What You Get
- A new Paystack storefront created under the name you specified
- Each product row created as a Paystack product with name, description, price, and quantity
- Products added to the storefront automatically
- Confirmation or error written back to column E per row
What If the Data Is Not Quite Ready
Prices are in naira and need to be in kobo
Create a Paystack storefront called 'Lagos Fashion Hub', then for each row create a product using name from A, description from B, price from column C converted to kobo (multiplied by 100), and quantity from D — add each product to the storefront.
The storefront already exists and you just need to add products
For each row in this sheet, create a Paystack product using name from A, description from B, price from C in kobo, and quantity from D, then add it to my existing storefront with ID in cell F1.
Some descriptions are too long and need to be truncated to 200 characters
Create a Paystack product for each row using name from A, description from B truncated to 200 characters if needed, price from C converted to kobo, and quantity from D — then add each product to my storefront ID in cell F1. Write 'TRUNCATED' to column E for any row where the description was shortened.
Convert prices, truncate descriptions, and load all products in one shot
For each row in this sheet, convert the price in column C to kobo, truncate the description in column B to 200 characters (marking 'TRUNCATED' in column E if shortened), create a Paystack product using name from A, truncated description, converted price, and quantity from D, then add each product to the storefront ID in cell F1.
Loading 20 products in one prompt means your developer can preview the storefront the same afternoon — not waiting two days while you work through the UI.
Try It
Open the Google Sheet where your product catalog lives, then Get the 7-day free trial of SheetXAI and ask it to load your products into Paystack in bulk. For related workflows, see how to create payment pages for specific campaigns, or how to export your transaction history once sales start coming in.