n8nflow.net logo

πŸ›οΈ Google Shopping Feed Optimization with Channable, Relevance AI & Merchant API

by Nikan Noorafkanβ€’Updated: Last update 2 days agoβ€’Source: n8n.io
Loading workflow viewer...

Getting Started

πŸ›οΈ Google Shopping Feed Optimization with Channable + Relevance AI + Google Merchant API

πŸš€ Automate, Optimize & Sync Your Product Feeds at Scale


🧩 Overview

This workflow automates Google Shopping Feed Optimization using Channable , Relevance AI , and the Google Merchant API.
It runs daily, enhancing product titles and descriptions, validating feed quality, assigning custom campaign labels, and syncing the optimized feed with Google Merchant Center.

The system ensures every product listing meets Google’s content standards, is SEO-friendly, and ready for high-performance Shopping campaigns.


🧠 Key Benefits

βœ… Automated daily product feed optimization
βœ… AI-enhanced titles and descriptions (via Relevance AI)
βœ… Google Merchant API integration (latest version)
βœ… Quality scoring and error detection before sync
βœ… Custom campaign labels for segmented bidding
βœ… Slack alerts for issues and daily summaries
βœ… 100% no-code deployment with scalable batch processing


βš™οΈ System Architecture

ComponentPurpose
n8nWorkflow automation and orchestration
ChannableProduct feed source (can replace with any eCommerce API)
Relevance AIAI title and description optimization
Google Merchant API (NEW)Product publishing and validation
SlackAlerts and reporting
Cron TriggerDaily schedule (6 AM sync)

🧭 Workflow Logic (Visual Summary)

Daily Trigger (06:00 AM)
⬇️
1️⃣ Get Product Feed (Channable)
Fetches product data for optimization.
⬇️
2️⃣ Data Quality Checks
Validates titles, GTINs, pricing, categories, and descriptions. Assigns quality scores.
⬇️
3️⃣ Split Products
Breaks the all_products array into single items for AI processing.
⬇️
4️⃣ Optimize Title (Relevance AI Tool)
Enhances product titles for SEO, clarity, and Google compliance.
⬇️
5️⃣ Generate Description (Relevance AI Tool)
Creates 300–400 character, benefit-focused product descriptions.
⬇️
6️⃣ Assign Custom Labels
Adds five segmentation labels: margin, performance, seasonality, stock level, and category.
⬇️
7️⃣ Aggregate Products
Combines optimized items into one unified dataset.
⬇️
8️⃣ Upload to Merchant Center (NEW Merchant API)
Publishes products via Google’s latest /products endpoint.
⬇️
9️⃣ Check Product Status
Verifies successful uploads and identifies disapprovals.
⬇️
πŸ” Analyze Product Issues
Summarizes errors and warnings from Merchant API results.
⬇️
βš–οΈ IF Disapprovals Found
β†’ 🚨 Send Slack alert for issues
β†’ βœ… Otherwise, post success summary


🧩 Environment Variables

Set these under
n8n β†’ Settings β†’ Variables β†’ Add Variable

VariableExamplePurpose
CHANNABLE_API_URLhttps://api.channable.com/v1Channable API base
CHANNABLE_COMPANY_ID12345Company ID in Channable
CHANNABLE_PROJECT_IDabcdProject ID
FEED_IDshopping-feedFeed endpoint
RELEVANCE_AI_API_URLhttps://api-f1db6c.stack.tryrelevance.com/latestRelevance AI API base
RELEVANCE_TOOL_TITLE_OPTIMIZER_IDtQy48Ld8n0zpRelevance AI Title Tool ID
RELEVANCE_TOOL_DESCRIPTION_IDhJ9bT01r8LqfRelevance AI Description Tool ID
MERCHANT_API_URLhttps://merchantapi.googleapis.com/content/v2.1Google Merchant API base
MERCHANT_ACCOUNT_ID123456789Merchant Center account ID
SLACK_CHANNEL#shopping-feed-automationSlack channel for reports

πŸ”‘ Credential Setup

ServiceTypeSetup
Relevance AIHTTP Header AuthHeader β†’ Authorization: Bearer {{$env.RELEVANCE_AI_API_KEY}}
ChannableHTTP Header AuthHeader β†’ Authorization: Bearer {{$env.CHANNABLE_API_TOKEN}}
Google MerchantGoogle OAuth2Scopes: <br>β€’ https://www.googleapis.com/auth/content
SlackSlack APIAdd chat:write Bot Token Scope

🧱 Node-by-Node Breakdown

NodeDescriptionKey Action
Daily Trigger (6 AM)Starts workflow every morningcron: 0 6 * * *
Get Product FeedFetches products from ChannableGET {{$env.CHANNABLE_API_URL}}/.../feeds/{{$env.FEED_ID}}
Data Quality ChecksValidates GTINs, titles, pricing, imagesReturns quality_score + all_products
Split ProductsSplits array into individual productsOperation: splitOut, Field: all_products
Optimize TitleCalls Relevance AI title tool/tools/{{$env.RELEVANCE_TOOL_TITLE_OPTIMIZER_ID}}/trigger
Generate DescriptionCalls Relevance AI description tool/tools/{{$env.RELEVANCE_TOOL_DESCRIPTION_ID}}/trigger
Assign Custom LabelsAdds 5 Smart Bidding LabelsMargin, performance, seasonality, stock, category
Aggregate ProductsCombines optimized product dataFor batch upload
Upload to Merchant CenterPosts via NEW Merchant API/accounts/{id}/products
Check Product StatusRetrieves upload resultsLists disapproved or pending items
Analyze Product IssuesSummarizes product disapprovalsReturns disapproval_count and warnings
IF Disapprovals FoundConditional routingSends alert or success message
Slack - AlertSends error summary to SlackIncludes product name and issue detail
Slack - Success SummaryPosts daily completion messageIncludes counts and optimizations applied

🧰 Testing Procedure

1️⃣ Temporarily disable the cron schedule
2️⃣ Run manually using β€œExecute Workflow”
3️⃣ Start with 3–5 products
4️⃣ Check:

  • Slack β†’ Success message
  • Google Merchant β†’ Updated products
  • n8n Execution logs β†’ No failed nodes

Once validated β†’ Re-enable the 6 AM trigger


🧾 Example Output

Slack Success Message

βœ… Shopping Feed Optimization Complete

πŸ“Š Summary:
β€’ Total Products Processed: 135
β€’ Products with Quality Issues: 12
β€’ Disapprovals: 0
β€’ Warnings: 3

🎯 Optimizations Applied:
β€’ Titles optimized for SEO
β€’ Descriptions enhanced
β€’ Custom labels added

API: NEW Merchant API (merchantapi.googleapis.com)
Next Run: Tomorrow 6 AM
Timestamp: 2025-10-22T06:00:00Z

Slack Alert Message

🚨 Merchant Center Disapprovals Alert

Total Disapprovals: 5
Total Warnings: 2

Critical Issues:
β€’ Product: Wireless Headphones (ID: 4829)
  Issue: Missing GTIN
β€’ Product: Yoga Mat Eco (ID: 7350)
  Issue: Invalid price

Action Required: Review disapproved products in Merchant Center.
Timestamp: 2025-10-22T06:00:00Z

πŸ“Š Success Metrics

MetricGoal
Feed approval rateβ‰₯ 90%
AI optimization success rateβ‰₯ 95%
Manual review reduction80%
Daily automation uptime99.9%
Scalable throughput5,000+ products/day

🧩 Maintenance Schedule

FrequencyTask
DailyMonitor Slack alerts
WeeklyCheck disapproval logs
MonthlyRefresh API tokens
QuarterlyTune AI prompts and thresholds

πŸͺœ Next Steps

βœ… Deploy workflow in production
πŸ“ˆ Connect to your performance dashboard
🌍 Extend to multi-language feeds (Relevance AI translations)
πŸ’‘ Add conversion optimization loop in Google Ads


πŸ”— References


πŸŽ‰ Conclusion

You now have a production-grade, AI-driven Shopping Feed Optimization workflow built on:

  • Channable for structured data ingestion
  • Relevance AI for content intelligence
  • Google Merchant API for publishing
  • n8n as the automation engine

πŸ’‘ Result: A fully autonomous product feed system that self-improves daily, keeping your listings compliant, optimized, and performing at scale.