Newly Disapproved Products
Detects products in Google Merchant Center that have been newly disapproved, but only for products that previously generated clicks. Sends an HTML email alert with links to Merchant Center diagnostics.
by Dmytro Tonkikh·chiliad.io
Overview
Newly Disapproved Products pulls disapproval data from Merchant Center via the Shopping Content API, cross-references historical click data from Google Ads, records newly disappeared products in a Google Sheet, and sends a formatted HTML email notification. Only products that have received clicks above a configurable threshold are flagged, reducing noise from products that never had traffic.
Setup
- 1Make a copy of the template spreadsheet: https://docs.google.com/spreadsheets/u/1/d/1-PfwEaaReSvOup8ki_HbuZlCCj2xXpzCulA8NpuriHg/copy
- 2Paste the copied spreadsheet URL into the ss variable at the top of the script.
- 3Set merchantId to your Google Merchant Center account ID.
- 4Optionally set clicksThreshold to filter out products with few clicks (default 0 = all products).
- 5Set emailRecipient to the email address that should receive alerts.
- 6Enable the Shopping Content API in your Google Ads Scripts project (Resources → Advanced APIs).
- 7Run once in preview to verify data is being pulled correctly, then schedule daily.
Configuration Variables
| Variable | Default |
|---|---|
ss | INSERT URL OF YOUR GOOGLE SHEET COPY |
merchantId | '' |
clicksThreshold | 0 |
timePeriod | '' |
emailRecipient |
Expected Output
Script sends an HTML email: "Google Ads script identified 3 product(s) newly disapproved in your Merchant Center account." with a link to the spreadsheet and Merchant Center diagnostics. New disapprovals are logged to the 'new values' sheet; all current disapprovals to the 'data' sheet.
Notes
Requires the Shopping Content API to be enabled under Resources → Advanced APIs in the script editor. The script compares the current list of disapproved products against the previous run stored in the spreadsheet, so the first run will not send alerts.