How It Works

This Google Apps Script turns your spreadsheet into an intelligent crawler. It scans your provided list of URLs and fetches their live HTTP status directly within Google Sheets, safely bypassing execution time limits by batching requests every 15 minutes.

Soft 404 Detection & Color Coding

Beyond standard status codes, the script uses Regex patterns to identify hidden "Soft 404s" (pages that load but display error text). It then automatically color-codes the rows—green for OK, yellow for redirects, and red for errors—giving you instant visual feedback.

Automated Email Alerts

Once the crawl is fully completed, the script complies a summary of all problematic URLs (404s, server errors, and Soft 404s) and sends an automated notification directly to your inbox so you can take immediate action.