The Scenario
You are an SEO specialist at a digital agency. Your client migrated their store to CloudCart last month. The old site had 300 URLs and you have a complete mapping of old paths to new paths in a Google Sheet. Every redirect needs to be live in CloudCart so that the organic traffic the old site was receiving lands on the right new pages.
Google has already started re-crawling the old URLs. Every day without redirects is a day of ranking signal leaking.
The manual approach:
- Log into CloudCart and navigate to URL redirects
- Click "Add redirect"
- Paste the source path from the sheet, paste the target URL
- Save, click "Add redirect," repeat
- At 300 redirects, this takes the better part of a day
- You discover on row 200 that you have been pasting target URLs into the source field for the last fifteen rows, and now fifteen redirects loop back to the old paths.
One prompt handles all 300 correctly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the migration map and creates every redirect in CloudCart.
Open the SheetXAI sidebar and type:
Create a CloudCart URL redirect for every row in this sheet. Column A is the source path and column B is the target URL. Set the redirect type to "manual" for all rows. Write the CloudCart redirect ID into column C for each successful row and the failure reason into column D for any that fail.
SheetXAI reads all 300 rows, creates each redirect, and writes results back to the sheet. You finish with a complete audit trail of which redirects are live.
What You Get
A complete redirect implementation with confirmation:
- All 300 redirects created in CloudCart — source path and target URL from the sheet
- Column C with redirect IDs — proof of creation for each row, suitable for a client deliverable
- Column D failure log — any redirects that failed with a specific reason
The redirect IDs in column C are your client deliverable. You paste column C alongside column A in the handoff report: old path, new CloudCart redirect ID, done.
What If the Data Is Not Quite Ready
Migration maps are rarely clean on the first pass.
When source paths include the full domain instead of just the path
The developer exported the migration map with full URLs like https://oldsite.com/products/widget but CloudCart expects just the path /products/widget.
Strip the domain from all values in column A so only the path remains (starting with /). Then create CloudCart redirects for all rows using the cleaned source paths and the target URLs in column B.
When some target URLs are relative paths instead of absolute URLs
Column B has a mix of full URLs (https://newsite.com/products/widget) and relative paths (/products/widget). CloudCart requires absolute URLs for targets.
For any value in column B that does not start with "https://", prepend "https://newsite.cloudcart.net" to make it an absolute URL. Then create CloudCart redirects for all rows.
When the sheet has duplicate source paths
Some paths appear more than once in column A because the migration was assembled from multiple exports. Duplicate source paths in CloudCart will cause conflicts.
Deduplicate the sheet by column A (source path), keeping the last occurrence of each duplicate (last occurrence is most likely the correct final destination). Then create CloudCart redirects for the deduplicated rows.
When you need the full cleanup and import in one pass
Full domains in column A, relative paths in column B, duplicate source paths scattered through the sheet, and you need redirect IDs plus a summary for the client report.
Strip domains from column A source paths leaving only the path starting with /. For column B target URLs that are relative, prepend "https://newsite.cloudcart.net". Deduplicate by column A keeping the last occurrence. Create CloudCart URL redirects for all remaining rows as "manual" type. Write redirect IDs into column C and failures into column D. Add a summary in column F rows 1 to 4: total rows processed, redirects created, duplicates removed, failures.
The pattern: clean the source and target data inline, deduplicate, and create all redirects in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your migration map sheet, then ask it to create all redirects in CloudCart. The CloudCart integration is included in every SheetXAI plan. For related workflows, see how to bulk-create products from a catalog sheet or the CloudCart in Google Sheets overview.