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

merchant center

disapprovals

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.

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.

Newly Disapproved Products

Overview

More Reporting scripts

Account Anomaly Detector

Account Health Scorecard

Account Structure Audit

Account Summary Report

Ad Performance Report

Ad Schedule Audit

Ready to Use This Script?

Setup

Configuration Variables

Expected Output

Notes