Alerts you by email when any shared negative keyword list approaches Google's 5,000-keyword limit, logging list sizes to a Google Sheet.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/negative-keyword-list-full-checker
Reviews search terms and adds negative keywords automatically using AI-evaluated rules you configure in a companion admin panel, with email summaries of every change.
Uses Claude AI to analyze your search terms and recommend negative keywords with clear reasoning. Each term is evaluated for business relevance, intent, and conversion potential — then exported to a Google Sheet with actionable suggestions.
Sheet-driven negative keyword automation: define rules in a spreadsheet and the script adds negatives and emails alerts about irrelevant search terms without manual monitoring. Supports MCC.
Finds brand search terms leaking into non-brand campaigns (inflating their stats and misleading Smart Bidding) and generic traffic riding in brand campaigns — with the misrouted spend quantified.
Measures how much of your exact-match spend actually flows through close variants and lists the zero-conversion variants — the most surgical negative keyword candidates in the account.
Reads negative keywords and placement exclusions from a Google Sheet and syncs them to multiple campaigns via shared negative keyword and placement lists. Optionally filters to campaigns with a specific label.
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.
| Variable | Default |
|---|---|
SPREADSHEET_URL | YOUR_SPREADSHEET_URL_HERE |
ALERT_EMAIL | YOUR_EMAIL_HERE |
NEGATIVE_KEYWORD_LIMIT | 5000 |
DEBUG_MODE | false |
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.
Lightweight and safe (read + email only). Uses a Google Sheet purely for logging. No third-party service beyond the optional sheet.