How to Use Sheets For Network Building

How to use Sheets to build your network. Using new interfaces from Google, it's possible to add today date SUPER easily. Sheets have added much more integrations with all of Google Workspace. Contacts also called People Chips makes it possible to curate your network in a sheet.

How to Use Sheets For Network Building on YouTube

→ https://www.youtube.com/watch?v=eqFY29nbmOg

Transcript:

(00:00) So here's a really quick tip to build a network with Google Sheets, and it uses Google Sheets, but I also wanna show off some pretty cool in new interface changes, meaning chips. These are people, chips. So in the past, if you wanna create a network let's say you're like moving to a new town or moving into a new industry, and you're like, oh, okay, I know a few people, but I.
(00:21) Build a network, what you would do is, or what I suggest you do is create a sheet with just 52 rows. Put person, email the date, and then meet them After you meet them, send them a follow up email and say, Hey, is there one person that you would suggest I talk to based on our conversation? You must do this afterwards.
(00:41) And ev if every single person you meet suggests to you one person to. Then you will never run out of people to meet. This is a very fast and very good way to build a network. I used this when I first moved to Los Angeles. I literally went down a list of people I knew, met them, they suggested someone. I went and met them.
(01:00) I reached out to even cold emails and cold dms, and I got people on the books and I went and met them where they are made it really. Bottom of coffee and then they suggested someone else. I go and meet based on our conversation, based on what did we talk about? What did we need? What are like the next moves? And that's the key to this.
(01:18) But here's something about Google Sheets that's really fun, is this new people chips. Again, it used to be like you want to type in a person's name, you had to go find their email address somewhere else, and it's like sharon gmail.com. If I wanted to meet like Andrew myself, I'd go like Andrew at.
(01:36) Andrew gmail.com and I'd have to go find their email in my Gmail or in somewhere else. And then I'd have to write the date. If I wanted to write the date of when I met them, I'd have to be like, oh, when did I meet them? But now there's some really cool date chips and email chips that make all of this so much easier.
(01:52) So the date chip, I can just type in today. And there it goes. Hit enter and I have today, and this is a date that doesn't change. It used to be if I typed in equals today, this would get me the date of today, but it would also change an update every single day. But now at today, or that's actually wrong.
(02:12) I don't add the parenthesis. That's a muscle memory. But you could also do tomorrow. Okay, I'm gonna meet this person tomorrow. That's the date that I'm gonna meet them. And then whoever they suggested, I can write right here. This person in email has also gotten easier and I can only, and I can do it now in one column I can do at Andrew, and now it's gonna go through my, the people in my workspace.
(02:37) It's gonna suggest them. And now here's a people chip. It will give you this message here. So it just click, do not show again. And you can dis or you can just dismiss this message. Basically mention people are given might be given access to this document. You don't want to do that. And especially if you're trying to build a network.
(02:52) So to dismiss, but also click that. Do not share button. Do not ask again, button. All right. But now look at this email address has everything baked into it. It's a chip connected to my inbox, so I can even create a new email right here in one click. I don't have to open Gmail, copy and paste their email.
(03:14) I'm like, oh yeah, I want to do network building. Network building. Hey, we talked about whatever and wanted to know if there's one. If there's one more person you'd suggest I talk to about this, this is super fast and super easy to be able to, I'm just gonna delete that. But now this person and email is now just a contact.
(03:43) This is great. Makes. Awesome. Makes it so much easier to build a very quick list of peop network building. Makes it very easy to email them. Follow up, maybe I say follow up date as well. Follow up date. And so I have marked, what date did I meet them? Maybe this is meet date and then I can just ha oh I added them.
(04:07) I sent them an email. So I do at. Not, no, no parenthesis. I keep doing that at today. Okay. You actually need to get that at today. So if you go with here and just type in text and then delete it and add text again, it doesn't work at today. Now hit today's date. Boom. You can also do at date, and you have the options of date, today's date, and tomorrow's date and yesterday's date.
(04:31) So really easy sheet to build for network. Right inside of Google Sheets is gonna be connected to your Gmail. Great for a workspace also, great to build a contact list if you're creating new venture, any type of thing here. Really cool to see this being more in sheets is much more integrated into the workspace world, which it's our behavior.
(04:54) We already are right? We are already checking our Gmail and copy and past. Emails into here. We're already adding dates, doing such meeting dates, follow ups, all that kind of stuff. Now it's much more integrated. Really cool, and hopefully this has been a good tip for network building. Again, I've used this.
(05:11) Before one. Just build a list of people you wanna meet. Ask 'em to meet. Once you've met them, ask them for one more person to talk to someone to email or meet as well. And make sure you do that follow up. Follow up is so easy and so few people do it, that it is mind bogglingly effective to build the network.
(05:30) It's just do that follow up. Ask, Hey, is there one more person you would suggest talk to? And funny enough, that kind of favor never goes outta. Three months later, you can ask the same question. Six months later you can be like, Hey, I've made X and Y progress. Is there one more person you should, you suggest I talked to? So now as you're building your list, you don't need 52 people to meet once a week.
(05:51) You only need like 10. Then maybe five of them are gonna suggest someone else. So now you have 15. Then about, 15 weeks, you can suggest, hey is there one more person you would. Now you have 10 more people. So now you have 25. So in six months, in 26 weeks, you could build up a list of people to meet every single week just from starting with 10.
(06:11) Really easy and effective way to network build and Google Sheets is coming together, making it super easy and super fast to be able to do things like this much, much faster. Really cool update to Google Sheet's interface, and I thought this would be a fun video if you're trying to build your network, give you that little tip of follow up and ask for one suggestion.
(06:30) Thanks . So much for watching. Check out this video to make more money using Google sheets, you can sell Google sheet templates, Google sheet workflows, checklists. All kinds of things. Check out this video. And if you are looking to learn to code inside of Google sheets, check out this video, it is for existing programmers, but I think it also gives you a very quick introduction to what is possible inside of Google sheets.
(06:53) And maybe if you are like a sponge with information, you can catch on really quick, check out how to learn to code in Google sheets. If you're already an experienced programmer.