Negative Keyword List Full Checker
2 installs
Alerts you by email when any shared negative keyword list approaches Google's 5,000-keyword limit, logging list sizes to a Google Sheet.
negative keywords
shared lists
limits
alerts
monitoring
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/negative-keyword-list-full-checker
Overview
Shared negative keyword lists silently cap at 5,000 keywords — once full, new negatives fail to apply. This script counts the keywords in each shared list and emails you when any list nears the limit, so you can split it before losing coverage. A simple, low-config safeguard.
Setup
- 1Create or copy a Google Sheet for logging and copy its URL.
- 2In Google Ads, go to Tools → Bulk Actions → Scripts.
- 3Click + to create a new script and paste the code below.
- 4Set SPREADSHEET_URL and ALERT_EMAIL.
- 5Authorize, preview, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
SPREADSHEET_URL | YOUR_SPREADSHEET_URL_HERE |
ALERT_EMAIL | YOUR_EMAIL_HERE |
NEGATIVE_KEYWORD_LIMIT | 5000 |
DEBUG_MODE | false |
Expected Output
Checked 6 shared negative lists. "Brand Negatives" — 4,812 / 5,000 (ALERT sent). "Generic Waste" — 2,140 / 5,000 (ok). Sizes appended to the log sheet.
Notes
Lightweight and safe (read + email only). Uses a Google Sheet purely for logging. No third-party service beyond the optional sheet.