Getting Started in 4 Quick Steps
- Install from Marketplace: Visit the Google Workspace Marketplace and install our official add-on directly to your Google account.
- Open Extensions Menu: Open your target Google Sheet and navigate to Extensions → [Add-on Name] → Open Sidebar.
- Select Your Column: In the sidebar panel, choose the column containing your target data (email addresses or URLs) and specify your output preferences.
- Execute and Monitor: Click Run / Verify. The add-on will process rows and write validated status tags directly into adjacent columns in real time.
Pro Tip on Batch Processing: Google Apps Script enforces a 6-minute maximum execution timeout per continuous run. For sheets with more than 500 rows, run your verification in batches of 150 to 200 rows for maximum speed and stability.
Troubleshooting & Common Solutions
-
Script Execution Timeout or Error:
Try running smaller batches of 100 to 200 rows. External mail servers and web hosts can take several seconds to respond; batching prevents hitting Google's execution limit. -
OAuth Authorization Loop:
If Google repeatedly prompts you to authorize, sign out of secondary Google accounts in the same browser window or open the sheet in an Incognito window. Accept all requested scopes to complete authorization. -
Add-on Sidebar Does Not Open:
Refresh the Google Sheet tab. Confirm your account has edit permissions on the active sheet (add-ons cannot write to view-only files). -
Slow Results on Link Monitor:
Links hosted on slow origins or with complex multi-hop redirects take longer to resolve. The monitor safely honors response timeouts to prevent hanging your sheet.