Bulk Create Shopify Products from Google Sheets
Imports new products from a Google Sheet into Shopify by mapping columns like title, price.
What it does
Import new products into your Shopify store directly from a Google Sheet by mapping columns like title, price, and stock to create inventory items instantly. This workflow handles bulk creation for test or staging data while automatically skipping existing products based on slug matches.
Step by step
- Configure a Google Sheets webhook trigger to fire on row addition
- Map sheet columns (title, price, variants) to Shopify GraphQL mutation variables
- Implement a lookup step to check existing product slugs before creation
Where the LLM does the work
- Generate the specific GraphQL mutation string for bulk product creation with variant handling
- Draft error-handling logic that parses partial failures from the GraphQL response
- Create validation rules to ensure required fields like price and title are present and formatted correctly
Watch out for
GraphQL errors often return partial success data, so parse the response carefully to identify which items failed.
Price formatting issues can break inventory creation, so ensure all numeric values are passed as strings without currency symbols.
Tools that fit
GraphQL API Create products in Shopify via Admin API
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Bulk Create Shopify Products from Google Sheets: Imports new products from a Google Sheet into Shopify by mapping columns like title, price. ## Specification - What it does: Import new products into your Shopify store directly from a Google Sheet by mapping columns like title, price, and stock to create inventory items instantly. This workflow handles bulk creation for test or staging data while automatically skipping existing products based on slug matches. - Trigger: Run manually (Manual · on demand) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - Google Sheets: Source product data and inventory details - GraphQL: Create products in Shopify via Admin API ## Known pitfalls, handle each one explicitly in your implementation 1. GraphQL errors often return partial success data, so parse the response carefully to identify which items failed. 2. Price formatting issues can break inventory creation, so ensure all numeric values are passed as strings without currency symbols. ## Reference implementation https://n8n.io/workflows/5664 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/bulk-create-shopify-products-from-google-sheets/ via usecasesforagents.com
Frequently asked questions
Can I use a different Spreadsheet than Google Sheets?
Yes. Google Sheets is only the example spreadsheet in this recipe. The same flow works with Airtable, Baserow and Excel. Swap the spreadsheet connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Also fits E-commerce Operator.