List Products

Retrieve detailed product information from Google Merchant Center

The List Products node retrieves comprehensive product data from Google Merchant Center accounts, including titles, descriptions, prices, availability, and product attributes. Perfect for product catalog analysis and inventory management. This is an AI-powered node that can understand natural language instructions.

---

When to Use It

• Analyze product catalog and inventory
• Monitor product availability and pricing
• Export product data for analysis
• Validate product feed quality
• Track product performance metrics
• Audit product information and attributes
• Prepare data for competitive analysis

---

Inputs

Field	Type	Required	Description
Account	Dropdown	Yes	Google Merchant Center account to query
Filters	Filter Builder	No	Conditions to filter products
Limit	Number	No	Maximum number of products to return

Filter Options

You can filter products using various criteria:

Field Type	Examples	Use Cases
Product ID	online:en:US:12345	Find specific products
Title	Contains “iPhone”	Product category analysis
Brand	Equals “Apple”	Brand-specific queries
Price	Greater than 100	Price range analysis
Availability	Equals “in_stock”	Inventory monitoring
Condition	Equals “new”	Product condition filtering
Product Type	Contains “Electronics”	Category-based queries

Filter Operators

Operator	Description	Example
Equals	Exact match	Brand equals “Nike”
Contains	Partial match	Title contains “running”
Greater than	Numeric comparison	Price > 50
Less than	Numeric comparison	Price < 200
In	Multiple values	Category in [“shoes”, “apparel”]

---

Output

Returns detailed product information:

{
  "products": [
    {
      "product_id": "online:en:US:12345",
      "title": "Apple iPhone 15 Pro 128GB - Natural Titanium",
      "description": "The most advanced iPhone ever with titanium design and A17 Pro chip",
      "link": "https://store.example.com/iphone-15-pro",
      "image_link": "https://cdn.example.com/iphone-15-pro.jpg",
      "price": {
        "value": "999.00",
        "currency": "USD"
      },
      "sale_price": {
        "value": "899.00", 
        "currency": "USD"
      },
      "availability": "in_stock",
      "condition": "new",
      "brand": "Apple",
      "gtin": "195949040015",
      "mpn": "MTUW3LL/A",
      "product_type": "Electronics > Phones > Smartphones",
      "google_product_category": "Electronics > Communications > Telephony > Mobile Phones",
      "custom_attributes": {
        "color": "Natural Titanium",
        "storage": "128GB",
        "carrier": "Unlocked"
      },
      "shipping": {
        "country": "US",
        "service": "Standard",
        "price": {
          "value": "0.00",
          "currency": "USD"
        }
      },
      "last_updated": "2024-03-15T10:30:00Z"
    }
  ],
  "total_products": 1,
  "account_info": {
    "account_id": "123456789",
    "account_name": "Main Store GMC"
  }
}

Product Fields:

Field	Description
product_id	Unique product identifier
title	Product title/name
description	Product description
link	Product landing page URL
image_link	Main product image URL
price	Regular price with currency
sale_price	Sale price (if on sale)
availability	Stock status (in_stock, out_of_stock, preorder)
condition	Product condition (new, used, refurbished)
brand	Product brand/manufacturer
gtin	Global Trade Item Number (barcode)
mpn	Manufacturer Part Number
product_type	Your product categorization
google_product_category	Google’s product category
custom_attributes	Additional product attributes
shipping	Shipping information
last_updated	When product was last updated

---

Credit Cost

• Cost per run: 1 credit

---

Common Workflows

Product Catalog Analysis:

[Select Accounts] → [List Products] → [Analyze Categories] → [Generate Catalog Report]

Inventory Monitoring:

[List Products] → [Filter Out of Stock] → [Alert System] → [Restock Notifications]

Price Tracking:

[List Products] → [Extract Pricing] → [Historical Comparison] → [Price Trend Analysis]

Product Data Quality:

[List Products] → [Validate Required Fields] → [Flag Issues] → [Export for Review]

---

Analysis Use Cases

Product Performance Analysis

Track top-performing products:

- List all products from account
- Filter by high availability and good ratings
- Analyze pricing and category distribution
- Identify best-selling product characteristics

Inventory Management

Monitor stock levels across catalogs:

- Filter products by availability status
- Identify out-of-stock items
- Track inventory trends over time
- Generate restock recommendations

Competitive Intelligence

Analyze product positioning:

- List products by category
- Compare pricing strategies
- Analyze product descriptions and features
- Benchmark against market standards

Data Quality Audits

Ensure product feed quality:

- List all products
- Check for missing required fields
- Validate image links and descriptions
- Identify products needing optimization

---

Filter Examples

Category-Based Filtering

Filter: product_type contains "Electronics"
Use Case: Analyze electronics inventory
Result: All electronic products

Price Range Analysis

Filter: price.value > 100 AND price.value < 500
Use Case: Mid-range product analysis
Result: Products in $100-500 range

Brand Performance

Filter: brand equals "Nike"
Use Case: Brand-specific analysis
Result: All Nike products

Availability Monitoring

Filter: availability equals "out_of_stock"
Use Case: Inventory alerts
Result: Products needing restocking

New Product Tracking

Filter: last_updated > "2024-03-01"
Use Case: Recent product additions
Result: Recently added/updated products

---

Tips

Data Retrieval:

• Use filters to focus on relevant products and reduce data volume
• Set reasonable limits to avoid overwhelming results
• Start with broad queries then narrow down with specific filters
• Consider pagination for large product catalogs

Performance Optimization:

• Apply filters rather than retrieving all products
• Use specific field filters instead of broad text searches
• Limit results for exploratory analysis
• Cache product data for repeated analysis

Analysis Strategy:

• Combine multiple filters for precise product selection
• Export data regularly for trend analysis
• Track changes over time by comparing snapshots
• Validate data quality before making business decisions

Integration Tips:

• Connect with price benchmarks for competitive analysis
• Use with product status to identify issues
• Combine with reporting data for performance insights
• Feed into automated workflows for ongoing monitoring