How to Scrape Emails and Verify Emails in Google Sheets for Free

Lidia Vijga

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.

Get the free 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.

To verify emails 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 to the 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.

Custom branding
Showcase your brand.
Video narrations
Easily video-narrate sales presentations or proposals when needed (otherwise video is optional). Redo slide if you made a mistake. Use built-in teleprompter to record longer videos.

Data rooms
Attach any supporting files and links. Make it easy for your prospects and clients to find the right information quickly.

Company profiles
Create company profiles with custom banners and info-packages tailored to different industries.
Contact details
Show your contact info easily accessible by your prospects and clients.
Custom CTAs
Add custom CTAs to drive prospects or clients to your calendar, sign up form, etc.
Engagement analytics
See how prospects and clients interact with your PDFs.

Feedback and Reactions
Collect feedback from prospects and clients. Feedback and reactions are not publicly visible.
Share PDFs
Share any existing PDF presentations and documents.
Live links
Share with a single link. Update files even after sharing your link. Get notified when your PDF is viewed. Turn off access anytime.

DeckLinks icon

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.

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.

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?

Web scraping publicly available data is typically legal but ensure you comply with a site’s terms of use. Avoid scraping private/protected data and overloading sites with requests. We highly recommend you consult with your legal council before attempting to do any web and/or email scraping.

Enrich scraped emails with additional data like names and job titles. Segment and tag leads, then reach out with personalized, relevant messaging and offers.

Verify emails for accuracy, target role-based emails, segment inactive emails, and comply with anti-spam laws to maximize deliverability.

Alternatives include sourcing email lists from reputable providers, using business directories, attending events, and leveraging existing customer networks.

About the Author

Lidia Vijga is a seasoned professional with 10 years of first-hand experience in B2B sales and B2B marketing. She has a proven track record of driving growth for companies across various industries. Throughout her career, Lidia has led numerous successful sales campaigns and implemented innovative marketing strategies that have significantly increased revenue and reduced customer acquisition cost for her clients. Lidia regularly shares her insights and experiences on LinkedIn, webinars, and public speaking engagements. Lidia believes in the power of personal qualities such as kindness, empathy, and the willingness to understand others. She is committed to empowering client-facing teams with tools that enhance their talent instead of automating it, and she firmly believes that teams that show their human side grow companies much faster.

Book a demo

We're happy to answer all your questions!


Live Q and A

Get 30 days free

Join 30-min live training – extend DeckLinks Business Plan free trial from 14 to 30 days. Watch a deck link example.

Share the article


Get our latest guides right in your inbox

DeckLinks - Tips and guides for the most ambitious teams

Table of Contents