Google Shopping Feed Optimization and Merchant Center Sync - n8n Workflow

E-commerce Managers seeking to maximize ROAS through better feed quality. PPC Specialists needing automated, segmented bidding strategies via custom labels. Data Engineers looking for reliable n8n templates for product data transformation. Anyone needing to ensure 24/7 compliance and monitoring of Google Merchant Center policies.

Maintaining a high-quality product feed is crucial for successful Google Shopping campaigns. This advanced n8n workflow solves the common problems of poor data quality, suboptimal content (titles/descriptions), and delayed response to product disapprovals.

The automation initiates daily, validates product integrity (using a custom n8n node for data quality checks), and then enhances conversion rates by integrating with AI services (like Relevance AI) to generate keyword-rich content. Furthermore, it assigns up to five custom labels dynamically based on margin, stock, and seasonality, providing powerful segmentation tools for Google Ads bidding strategies. By utilizing the Google Merchant API, this n8n workflow ensures immediate sync and proactive monitoring for critical errors, guaranteeing that your products stay visible and approved.

This comprehensive n8n workflow operates in four stages:

1. Initiation and Extraction (Trigger): The process starts with the Daily Trigger - 6 AM n8n trigger, running every morning. It immediately fetches the raw product feed data via an HTTP Request n8n node (from Channable or an e-commerce API).


2. Validation and Splitting: The Data Quality Checks Code n8n node validates critical fields (GTINs, prices, image links) and assigns a quality score. The results are split using the Split Products1 n8n node, preparing each product item for individual processing.


3. AI Optimization and Labeling: Each product item is sequentially passed to external AI services (Optimize Title and Generate Description HTTP Request nodes) for content enhancement. Following content optimization, the Assign Custom Labels Code n8n node dynamically generates custom labels (margin tier, performance, stock level) essential for campaign segmentation. All processed items are then re-aggregated.


4. Sync and Monitoring: The optimized feed is uploaded in batches to Google Merchant Center using the Upload to Merchant Center HTTP Request n8n node (targeting the NEW Merchant API). Immediately afterward, the Check Product Status n8n node verifies the API response. The Analyze Product Issues Code n8n node checks for critical disapprovals. An IF Disapprovals Found n8n node handles flow control, routing critical issues to an immediate Alert - Disapprovals Slack message, or sending a Success Summary confirmation for daily operational reporting. This complete n8n workflow ensures a daily optimized feed.

To deploy this n8n template, follow these steps:

1. Import: Copy the provided JSON and import it into your n8n instance as a new workflow.


2. Credentials Setup:

1. Activation: Once credentials and variables are set, activate the n8n workflow. The n8n trigger will start the automation daily at 6 AM.

Daily Trigger - 6 AM (n8n trigger): The starting n8n node. Configured to run daily via a Cron expression (0 6 ).
Get Product Feed (HTTP Request n8n node): Fetches the external product data feed using environmental variables for the URL and secured HTTP Header authentication.
Data Quality Checks (Code n8n node): Custom JavaScript implementation to perform data validation (checking for missing GTIN, image, price > 0, title length constraints) and calculates a quality score for every product item.
Split Products1 (Item Lists n8n node): Essential for preparing the batched feed for individual AI processing by splitting the aggregated 'allproducts' array.
Optimize Title / Generate Description (HTTP Request n8n nodes): Uses POST requests to call external AI tools (via Relevance AI URLs configured in environment variables) to dynamically rewrite marketing content.
Assign Custom Labels (Code n8n node): A custom n8n node that calculates and assigns five critical custom labels (customlabel0 through customlabel_4) based on derived product data (e.g., calculated margin, stock quantity, and seasonality).
Upload to Merchant Center (HTTP Request n8n node): Pushes the fully optimized product data to the Google Merchant Center using the new Content API version. Crucially configured to batch operations, processing up to 1000 products per API call.
Analyze Product Issues (Code n8n node): Parses the API monitoring response to categorize and count critical disapprovals and warnings, preparing the data for the alerting stage.
IF Disapprovals Found (If n8n node): A core flow control n8n node that branches the workflow based on the presence of critical disapprovals, ensuring rapid issue response.

• Alert - Disapprovals / Success Summary (Slack n8n node): Handles notification. Sends detailed alerts or summaries based on the daily outcome of the entire n8n workflow.