all right so we are live first let's fix some uh video for uh Twitter we are going to uh try to keep uh the stream of today short but let's see how far we get um this way i think everything is So let me just try and fix this first i just want marketing i'm going to uh try something uh let's see let's see let's [Music] see i need a different style to make a short video about the scraper it has run all day all night had a couple of errors fixed that uh today and uh we already got 14 now 39 email addresses so and we have 23 rated so is this still running or this is giving okay this is running every half an hour let me uh do this bit faster for the stream uh another issue uh I had with the uh lead scraper is the this note the remove duplicates it didn't function so I had some issues with uh the place ID place ID is in the Google sheet it's over here this this row this column it gave uh yeah some errors because the same companies got scraped uh the status got uh set back to in progress so uh it gave a lot of errors so I changed this note to uh set no set has to uh the string is the website then we are going to remove the duplicate according to the website uh another issue I had with the crater was um was the let me think it was the email scraper didn't function this one it got stuck uh with this row because this website is offline so I need to uh fix that as well let me see oh and another thing that happened was that the zip codes um best thing you can do is just delete a lot of zip codes because if the companies are really close to each other uh you will just uh burn your uh rate limits pretty fast and uh you will not uh scrape any new companies so just remove a lot of zip codes i'm not sure how this will affect you in your own country but uh uh it's best to just remove them uh let me check if you will not uh sound okay I think the sound is okay right just let me know if uh the sound is uh having trouble uh got a school community still going join it if you want always happy to help so let's check oh man i just need a simple search i'm not really familiar with the advertisement with Cap Cut but let me just try to fix it myself otherwise I'm just going to send it to uh to my editor and uh let her do it but I like a little bit creativity and I think that I just need to find the this is nice let me check this one just need to find the correct uh let me grab the video I made all the need to find video let's see can let me let me do that for for a second [Music] studio just an area no no no no no wait wait wait wait wait i need this mic just a small area to take and this is all part of the building a brand a meaningful brand ready we're going to execute the workflow and we got an error so let me fix this what is the error aha let me run so the status is done let me go to the result and the website's offline so uh okay that's something let me just uh fix this uh column status is offline and done so just keeping my uh to-do list in the no in the chat okay so I need to do this and then it will work for this one as well for this one as well oh no no no no no no no this one so I need to fix that as well it's something we are going to fix okay let's restart the recording then execute workflow again first let me just delete this and remove the sound i don't want any sounds zero nice export social media yep let's uh and file studio no man let's Okay let's do Yeah let's do the best quality doesn't matter really just a small uh Oh let me check if you can see my screen oh you can't okay I'm working uh uh I recorded with Screen Studio and just uh creating a little clip first part scraper wait be right back with the second one so we are going to play this one as well let me just zoom out a bit let me get my Okay it's done let me enlarge the area a bit so it's all inside and the execute button as well and let's wait for it to start and let's execute the workflow yeah this this is so satisfying something I will need to film building a brand is part of the daily routine so let me get my chem flake well no no no no no come on see we are going to watch the game remove that and let's see okay it didn't already start right no it didn't all right this turn so I will need to edit that one as well re remove and and reduce the volume to zero and eventually do like this i'll shorten the clip because didn't pay attention it's still running running this knife export it and generate leads from maps then we are going to do this one let me just remove this for a second save to workflow is it done no not yet uh Champions League where are you so let's go uh where is the not on for you so let's do the second one here we are make it a bit smaller start recording wait for a second and then execute this one as well great just short clip volume to zero like this export export it uh brushless and then we are going to Okay all right let's start this one start the recording let's go just uh recording uh a couple of uh [Music] um videos going to edit them uh so uh I can Okay so Oh this is okay i need to cut this part out because it's the wait note of 30 seconds and I will just uh cut it out so uh I can just uh edit it now we're using uh Screen Studio yeah it works okay i'm looking for the Okay it's uh we got the Sport Roland Ross and the Champions League final so pretty uh all right so just uh using uh screen studio to uh let me cut this weight note out so where does it start over here wait wait wait and I think it's done here and now let's cut this out this out this 18 seconds so nice all right oh what was that okay nice okay fire crawl email creator nice okay so let me grab my cap cut uh let's upload the videos when they are done let me this these four all right so I've uploaded the clips to uh Oh damn i can't watch the but doesn't matter so I am going to Let's see [Music] uh Okay okay okay okay so uh I need to adjust this image as well uh let me pull up a screenshot of the template i think that will be uh good to show template where is my project it's over here so let's use this one just making a new video going to start the game on uh Okay so I've added a couple of things to the to the template let's see okay it's not working it i'm not going to do that where is my Where's the image i just I don't want that image oh my god I'm so bad with this how do I delete this okay nice uh delete this whole clip no I can't okay I can delete it like that so let's see let me first start the game so I won't What was it right so watching the game at Google Maps okay Google [Music] Maps Wraper get business information at the rate their website i need to adjust the text um this will need to be a different color oh wait i can do it yeah uh what is it videos okay let me just delete the video and why is it doing i just want to uh delete oh the Okay let me get a new uh template cuz this is uh Let me get a new template it's holding me up a bit but don't worry we are going to make this okay open see this will work better so let's check generate yeah let's try this one because this will work better so let's fix some bugs so the first one was the site this right let me check was this one so this the first one we're going to fix the this is reading the status done so we are let's update screenshot just making status done and we need to add the uh was it let me check the roll status is offline and XD is done all right so this is doing uh websites offline which one is this doing it not found that found i have to remember what And it's okay site is offline okay so in this workflow we are taking the screenshots and this is updating the website status and this is pulling x and this is pulling when xi is done so when the status is offline we have to set this to say the site is offline as well so when we are going to take a screenshot and we notice the website's offline it has to update this part as well to sites offline yeah let's do it like that okay so let's check i think it's fixed now and we are add rating to sheet so this has to be uh at rating to sheet at rated to sheet this will be easier to uh add rating to ship and this is at yeah bit uh error this is when not sure what that's doing but get this is updating yeah okay nice side of line hit okay what we are going to build uh tonight is uh uh pop up let me just forgot to post an X nice one definitely try out serless as well like this nice okay live uh stream for themsel final yeah uh if you are posting on X never post your uh URL in your first message always do it like this uh because Twitter want to hold you on their platform so never do it like this what we are going to do today so a bit of this and let me get what else now it's good for now uh how far is kept cut is it already doing [Music] something is it me or is the quality so shitty [Music] damn why is the quality so [Music] bad it's all so loud and Oh my god i just want to maybe I need to build u cursor for uh these kind of short clips and uh Victor is really nice dude you have to check his uh check his uh group on Twitter AI agent builders let's see damn okay okay what what he what did he build a web crawler AI bot okay that's something we are doing currently initialize crawling workflow with a form yeah [Music] yeah it's okay so let me uh Google maps scraper i exported it in uh in the best quality there was but it's uh Okay so let me see what I recorded it in a great quality but it's uh Okay for now that's okay man that's a freaking build i don't like uh I'm not a designer another video editor i just want to build [ __ ] okay let's get this uh let me check the executions everything is running okay why I don't see any new emails been added oh my god look it's I really need to fix this because it's deleting the emails the emails is this one running yeah this is it will run now it's running every 2 minutes I think is it what I That's okay let me see what is going on why there are no new email address added there are new companies done i want to download it and then you just Oh my god oh my god why is this text why do I remove that a really big written on the page travel [Music] Travel uh travel block how do I delete that person [Music] music this text Don't see anything how I should be able to fix this how do I delete this travel flock okay this is not [Music] uh you are This one need a small video from behind uh to post it's so [ __ ] hard okay let's see if the What did the scraper do it scraped this eagle found and it's this one okay so let's do it again it It's working but Okay email not found so let's check it is the email not on the website oh oh my god this Oh my god it is but it's on the I understand the [ __ ] email is found but okay let's do it uh manually and add the email um okay let's check this out the emails are scraped uh this is the uh the screenshot tool we're using let me just set it to 5 minutes so it runs every 5 minutes let's uh show how it works it grabs um a business with the status X it selects one item it's uh using a browser list to uh take a screenshot of the whole website it uploads it to uh the Google Drive and then updates the status on the it to done so we should see this row this is what we just did right let me check yeah of course nice let's run it again and eventually the goal is to uh Oh wait this website is offline is offline okay then the status will be updated to side of line and it will run again so what we are going to build nice this is running right this now running smoothly is to uh build one flow where we are going to send an email to those companies let me post this uh nice this is a nice video it's short but uh good uh built confused and then and browserless oh wait this one All right forgot one thing um if the website is uh No wait I guess five nice okay uh currently live let's build this currently live tell me all right so this was a long uh warming up we did but we are ready let's check the sheet nice it's working great okay let's uh let's start um what we are going to build is uh we just set this lead runner let me check yeah this what we are going to do as well we are going to delete some more zip codes uh like this and then going to do the same with all these so we will have bit less zip codes to grab but it will uh be better for the whole list so for now uh optimizing uh the zip code uh sheet is uh important really important because the yeah the the whole flow uh could break if you're not uh updating it uh and don't have the correct zip codes on it so as you can see yeah it's just it's this is really annoying it's still uh just scraping and updating okay this this is really annoying so let me add a note so before I release this whole uh workflow uh and uh it's uh really a plug and play i need to fix that one as well otherwise it will just keep going in a loop uh the email will be uh scraped for now yeah there are a couple of companies that I think they're doing such a great SEO because they are almost active in every zip code area so I need to find a solution for that if you have an idea just uh tell me in chat how I could uh do that currently have this remove duplicates but it's not working um for now it's okay let me go to the workflows I have and check the email sender where is it where's the email sending okay this one I'm going to duplicate this one send emails to Android same autoation and I'm going to refresh this page and bring this workflow to the right folder typical scrape workflow and it sits in this folder all right so this is what we are currently working with we have to select the correct sheet select the results and let me see the other workflow first how we previously set it up uh loading action okay so we're working with action action is currently empty so what we are going to do we are going to add a filter and we are going to pull the all the companies where the action area is empty then what we are going this is this will be the first email uh where we are going to create an outreach email and we are going to send because these are all caterers going to send them maybe I should filter them on the rating so when there are one or two what should I do um no let's just send them an email if they want automation just like this and I just created the video for it I will need to uh upload the video to let's see I need to upload it to I can just make a Where is it can I do something like this i'm just working in u uh Screen Studio Pro uh can I open it let me check is this a No it isn't so can I open It's not recorded with uh open last project show settings no no no can do it okay so let's see what would be best for this i don't want to do it in YouTube because yeah uh I could do it in YouTube but let me think about that how I should do that um okay I will just think about it later so name website email this is what we are going to uh it's a set note this what we using just to set all the correct credentials we have 247 items then uh what's important is the status is empty but we don't have all the email addresses yet so what we are going to do is just limit to 10 items because this Yeah we're just testing so we're limiting it to 10 items because we do have 10 emails then we are going to Okay uh do we need that now we could just set email found email not found if Let me check stair is in front there is or oh no let me just do it like this you know it's not empty this should be nine items and there's one empty so we check there's one empty so one two three four five six seven eight nine okay pretty good okay so we have selected nine items and we are going to create an HTML template with an email okay so what we are going to do we are going to our friends of ch and let's go to GT40 4.5 I want HTML active in the catering business and the idea I got is to use this hook uh start them with aation on NN where I do the cold outreach for them as a company and email all companies near their zip code area to inform them about their service and promote their catering to again so uh that uh during the holiday season there will be more business or then can you brainstorm with me about the one the first email um the second goal I have I have created their website as well and [Music] can host their whole website for 5 a month with email and for security like this uh I'm going to create the first email uh for now just create the first HTML template and let's think about it let's see uh where uh 4.1 comes up with how is the post doing so hard to uh to uh get noticed sometimes only thing that uh actually uh works is uh start as a reply guy just uh be a reply guy uh almost 200 followers come and uh join uh the group uh and uh let's start uh building together um okay let's see current hook refine your initial hook brainstorming use 10 automation to email nearby business and boost gathering sales during yeah maybe it's uh uh maybe I just need to email them uh not about NAN but just to start with uh Yeah yeah did Yeah i actually really like uh 4.5 for these kind of brainstorms okay uh oh maybe what I need to do is to fix the video video hosting free of stream or vimeu maybe I will do the fier [Music] thing uh join if Oh uh let's see maybe I will just upload the video to Femu and then uh Yeah man femu and they got a free uh Uh does canvas offer something like that uh what was that other thing not zoom but what was the other uh man what was it what was it what was it what was it i could do it on Let me just try something over here i could just do it on uh jump share there was another tool that was uh Why isn't this working check why is this working okay just uh trying to see if jump share is uh show your video at CTA at CTA call to action link LMD have spot I could okay uh link button text [Music] uh jump share free let me check 350 upload limit 1 minute time okay sick yeah going to do it with the jump share just setting it up and let me check um let's see what's good i think it's good to do something like this and uh right around it show my photo no not I need to upgrade [Music] can I embed the video i go to this page okay this pretty cool let's just uh do it for the first video with the jump share because I'm not really sure share video via link jump share looks all right yeah I'm not yeah for now it's okay let's just do a jump share this is a video I made about promotion and make the email in Dutch this is my Well so let's go to send automation grab the WhatsApp contact link and add it to the email as well oh damn i didn't didn't copy the link there it is now let's go put the freak what was that look look look the the workflow is running like a maniac scraping all the emails and adding them to the list set it to uh run every 2 minutes so yeah I like this screen a lot execution screen all green everything in the green so just adding of making the first outreach email and I have to change this because this Okay let's check this and then execute the step nice yeah okay uh yeah I just Yeah I could write the HTML myself but it's in Dutch the [Music] video there is the video again so I can see if this will Oh right a screenshot of the video yeah u not found this one you have to check that a second uh let's think about it and then maybe it's better to do just a YouTube uh or any other options no let's just do uh I'll just do a YouTube link and embed it myself make it a video upload maybe uh get a lot of more subscribers like that as well uh do a lead scraper just uh doesn't really matter i'm going to hide it so continue continue just uh creating a a YouTube video uh to uh oh wait am I able to embed embed the video if I if it's hidden i'm not sure where is it uh where's the link uh it's over here so let's do like this and then close it it's easy to step i don't think it will work video is hidden so let me just change the status of the video to mic okay just uh doing some steps uh like this go check the video uh like this then i don't really like the shiny emails and uh don't think people are into those emails just uh make it a bit boring but uh cool to uh see and to receive okay let's Oh this was the last email we of the last uh Hey what the freak on man why isn't uh videos okay html viewer html viewer and email let's see if the Yeah [Music] just Okay okay okay it's pretty okay it's pretty okay uh let me check with uh buddy of mine [Music] oh uh okay i think I need to make it clear in the email that the that the automation is set up with our system and that they don't need to do anything for it so I think to it's better to make it clear that that's the that we don't expect them to uh run the automation and uh do uh all sorts of uh stuff to automate themselves they just need Yeah how do I show them in the email [Music] uh okay let's try uh cloud and move on to it uh just doing it uh in Dutch this time to claw it try to see if it's uh okay champions League final is currently in the kickoff show so uh who do you think is going to win okay they're [Music] actually Oh no uh we can just set up an NHN interface for them set up the whole workflow for them create Yeah they don't need to know about Nad uh oh so yeah search for uh uh monthly fee for the outreach like this a monthly fee for the outreach so we could promote all kinds of uh doing a cold outreach is this a one time service could be could be a yearly service okay let's try this oh wait wait wait wait wait wait okay got some tips a bit social proof um yeah social proof let me think about that yeah yeah uh-huh thank you my beautiful wife brought me some tea hey darling stop it [Music] don't be my This uh this is a much better email this created by claw let me just make a screenshot let me see it's It's pretty good pretty good let's go to my HTML viewer and nice video is in it [Music] uh let me take a screenshot okay nice okay uh targeting messaging campaign settings no okay let's see if this will uh uh this will work i got a video removed it i got a video of the outreach working doing its thing [Music] um yeah I don't like the YouTube uh because they will see the stream as well they they could they could look up the company and uh see the stream like that but uh uh HC uh video embedding the embedding in mail i don't want to pay for it oh let me I know let me check something uh do I got my easy panel want to see if easy panel is offering something like that for let me go to the project and let me check video we have something shot no rereamer no chips sync No Daily Motion daily Motion is this still a thing let me see okay it's okay this uh Let me check sign up let me check how this is working on daily motion uh just uh looking for a way to uh embed the video in the email without using uh YouTube currently checking if video partner at video currently is checking if daily motion I can do it with the emotion next up category education okay go public safe are people uh still using that emotion or I just Oh my god private no be private review nice okay is this working is it public okay this public I'm uh working in uh six different uh screens just checking if I can uh share embed the video okay let's see delete that go where's the video html viewer I frame nice oh this is cool man okay there motion it is great tip my little brother okay nice so daily motion is uh pretty cool that's working okay uh so we built the Oh let me just uh for now okay let's delete this and this and the merge for now we're just uh creating uh the first outreach and that's this one so this is the template uh just one email we if you just joined I'm just doing a really short recap we are uh we scraped all these companies and we are uh scraping their emails from the website we are rating their website with an AI agent we have downloaded that there taken a screenshot of their website and the agent has raided the website and now we are going to email them so we have 248 companies let's see if the scraper is let me check where is the scraper this working because uh this I need to fix the because uh the remove duplicates tool is not working yes as you can see it's still getting oh my god all double just adding them again to the list so that's so annoying uh okay I need I will fix that when we have set this one up so we are going to uh set mil one so just leave it like this and uh for now it's okay then uh what we are doing in this part we are updating the we're using the name and then the email one okay we are updating the Google sheet with the let's uh do the name match on the name yeah we could match on the website i like website better cuz I'm matching on the website with all other uh workflows as well so update the email set email one so this is the first mill we are sending them so we're keeping track of what kind of mails we have sent them and let's do uh let's add another row so let's do it in this one let's change this to uh outreach and then uh outreach one so we are going to make outreach one is okay uh outreach called email because we're going to send another email outreach uh with the rating of the website if the website is bad uh that's maybe uh a bit bit harsh but uh if the website is uh okay this is working so the emails are set update in row no email so this is not necessary I think because we already did that okay so is this handle this um no email action i don't think this is necessary it just has to output the error and continue because this will uh let's do error trigger no no no wait let's do uh execute sub workflow executes the workflow and I have a special error workflow workflow name is uh called outreach error message is no email and last note executed is let's do this because it's better so now it's okay okay let's check this one okay let's remove that this the first mill to it's up here uh oh wait wait wait wait to uh check update email did I forget to Yeah I forgot set contact email i need to do email oh I need to uh do one more thing yaoja then I need to add the name because what the freak email oh this is the title of the email let's do Mark mark the name yeah that's nice uh This is cool this is pretty cool yeah um shall we call it outreach is that Is it really uh uh shall I call it outreach nice man look at this system is so correct like called outreach one email but we will need to update it because yeah uh is it called outreach no right we it's campaign installing end I need to adjust that one as well campaign let's see where is that oh wait I need to add my number need to add my WhatsApp number in there uh link it to add it here paste it like this okay so I'm just going to send them to WhatsApp and uh make sure they contact me on WhatsApp so it's in this part it's over here there let's move this i don't like this okay oh the game started the game started let's remove this yeah these are all AI uh dashes so when you're uh yeah a bit alpha when we're generating uh content always remove the AI dashes let's see let's run it and then this should work it's working video is working let me just update it and send one update this one as well and send one uh test mail to myself to uh just send myself portmation.org let's just Oh I need to add the subject was it So let's make the subject like this make an expression JSON name okay I need to grab the name limit name HTML more remove this one and edit and execute let's see if this will work send so let's check if I got email give it a couple of seconds let's see if the generate leads yeah that's okay it's still doing this so annoying i need to uh this the if this works and I got the email I'm going to fix that uh because the duplicates has to be removed from the from the list didn't got an email got an email give me oh my god oh I see what the problem was uh I forgot to uh set to execute it once so I got uh 9 mills okay uh uh okay looking at the email it isn't working the video isn't uh embedded in the email so let me check the HTML html is correct but I think let me check the email on my phone i think that's the problem okay then freeze them free is going to throw the ball next to the pitch so let's see the email isn't working yeah oh this is the hall of fame but no daily motion it's just continue playing so um what I just did was use this workflow sent the first uh test email to this uh outreach uh automation but uh the email is in plain text and not HTML we specifically said that the email should be in HTML so we will need to fix that um another thing we are going to fix is in this workflow we got uh a lead scraper it's scraping companies from uh Google Maps according to a zip code list but it's updating uh current scraped companies and uh this remove duplicates is not working so we're going to fix that one as well uh let me first see why it isn't why the email isn't showing up in HTML maybe let's just see why cuz I like this HTML a lot better maybe if we send let me just try uh execute just once and we're just sending on one email let me see if that was the issue because we all send nine emails at once so uh if you got any question about the workflows just uh you can just ask them yeah I like this workflow a lot so let's just organize a bit like this this closer uh yeah what another thing we are doing in this workflow is that we are scraping their email addresses uh then we are uh taking screenshots of their uh websites with this with browserless currently running every 3 minutes and this AI agent template is uh analyzing the screenshots and rating them this is the rating that you see in here so this should be a screenshot of our whole website and it is as you can see we can zoom in we can scroll to the screenshot and what is the rating that they did oh it's three stars and what's the full message designed decent with clear sections but the color scheme could be more professional and the content needs better organization yeah that's a pretty good uh analysis of the website so when we are uh doing the outreach for the website that's something we are uh mentioning to them as well so we are first going to send them an email to uh try to get them hooked on the outreach uh tool that we just built if they don't want to uh use the outreach tool then we are going to send them in a couple of weeks a new email so for example this website get a onestar rating this got a two star let's check it out oh this is two stars yeah yeah this is pretty bad this could be the screenshot as well because there is uh but uh and we're going to try to uh sell them uh website upgrade and the hosting uh upgrade so they twice [Music] All right let's check Twitter for a [Music] second nice okay uh let's see if the email has arrived okay still not let me try to fix that for a second [Music] let me go and try to fix this oh this one I forgot [Music] okay that's running so where is the Okay this is the Yeah this workshop i just try to fix the uh email sending problem so we are using HTML as email type we got a pretty cool HTML as well but the email is uh still in plain text uh we embedded a video in it so let's [Music] uh let's try to fix that one and then we can continue to fix the duplicate problem that we just had uh where's my screen i just noticed that the Xcode is really really bad uh badly rated private i want to [Music] be How many screens opened currently oh yeah uh we also are going to fix the crawl for AI service what I wanted to say just closing couple of windows because they were insanely Okay so this are my settings in HTML so one Paris Jame just scored just scored a goal nice oh let's [Music] see what the freak are they doing okay let me check the HTML one more time maybe that's the problem got a bit of scrap damn uh oh okay we can't uh I just find out we can't uh how to put a video in email okay I'll be just uh Okay I should create a thumb temp thumbnail just uh how can I uh embed a video into an email let me just check this share what holy smokes let's see now about [Music] the Okay so uh let me just take a screenshot of the template so uh let me take a screenshot here oh uh wait wait wait i need to remove this one for a second let me see need to save it okay uh that's saved so Mhm i like this new email [Music] just generating u I'll generate a thumbnail for the video and show that in the let's see running check the I need to fix this part this really annoying that website still adding duplicates so I'll need to uh maybe write a function out uh get at Rose do I have here so because it's at rows and sheet ed update oh wait wait wait wait wait wait wait wait uh when I do let's try it match them on the website and maybe that will fix it oh it's already updated nice let's try that and then run it one more time see if that will fix it no it's still uh adding uh duplicates okay we are going to fix that now because it will break uh the automation and then that's why it's uh not working so let's see why so in this step it's adding them and updating the status so phone number is working is the website in here updated or not because we are going to need the website to maybe we can adjust that note to just append and not update [Music] [Music] and we just append work because the duplicates are removed and we are just where's the phone number JSON place JSON place it's a pretty u base array [Music] base first [Music] number um code I don't Yeah we could add something like uh phone number and just remove it for now because yeah I don't want scrap the phone number let's just try it like this let's see what What happens because now they won't be added in here but they will be added down here I think and they're done let's see if what is it nothing uh two items didn't update at all no it didn't add them to the list uh let's see uh okay we have to append or update then see how much there should be now in the list oh wait they are They're over here uh okay just do it one more time because maybe I didn't search for them very good uh okay let's see if they are going to be added to the list new one two items two items one what is this okay this Okay but these are already in the list as you can see yeah so this uh team not found the this is already in the list so this is not working as well so we will have to find another solution for this let's see um see let me see shoot the faces [Applause] okay why this isn't Oh wait wait wait wait wait website website uh want to do it like this website Yuri website let me see website Yuri then in here cuz the the field is called website Yuri the JSON places place array just doing that let's website where is it website website Yuri let me just check if that could be that could be a thing yuri website Yuri okay let's check let's check this sheet cuz we will No it's not working i'll immediately see that we are finding duplicates are we still upgrading this i think we are okay we're still finding duplicates and oh we're also finding new ones let me check this one oh this is a new one as well so let's check how many 18 we found 18 this one this is four times the ship okay okay this might be This might be it but let's just do one more run because I still saw some [Music] here yeah you're still doing maybe I could add this [Music] yeah let me just remove some zip codes [Music] again like this removed rows go let's see what happened okay this one is scraped 14 items 14 items added to the list and still this is so annoying uh email not found here and here email found okay okay okay okay okay this is annoying this will break the workflow okay let's see it's not working but there are uh as you can see there are six 16 items entering 14 items going through the next part but there are are they let me check let me get this part and then go through [Music] uh and let me get this one after it's sent let me go to uh for this I got a special solution for it let's see if this will work oh wait let me go yeah not work you okay uh let's go to uh let's go to uh [Music] Gemini oh thank you this is this is the the the great thing about [Music] AI okay okay okay okay that's not correct there are things hey wait why this state doesn't have an email of course [ __ ] it up it found an email uh minding titf server desk nice uh and the site is not offline it's not offline right where is the say the websites of mine see what website oh yeah it's a redirect okay so let's do it like this for a second this one nice update offline Mr it's not offline sir yeah it's uh it's not an automation until you have tested it pretty good and then it will be an automation for now it's still in the test zone so it's it's outputting less items so here are 16 here are 14 let's try to take a piece let's try it like this got the [Music] order all right maybe I will create a function note to uh add to the see let me see let me see this is still going [Music] let me grab the Let me see where I got that this is pretty cool image all right uh I just created a new image for the outreach tool so let me check and so we [Music] can use that image uh oh my god the image isn't working uh why the image isn't working [Music] uh let me see why the image isn't working i can't download the image so uh that's a bit strange okay oh it is that was a bit uh strange but I couldn't download the image uh let me see okay nice uh okay and where is the image link we got an image link oh uh I mean the video link where is it so like this okay let's create a new outreach email and then get back to fixing uh the duplicates oh okay okay but I think for the most companies the URL is just is this one yeah that's just the annoying part sometimes the scraped URL without the HTTPS oh this Yeah this dude is is working as well this is working as well okay let's uh let's fix that that as well that we uh it scraped the email but it's we will need to add https to all these websites so let me fix that place ID when they how are they yeah like this okay uh function note let's create a function note for that okay let's try this one first uh function note okay let's check local will work five items swipe items so we got Okay no it didn't work uh okay progress but we got some new one new item [Music] there so let's check yeah I think we got the new item okay how is it passing and true where said URL the correct item that we need website URL JSON map item JSON website no it's this one let's try to run it again with this in it it's important to know uh a bit of JSON and uh to uh yeah know what you're doing otherwise running such an automation could be really really hard isn't removing removing the emails so that's good wait for Oh my god i found the phone number okay that's not what we are looking for okay um let's see okay uh let's clear this check i'll check here yeah let me check one thing based on place website Yuri because there's Uhhuh that that could be a thing that there are several website maybe we should do another name [Music] uh text display name text there's here there's a website y can I search website y can try this oh my god why is it freaking copying everything [Music] let's see this message is not too long okay nice look I replace key for item okay okay okay look nice this is a good thing we found that because there are there are two places where this is uh how you uh fix an automation and try to make it work especially if there are such small little annoying bugs that are uh breaking the whole automation because yeah this is breaking the automation uh and making sure that uh uh the next part scraping the emails isn't working because um let me gra this one the last execution this is not correct uh so when you are uh running uh a community or anything that's uh show me this man email found but there isn't an email okay all right we changed some fields empty exists but so yeah if the email exists then it has to be true but the email doesn't exist though why email is this is a success uh email not found so it has to update it email not found if the data email uh what does it expect to have is true for the first input item yeah but oh maybe because it's Yeah so we have [Music] to contains value this now it's false so let's run this one and then this should be email not found okay so this was a a little bug that is annoying but it's So let's do this and let's check it out why this isn't found all right this should They should have an email right they got an email damn they're almost everywhere these guys uh this uh this may be a good p page to add to scrape for an email they Yeah they got a phone number okay so it took the phone number because it couldn't find the email okay let's go let's go let's go um this is not working so let me see where the first website Yuri is let me just add it myself website Yuri is this the first one is the place it's the place theory place one and where's the other one uh is it somewhere point to other website add it to the URL reviews [Music] uh what's over here it's this one yeah this different one okay nice so let's try it again uh what we want to see is that there are less items [Music] added there's still it's not working okay so uh let's input let me check what's going on because uh this pretty annoying uh wait wait wait wait wait wait because I will share is that correct [Music] i am oh let me see this is going to work because uh it's pretty annoying that There are still okay okay so it wants another function not let's check that items yes status map yes status the map row okay so uh I'm not sure if this will work because I think it's just guessing yeah so it's just guessing that's what I net uh row constant query row JSON it does it got that row see if uh yeah this is updating the scraped companies it's this one no Yeah how are we going to fix that because we will need we will need uh this is a second step here uh just let's remove it for a second and this one as well that we are that's what we're going to do because uh I think I got a solution for this problem if you got any questions uh just uh send them in the chat about Naden uh if you're looking for a community uh currently uh building a meaningful brand all these templates just uh ready for you to download as well this outreach system that we're building now optimizing it you can download it as well um doing a live stream almost every day fully uh self-host your NN with all tutorials how to add uh browserless SSH key easy panel hookaro for your text to speech and one of the best uh I haven't seen anyone make an end video about this with the YouTube transcribe API So uh um you could uh just uh pay $3 a month to use it uh what I'm doing with it is uh it's this i'll show it let me get the workflow where is it i'm scraping to build a new template and it gave me an error today so I need to fix it I think but yeah it's giving me another error it's uh saying that uh this can't be found at zero can't be found but this Oh wait uh because it can't be found because why it can't be found didn't we pull a new video yeah we pulled a new video what's the video ID lt okay just checking something yeah okay this the video ID let me just try something new taking a tea drinking a lot of um tea lately to keep the voice nice and smooth i'm not a fan of ASMR but uh if you are you're not on the right channel um this [Music] What is my let me see just uh using uh using uh cursor as my terminal to check something on the server side so uh when that's done I will be hide building but I need to check it first because this is pretty annoying that it's not working now where oh it's over here okay [Music] oh let's see and this what's this doing info okay nice um okay so let's [Music] check oh wait ah this is so annoying forgetting to set the Oh my god okay for getting to uh incursor to set the agent to uh agent mode and uh just using off mode so for now uh yeah we were doing this let's continue let's continue with building and fixing the scraper um what we are going to do is because we are sending 19 items we could uh when we we could remove this one because I think in this phase we could add a Google sheet and uh get rows in sheet [Music] get all the results do we need We don't need to filter them oh we don't need to filter them we could just get them all oh wait let's turn on uh Okay let's see what's happen uh this is still going oh XXX let's enlarge this one so this keeps going and okay okay we got them all so 5,000 items okay that's a bit uh what we are going to do okay will it only get one item then because if it's Oh my god I forgot to Yeah I know i forgot to uh pin the previous results so uh copy to editor yeah copy editor let's pin them all and so we can test uh press P to to pin uh nodes so they won't make a new API call uh and we could just uh rerun the workflow without uh oh keep some data too lot okay okay okay so it's We will need to reload it yeah save it okay it's still here okay nice yeah okay let's just continue with this uh part and let's see if we can fix this part so we pulled all the uh rows from the sheet but I think we can add a filter if uh status email found email [Music] found at filter latest email not found uh no wait [Music] and say this in progress like this what happened yeah okay okay safe like [Music] this oh wait um I need to do remove this and or [Music] And the last [Music] one great execute let's see if this will work nice so these are all results we got so now we are going to check these 19 items with these items uh and then remove duplicates uh how to do it let's see remove duplicates remove repeated within current input what was this we select fields compare remove duplicates remove duplicates just to compare if I uh do it like a website website Yuri and then failure to the the DD pawn let's try will [Music] happen nothing Okay kept value is new remove value is new add field scope history size um if this will be able to run for me uh let's delete that one i want to so I want what I want is to compare let's just say yeah let's try my uh let's try this [Music] [Music] Okay so I Yeah what I thought was an if or a merge uh maybe a merge is better merge merge and then append matching [Music] fields but fields to match so what I could do is merge them if they are combine append yeah so what I could do is uh uh input one and input two and then uh fields to match this expression fields to match is the [Music] website no no no keep Enrich output too let's [Music] see okay let me check if this company is on the list is this in it in the file could this be the solution for it just pull them all merge them to one new output and continue let's see what will happen if we just fix it actually let's see oh this one this one is still it's just one okay there just one let me with the merge option let's just try it again try again there was just 19 items so now five five items five new items damn still uh this still okay so okay [Music] uh 83 oh we got an error i got an error in one of the executions and running a telegram uh bot which is uh sending me messages when I got an error in an execution like this email found oh yeah okay yeah that that's uh pretty annoying i'm running uh this workflow every 2 minutes so we will have to uh set it back to 5 minutes just hit the rate limit uh uh for it let's see which one we're running as well we're running this one as well taking screenshots and this is running every 3 minutes I think yeah or every five as well okay that's okay for now let's just continue fixing the other workflow is this the same yeah this is same okay uh this is screenshot one let's save it okay let's uh try to fix the [Music] the in progress status changing for already scraped companies so let me check this list because we are appending the companies that are already on the list and that's pretty annoying so like this one uh this is breaking the automation and we need to fix it okay so why did website Yuri oh look look look look undefined JSON website let me check why it's undefined okay that's strange could be the reason why it's input to one keep me just [Music] keep out multiple items there are multiple matches [Music] yeah let me I'm just trying to make sure the duplicate items aren't added to the list so like this uh as you can see the status changed to uh in progress but yeah that shouldn't be happening because we already checked those this uh will break the whole automation uh this one as well not sure maybe it's it's a caching problem because there time the same companies this one is just uh white undefined i could use field to match let me try the the place ID uh where is it oh uh it's this one to match on the place ID that's uh a unique number and both are having that one item one item sent so one item is updated it should so how is that possible which item just got sent okay okay okay just that one so now that that item has been sent let's try it again so when two items two items are sent to the sheet which is it is two items so two items are sent already on the list uh yeah yeah i know okay uh another issue could be that the zip codes are just too close to each other so removed a lot of them and try to uh Yeah these are all Dutch zip codes i'm trying to uh see if let's see if we are Okay nine new items okay so this is okay so the merge isn't working so let's try another solution it's uh still uh adding uh those companies to the list nine items and place ID let me check if the place ID is uh [Music] uh already twice in the list on my over here it's on this one this is called And it's here and then it's here again yeah so annoying so this one got added three times to the Google [Music] sheet so we're going to delete it once and it's the Oh what was it it's over here row 16 and it's again on row oh okay this one okay nice so it just got added twice to the Google sheet but let's try another approach so we are merging them we are getting them all and then trying to merge them but that isn't working undefined so the place ID is undefined can I uh that maybe I should use that one field to match different names we uh try that place ID one and then uh where is it place ID let me try it like this so what will happen now five items are in simply the still not working oh my god this is annoying and there are each time the same company so uh place ID five and then when I open up this one these are the five so once I set it to expression input field one is the website URL and the remove duplicates is the I could use the phone number latitude it uh do it like this field two let's try it again it should work we should be able to merge the two items but maybe it looks like this i don't know that could be the problem the JSON place website is undefined so it can't be matched so because I think we can't set it up like this so for now let's see input one and input two it's not running at the same time so uh we will have to add something here let me see filter item let me try to remove this one and this and this and just add a filter so value one is website Yuri value two is let's see what will happen so we should only have one kept one so okay okay okay this uh okay this might be uh some might need to something so let's try to do it with the place ID and the place ID from this uh where is it here on top remove it we might be on to something oh this company has a really annoying one let me just fix the image found otherwise we will get some trouble with the other workflow still running taking screenshots and are there any new ones not yet so let's see i think we're on to something i think we could make it work like this so there's nine items we're filtering them we are discarding 282 and if there's just one item being sent let's check the zip codes again delete a lot of it and let's go try it again let's see how much we are going to send one item again it's a new one results no this is the new [Music] [Music] one and here are four items it's the first one oh table it's easier to see the first one this the second one sandwich shop uh what's the URL yeah this already in the list i know because I already scanned most of it earlier this one let me check if this one is already in the list yeah it is i think this is it we found the solution to fix the application problem and let's update it to MDK yeah I think this is it we're going this uh let's check because it's not updating the Oh wait wait wait wait what's this remote because this will give errors let's try to run it again because it's think uh there might be an issue yeah it's deleting stuff wait one item which one 17 party catering and which one did it just delete or did it add just an empty body catering found it just didn't do anything 11 oh wait party catering yeah okay okay uh it's adding empty rows why is it doing that uh we got another error let's see what error is uh it said we got an error here why oh what's it what set of line this one it's an old one okay okay okay it's a old one let me just continue uh let me just remove some more zip codes try to see if that's the issue i almost went with the left one type of [Music] line is it still yeah it's still adding empty okay uh we got 280 companies it's a bit uh it's okayish okayish um okay which zip code I just cut uh split out limit loop ships there 10 zip codes at once very zip code 96 111 961 Okay let me do it just like this and then just do the final couple of zip codes scrape them and let's see what companies we will get uh let's set the zip code two items oh nice look look look uh it's kept two items so this one progress and it set this one okay but it's sending 14 are they all the same yeah no yeah I know i know that this is the same so let's see the results okay we don't got the error with the in progress but we are there are adding empty lists so that's pretty annoying let's see if we will just progress [Music] okay let me get this uh and checking uh Let me just get the the zip codes because uh [Music] uh I need some more zip codes [Music] [Music] okay uh oh all right i just need this So I can't imagine that this are all the companies that we uh can uh find yeah it could be so only 280 companies it's uh it's okay it's uh yeah it's pretty it's okay but uh uh yeah let's try a different niche on a different in a different uh a different niche to see if that will help uh but for now I think the list is pretty complete yeah okay so this is good just say here okay uh during all these uh little issues let's see if this working now aha um this is what I mentioned youtube transcribe API uh if you are uh self-hosting and want to set this up go to the school community and here's a guide how you can set this up what we are doing here we are uh scraping a YouTube channel where we are going to create uh videos about uh we are uh generating a voice over so um we are just running this every 3 hours to get all the new videos of this YouTuber so if I run it again you will see that it won't uh continue because uh all the videos are already scraped um what I just did was uh just fix this there are it's looking for all the videos and checking them with the Google sheet we got so currently it just uh continuing to loop but eventually this will stop because there are no any new rows so uh when I go to this cute is this for now I think it hit an infinite loop so just stop it for a second so to try to see it's not equal to uh do we have stop workflow if it falls it just keep on looping but that shouldn't be the We don't want that output we want to stop it uh oh wait yeah wait we'll set a wait note for uh 3 hours wait let's do minutes and then 20 minutes 190 minutes uh 20 let's do 20 and when we run it again it will check oh this would be funny if there's just a new video uploaded yeah this Yeah I I just checked there isn't any new video so uh this shouldn't uh uh false oh wait it's false three items to true and one item to false see if it's okay no nice so it it had three items that were true it ran one item through the loop and now it's waiting 3 hours because the schedule trigger is also 3 hours to run again so then it will run again through the loop and check if there's new video it will run through the whole workflow if there isn't a new video it will just keep on looping so it's active and for now let's uh stop this execution and let's just handle the schedule trigger so as you can see uh these are all the videos that we are scraping so test that uh if you want to uh set it up for yourself and don't play yeah I before I had this I uh searched for a service that could uh do it for me yeah $40 a month for uh 10,000 churches it's uh it's insane so uh when you are self-hosting just uh set it up with this guide go to the school community link and install it uh if you want to get help with the self-hosting your NA10 uh two days ago I got a stream and set it up myself so go watch that stream or just uh check out uh the guides in the school community how to set it up uh this is a browserless a scraper uh Cooro is a texture speech model you could use the API and crawl for AI to uh crawl so let's check the final part of the final steps what we are doing we scraped all the companies we are rating them with an agent and now we are going to set up the gold outage email so let me get this okay uh [Music] okay okay so let's [Music] see let's update the This is delete and delete i'm going to update uh this uh zip code list and then start a new scrape to scrape even more companies oh let's do the final three yeah this is running on the schedule trigger as well every hour do it pin that because that's annoying um this is the taking screenshots and this is the scraper for the email and this is the uh outreach email template where we are sending the emails to the scraped websites see it's just Okay let's try this new list let's see how it Okay is this okay um yeah okay uh let me just check one thing because uh just uh trying to get a list of zip codes for Belgic and it's uh I'm going to set it up for Belgic as well so this could be something this actually might this is sound yeah okay what what did I just How did this happen it just returned mine own list on Yeah 94 017 it's not okay okay it's not uh me copy let me select it working and copy it don't copy it okay I'll download it let me just uh try to open up the list and uh it's a CSV file where am I okay uh going to see it okay it works okay that's our smaller list but let's just scrape the last two companies and then uh let's see what's happen it's going to uh be the output like the filter option a lot so three are kept which three are kept let's see what the output is 200 MB 222 is kept as well instagram let me just Yeah uh this this was something I uh thought about at Instagram and uh scrape that as well and send them a message on there as well that could be uh something it's uh still in progress but uh that could be something uh I add in the future um okay for now let's see let's see let's see let's see um okay this is kept a so the the 248 248 a is let me remove it and try to run it again and see if we are without errors one item is kept so this is row nine the Why is row nine kept so that's pretty ammon it's okay it's this one it's giving a lot of errors on bugs uh okay for now it's uh I think uh we're done with this yeah with this list okay nice let me grab the the Belgic uh zip codes as well 25 and try to do that in Belgic as well so oh wait wait wait wait let me see um what's the HTML fixed okay okay let's see if the HTML that we are Let me execute the step okay uh is this one going to work uh when I press this or go to the video yeah yeah this just uh small let me uh go to Canva and uh fix that image to make it more Canva such a great tool like this and this and then expand magic expand full page expand yeah so we are expanding the page then uh image free let me upload the image what oh man this bad this okay uh didn't expect uh to beat that so let's try this one it's pretty It's okay it's okay so let's download it download okay let's wait for a second upload it then uh let me see where the image is this image we grab the link of this video so where's the the image oh wait that's funny execute step yeah okay maybe a bit too much but max width height 100 yeah just testing to see yeah okay this won't work how to uh So let's just keep it like this and try to [Music] uh test the email so execute once okay let's send the email [Music] oh nice we got some okay let's see if the email is delivered and then uh I can schedule to uh send the email uh tomorrow yeah thanks brother always uh good to have you around and uh let's wait uh until you're back from your sabbatical and start uh building again bro okay let's wait for the email we only sent one right yeah okay okay so let's wait still no email okay um we have updated this one so for now what we can do is uh do like this duplicate this page come on okay uh results for uh let's see which uh niche we are going to scrape results for uh accounting like administration admin so we are going to delete all the results and then start a new scrape in a separated separated tab to start uh scraping them see it yeah nice okay so this is the beauty of uh when you got a working uh Okay okay okay it's uh the images okay I think we have to do just plain text because uh the output of the email is not that great it just let [Music] me Okay so let's see uh if Cloud can fix it first so that's the beauty of uh running an automation uh when you have uh set it up uh this is how I organize it uh create a new folder uh Google scraper admin and in that folder you're going to uh set the whole scraping template so what we are doing here is duplicate it and rename it to admin duplicate so it's now in uh this folder and we are going to move it to the next folder this the first one done uh this one we are also duplicating and we're calling it admin then we go to the folder and move it to the admin folder i will just show you in a couple of minutes how you can uh do this with an automation that's tested and running this one as well it's a screenshot admin duplicating it going to the current folder move it the admin folder and then close it and this one as well the email scraper duplicate it admin go to the folder and move it and just like that you have it this one as well go to the Yeah they can't see the folder because the Let me just do it like this and no you can't see it we have to go like this or is it I just delete it [Music] [Music] it's this one because uh admin uh this one isn't in the correct folder uh move to folder Google scraper okay now it is then you can just go to your admin folder and you can start your whole new outreach like this oh I think uh one of my videos is starting to pop let me check [Music] uh let's see uh there are four reactions to this video yeah a bit alpha for you watching uh don't use the N10 automation YouTube note just uh use uh uh a solution that I came up with and uh that's uh this one let me go to the one of the notes uh this one what we're doing is uh downloading it uploading it to the Google Drive downloading it and sending an an email to uh to a VA and the VA is uploading it to YouTube and just like that that's working a lot better than uh using u the automation tool because I think YouTube doesn't like that okay so generate leads what we are going to do is to get this uh zip codes this is for the catering companies what we are going to set up now is to ignore catering where is it where is it where is it ignore and go for let's see lawyers no we want administration where is it like cleaners marketing accountants i like bookies i want [Music] bookies take finish book handle okay [Music] um wellness center let's think about uh Okay let me go to uh is this actually not uh what's this that's the category of this administrative uh administration no I want to see accountant powder accountant booker bookowder bookowder okay let's uh add one out then uh what is the accountant let's add it and remove these two because let's see if we uh oh like this [Music] Let's uh check for a bit [Music] okay okay sent in blue Mailchimp let me check just one thing cuz the email is not getting sent in mail what do we have mailchimp Mandreil Outlook Milche Mail Gun Milk Check Mail Gun is it pricing pricing i want to know what cost is me 300 ms a day okay tracking analytics and web hooks let me just uh buy a mill gun i just need mill gun let me just set it up we are uh we built an uh [Music] what I want nope i don't want paid plan dude okay okay sign up annoying capture uh let me just setting up an uh account for milk and going to test uh an email uh them to see if it will work no gun [Music] uh okay immediately a very big popup just Oh I got an verification just continue with another yeah they are uh pushing hard on the capture just need to verify be right back [Music] uh let me get that go all right same one nice [Music] sh one man was a crazy crazy game nice okay I'm in so let's set up oh wait i can just maybe check something uh where was it mail gun okay credentials email domain API key okay key and email domain not sure what email domain is it's email domain okay i think it's the [Music] just my own email that I registered let's check if this uh I just got an uh save this thing okay uh okay uh let's see if this will work uh remove the Gmail part enter in no gun let's go okay no uh is this Yeah this is correct one I think update okay so we got HTML from email oh uh is this uh let's try this at will this work or do I need to use my um do I need to use my uh oh wait okay let this port do it like that cc no subject this test one html will be this oh nice let's just try okay from there should [Music] be this would be an issue i need to make a new account check your credentials uh not sure why I'm getting this oh wait yeah okay uh let's see okay next next next i want to use API curl i'm done nice we got a need download from uh I'm uh I think it's this forbidden this is sandbox but uh settings for sorry for the delay this a bit uh extra setting up if this uh won't work okay okay confirm uh let's see just added a new test email to uh from the pearl unbox from Come on try it again forbidden oh wait this like this extra a forbidden okay h it is pretty annoying let's see what am I doing wrong main settings sendings verify domains i never used the mail gun if you got any tips how to use setup mail gun welcome so mail yeah I got milkchin but mandril it's mandrel it's mandrel mand drill mandreil it's a bit uh yeah they all want to prevent you from uh sending too much emails or sending spam so oh it's paid Mailchimp at all yeah I really hate Mailchimp so just send an email yeah I could I could set this up and uh send uh and try it let me grab my credentials let's delete this otherwise it's just user password host okay uh I can uh self-host uh an option to uh set it up really want to test sending the HTML emails outside of Gmail so uh if that works I can just use uh outer workspace email i have an email here don't let me check just second checking I set up my email is it on Cloudflare yeah I think so uh automation.work DNS name servers Fenix default okay oh I think this is on my [Music] hosting let me check let me check this will work almost there almost [Music] there email accounts yeah it's over here oh nice okay I can just create an email uh or I can just use that one uh this one download profile [Music] uh okay let me see user is user is this [Music] password uh do I have the password somewhere here uh let's see oh password just to check or delete this account uh I've checked it so don't worry mail and host name oh wait wait wait wait wait wait wait i didn't see if it worked okay uh let's connect it and see if the test uh from email work to email support at work subject is test one HTML is this execute step let's Okay this would be great if this works as well we got a fallback for the Gmail yeah it's taking very long why this is taking so long let's just wait for it and uh this [Music] one yeah okay i think okay for now this is okay so what we are going to do we are going to scrape those zip codes then we are going to add them not to this result but to results for admin and that are the same one to get uh update status to success oh yeah this was this [Music] happens for a second that uh get [Music] subcategory let me try to see if this will Oh wait yeah yeah wait settings google Maps categories yes the URL zip codes company filtered zip codes uh not sure what I just did um [Music] uh like this yeah I [Music] think okay yeah I see we got to update this one as well to use it's checking out the zip codes and it's saying we already scraped all those zip codes so oh wait wait wait wait wait wait wait let's see [Music] okay uh oh so oh wait there's no data [Applause] okay uh okay let's just give it a second and like that we can just This is [Music] running beautiful so this is running that's running let's try it [Music] again oh yeah the uh Let's just do it like this try it again oh wait and then kill this one for the first for the first run I think we will need to uh remove those two yeah look nice this is sick nice so for the first uh Oh damn there are a lot just keep Okay it just keeps going 50 found okay so it's done is it didn't update this so this could be okay uh like this okay okay this timed out yeah I'm not even sure if this worked we just like this then save testing i don't think it worked yeah it doesn't work not for sure it's taking way too long perfect let me check the [Music] settings but find host name [Music] [Music] [Music] [Music] [Music] still testing so this this won't work uh let's see and to fix this one it's a code there it is category try to make that work sure if this is it no not yet need to update the zip codes on that page let me see i can connect with the settings okay this is settings yep scraped okay nice uh okay it says it's script and the final part is things number is empty okay category doesn't have that oh it has okay uh no way it didn't scrape all those right no way scrape them all no way i didn't scrape them all right this is all the companies of all these zip codes let's uh try this again because I think there is an issue with this note let me see i do it like this grab this one just checking something subcategory JSON no it's this one i need this i need this h like this okay okay I fixed it i think now it will just update yeah look nice okay so that was the first zip code and now we're going to scrape more so this is working pretty good uh let me just check one as well damn this is pretty okay so we are scraping now bookies we need more bookies there are a lot of bookies man damn so for the previous previous scrape we uh [Music] scraped the leads of uh catering companies so where is it this one uh yeah you're looking at that screen there's such a Oh wait you got an error yeah sorry man sorry sorry getting too much requests um [Music] [Music] okay okay uh I think if we uh do for the for the catering companies the same thing so select two uh possible options and we'll get much better results so just like this we're generating uh scraping so much new companies as you can see damn the work music stopped so it's time as you can see we are scraping bookies from Google Maps and this is the list of zip codes we're looking for um catering local what that's not okay why is it that we forget to No no no no no right no uh catering no it's ignored okay why is it scraping catering is this really a catering company yeah it is okay nice that's strange that's strange why is it doing that filter subcategory bookie bookie bookie key 105 okay it's Oh let me check 105 no it's ignored it shouldn't uh grab that one filter it's not equal to ignore so did I no it's really Oh look this is the problem i forget to use capital I let me just [Music] uh let me Okay that's just a stupid mistake i don't need to uh so that's why we we got so much results uh let me delete all these catering companies because we just want bookies um let me start over because this will uh destroy the Okay let me start over okay let's do it again and that was just a little minor hiccup yeah if you are uh looking for uh Nadm and uh looking for someone who could uh get you going and uh get you over that overwhelming feeling when you look at such a big workflow where to start where to adjust it how to improve it uh contact me i could do a live stream together with you and just uh uh get you a workflow completely free you can just go to sam automation work message me which workflow you want and uh we can just rebuild the workflow completely from scratch so you uh will get to know how to use it and I will help you get started so just uh send me a message on WhatsApp or of course uh you could also go to the school and uh get to the knowledge base and in the credentials you will find how to set up your Nitan credentials for all the services we're talked about so especially in this we are using a lot Google Sheets API so here's the full tutorial how to set up your credentials let's see now we are just scraping bookies and there are a lot of them damn it's u uh just one more run then I will set up the Where is it where is it where is it yeah this this is annoying this is something I will fix tomorrow because I'm not going to send the outreach emails now i'm just uh scraping scraping the companies okay let's see nice there are a lot of bookies bookie bookie bookie all right let's continue scrape more there is one just one item okay ah there's the rest 20 more let me check if they are nice so I think bookies will be a good uh customer for uh cold outreach as well especially uh uh another uh category I think thought about was personal trainers that's something I'm going to add let me check on Google Maps personal trainer is that something personal trainer sports hall personal trainer yeah yeah I think that's a good category to add there are personal trainer uh let's see because they could be this ignore with the capital I because otherwise we're going to scrape personal trainers nice okay if you can see the scraped amount of uh companies getting uh lower because we are uh scraping uh 75 zip codes in the Netherlands you could do this in uh the states as well uh in Belgic everywhere where you are you could just uh do it all right so thank you for watching this is the end of the stream uh see you next time bye-bye