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ยทadsapp.report/solutions/newly-disapproved-products
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.
| Variable | Default |
|---|---|
ss | INSERT URL OF YOUR GOOGLE SHEET COPY |
merchantId | '' |
clicksThreshold | 0 |
timePeriod | '' |
emailRecipient | test@test.com |
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.
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.