Google Sheets template
Google Sheets: re-verify your lead sheet every week
Paste one Apps Script file into your sheet. Every Monday it re-checks the addresses that have not been checked in six days and shows what changed since last week.
About 10 minutes to set upPeople who keep a long-lived lead or customer list in a sheet and want to catch addresses that went bad.
How it runs
- 1
Install
Paste the script into Extensions, Apps Script.
- 2
Save the key
Run svwSetKey once. The key stays in your Google account, not in the sheet.
- 3
Schedule
Run svwInstallWeeklyTrigger once.
- 4
Every Monday
Rows not checked in six days are re-checked and the result is written beside them.
What you need
- A Google Sheet with a header row and emails in column A
- A SimpleVerifier API key from simpleverifier.com/api-keys (starts with sv_live_)
Set it up
- Open your sheet, choose Extensions then Apps Script, and paste the file into a new script file. If your tab is not named Leads, change SVW_SHEET_NAME at the top.
- Save, choose svwSetKey in the function list and press Run. Accept the permissions, then paste your key in the prompt.
- Run svwInstallWeeklyTrigger once. It sets a weekly trigger for Monday morning in the sheet's time zone.
- Run svwRun once by hand to see the five columns appear: SV status, SV action, SV reason, SV checked and SV previous.
- Filter the SV status column on invalid and risky each Monday and clean the sheet before the next send.
Where your judgment still matters
A changed status is a signal to look, not a reason to delete. A mailbox can fail once and recover. Compare SV previous with SV status and decide what to remove. This script does not touch your other columns and does not delete rows.
Start with your own key
Every template calls the SimpleVerifier API with your key. Create one, then run the template on a handful of rows. To check a whole list without any setup, upload it as a CSV.
Common questions
- Can I use it with the SimpleVerifier Sheets add-on?
- Yes. The functions use a different prefix, so the two files do not clash, and inside the same Apps Script project they read the same saved key. Use the add-on for one-off checks and this file for the weekly run.
- What if my sheet has thousands of rows?
- One run stops before Apps Script's 6 minute limit and keeps what it checked. The next run picks up the rows still waiting. The script paces itself under 120 calls a minute.
- Which SimpleVerifier plan do I need?
- Pro is $39/month with 10,000 API and MCP calls included, then $1.50 per 1,000. Cancel anytime. Each key can make 120 calls a minute.
- What do valid, risky and invalid mean here?
- The result has a status and an action. Action send means the mail server confirmed the mailbox. send_with_care is a catch-all, role inbox or provider that hides mailbox status. retry_later means the check could not finish. do_not_send means the address will bounce or is a throwaway. Catch-all addresses are never marked valid.
Related: Google Sheets add-on · API docs
All workflow templates · By SimpleVerifier Team