Hacking the Email Spreadsheet
After collecting a bunch of emails during a big launch or conference, we’re often left wondering “who are these people?” and “what’s the best way to get in touch?”. Buying a list of email addresses or a lead database presents a similar challenge. The easiest next step is to create a generic email campaign and get the average 2-3% click rate.
Since we launched StackLead on GrowthHackers and Hacker News, we’ve spoken with many salespeople and growth hackers with lists of email addresses that they want to contact, but don’t have a scalable way to personalize their outreach. Rapportive works well for understanding someone you’re about to contact, but can’t support researching and prioritizing hundreds or thousands of leads.
Researching a batch of email addresses is simple:
1) Open this Google Spreadsheet and click “Make a copy…” under the “File” menu.
2) Copy and paste the list of email addresses you want to research into the “Email” column.
3) If you don’t already have a StackLead account, register and copy your API key. Back in the spreadsheet, click “Preferences” under the “StackLead” menu.
You’ll be required to authorize the spreadsheet so that we can fill in the research data. If you’re having issues, please try logging out and logging back in with the correct Google Drive account (shown at the top right of the page).
And then you’ll be able to paste in your API key.
4) Click “Run StackLead” under the “StackLead” menu.
5) Wait for us to fill in the StackLead research data (we’ll mark processing or finished addresses in orange).
Note that this last step might take a few minutes depending on whether or not we’ve seen the email address(es) before. If you’re researching up to a thousand emails, it’s best to check back in 4-6 hours. For larger jobs or other custom requirements, please reach out at firstname.lastname@example.org.
Enjoy email spreadsheet research powered by StackLead. We’ll follow-up soon with a post on some useful ways to use this research data. Please let us know how we can help your sales process in the comments (or get in touch on Twitter).