Skip to content

Verify lead sheets with native formulas.

Clean emails, phones, and WhatsApp numbers using formulas or our Bulk Sidebar.

Spreadsheet formula example =PROWEBLOOK_VERIFY_EMAIL(A2, TRUE)
View setup steps Copy starter configs Get 50 free credits

Includes 6-hour CacheService SHA-256 deduplication for formulas and permanent cell write-back in the Sidebar so reopening a sheet never burns extra credits.

Set up in any Google Sheet in 60 seconds

Uses least-privilege @OnlyCurrentDoc scope (spreadsheets.currentonly) and locks outbound HTTPS strictly to proweblook.com.

  1. Open Extensions then Apps Script

    Open your lead spreadsheet in Google Sheets and select Extensions, then Apps Script from the top menu bar.

  2. Paste Code.gs and Sidebar.html

    Copy src/Code.gs and src/Sidebar.html from the official open-source repository, save the script, and reload your Google Sheet.

    Open GitHub starter repository

  3. Connect your ProWebLook API key

    Click ProWebLook in the sheet menu, open the Sidebar, and paste your API key. It is saved in UserProperties and validated with a free balance check.

    Get 50 free signup credits

  4. Bulk verify or type =PROWEBLOOK_*

    Highlight a column of emails or phone numbers and click Bulk Verify Selected Cells to write permanent color-coded values into adjacent columns.

GitHub repository (proweblook-google-sheets) Explore API documentation Contact ProWebLook support

Built specifically for spreadsheet quirks and credit safety

Google Sheets recalculates custom functions periodically and strips leading plus signs from phone numbers. Our add-on solves both automatically.

Permanent-value Bulk Enricher Sidebar

Zero recalculation waste

Writes static verdict strings and status colors into adjacent columns, with a Skip already-verified rows toggle, live progress bar, and Stop button.

Email Verification API

2D Range Batching + 6h CacheService

Parallel UrlFetchApp.fetchAll

Pass ranges like =PROWEBLOOK_VERIFY_EMAIL(A2:A20) to batch up to 25 uncached rows in parallel while caching completed lookups for 6 hours.

Bulk WhatsApp Validation API

Automatic + restoration & E+10 guard

Protects phone & WhatsApp credits

Restores stripped leading + signs on numeric E.164 cells and blocks corrupted scientific-notation pastes (such as 1.41556E+10) before calling the API.

Phone Number Validator

One-click Demo Lead Sheet generator

Instant testing workspace

Click Insert Demo Lead Sheet inside the sidebar to scaffold a formatted sample table with headers and example formulas ready to test.

WhatsApp Number Checker

Copyable Google Sheets formulas

Paste any formula directly into a cell after connecting your API key in the ProWebLook sidebar.

Verify an email range in parallel

Checks 19 rows in one parallel batch and outputs deliverable, undeliverable, or unknown.

=PROWEBLOOK_VERIFY_EMAIL(A2:A20)

Spill phone carrier, line type & E.164 format

Validates national or international numbers and spills five enrichment columns to the right.

=PROWEBLOOK_VALIDATE_PHONE(B2, "US", TRUE)

Silent WhatsApp Business check with full details

Checks active WhatsApp registration and personal vs business account status without sending any message.

=PROWEBLOOK_WHATSAPP(B2, TRUE)

Frequently asked questions

Should I use =PROWEBLOOK_* formulas or the Bulk Sidebar for 1,000+ rows?

Use the Bulk Lead Enricher Sidebar for large lists or long-lived sheets. Custom formulas in Google Sheets can recalculate when Google refreshes a workbook after cache expiry, whereas the Sidebar writes permanent static text into cells that never re-run.

What happens if Google Sheets turned my phone numbers into 1.41556E+10?

Both the custom formulas and the Sidebar detect scientific-notation corruption locally and reject the cell before making a network request, preventing wasted phone or WhatsApp credits.

Can collaborators in my Google Sheet see my ProWebLook API key?

Your API key is stored in Apps Script UserProperties scoped to your Google user account. Custom formulas only run when you explicitly enable formula execution for that sheet in the Sidebar.

Which Google OAuth scopes does the add-on request?

Only spreadsheets.currentonly (the active spreadsheet you open it in), script.container.ui (to render the sidebar), and script.external_request locked via urlFetchWhitelist to https://proweblook.com/api/v1/zapier/.

Does =PROWEBLOOK_BALANCE() cost any credits?

No. Balance checks are always free and let you display live remaining email, phone, and WhatsApp credits at the top of your workbook.

Turn messy lead spreadsheets into verified outreach lists

Create a free ProWebLook account with 50 email, phone, and WhatsApp credits and connect Google Sheets in under a minute.

Get 50 free credits All integrations