Shopify URLs, right in Google Sheets
Get the .myshopify.com URL for any store, one cell at a time or a whole list at once. Clone the template and start in seconds.
Clone the template, or check a single URL in the browser.
=SHOPIFY_URL("polyandbark.com")Clone it, authorize it, use it.
Make a copy of the template, then follow these steps.
Make a copy
Click Add to Sheets above or go to File → Make a copy to get your own editable version.
Authorize the script
Open the ZevOps menu at the top and select Resolve Shopify URLs (Bulk).
Use the formula
In any cell, use the formula:
=SHOPIFY_URL("polyandbark.com")Or reference a cell: =SHOPIFY_URL(B2)
Bulk processing
Have a list of URLs? Highlight them all and click:
This processes every selected URL at once, which is much faster than formulas for large lists.
What you get back.
| Input | Output |
|---|---|
| doelashes.com | douxlashes.myshopify.com |
| polyandbark.com | poly-bark.myshopify.com |
| apple.com | Not Shopify |
Customize it, or skip the sheet.
Questions? Email z@zevops.dev
Want to customize it?
Clone the Apps Script project and make it your own. Fork it, modify it and use it in your own projects.
View and clone the Apps ScriptNeed to check a single URL?
Use our web-based extractor for quick lookups without opening a spreadsheet.
Try the web extractorWant this synced to your CRM automatically?
A spreadsheet is a good start. We build the integrations that keep Shopify, Stripe and your CRM matched on the myshopify URL without anyone pasting lists.