[Tutorial] How to generate leads automatically within Google sheets? (with a Free spreadsheet)
This tutorial including examples is also available in this Public spreadsheet I’m sharing with you my secrets when I have a list of contact I want to convert into leads. I broke down the process into 4 stages: scrape, clean, enrich, engage.
In this example I scraped (copied from a webpage) the best performing CEOs from HBR. I used the native IMPORTHTML method The data is often coming not cleaned – I made sure it is clean enough so addons can work with it Enrich – at this point I can search Linkedin 1 by 1 and copy to the sheet. I love my personal time so I used the “Linkedin Bulk Search” addon and got the linkedin profiles together with images Engage – now we can again go 1 by 1 and sent a personal message or use on of the linkedin automation tools to approach (use with caution!). Another option is to use an addon like “hunter” to get the email and send a cold email
Note – when outreaching always remember to send a message with high value and respect the other person boundaries
submitted by /u/trip_to_asia [link] [comments]