Loading...
Answers
MenuHow to get email contact list off of website on to spreadsheet for email marketing
Hi, there is a list of contact details (business name, owner name, email address) for an industry I serve available online publicly. The listing has 20 contacts per page and the rest are opened via pagination. There are between 4 and 5 thousand, I want to take the list and add it to a spreadsheet to upload to an email marketing platform. Would I need to manually copy and paste every one or is there some automated way of doing it?
Answers
The fastest way to accomplish this is probably to use Fiverr.com and hire someone to scrape the email addresses and send them to you in a spreadsheet. Or post an ad on Craigslist with a description of what you want and you will get a ton of responses. On Fiverr perform a search for "scrape emails from a website" and you shouldn't pay more than $5-$10 for the work. For DIY, you can use something like Import.io or Parsehub. The general term for this type of task is "website scraping." From a business perspective, I think it's better to pay someone else to do it because it costs nothing and will be faster than doing it yourself. Lots of websites block web scraping these days but people who sell scraping as a service will know how to get around that type of barrier.
Totally agree with Jeffrey on this. Also most no code parsing tools do not really work as expected most of the time. And websites change from time to time, rendering a one-of solution useless after a change in the code.
Plus you only pay for results and can determine the format you need for further processing.
Microsoft Excel has included many new features that have made the spreadsheets much easier to use. The first step in creating your email list from Excel is to prepare your list, meaning that you use a header row to define the content in each column of your spreadsheet. Managing email lists requires you to be knowledgeable about many list-building and management hacks.
You can read more here: https://www.campaignmonitor.com/resources/knowledge-base/how-do-i-create-an-email-list-from-excel/
Besides if you do have any questions give me a call: https://clarity.fm/joy-brotonath
Agree with others that, if you really want to do this, hire someone via a freelancing site.
But I'd ask first whether you really want or need to do this. Emailing people who haven't raised their hand to hear from you will almost definitely result in low opens, little engagement, and a problematic sender score.
You're better off attracting leads to you rather than landing in their inbox uninvited.
This can be so hard when you're a new business and you don't yet have a list. You might have to rely on paid tactics (ads and social posts) more at first than on organic. But, with the right strategy and content, eventually your organic will overtake your paid and you'll have an engaged list that actually turns into leads and customers. Not unsubscribes.
Related Questions
-
How do I get people to subscribe to my email newsletter?
I would seriously consider launching a blog and posting content of the same type to the blog, in abundance. Then add a popup box to the blog to collect email addresses. Post daily blog posts about topics related to your blog and your newsletter. If you do this consistently, over time, you will build up traffic to your blog and also get people entering their email into your popup. This is the free way to do it...EW
-
How do you approach an influencer, a "guru" or a podcaster /blogger in your niche offering a commission without being too direct?
Do the opposite. Think about it from their point of view. They get requests like these all the time and most of the time the request comes from random people they don't know. That would be kind of annoying right? You get an email from someone you don't know but they want you to do something for them? You'd delete that email too. Best way to get their attention...get a referral from someone they know and trust. Get someone else they know and trust to introduce you (this is the whole reason I built my business www.reverralriver.com). Referrals work the best. Second best way...develop a relationship with them before asking for anything. Don't email and ask for something right away. You wouldn't ask someone to marry you on a first date would you? Develop the relationship slowly. Give them value before ever asking for anything in return. Over just a few short weeks you could easily establish a relationship to the point where you could actually mention an "ask" which should be very open-ended and create absolutely zero work/friction for the person you are asking. One of my favorite techniques to warm-up a relationship...just email and tell them you appreciated (insert an article they wrote or service they provide, whatever, just stroke their ego). Tell them you're a fan and often point people their way. Then go way above and beyond and find their physical mailing address (it's not that hard to do) and send them a small gift or hand-written postcard in the mail just to say thanks. Then email them once you know they got it and just say thanks again. Then start emailing them various articles or things they might think are valuable, I'd say no more than once every 4 days. Connect on LinkedIN and message them funny pictures or GIF's. Show them you're human. Make them laugh and smile and just say "Hey I appreciate all you've done so just wanted to return the favor and make you smile (insert funny GIF here)". Then, once they know who you are, don't ask them directly to partner...ask them if they know anyone who would be interested in partnering. Below is a template I've used with great success...and the beauty is that they will often ask for more info and get interested themselves, but usually only if you have offered them some sort of value to stand out amongst the crowd. --- Hey (prospect first name), Hope you laughed at the last GIF I sent. I was just wondering if you knew anyone that would be interested in a partnership/affiliate opportunity… Real quick summary… I’m building a SaaS that automates the process of asking for referrals…it uses artificial intelligence to find potential leads in your existing customers network and makes it super simple for your customers to make the referral (one click of a button). If you know anyone that has an audience of people that would benefit from something like this I'd be grateful for an intro. I won't let you down I promise if you can make an intro. I’ll draft up all the marketing material and do all of the work, so all they would have to do is say “ok”, hit copy, paste, and send and I’d be happy to pay them 25% commission for life (or if there is another payment structure in mind I’m happy to talk about it) So what do you think? Can you help me out? Thanks, Parker ---- If you found this useful please upvote. Book a call with me if you want to know more or if I can help further.PW
-
How can I go about using social media outlets to attract new clients?
Hello, great question here. First of all you should understand that there is no 1 way and depending on who your audience is and what you sell the answer will definitely vary. A short answer however would be - engagement. Forget about likes and follows and shares are engagement, if you want to be a successful marketer you need to see engagement as conversations. The more conversations you can build around products the more you can rely on them to follow links or follow up on a request when you do make one. With that said, social media updates should be about what your followers want to see - depending on the social media - try to avoid being too pitchy on each post. My name is Humberto Valle, I have been a strategist for about 10 years now and have helped countless of entrepreneurs and businesses thrive through creative competitive strategy and marketing and I'm the co-founder of Unthink.Me. I hope my answer helps you a bit.HV
-
We are launching a white label platform on Goodsie targeting small/medium size design/devs firms. Any ideas on where to start our marketing efforts?
The 1st thing you should do it to identify 100 potential customers from your group to approach them and to offer them to use the platform to test it out. These people will not only give you feedback on how to improve it but also will give you testimonials for your website. The next thing to do (when you have the testimonials) is build some landing pages and to run some Google AdWords. Do some A/B testing and test different value propositions. I recommend adding some retargeting to your site so you don't lose visitors forever. When you have tested out which keywords work best, you cans tart investing more in SEO. It will take time to rank well but it's worth to start doing it early. Focus on content marketing that is related to your product and at the same time attracts and educates your target audience. Use ebook and webinars to generate leads and engage your audience. Don't forget to focus on blogging. That is really important in your type of business. Share your content on social media during the day. Use followerwonk to know when to share on Twitter and run some tests to figure out the best time for Facebook and Google+. Find influencers in your industry and connect with them online. These people will make the difference in your business. I believe in the first months you should focus on: 1. Getting feedback about your product 2. Generating leads through PPC, SEO, content marketing and social media. 3. Using your first users feedback to generate some publicity If you're looking for a more in-depth strategy for your business, don't hesitate to schedule a call for me. I'd love to learn more about what you're doing and to help you out craft the strategy that will help you achieve your goals. This is my VIP link for a free consultation https://clarity.fm/martinzhel/inboundMZ
-
What is the industry average conversion rate for cold emailing?
Cold emailing is just as bad for you and the recipient. Even if you have the perfect list, the attempt to sell in a cold email is rarely going to be effective. You're better off curating the list to the top prospects, find a mutual connection on LinkedIn or even just cold-invite them on LinkedIn,. Worst case scenario, send a 'permission pass' email where you simply gauge interest and let them know you won't be emailing them again if there's no interest. Keep it very short, non-commercial with just solid information/links to web, and an easy to reply yes/no answer.BI
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.