Newly Disapproved Products

Name: Newly Disapproved Products
Author: Dmytro Tonkikh

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.

Shopping

PMax

shopping

merchant center

disapprovals

by Dmytro Tonkikh·adsapp.report/solutions/newly-disapproved-products

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.

Ready to Use This Script?

Configuration Variables

Variable	Default	Description
`ss`	INSERT URL OF YOUR GOOGLE SHEET COPY	Google Sheet URL for storing and tracking disapprovals. Must be a copy of the template.
`merchantId`	''	Your Google Merchant Center account ID.
`clicksThreshold`	0	Minimum historical clicks a product must have before triggering an alert.
`timePeriod`	''	Date range for click data. Options: TODAY, YESTERDAY, LAST_7_DAYS, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS. Leave empty for ALL_TIME.
`emailRecipient`	test@test.com	Email address to receive disapproval notifications.

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.