150 VCs Actively Investing by Lemon.io

Sheet was provided for free on Twitter by Lemon.io and here I converted it to look and feel like Lemon.io's awesome design on their website. Turning a Google sheet to dark mode is always fun.
Transcript

Watch on YouTube: https://www.youtube.com/watch?v=PXJI4SCsZZI

Transcript:
(00:00) Hello, welcome. We're gonna spend the next few minutes the duration of this video on improving this VC's list Google Sheet that I found on Twitter from Alexander. So Alexander said he's putting together a list of 150 VCs that are actively investing. . Um, which is really cool. And this is the type of thing that is fantastic for Google Sheets because it's very simple to create, uh, update and then release, right? And you can release this in seasons.
(00:29) You can say, you know, these bcs invested in the last three months and maybe you got to say a hundred, and then you went out to your. Private group or private network, and you said, Hey, I put together a hundred, but I want to get to like 200. Let me know if there's anyone on this list that I should take off, or is there anyone not on the list that I should add? And here's a criteria, and Alexander did this on Twitter.
(00:53) And so we're gonna go and take this. Uh, this is it. We're gonna take this sheet and we're gonna try to make it better. Uh, I'm gonna probably talk more about branding than anything else, but let's say 80 20 branding to, uh, usefulness and actually use, uh, helpfulness of this sheet and maybe a few things we can do differently.
(01:13) So I made a copy. I haven't done any work yet and I haven't also just checked out lemon.io, which is the reason that this all exists. This is a great lead magnet for lemon.io, where a. Works and is the founder of. So let's check out lemon.io. Oh my god, this is an awesome design. It is exactly. Uh, just neat.
(01:36) It is , uh, very distinct and I really wish that this Google sheet looked and felt like this website. So I'm gonna take a quick screenshot of this section and it looks like there's a yellow, but there's more of a green. Yeah, let's take this yellow and purple as well. A screenshot there. And I'm gonna go to HTML color codes.
(01:59) I'm gonna upload this file just to get the color codes. We'll have this later. Oh man, this is so cool. Uh, let's find the, there it is. Let's take this one first and we'll also grab the other one here to grab that yellow. So we want that color code yellow. We want maybe this purple. this purple.
(02:22) Probably the same purple as before, but yeah, we want that yellow. Definitely want that yellow. Um, we want this green and this purple here is probably the same purple as the other one. There we go. So we're gonna grab those. We're gonna have these color codes available to us. And let's just double check this is.
(02:39) What? That's zero. Zero, zero. Yeah. So this is a really cool use. I usually don't use the blackest black, but because lemon.io is, we're gonna do that, we're gonna make this like a dark version. I see that he tried these four different colors and had these distinct, you know, uh, the, the, what typically happens with a header, right? We want a bold header and then pastel.
(03:02) everything else. So I don't think that's necessarily the best, especially because we wanna brand the hell out of this Alexander who is putting this list out on Twitter for free. People can copy it just like I did and use it, and we want to make sure that people want to share this one, that it's useful, right? That's number one goal.
(03:21) It's useful and people use it and then they share it. Um, but second, once they share it, that there's a mechanism to get back. To us that we made it and it should feel like we made it right. This is for two reasons, one for branding, because people reading it want to then see like, who made this thing right? Oh, it's lemon.
(03:41) It's clearly lemon.io made this thing. But there's a secondary reason that is almost more important is like, we want to feel good working on this. We want to feel like it's ours. We wanna put our soul into it. We wanna put our, our. Demonn soul into it sometimes. So let's check this out. I want to create a start page first that has at least some branding on it.
(04:04) And this, this message, I'm only going to use a few columns and a few rows. We're just gonna put that right in the center. We're gonna use this. Where is it? Text wrapping. Hey friends. Actually we can put this on a whole, we can make this a lot easier to read. Hey friends, we've put together a list of vc, list of VCs, VC that are actively investing, and I hope it's helpful to you if you're right.
(04:34) Yeah, we can separate this a lot. Let's insert a row. ? Nope. Insert a row above. Uh, in case you are hiring, we are, we run a marketplace of vetted engineers from Europe and let 'em check us out. And that just that check us out is not enough. Let's have a much bolder, more interesting, uh, called action.
(04:58) And a button too, right? We're going to use. Let's say the blackest black. And for right now, the whitest white here. But we want to get a really cool button. I'm going to use my, uh, extension button styles. I need a three by three area. Uh, I'm gonna insert a few more things here. I want to create a cool button.
(05:20) Let's just do that. Uh, three by three. I need a three by three. That's it. I want extensions button styles. Show sidebar. So here we're gonna, uh, Button style. We're gonna be able to create our own button style. We want a background, which is gonna be, the button that people click is gonna be this yellow, this particular yellow.
(05:41) Let's use that. We can usually put in just the, uh, hex code here. There it is. I can't, D f F F. Zero. Zero. Okay. Since I can't copy and paste it. Do D F F F zero zero. Perfect. Hit enter the font color. We do want, ah, actually, do we want it white? No, we want it black. All right. I'm gonna close the original one.
(06:09) Let's go to ours. Font color. We want black, and we'll do the blackest black for right now. And the shadow color that's going to be, uh, let's make it this purple. Let's see what we got here. C five eight, F F F C five, eight. Let's see what this looks like if we do it. C five, F F F eight.
(06:35) That I don't think that's correct. No. C five, eight. F, F, F. Oh my God. So close. C five, eight. Nope. Gotta delete that eight. Put it here. There we go. All right. And now I'm gonna set the custom style and you'll see what happens. We got a cool button. That's it. There was one click. I did not, um, I did not pause this video.
(07:00) That's button styles. It's free. If you want to grab it. I'm gonna merge these cells across three. So it's, uh, we're gonna do right here. Merge these cells across so that way I think we messed up the text a little bit, but easy to fix by just merging these cells. Do, do, do. There it is.
(07:22) Now we got a cool button. Ah, one thing we need to do is free, uh, view show, take away those grid lines. I want to do that right here too. Before we do anything. Get rid of those grid lines. We're gonna add those grid lines back, uh, if we wish. Okay, so now we have this cool start page, right? We wanna start everyone here and we want this.
(07:41) Check it out, right? Lemon. We're gonna just write it. Lemon do io right there. Uh, I don't know what font they use. Mm, looks like a pretty cool, boldest, nice, nice font there. Uh, I'm going to use, I don't know if this is right, lemon.io with the press start. Now that doesn't look right.
(08:03) Maybe Comforta, but it's gonna be all caps. lemon.io definitely. Right? Because it's all caps here. Ooh. Maybe Oswald. Maybe Oswald would. Oswald would be cool. . Yeah. That's nice. Make it really big. Okay. Not that big. Yeah, that's cool. Nice. So now people can click here. Looks like a nice big button.
(08:25) Click lemon doo. Get right away there. Uh, we might even add this somewhere else if we want, but for right now, uh, we can actually just grab this, uh, one thing. Oh, we want to change this color back to black, I think. And do we want it to be underlined? We can take the underline. 50 50 on that. Uh, this text white is okay.
(08:48) I do want to give it a little bit more room. So something like that. Um, and vertical align. I think that's okay. Also, much more room to. right here. If they wanna write more stuff, if they want to introduce themselves, put a picture of themselves. I would highly recommend if you are a service or an agency, put a photo of yourself in here, in your Google sheet, in your lead magnet.
(09:16) Definitely. Like let people know you're a real human being behind all of this. Okay? Now what's cool is we can. this row. That does not mean that we have to get rid of all of our branding here, right? What we do want to do right now is change this all to black, uh, background change the text to all white, and now this is looking much more, very quick, right? Just this whole video so far is 10 minutes long.
(09:45) But right now, just that couple of clicks, we've now turned this much more into what looks like lemon. Right, and we're gonna do much more. So let's do this vc, uh, they chose roboto. I might do something weird, like really big headers. Um, this maybe call that activity and call this apply. and they did a really cool thing here by the way, and I should have mentioned this earlier, is there is just enough information to be interesting here.
(10:20) You have industry of the name of the vc, the industry, the stages at they're at right now. So originally when I was like looking at this, I was like, ah, man, there's probably a better way you could do this data. Uh, but all of the ways that I thought about it were like way complicated and sort of.
(10:37) If this is a lead magnet that's gonna be updated not every three months, but created a new one every three months or every qu uh, every year. Um, you might just want to have a little bit of text here instead of having like a dropdown menu and status and columns and stuff. So 50 50 on that. But let's get back to this header because I'm not done branding this.
(11:02) Uh, we wanna maybe bring. there. We could do something like this is bring in some color, right? Every other one could be a different color. That's it. Just three whites and then a pink and a purple. And maybe they're, maybe they wanna put maybe the make the apply. Uh, A different color and VC a different color.
(11:24) We, you know, honestly, we don't even need that vc. Like, we sort of get that these are names who they are. That helps a little bit getting into the information faster. Um, but we are not done. We are definitely not done. I'm gonna make these in the middle. Um, I want to change the, uh, alignment of these.
(11:48) I want them all to be in the middle. . I don't know if centered is correct for everything. Actually it's not. But I do think that to the right is good for this left column and there is a tiny little gap. I don't know if you can see it. I scroll, you can see it, but I might wanna make that a little bit bigger.
(12:06) So let's put a whole column there. and make it a tiny little row, but just a little bit bigger. I don't know why, but this feels right that we have a little bit more room or I think we can do that freeze. I think we can do that freeze instead of this. I'm gonna delete that column and just do that freeze.
(12:28) Yeah. It gives it a little bit more in this line. Uh, yes and no. I'm not, I'm not married to that at all. I think. We do need that blackboard there. Okay. To get more branding here. The problem with adding more branding on the data side of it is that generally we want to be more useful than branded. Yes.
(12:53) Like 80% useful to 20% branding, but we wanna brand the hell out of this thing. Right? We want to, we want our email, we want our, uh, contact information. We want, uh, we can create a whole nother. Uh, thing here called contact or hire because that's all what Lemon does. It says it higher devs. So all of this text we can put right here for people to see.
(13:23) Let's see. So right there, boom, boom, boom. There. Uh, delete that row. So we can have some more, I don't, I don't know what texts they might want on there, but they can do some more texts. We can call this VCs or database. I like calling it database or db, but maybe VCs, uh, let's do some more stuff here.
(13:50) Oh, we, okay, so we need to get branding in here, but we don't wanna get in the way of, of the usefulness of this. Right. Usually people will freeze this row. . And then what usually people do in branding is they'll add a row above and they'll say, lemon io, right? Contact us, which is what the original one was.
(14:13) But what I would do is I would have this row, I would. , I would freeze it, but I would put an additional row just under the frozen row. And this is where I would put lemon io uh, lemon.io branding. I would put it across the whole thing. I might even add two rows, insert another one. So I have, might have two rows so that it can be like a nice, let's see.
(14:38) Uh, just give it some. Uh, I think we have some. Yeah, we, we will do the, uh, borders soon. What do we want to do here? Let's take away all of, let's take a different color. Maybe here's where we can add that yellow in, or no, that purple right? Maybe we can even make it a purple line so we can do it if it, we, we don't want it so thick, we can delete this row, add a.
(15:10) thick border with this purple. At a purple line there. See? And now we can say this list is brought, is was created by the folks at Lemon. Now I'm saying this, I'm writing these words. The list was created by the folks at Lemon, but um, perhaps. The people at Lemon will want to do, will want to write this in their words, we've created this list so that you can blah, blah, blah.
(15:43) Like I'm writing it about them, but they might run and write it about themselves. I would do a completely different, uh, font as well. Maybe, maybe this, maybe a bit bigger. Give it a little bit more room. Center it. I think it's already centered. Yeah. Maybe even give it a little bit more room. Why do I, and now the question is, why did I put it under the, uh, Frozen row.
(16:14) It's because the moment you scroll down, you now have all of the room here to, uh, use it. Actually, I will go to a hundred percent. I usually have it much, uh, zoomed in now I'll un zoom it. It'll zoom it out. This is what it looks like. So now we have much more room to actually use this list.
(16:30) Of course. I understand that in order to use the maximum length and also in order to sort this, if maybe you wanna sort it alphabetically or you want more sortable da, maybe there's more sortable data and some. Kinds of, uh, things. People will delete this. It's okay. We wanna add that branding just in case, but we wanna add, we don't ever wanna brand add branding one place.
(16:52) We have it on the start. Lemon io. We have it here. VCs, we have higher here. Uh, we'll even, I would even put it here. 100 V, 150 VCs that are actively invest. Buy lemon.io. I would add it right up at the top, right here on higher, right here at start. Know how to, I would have links back to those pages of like, you wanna hire, like maybe right here I put, wanna hire a dev? Let's make this way smaller, . Um, maybe make it centered.
(17:27) Centered. Yeah, it's all good. And maybe even make it. That, that looks cool, right? ? That's pretty weird. Wanna hire dev and then put a link here to higher the higher page. So now this is just linking to this page here. Higher. Uh, we can even make this a little less like that. And when somebody just scrolls over at there, oh, higher, maybe this industry and this activity are a little much, it's okay.
(17:59) We can bring it back down. and have this nice purple across, okay, now this data, what do we wanna do with this data? It's all 10. I don't like that it's 10. I would keep, I would get it at least 12, maybe even 14 or 16 font size. Um, people can always make it less. It's, I see people way less making their font larger and this just makes it so much easier to read.
(18:24) Like, ah, you, yeah, you wanna see that It's a long list. It's. But we also want to actually read it. Um, these all have links to them in the name. And then there's apply. So I like this. I like that there's an apply column. What I might do is add a column here, merge these two. So this is both apply.
(18:49) I think you'll see what I'm doing in a hot second. I'm gonna copy this over. And what I'm gonna do here is I'm, when it equals, hyperlink. The URL is going to be G three, the the cell to the right of it, and the link label. I'm gonna make an emoji, I'm gonna make an arrow. Um, there might be some other cool things like dev, like apply, like this might be a cool thing to do, this little emoji.
(19:21) Or let's do both. Let's do. an arrow and this, uh, let's center it. Let's make it way bigger. No, I mean like way bigger. Double. Yeah. That looks cool, right? We can even un uh, underline it. So if somebody scrolls over, it's at our offices now. We copy paste this all the way down. Ooh, cool.
(19:44) Right now we have not just this like link, that's a text we've now made. Sort of button, right? Um, I might do a little bit of, uh, alternating rows here of colors. Oh yeah. And then I would get rid of those borders for right now. We might add more borders later, but what this is doing, wait word.
(20:09) Let's do that again. Let's go here. Paste this or make it here. Oh, is that border still? there. Hmm. I think we need to do that. There we go. Okay. I would do one less, right? Maybe there might be a way to do it. Not one step less, but let's see if, go back to the black custom and I want like just a little pip over.
(20:38) , is it gonna be just zero two? 0 2, 0 2 maybe. I think that's almost the same. . Maybe we need to do just a little bit more. Oh, that's because it's, we wanna go up, let's do seven. Okay. That is no difference, right? Am I going crazy here? This is different, but it's not different. , we want J just barely different.
(21:06) . Maybe go there. . Okay. There. It's old. Oh my God. It's very hard to tell. But here's the cool thing that it will add a subtle line in between each one. So we're gonna take two of them. I'm just gonna copy and then we're gonna paste the value, uh, not paste value, sorry, paste. Special format only.
(21:26) Now that's cool. It is just barely noticeable that there is an alternating color here. not taking a full step across. We're just like a little bit, that's not, that's much nicer than adding those borders. We could do some cool things with maybe like purple and yellow borders, but we wanna leave yellow.
(21:47) Maybe actually change this text to that yellow. Yellow means action. I know earlier I had the industry as yellow and the activity yellow, but let's try to keep that yellow. Action. Right. Um, I think they do a what? Good job here with this yellow here. The buttons are this yellow. Yeah. That's cool. So like, this is a, this is actually could be um, yellow as well, right? Cuz it's a button we can press, we can go to that hyperlink.
(22:16) Um, I'm seeing this text is a little, that's why I say 14 or 16. Or what we could do is keep the name of it. Four, uh, 16 and maybe take this down to 12. Yeah. Nice. And maybe take the activity column too, down to 12, right? So we can fit in a lot more. Uh, this stage one might be very important cuz you're gonna probably like scroll through this and wanna read this first.
(22:50) Maybe industry first. I'm unable to really get gauge where the hierarchy is. Whoever wrote this will know what is the most important pieces of information. So what I would make those bigger and bolder. And, oh, one more thing I just remembered. Let's add this. We don't want the header to be exactly the same font as the text.
(23:15) We want it actually a little less. So before the, she was like bold header and then pastel. data, but what we wanna do in this is bring up more black into the text. So meaning gray, let's see how far we can, that's pretty cool. Right? So now it's, it's a little subtle hint, but it. Takes your eye from like seeing it all the time, even though it's big and it's bold.
(23:44) We might even make these like all caps industry, we might, uh, take these down to like 22 maybe to make it a little less in your face, but also maybe you wanna be in your face like this, you know, behold mighty devs you're searching for. Um, I would take this, this kind of text and put it on higher.
(24:06) I would also. that this guy, this guy's great. Let's get this guy onto the sheet so that there's some kind of messaging that's similar. We're gonna add him over here. Let's add some more. Let's insert a image over sales. Yeah, let's get you in there, sir. Love your look. Love this illustration.
(24:35) Right? Ooh, we need to add some more lines. Great. Nice. I have a little uh, issue. I think we can crop this in some way. It's okay for right now, . I'm gonna move him here. Great. I hate that little , the little yellow thing there, but it's okay. For now, this is just a test. Get rid of aerial. I don't know if we want Oswald here.
(25:02) Maybe Comforta or co. Ooh, this is nice. Codeine. Make that bigger. I want to merge horizontally. Yeah, this can even be bigger. There we go. Nice. Right. Big button. This looks like their homepage, right? It looks like a lemon io thing. It feels like a lemon io thing. Want to hire dev? Nice little. Uh, I think, uh, sideways font here was really cool.
(25:35) Um, we don't need this industry al caps, we don't even need all these big, but I think it just makes it look different, right? Um, we still have all of these as Roberto, we end, we ended up putting. Font up higher. We added a little button here to apply so you can click here. Nice. Really, really like the look of this right? And like I said, we'd spend 80% of this time on branding, even though you really definitely wanna make sure that a sheet is useful.
(26:09) I thought this was really good sheet. I thought this was well done. It had just the right pieces of information to make decisions, right. Uh, people who need it want it right now. They don't want to be sifting through a lot of, uh, Filters and things. There's some lead magnets, magnets that are great for tracking an industry.
(26:27) This is like, Hey, here's a list of industry, uh, uh, VCs that are funding right now. Go through this list. I mean, someone who's gonna use this wants 150 items and will go through each and every one. So I was wrong in saying they won't sift, they will sift through it. They will go piece by piece, whereas there's other lead magnets and.
(26:46) Literally other sheets you can create that are like more filterable, indexable, uh, uh, an annotated, you can add more tools to it. I think the best thing I did here was just take a little bit of text away with this url, make it a little bit to the right and uh, have some iconography. You can also change this, right? Maybe this emoji is based.
(27:13) something here, right? Like based on what stage they're in, is what this emoji is. Um, or based on where, where it is, you can also, oh, let me, I, I will suggest one thing. If you're a better Sheets member and watching this, there's a video about bringing, do main icons, getting a company's icon just from their, their domain.
(27:35) I would do that here. There's a whole different video on that. That would be really cool because a lot of these, uh, Con, uh, URLs on the apply are the VC's, um, the VC's website, so you can get a lot of cool icons that way and make this little bit more icon I graphic. Alright, hopefully you enjoyed watching this video and got something out of it.
(28:01) Uh, thanks to Alexander for. Uh, sharing this, this VCs list. I hope this is a better version. I hope you feel better about this version, or at least even if you don't like this exact version, you took the direction that I was, uh, sharing with you and did that, right? You have this great illustration, these great bold colors on your website.
(28:21) Bring them into sheets. Put your fingerprint on this, put your soul into here, and then people will really feel it when they're going through this data and they'll really feel like, oh, I, I owe you one lemon, not lemon Alexander and lemon. Um, Photos, faces are gonna be great here just to make sure.
(28:38) Oh, cuz gosh, we do this all the time, right? Google sheets is so inhospitable. But we wanna see a face. We wanna say, we wanna know that a human was behind this. Someone else was here at this sheet, was on this place at this time, and helping us, giving us this . Information in this particular way. Thanks for watching that whole video.
(28:59) Hope you enjoyed seeing the change of that sheet. If you're looking for something like a dark mode, watch this video where I create basically a fake dark mode inside of Google sheets. You can turn on and off like a toggle with one click or watch this video where I go into 85 sheep domains or domains that have the word sheet in them and come up with.
(29:21) I try to come up with 85, business ideas with these available domains. Go check it out right now.