In this short guide, you will learn how to scrape and verify emails for free in Google Sheets. All you’re going to need to have is a list of your prospects and the domain names of their respective companies.
How to scrape and verify emails in Google Sheets
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.
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.
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.
Bring more of you into every deal
Captivate prospects and clients with personalized experiences, access real-time engagement analytics, and win more deals.
Watch deck links examples
Deck links created by some of our users.
Never lose control of the sales process. Equip your product champion or a gatekeeper with a presentation video that can be shared with the decision-makers. Don’t let your message get lost in translation.
Build customer loyalty and reduce churn. Create videos that will keep your audience engaged. Maintain great customer experience. Educate your clients about new products and offerings. Expand average account size.
Build trust and long-term relationships with donors. Create videos, share your mission and values, and connect with the donors on a human level. Make it easy for the donors to give by including a ‘Donate’ button on your video.
TIPS FROM SALES LEADERS
VIDEO SALES TIPS
Quick Video SALES TIPS from Sales Leaders and Sales Influencers in the B2B space.