Chapter 1 of 7 · Eight email columns
About this video
This video uses sample data, not real Scrap.io data. It doesn't show how to scrape. BillionVerify is not affiliated with or endorsed by Scrap.io. File verification needs a paid account.
Video transcript
Eight email columns
Scrap.io's sample export has eight columns that hold email addresses. Here's how to get them into one list you can verify. The sample file on Scrap.io's home page is a good map. Email holds one address. Then come Individual, Contact, Sales, Marketing, Finance and Administration email. File List Verify reads one column, normally the one called Email. Every other type stays unchecked. The eighth column, All emails, is different. In the sample it's JSON, one record per address, each with a category and the pages it came from. Two of those fields can look like verification: is disposable, and has MX. Both describe the domain. Neither tells you this one mailbox exists.
Trim before you stack
So start trimming. In the sample, about one row in five says yes under Is closed permanently. Those businesses are gone, so delete the rows first. Next, check the business type. Scrap.io searches secondary categories too, so unrelated shops can land in your file. The Main type column catches them. Now remove repeated places, using Google ID. Do it before you stack. After stacking, one place fills several rows on purpose, and that ID repeats for a good reason.
Stack into one column
Time to stack. Copy each email column under the last one, repeat the place on every new row, and add a column saying which type it came from. Name the address column email. And All emails? In the sample it holds 255 unique addresses, against 91 in the typed columns. Most of its records say category unknown. So stack the typed columns first, and save the JSON for your best accounts. If you do open it, read the category. Individual goes first. Info-contact and booking are shared inboxes. Recruitment is a hiring inbox, so leave it out.
Verify the stacked file
Now open File List Verify, and add the stacked file. This number is your test. Count the unique addresses in your new column. If the precheck is close, nothing got left behind. Click Verify and walk away. An email lands when the job finishes. That's a larger sample list, not a Scrap.io export. Your split won't match it.
Route each result
Valid addresses from the Individual column go first. Role results get a note written for the front desk. Catch-all goes out small. Unknown waits. Invalid joins a suppression list. Tick a status, then click Export Results. Your type column and Scrap.io's fields stay in the download, and our columns land at the end.
What it costs
Now the bill. Valid, invalid, catch-all and role use one credit each. Unknown, bad syntax and disposable cost nothing. File uploads need a paid account, and any credit purchase unlocks them.
Get started free
20 free credits every day you use your account, up to 600 a month. No credit card required. Start at billionverify.com.
Featured in this video
Scrap.io Email VerificationScrap.io Email Verification: add verification after Scrap.io Google Maps exports, clean contact lists, and route valid, role-based, catch-all and invalid mail.Try Scrap.io Email VerificationMore in Google Maps Leads
All email verification videosBillionVerify pricing
Start free, then pay for what you verify. Pick a plan or buy credits once.
billed yearly $96
Save 60%$0.0004 / per credit
All 240,000 credits arrive at once. Use them anytime.
Choose your credits
Included in every paid plan
- 240,000 credits / year
- Single email verification
- Bulk email verification
- Email Finder
- Bulk Email Finder
- Company Search
- Live SMTP mailbox check
- Real-time API + batch processing
- CSV & Excel upload support
- Comprehensive verification reports
- Workspaces and teams with spend limits
- Credits never expire
Try the AI email verification features
20 free credits every day you log in, up to 600 a month. Free AI first email verification across every feature, no credit card.
Native MCP Server integration · Catch-all reported separately · Free tier, no credit card