The Scenario
You just reorganized the store. New collection structure, new product placement logic. The plan is mapped out in a Google Sheet — 300 rows, each one pairing a product ID with its target collection ID. Someone on the team did the thinking work. Now the question is who does the 300 clicks.
That person is apparently you.
The bad version:
- Open Shopify's collection editor for each target collection, click Add products, search for each product by title (because you can't search by ID), click Add.
- Realize after 20 collections that the admin doesn't let you bulk-add products to a custom collection without scrolling through the catalog each time.
- Try the workaround of editing the product and adding it to the collection from the product side — same click count, different screen.
300 product-collection assignments. One by one. That is not a job. That is a punishment.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the mapping data and creates Shopify collects — the product-collection associations — via the API, in one batch. You don't touch the admin.
For each row in my Collection Mapping sheet, add the product ID in column A to the Shopify custom collection with the ID in column B — write 'added' in column C for each success
What You Get
- A Shopify collect created for each row, linking the product to the specified collection.
- Column C updated with "added" for each success and an error message for any row where the product ID or collection ID wasn't found.
- The collection pages in your Shopify storefront update immediately once the collects are created.
What If the Data Is Not Quite Ready
Some products are already in the collection and the re-add would error
For each row in my Collection Mapping sheet where column C is blank, add the product ID in column A to the collection in column B — skip rows where the product is already a member — write 'added' or 'already in collection' into column C
Collection IDs are missing — you only have collection handles
For each row in my Collection Mapping sheet, look up the Shopify collection ID for the handle in column B, then add product ID in column A to that collection — write the resolved collection ID into column D and the result into column C
The mapping spans two tabs — core products on one, bundles on another
Add products to collections for all rows in my Core Mapping sheet (product ID in column A, collection ID in column B) and all rows in my Bundle Mapping sheet (same structure) — write the result into column C of whichever tab each row came from
Resolve handles, skip existing members, add from both tabs, and log collect IDs
For each row in my Collection Mapping sheet and my Bundle Mapping sheet where column C is blank, look up the collection ID from the handle in column B, add product ID in column A to that collection if not already a member — write the collect ID into column C and 'skipped' if already present
One prompt handles both tabs and the deduplication logic without a separate pre-check run.
Try It
Get the 7-day free trial of SheetXAI and open the collection mapping sheet from your store reorganization, then ask SheetXAI to create all 300 collects before the new navigation goes live. The next reorganization will use the same pattern. Also worth reading: how to remove orphaned collection associations, or the hub overview for all Shopify workflows.