Shopify Scraper Template for Bulk Product Research

0:01 So here is a Shopify Scraper template . This is available for all members, monthly, yearly, lifetime members. If you're a member of Better Sheets, you can get this right now. 0:10 Here's how it started: I created this original concept where you put in a Shopify domain, and it literally uses a single formula , Shopify Scrape, and it's just going to grab. 0:25 All the list of products and their prices and also variants. It gets some other information. Well, I've added to this, I've made it a little bit better where you can do bulk. 0:34 So I'm going to show that right now. Better Sheets Members Tour March 2026 Get Sheet Done: Start Your Business in Sheets OnlySheets 5 Google Sheet Templates You’ll Get as a Better Sheets Member

But before I show you, I want to show you the trick that it uses here on Better Sheets. 0:41 We're going to go to App Script , but it actually, the App Script sort of does other things. I want to show you this. 0:48 Slash products.json. That's it. So if I go to a new URL, allbirds.com, and just do slash products.json, I'm going to click pretty print , and here is all of the information. 1:03 So this is really useful if you are just literally doing some research, competitor research or market research, and you're just copying and pasting this. 1:12 Stuff. Extract URLs from Google Sheets Advanced Coding in Google Sheets for Programmers SearchLord Scrape Google Maps in Google Sheets

Maybe you're already in a product, you're already building a product, you've already built it, you're already out there, and you just do one of price comparison. 1:20 This is great for that. You already know your domains, you already know what domains exist, or you're just saying, okay, what's out there, what's on the most popular, or what's on not popular. 1:32 So the other part of this function is just grabbing it using JSON.

A parse and URL fetch app and just going to that exact URL, getting that, literally, get content text, literally grabbing that text, and then mapping it out across the title, the vendor, the variance, price, and length. 1:51 Okay, way more stuff here. And you can get this. It's free for members. Go up to, just make a copy of this sheet into your. 2:02 Into your Google Drive. And let's set it up. So click Set Up Sheets. It's going to create domains and products. 2:09 And now, in domains, I'm going to paste. I have a list here. One second. I have a list of supplements. Build A Business: PR Agency in a Google Sheet Access Free API's with Google Sheets How To Sell Google Sheets For Fun And Profit 17 Minutes of Google Sheet Business Ideas

2:17 Like, let's say we are trying to figure out supplement prices across many, here's 10. And I want to do that, but I don't want to just use this formula . 2:29 So I can, I can put one of these, by the way. If I just have this here in B2, it's going to load this list. 2:38 Done. Easy. And all this is, is just Shopify scrape. That works. We can just go to any page, just equal Shopify. 2:49 Scrape, put in quotes, the domain, and it works. One thing I'll actually show you that I'm going to update here, go back to this code. Build A Business: PR Agency in a Google Sheet Shopify Scraper Bulk Keyword Search Across Many Sites

3:00 Above this function , I'm going to add a comment , and it's going to be at custom function . Doing that inside of your sheets means I don't have to. 3:13 Guess, I just do equals Shopify equals. Oh, I didn't save it, probably. Oh, it needs to be on. There we go. 3:28 Equals Shopify screen. There it is. It's already there. I don't have to like remember the whole function . Oh, I need the domain in quotes. 3:36 There you go. Okay, it worked like that, totally fine. But I want to take all of these domains, I want to get them into this products list. GPT in SHEETS Create Custom Functions in Google Sheets

3:44 Watch this, click Shopify Scraper , Scrape Domains. The first time it does it in your sheet, you're going to have to authorize it. 3:52 So it might take like a few clicks. But look at this. This get me, I think it was last time I did this, 1,200. 4:00 Oh, it actually. It's still going. There, it scraped nine domains. Ah, so it had an error on this one. Could be for a few reasons. 4:10 Maybe it's not a Shopify store. And it just will share with you the error here. Pretty cool, right? Pretty darn cool. 4:19 I've gotten 1,228 products into here. I have prices. I can now. 17 Minutes of Google Sheet Business Ideas

I'll sort this sheet by highest price. I can sort it by the actual thing. 4:33 And now you can do your own kind of work on this, right? Way protein blend, way protein isolate. Okay, those are differences. 4:43 Maybe you create like drop-down menus here and categorize these in your own way. These products, maybe it's like high-price products, low-priced product. 4:53 Here's a welcome gift, a free product. Let's see what that is. Like, let's go to A to Z . There's the free stuff. 5:00 Okay, now I can see Bloom New has some free stuff. Ghost Lifestyle has a test bundle. Get Nutrition Facts From Barcode in Google Sheets

Okay, that's probably just literally test intro bundle. 5:10 Okay, here's the lower price stuff, right? Okay. Now we can do our research. That's the whole thing. I hope you enjoy it. 5:17 I hope you enjoy the Shopify scraper . I hope you enjoyed also knowing this new URL thing hack, which is just add/slash products.json to the end of a Shopify store, and you get all of this stuff.