Skip to main content
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

FieldTypeRequiredDescription
AccountDropdownYesGoogle Merchant Center account to query
FiltersFilter BuilderNoConditions to filter products
LimitNumberNoMaximum number of products to return

Filter Options

You can filter products using various criteria:
Field TypeExamplesUse Cases
Product IDonline:en:US:12345Find specific products
TitleContains “iPhone”Product category analysis
BrandEquals “Apple”Brand-specific queries
PriceGreater than 100Price range analysis
AvailabilityEquals “in_stock”Inventory monitoring
ConditionEquals “new”Product condition filtering
Product TypeContains “Electronics”Category-based queries

Filter Operators

OperatorDescriptionExample
EqualsExact matchBrand equals “Nike”
ContainsPartial matchTitle contains “running”
Greater thanNumeric comparisonPrice > 50
Less thanNumeric comparisonPrice < 200
InMultiple valuesCategory 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:

FieldDescription
product_idUnique product identifier
titleProduct title/name
descriptionProduct description
linkProduct landing page URL
image_linkMain product image URL
priceRegular price with currency
sale_priceSale price (if on sale)
availabilityStock status (in_stock, out_of_stock, preorder)
conditionProduct condition (new, used, refurbished)
brandProduct brand/manufacturer
gtinGlobal Trade Item Number (barcode)
mpnManufacturer Part Number
product_typeYour product categorization
google_product_categoryGoogle’s product category
custom_attributesAdditional product attributes
shippingShipping information
last_updatedWhen 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
I