every Shopify store's domain has a secret page that lists its products and prices. I've turned this into a Google sheet If you're doing market research, product research, competitor comparison, you might already be copy and pasting from a website into a Google Sheet, then doing your analysis one store at a time. you're gonna wanna use this sheet. This Google Sheet does it for one store or 100 stores in moments, literally seconds. I know this doesn't look like much, but this is so powerful. Created a Shopify scraper . It is free for all members, Better Sheets members, lifetime members, monthly members. Go grab it at bettersheets.co/templates. Uh, it is the latest bettersheets.co tutorial. I show you the, how to do this, and I show you all of what's going on, Shopify Scraper Template for Bulk Product Research Sell a Competitor Research Template Built in Google Sheets OnlySheets 17 Minutes of Google Sheet Business Ideas

and then you can just grab the sheet. I'm gonna just show you the output of this 'cause it's absolutely amazing. Take a- any Shopify URL, like allbirds.com. allbirds.com/products.json. Just add products.json to the end of any Shopify store and you can get the exact products and their price list. Now, if you don't wanna copy and paste this or figure out how to do the JSON, I've done this all for you. I've done this right here. So all you have to do, just go to any sheet, equals Shopify scrape, put in the domain, which is allbirds.com, and it's going to output in a moment, that was just, like, w- two seconds maybe, all of their products, all of their prices, all the number of variants. Shopify Scraper Template for Bulk Product Research Shopify Scraper Keyword Search Amazon in Google Sheets

Okay. But that's not all. I've ended up making this a bulk Shopify scraper . I think this is going to be so cool for those who are doing market research, for those who are doing anything where you're like, "Hey, I wanna find out what's the price of this thing across a bunch of Shopify stores." Okay, all I have to do is click set up sheets. It's gonna create two pages, domains and products. I can put in any number of domains here For this purpose, for this example, I am looking at like nutrition, uh, domains, and only like 10 of them. Maybe you have hundreds Look, all I have to do is go up to scrape domains, click button, and it will work. The very first time I run this, it will, uh, have, have to authorize it. Shopify Scraper Template for Bulk Product Research Build A Business: PR Agency in a Google Sheet 17 Minutes of Google Sheet Business Ideas

But all it's doing is going to that page, adding that products.json, trying to get all those products. This one does error out. Some of them do oddly. Sometimes it's not even a Shopify store here I click on products. That's 1,200 pro- and that was real time. Here's what I can do with this, this information. Okay. I can look at prices across the entire thing from highest to lowest. Let's go see that. So the highest priced thing is this Athletic Resilience Stack. I can click on the domain and see it. Like, I can go to it if I wanted to. I can see the title of the actual product, the actual price, how many variants there are. But that's not all. Like, look, I can add to th- now this is in my Google sheet, right? Shopify Scraper Template for Bulk Product Research Roasting Google Sheets Shopify Scraper 17 Minutes of Google Sheet Business Ideas

I can add to this. I can add my own sort of context. Maybe I want to add some kind of categories to this. Maybe I'm looking at competitor prices of the exact same thing, so I want to have, like, exact numbers here. Okay, this OG bundle or this protein powder, and how much is it? Oh, it actually says it here, five pounds. Okay, now I wanna mark over in another column, five pounds, five pounds, five pounds, five pounds, and then I wanna compare it to my price. And I, I'm like, "This is awesome." I think this is so cool and could really, really help market research, competitor research, product research, all kinds of things. I hope you get this. This is free for all members. For, like, nine bucks a month, you can start, you can grab this, and then you can cancel. I don't care. Just go grab this. But also, I care a little. 10 Google Sheets I Wish Someone Would Make Build A Business: PR Agency in a Google Sheet 5 Google Sheet Templates You’ll Get as a Better Sheets Member

I want you to have a better time in Google Sheets. Stop copy and pasting. Stop, uh, redesigning your sheets without any knowledge. I show you so much cool stuff in Google Sheets that you can do with Google Sheets, without Google Sheets. Without? That's weird to say. But yeah, I really want to, to hear what you else you wanna do from this. Um, I showed this to a few people before when I was like, "Oh, I just have this, like, weird little scraper thing." They're like, "Oh, I want to scrape a ton of sites." Okay, it's done. What do you want out of this? What are you looking to do on Shopify with this data ? Do you want some more formulas here that are very specific to c- cracking the code of these titles? Like, if they have numbers. They're, they're all over the place. 10 Google Sheets I Wish Someone Would Make When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa Advanced Coding in Google Sheets for Programmers How To Sell Google Sheets For Fun And Profit

Like, here's $175 value, 139. Buy four, get one free. Do you wanna know when the number … um, when it lists the word free, when it's get, when it's pounds, when it's this? Like, oh my God, I can show you so many cool little formulas you can add. But what should I show you? Comment down below. I'm more than happy to keep adding to this You're watching Better Sheets here on YouTube. Watch this video or this video. It's gonna make your Google Sheets better Go ahead, ask me anything down below in the comments . And I'm going to answer it in a future video become a member of Better Sheets today. . You get videos, you get sheets. So what do I have to do to get you into a brand new Google Sheet? Go buy some tools that I've built inside of Google Sheets doing things in Google Better Sheets Members Tour March 2026 Absolute Basics of Google Sheets Better Sheets Videos Checklist How To Sell Google Sheets For Fun And Profit

Sheets you never thought possible. Go check it out Announcing OnlySheets Great Sheets! Seedtable Created an amazing Community Board SHEETS and SHEET NEW FORMULAS in Google Sheets