Hey there stranger!

Sign up to get access.

How to Make a Marketplace in a Google Sheet

About this Tutorial

Make a marketplace where sellers and buyers do not have to have edit access to a sheet.

Video Transcript

 Hello, welcome. I'm Andrew of Better Sheets. You may be watching this video in order to learn how to make a marketplace in a Google sheet. This is my implementation of it. I've used some interesting features of Google Sheets and tried to make something really cool. Hopefully you enjoyed using it and you wanna make one for yourself.

I run better sheets. You may be watching this as a member already. I released this early to members. Hello. And everyone in the public is actually able to see this. If you're a member, you are more than happy. I'm more than happy if you share this with anyone who wants to build a marketplace and a Google sheet.

When, if you become a member of, of Better Sheets, I go into a lot of the finer details of this. , right in this video, I am gonna like speed through all of the features and, and what I did to make it. I'm not really gonna go in depth into like exactly the functions and the functionality of what I made.

I'm just gonna show you how I made it and I think it has a really nifty trick to it. In order to unlist things, which was like the hardest problem of once you can like, add things to a Google sheet, but how do you take them off without having, without being able to edit a sheet which. Was the biggest problem to overcome.

So hopefully you enjoy this unwrapping of how I made s Smart, and I hope you can learn something from it too and hope you come and join better sheets and, and learn how to make really cool Google sheets like this. Okay, so the first step I'm gonna show you is just all of the sheets that are involved with this, they were hidden on our hidden for the normal user.

If you wanna make this sort of public and, and not show your work or this work, you can hide these and then people can just see this and click on these links to sell something. So let me do this. Let's add something. I'll go through quickly, all the four sheets and then we'll use it and I'll show you the finer details.

So the first sheet is sell. So this is literally a form and people list their items and then their contact information. And the idea is here, which we'll use later to unlist things. . The first filter we get, we get a filter and it says, okay, anything that has a timestamp of today minus seven, we get everything that's been posted within the last seven days.

So that's how, initially anything that's been one of the features is if it's been listed for more than seven days, it comes off. This is how we do it. We just use a filter that if it's within seven days, it's on. If it's not, it's off this filter or this or this. , this number or this column will come into play next.

I'll show you that in a second. So the second filter we go through is say, okay, filter for everything. We only want where the column G is equal to zero. So this is here, and what this is doing is it's matching anything on the sold and it's matching it just with the id. Okay. I don't know if that makes any sense, but basically people will sell, the functionality is people will add something here.

They'll input their own id, which I recommend a nine digit random number, and then they'll use that number to list it here. So anything that exists in both sheets shouldn't be listed. And then it gets filtered out here, so it doesn't show up here. And this is the final is we just take an array formula of this filter so we don't.

The ID, and I'll show you that in a second. Let me fill this up with a couple things and we'll show to fill it up. I'm just going to this link that I gave to sales. Okay. So I've filled, I've filled the marketplace with two items. Here's item one, item two, the description of each, the contact here. And now we can see in filter one, we have them here and they have literally a blank column here, filter two.

we see them listed here because they have fulfilled that they are not, they have a filter column G of zero. Okay. And they are not here on this sheet. So once they become sold, I just have to go unlist something and click on this one. And all we're doing is submitting the id. So let's submit item one, unique id.

Let's submit that.

And wait for it to update. There it is. It's off the list. So let's go back to, it is still on the cell list. It's on the filter one list, but now it has a match, right? So this array formula, it says match F two. This, this ID with whatever is sold on column B of sold. And if it matches what it's gonna do, it's gonna give you the row that.

Okay, so this actually comes into handy if you want to add things to this to know who, who sold it, when did it sell. You can do all that. Basically, you can take this, ID find out here and sit and figure out when it was sold. But that's some functionality we can add later. Like how many items are sold, how often they're sold.

You can do that later. That makes a sheet better and so unique. Item two is still here because it passes the filter of zero in this column.  because there's no match. It doesn't exist on the sold one. So it still exists and it will come off in seven days. In fact, let's try it. Okay, so just to test this out, I'm gonna try to edit this and I'm gonna say this was like put on two weeks ago.

All right. And so does this still exist on the marketplace? No, it doesn't because it go, doesn't pass the filter and it's done. We've unlisted. . So if you wanna learn how to make really cool Google Sheets, really cool functions and really creative uses of of Google Sheets, come check out better sheets.co.

If you're already a member, thanks for watching this and I would love your feedback if this is something that was like super useful or if this was like something you already knew. . If this is like a weird creative idea on how to, how to use Google Sheets and you use this, I would love to absolutely.

I would absolutely love to see your implementation and help you implement it in unique ways. There's so many things we can do better than this. Even. You can list like items sold, how many items. You can put a little dashboard here to show like how many items are for sale, how many sellers you can add in seller name or contact information.

You can combine. Really cool. But this is the bare bones basic, like here's a marketplace in a Google sheet without allowing anyone to edit except the owner of the Google Sheet. This is a really cool thing I've never seen implemented. If you know of someone else implementing something like this, I really wanna see it.

I wanna share it with the world and, and help the world make better sheets. Check out better sheets.co if you haven't already.