CSV Batch Validation & Reporting

{
  "trigger": {
    "app": "google_drive",
    "event": "new_file",
    "filter": "file_type:csv"
  },
  "action": {
    "app": "validationcore",
    "endpoint": "validate_product",
    "data": {
      "products": [
        {
          "title": "{{title}}",
          "description": "{{description}}",
          "price": "{{price}}",
          "gtin": "{{gtin}}",
          "brand": "{{brand}}",
          "category": "{{category}}"
        }
      ]
    }
  },
  "output": {
    "app": "google_sheets",
    "action": "create_spreadsheet_with_data",
    "data": {
      "title": "ValidationCore Optimization Report - {{formatted_date}}",
      "headers": [
        "Product Title",
        "Compliance Score (%)",
        "Revenue Opportunity ($)",
        "GMC Status",
        "Priority Level",
        "Total Errors",
        "Processing Date"
      ],
      "rows": "{{#data.products}}{{title}},{{gmcCompliance.percentage}},{{totalRevenueImpact}},{{gmcCompliance.status}},{{gmcCompliance.percentage}},{{gmcCompliance.errorCount}},{{zap_meta_timestamp}}{{/data.products}}"
    }
  }
}