Searching through LinkedIn, copying and pasting emails one-by-one, banging your head as half bounce back – we’ve all been there. Building great prospect lists shouldn’t be so painful. What if you could instantly scrape and verify emails in Google Sheets for free without installing any external tools or paying for subscriptions? Sounds too good to be true, but it’s easier than you think. In this step-by-step guide, I’ll walk you through a simple setup using Google Sheets formulas and Apps Scripts to scrape and verify emails in Google Sheets for free.
Step 1. Get the Email Finder Template.
Make a copy of this Email Finder template in Google Sheets.
Step 2. Add the list of your prospects.
Populate the first_name, last_name, and domain columns.
Tips on creating an inbound sales strategy optimized for the buyer’s journey. Accelerate growth with inbound tactics that attract and convert.
Step 3. Create email verification spreadsheet.
To automatically verify emails you need to create a new Google Sheets spreadsheet. Name if “Email verification spreadsheet” and leave it blank.
Step 4. Copy the “Email verification spreadsheet” ID.
Copy the “Email verification spreadsheet” ID by clicking on the address bar and selecting the spreadsheet ID as shown in the screenshot below.
Step 5. Go to "Apps Script".
Go back to your copy of the “Email Finder Template” and click “Extensions” and select “Apps Script” in the drop-down menu.
If you’re getting the “Sorry, unable to open the file at this time. Please check the address and try again.” error that means you need to log out of all of your Google Accounts and log in to the account that has your Email Finder Template.
Showcase your brand.
Create company profiles with custom banners and info-packages tailored to different industries.
Show your contact info easily accessible by your prospects and clients.
Add custom CTAs to drive prospects or clients to your calendar, sign up form, etc.
Collect feedback from prospects and clients. Feedback and reactions are not publicly visible.
Share any existing PDF presentations and documents.
4x Sales Content Engagement
Record and share Video PDF presentations and proposals and WOW your prospects and clients with the most personal customer experience. Access engagement analytics. Learn more.
Step 6. Paste the “Email verification spreadsheet” ID.
In the “Apps Script” window replace “COPY PASTE SPREADSHEET ID HERE” with the “Email verification spreadsheet” ID you copied in Step 4. Click “Save”.
Step 7. Run the Email Finder script.
Go back to “Email Finder Template” and press the purple button that says “Run the Script and Find emails”. You will need to give Google Permission to run the script.
Once the script is done scraping emails, it will populate the emails column with verified emails.
Is web scraping legal?
How can I turn scraped emails into leads?
Enrich scraped emails with additional data like names and job titles. Segment and tag leads, then reach out with personalized, relevant messaging and offers.
How can I optimize scraped emails for deliverability?
Verify emails for accuracy, target role-based emails, segment inactive emails, and comply with anti-spam laws to maximize deliverability.
What are the alternatives to web scraping for finding emails?
Alternatives include sourcing email lists from reputable providers, using business directories, attending events, and leveraging existing customer networks.
Crush sales quotas with ChatGPT. Identify SQLs, craft pitches, overcome sales objections and more with these advanced ChatGPT prompts.
Level up your sales skills and processes with the top ChatGPT plugins for cold emails, resumes, follow-ups and more. Boost results fast.
Use our ONLINE PDF compressor to compress PDFs and Learn 5 Other Ways how to reduce file size on Mac OFFLINE in Adobe, Keynote, Preview App.