Auto Negative Keywords (Google Sheets)
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.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/auto-negative-keywords-sheets
Overview
Reads a rules spreadsheet describing which search terms to exclude (by filters on clicks, cost, conversions and text) and applies negatives at the ad group, campaign or shared-list level, emailing a summary. Runs against a single account or across an MCC. Use it to continuously prune wasted spend from Search and Shopping.
Setup
- 1Copy the Google Sheet template linked on the source page and set up your filter rules and output tabs.
- 2In Google Ads, open Tools → Bulk Actions → Scripts (in an MCC use the MCC-level Scripts).
- 3Click + to create a new script and paste the code below.
- 4Set INPUT_SHEET_URL to your copied sheet.
- 5Authorize, preview, review the Output tab, then schedule hourly.
Configuration Variables
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
TEST_MODE | false |
LOG_INVALID_SEARCH_TERMS | true |
Expected Output
Processed rules from Settings tab. Added 12 negatives across 3 campaigns; wrote details to Output tab. Email sent: "Auto Negative Keywords Pro — 12 negatives added".
Notes
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template that drives all rule configuration; the script self-reports run info to shabba by default. Most configuration lives in the sheet, not in the code. Detects MCC vs single-account automatically.