{
  "name": "AI-driven WooCommerce product importer from Google Sheet with Yoast SEO meta",
  "nodes": [
    {
      "id": "aa2d7a06-6e8d-4abc-ab5f-53e9698b1655",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -360,
        -340
      ]
    },
    {
      "id": "1f2465ab-90fa-44f1-8c06-58b1436dccd0",
      "name": "OpenRouter Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        180,
        160
      ]
    },
    {
      "id": "29832953-a3e1-481d-a8bb-238bbf3c736c",
      "name": "SEO Expert",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        200,
        -60
      ]
    },
    {
      "id": "e61c4d07-e535-404d-a58e-1676e043d1cb",
      "name": "Get products",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        -340
      ]
    },
    {
      "id": "a3ca44a3-a270-4339-aae0-5e7963a9d695",
      "name": "Map categories",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        -320
      ]
    },
    {
      "id": "fe36f50a-1197-4f8a-a02f-70687e5049c8",
      "name": "Create product",
      "type": "n8n-nodes-base.wooCommerce",
      "position": [
        680,
        -320
      ]
    },
    {
      "id": "5f70ca85-45c0-483e-ae01-364d5fedb9f8",
      "name": "Creation done",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        940,
        -320
      ]
    },
    {
      "id": "de6904d1-5697-4fee-8492-e47a694e86c9",
      "name": "Update meta",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        920,
        -60
      ]
    },
    {
      "id": "f9f0eb06-3d76-4675-af0a-8ec9b3811b79",
      "name": "Set SEO meta",
      "type": "n8n-nodes-base.wooCommerce",
      "position": [
        600,
        -60
      ]
    },
    {
      "id": "0ae1b508-9990-4f7b-bf64-e612ef5f0396",
      "name": "Loop products",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        120,
        -340
      ]
    },
    {
      "id": "e713e1cd-b0cc-465d-971a-54a8002e0c39",
      "name": "Send message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        400,
        -500
      ]
    },
    {
      "id": "06228035-8e02-4830-bf54-23096e6e1ca7",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        440,
        160
      ]
    },
    {
      "id": "c46b05a5-a565-48fe-a8ad-fad34eab267c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -460,
        -1060
      ],
      "parameters": {
        "width": 800,
        "height": 480,
        "content": "## STEP 1\n- Install Yoast SEO Plugin on Wordpress\n- Add this code in function.php file\n\n```\nfunction abilita_yoast_meta_api() {\n    $meta_keys = ['_yoast_wpseo_title', '_yoast_wpseo_metadesc'];\n\n    f"
      }
    },
    {
      "id": "5cde4743-f5ab-4670-b836-d0d32b54db98",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        -840
      ],
      "parameters": {
        "width": 800,
        "height": 260,
        "content": "## STEP 3\n- Copy [this sheet](https://docs.google.com/spreadsheets/d/1vNkSgWHsgYDCusD-xKSrQg64hd7WvOjQmqdB2NdVFG4/edit?usp=sharing) and add product details to be inserted in columns A to I\nIMPORTANT: "
      }
    },
    {
      "id": "cea0f8f9-2a98-465b-925c-48b9d3ea99a2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        -1060
      ],
      "parameters": {
        "width": 800,
        "height": 180,
        "content": "## STEP 2\n- Enable WooCommerce API from Wordpress\n- Add CHAT_ID in Telegram trigger"
      }
    },
    {
      "id": "e61ca71a-3960-49e2-a331-b8f3df8abcd7",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -460,
        -1280
      ],
      "parameters": {
        "width": 1640,
        "height": 180,
        "content": "# AI-Driven WooCommerce Product Importer\nThis workflow streamlines your WooCommerce product creation process by integrating directly with Google Sheets. Simply input product details into your spreadsh"
      }
    }
  ],
  "connections": {
    "SEO Expert": {
      "main": [
        [
          {
            "node": "Set SEO meta",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update meta": {
      "main": [
        [
          {
            "node": "Loop products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get products": {
      "main": [
        [
          {
            "node": "Loop products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set SEO meta": {
      "main": [
        [
          {
            "node": "Update meta",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Creation done": {
      "main": [
        [
          {
            "node": "SEO Expert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop products": {
      "main": [
        [
          {
            "node": "Send message",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Map categories",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create product": {
      "main": [
        [
          {
            "node": "Creation done",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map categories": {
      "main": [
        [
          {
            "node": "Create product",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "SEO Expert",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "SEO Expert",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Get products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}