Build cold email list. Send automated follow-ups. DEMO.
Thinking about cold emailing? This is my automated framework to do it. When dealing with cold emailing your are going to have basically two issues. First how to build the email list that contains name, last name, email address. Second how to send automated follow-ups. My framework does just that and even more, it’s fully automated thanks to Sheetsu.com. The only manual thing is collecting domain names.
Who is doing what?
I’m using Google Spreadsheet file to store domain names list. Clearbit.com for data enrichment so from just the domain name (example: RST-IT.com) Clearbit.com will give me the name, last name and valid email address of the employees that work there (example: Kriss, Marszalek, kriss@rst-it.com). To send data between Google Spreadsheet and Clearbit I’m going to be using Sheetsu.com. Sheetsu.com will push the output data the name, last name and valid email of the prospect to Google Spreadsheet file. The last thing is automated follow-ups. This can be done with FollowUpInc.com.
Test it for free ;)
1. Collect domain names and store them in Google Spreadsheet.
2. Sign up to Sheetsu.com
3. Sign up to Clearbit.com
4. Run PERL script (download link bellow)
5. Sign up to FollowUpInc.com
… collect prospects ;D
Get API key from Clearbit.com
Get API URL from Sheetsu.com
On Sheetsu.com first, create API by copying the link to your Google Spreadsheet file where you want to store domains list and emails list. When ready copy API URL to use it in PERL script.
Mac vs. PC
Mac users can grab PERL scripts provided in this example and just run them cause they have PERL language installed on their machines. Download, unzip archive to se directory in Desktop directory go to Terminal and run scripts. Windows users You will have to install PERL language. To do that go to the website download and install it on your machine.
Run the script and watch how your list is building
For Mac users. Unzip se.zip (se: Sheetsu Enrichment) to se directory in your Desktop directory. Then go to Terminal proceed like in the video. The Windows users don’t have to use chmod command. Scripts are written in PERL language.
> cd ~
> cd Desktop
> cd seScripts need to be executable files, use chmod command in the se directory where you have unzipped files from se.zip.
> chmod u+x *Run script that is doing it all ;)
Script name is 0_do_it_all.sh and it’s taking four parameters 1) sheet name where domains are stored in our example “domains” 2) sheet name where emails are stored in our example “emails” 3) Sheetsu API URL that you can take from Sheetsu.com 4) API KEY from Clearbit.com
./0_do_it_all.sh domains emails SHEETSU_API_URL CLEARBIT_API_KEYIt’s ready. You can right now #ProspectLikeCrazy cause #SheetsuConnectsItAll.
Prospects list ready — so send automated follow-up’s
Go to FollowUpInc.com and create the first campaign by providing the link to the prospects from Google Spreadsheet. Write the initial email, follow-ups emails, chose when to send automated follow-up. You can use key words like {{name}} {{last_name}} {{email}} in email content to make it more personal. You get the idea … ;D
Watch step by step video …
Links
https://goo.gl/CbZwiD — se.zip PERL script
https://docs.google.com — Google Docs for spreadsheet’s
https://sheetsu.com/ — pushing data from and to spreadsheet’s
https://clearbit.com/ — data enrichment
https://followupinc.com/ — automated follow-up’s
https://www.activestate.com/activeper... — PERL for Windows
Drop us an email at team@sheetsu.com. We are happy to talk with you.
