Upgrade Your Outreach LIVE COWORK SESSION
In this live coworking session, we build a Google Maps scraper designed for outreach, utilizing Google Sheets and Apps Script to automate the process of finding and contacting businesses via WhatsApp.
Okay, we're creating a Google map scraper from scratch here. Not really from scratch. We got a little bit of a head start. We're going to do this in real time because we have a huge head start. Uh we have used a Google map scraper and have made a video about this already, but I want to make it scraper for outreach.
tool I've been using. So, I've been making a tool and we'll just keep making it. I'm going to go through a bit of this. I don't know if I need reviews. Um, but we do need to set up the sheet and the app script . So, what is the old ultimate goal? Let's let's write that out so we know what clear goals we have.
include phone number and then we want to check for already outreached phone numbers. We've already outreached them. Then we want to set outreached. So basically just highlight and copy to outreach chat.
video already getting Google Maps to do this. Just intro search and get the uh responses that Google Maps would normally get. We get this kind of this WA's WhatsApp. Oh, um let's set it up.
have a link here that will include that message already. we click it and we send a message through WhatsApp. Um, so let's look at our app script . Um, so we have all this stuff here.
This always happens to be in a different stream on a different account. I don't really care about the reviews, but we do have it. Um, oh, I want to edit this so that it's actually one for us.
edit edit that later. Again, I'm trying to search for this is a sort of like a a live session to see how long it takes.
places on Google Maps, reach out to them by WhatsApp. Um, how what do you want to name it? Start a new project.
I'm basically enabling the API now just to get a new um a new API key so I can actually use this.
lot or it's the wrong guy. This is completed, but we didn't get anything back. So, let's log some stuff. We do need the correct API.
What is this? the right ACI maps platform API key.
Let's try it again just to see if it I'm going to delete this tab. So, by deleting the tab, I don't actually delete everything.
See what the response is. See if there's any no log whatsoever.
There we go. We needed to create that OP. Wow. Cool. So that's all we need to do is create that O client. And now it's suddenly working.
almond milk, and new type of milk, wonder." I wonder what's in the milk.
We want we want wrap or clip .
Just thinking out loud here. Does it look right? Like obviously we can move stuff around if we need to, but for what we need to do, I think feels right.
delete that. We will need to redo that API key when when this is published.
built by. Why did I say created by? Built by. Always built by. Um, this scraper and outreach manager enables you to quickly search via Google Maps API for some locations, get their phone numbers, and then outreach to them via WhatsApp.
and you saw me take a product from Okay, I use this internally, too. Now, anyone can make a copy of this and start using it. Pretty cool, right? Search Google Maps, upgrade your outreach.