Check a list of emails in Google Sheets
The Google Sheets connector checks the email column of your sheet without exporting or importing anything. Each address goes through the YesWeCheck engine, SMTP included, then its status, score, reason and date are written in four columns next to your data. Filter, sort, share: the sheet stays yours.
How it works
-
Connect your Google account
One click on Sign in with Google from your customer area. At this stage YesWeCheck gets no access to your Drive.
-
Choose the sheet
Select the file in the Google picker, then the tab and the email column. Only the files you choose can be opened.
-
Find the verdict in the sheet
The addresses are checked by the batch processing engine, SMTP included, then four columns are filled row by row.
What is written in the sheet
Four columns added to the right of your data, with their header. If you move them, they are found again by name at the next check. Every row that carries an address receives its verdict, duplicates included.
| Column | Content |
|---|---|
| YWC status | valid, risky, invalid or unknown |
| YWC score | Score from 0 to 100 |
| YWC reason | Reason: catch-all, disposable, mailbox does not exist, domain without a mail server, typo… |
| YWC checked on | Date of the check |
You stay in control
Access limited to the files you choose
The connector only sees the sheets that you select in the Google picker, never the rest of the Drive.
Check added rows
Every row added at the bottom of a watched sheet is checked within minutes, with a daily cap that you set.
Several sheets
Save the tabs you need and check them whenever you like, each one with its own email column.
Nothing is deleted
The connector adds columns. Your rows and your data stay intact.
Security and credits
The connection goes through the Google screen: no password is entered at YesWeCheck. Access is stored encrypted and disconnecting revokes it at Google. A check costs the credits of batch processing: one credit per address checked with SMTP, except when the result is undetermined.
Frequently asked questions
- How do I check a list of emails in Google Sheets?
- Connect your Google account from your YesWeCheck area, choose the sheet in the Google picker, give the tab and the email column, then start the check. The result is written in four columns added to the right of your data.
- Does YesWeCheck have access to my whole Google Drive?
- No. The connector only opens the files that you choose yourself in the Google picker. The rest of your Drive stays invisible to it, and you can withdraw access at any time.
- Which columns are added to my sheet?
- Four columns, each headed YWC: the status (valid, risky, invalid or unknown), the score from 0 to 100, the reason and the date of the check. Your existing data is never changed or deleted.
- What happens if I sort the sheet or if an address appears twice?
- The verdict follows the address, not the row number: a sheet sorted or extended during the check receives the results on the right rows, and each duplicate receives the same verdict without being charged twice.
- Can added rows be checked automatically?
- Yes. Switch on automatic checking for a sheet: every row added at the bottom is checked within minutes, with a daily cap that you set to keep credits under control.
- How many credits does a check use?
- One credit per address checked with SMTP, except when the result is undetermined. Duplicates and cells without an address are not charged.
Get started
Create an account, connect Google Sheets and run a first check on a small sheet.