Automatización de marketing de afiliados de Amazon

• •Pueden requerirse credenciales de autenticación para la API de destino
• •Credenciales de API de Google Sheets
• •Credenciales de Graph API de Facebook

{
  "id": "EPSFcDt1f8LdRzZU",
  "meta": {
    "instanceId": "061ca141d020a6e1355b8c7fe05f92a699e37e92079ad2e150a506ee8bbe9e11"
  },
  "name": "Amazon Affiliate Marketing Automation",
  "tags": [],
  "nodes": [
    {
      "id": "7c77fce7-01ef-4ab9-898c-f4378cfb12fb",
      "name": "Detalles del Producto de Amazon",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1248,
        144
      ],
      "parameters": {
        "url": "=https://real-time-amazon-data.p.rapidapi.com/product-details?asin={{ $json.output }}&country=US",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "x-rapidapi-host",
              "value": "real-time-amazon-data.p.rapidapi.com"
            },
            {
              "name": "x-rapidapi-key",
              "value": "YOUR_API_KEY"
            },
            {
              "name": "country",
              "value": "US"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "0a1dc175-1109-475c-908d-f13c4876e5c1",
      "name": "Imagen del Producto",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -576,
        496
      ],
      "parameters": {
        "url": "={{ $('Amazon Product Details').item.json.data.product_photo }}",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "9150b652-f44a-45d4-83c7-3fd85a1cde48",
      "name": "Subir Imagen al Servidor",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -368,
        496
      ],
      "parameters": {
        "url": "=https://generativelanguage.googleapis.com/upload/v1beta/files?key=YOUR_API_KEY",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "binaryData",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Goog-Upload-Command",
              "value": "start,upload,finalize"
            },
            {
              "name": "X-Goog-Upload-Header-Content-Length",
              "value": "123"
            },
            {
              "name": "X-Goog-Upload-Header-Content-Type",
              "value": "image/png"
            },
            {
              "name": "Content-Type",
              "value": "image/png"
            }
          ]
        },
        "inputDataFieldName": "data"
      },
      "typeVersion": 4.2
    },
    {
      "id": "51f82722-4ea3-423c-80be-fdb8ae8f1f15",
      "name": "Modelo de Chat OpenRouter",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        -96,
        336
      ],
      "parameters": {
        "model": "google/gemini-2.0-flash-exp:free",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "2c2b5f47-cc55-4d2a-9184-67fc16d28e73",
      "name": "Convertir a Archivo",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        528,
        464
      ],
      "parameters": {
        "options": {},
        "operation": "toBinary",
        "sourceProperty": "candidates[0].content.parts[0].inlineData.data"
      },
      "typeVersion": 1.1
    },
    {
      "id": "b56e9f83-0da7-4655-af71-f7ada6c9a175",
      "name": "Facebook Graph API",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        960,
        464
      ],
      "parameters": {
        "edge": "photos",
        "node": "me",
        "options": {
          "queryParameters": {
            "parameter": [
              {
                "name": "message",
                "value": "={{ $('FB caption').item.json.output }}"
              }
            ]
          }
        },
        "sendBinaryData": true,
        "graphApiVersion": "v22.0",
        "httpRequestMethod": "POST",
        "binaryPropertyName": "data"
      },
      "typeVersion": 1
    },
    {
      "id": "ab6aaa26-df15-4305-b509-a8a6c058ad0f",
      "name": "Modelo de Chat OpenRouter1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        -976,
        320
      ],
      "parameters": {
        "model": "google/gemini-2.0-flash-exp:free",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "1a625956-49b9-4d6c-98f5-cf26fdb8e64c",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -2000,
        384
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {}
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1unoIMG4dKLP1Fw0euo64deo_FyBJp4viN4_Sy4LT0Dc/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1unoIMG4dKLP1Fw0euo64deo_FyBJp4viN4_Sy4LT0Dc",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1unoIMG4dKLP1Fw0euo64deo_FyBJp4viN4_Sy4LT0Dc/edit?usp=drivesdk",
          "cachedResultName": "Affiliate Automation"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2c432e37-5015-4f84-8765-58f8be937812",
      "name": "Modelo de Chat OpenRouter2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        -1680,
        544
      ],
      "parameters": {
        "model": "google/gemini-2.0-flash-exp:free",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "c10eba08-eedc-498f-8bf6-6bce81283408",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1168,
        464
      ],
      "parameters": {
        "columns": {
          "value": {
            "Product Link": "={{ $('Google Sheets Trigger').item.json['Product Link'] }}",
            "Facebook Upload": "Done ✅"
          },
          "schema": [
            {
              "id": "Product Link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Product Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Facebook Upload",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Facebook Upload",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Product Link"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1unoIMG4dKLP1Fw0euo64deo_FyBJp4viN4_Sy4LT0Dc/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1unoIMG4dKLP1Fw0euo64deo_FyBJp4viN4_Sy4LT0Dc",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1unoIMG4dKLP1Fw0euo64deo_FyBJp4viN4_Sy4LT0Dc/edit?usp=drivesdk",
          "cachedResultName": "Affiliate Automation"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "fd610152-2766-4a98-a279-d9143ef824c5",
      "name": "Esperar",
      "type": "n8n-nodes-base.wait",
      "position": [
        736,
        464
      ],
      "webhookId": "fe8a2c4f-1f11-4f61-843b-a14ce0fefd74",
      "parameters": {
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "5ff4b215-8ee9-4546-9089-4793b14edbee",
      "name": "Pie de foto FB",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -976,
        144
      ],
      "parameters": {
        "text": "=You are a copywriter helping an Amazon affiliate marketer write high-converting, scroll-stopping Facebook captions.\n\nFor each product, generate a short and engaging caption (1–3 lines max) that:\n- Grabs attention fast\n- Focuses on the product’s top benefit or unique feature\n- Sounds casual and native to Facebook\n- Includes a CTA to buy\n- Ends with the affiliate link\n\nHere is the product name and features:\n\nProduct: {{ $('Amazon Product Details').item.json.data.product_title }}\n\nAbout Product : {{ $('Amazon Product Details').item.json.data.about_product[3] }}\n\nAffiliate Link: {{ $('Amazon Product Details').item.json.data.product_url }}?tag=rakin114-20\n\n\nGive only 1 caption directly and don't contain any symbol. Add emojis and with the affiliate link add here's the poduct or purchase link any thing that goes well.",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 1.8
    },
    {
      "id": "3d13ea66-ad45-49fa-bc9f-aa549bfa371e",
      "name": "Generar Prompt de Imagen",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -96,
        160
      ],
      "parameters": {
        "text": "=Create a very short prompt for an AI image generator that will be fed a photo of a product, to ultimately have professional product photography. \n\n- If the product is wearable you have to include the product worn by a human model, if it's not wearable then include a model holding it or doing something with it. The product should ALWAYS be with a human model, and with the model's face visible.\n\n- Make sure to include instructions to get the best realism, the best lighting, the best angle, the best colors, the best model positioning, etc. according to the type of product.\n\n- Always prompt it as referring to the product, eg. \"this [PRODUCT]\" so that the AI image generator knows that it's gonna be sent an input photo of the product.\n\n- Make sure to always instruct to include subtle grain for a cinematic look.\n\nThe description of the product will be sent to you. Only reply with the final prompt inside double quotes.\n\nThe prompt must be under 100 words and very simple.\n\n\nHere is the Product Description:\nProduct Title: {{ $('Amazon Product Details').item.json.data.product_title }}\n\nAbout Product: {{ $('Amazon Product Details').item.json.data.about_product[0] }}\n\n",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 1.8
    },
    {
      "id": "1122ff77-f6f2-46bb-b62c-f6060e1aaad9",
      "name": "número asin",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -1680,
        384
      ],
      "parameters": {
        "text": "=You only have to give the asin number from this amazon product url:  {{ $json['Product Link'] }}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 1.8
    },
    {
      "id": "71e48678-a38a-44c0-8222-eae6c3559b49",
      "name": "generador de imágenes IA",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        464
      ],
      "parameters": {
        "url": "=https://generativelanguage.googleapis.com/v1beta/models/gemini-2.0-flash-exp:generateContent?key=YOUR_API_KEY",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"contents\": [\n    {\n      \"role\": \"user\",\n      \"parts\": [\n        {\n          \"fileData\": {\n            \"fileUri\": \"{{ $('Image Upload To Server').item.json.file.uri }}\",\n            \"mimeType\": \"{{ $('Image Upload To Server').item.json.file.mimeType }}\"\n          }\n        },\n        {\n          \"text\": {{ $json.output }}\n        }\n      ]\n    }\n  ],\n  \"generationConfig\": {\n    \"temperature\": 1.4,\n    \"topK\": 40,\n    \"topP\": 0.95,\n    \"maxOutputTokens\": 8192,\n    \"responseModalities\": [\"Text\", \"Image\"]\n  }\n}\n",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "da6e2741-b0f3-4924-87d0-070f30c4a62b",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -352
      ],
      "parameters": {
        "width": 528,
        "height": 272,
        "content": "---\n\n## 1️⃣ Purpose of This Agent\n\nThis workflow automates:\n\n* **Fetching Amazon product details** from a product link (via ASIN extraction).\n* **Generating Facebook captions** and **product images** with AI.\n* **Uploading** final creatives directly to **Facebook** and updating a **Google Sheet** for tracking.\n\n---\n"
      },
      "typeVersion": 1
    },
    {
      "id": "ce082196-a1c0-4411-a9c2-925975475f19",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        -400
      ],
      "parameters": {
        "width": 608,
        "height": 320,
        "content": "\n## 2️⃣ How to Use\n\n* Add a **Product Link** to the connected **Google Sheet**.\n* The workflow will:\n\n  * **Extract** the ASIN number.\n  * **Fetch product details** via **RapidAPI**.\n  * **Generate Facebook captions** using OpenRouter AI.\n  * **Create product image prompts** and send them to **Google Gemini** image generator.\n  * **Upload** the generated creative to Facebook automatically.\n  * **Mark the sheet** as “Done ✅” once complete.\n\n---"
      },
      "typeVersion": 1
    },
    {
      "id": "6ad4dae7-88d7-4531-b1d6-f921c75fee0f",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        -528
      ],
      "parameters": {
        "width": 896,
        "height": 592,
        "content": "## 🛠 Setup Guide\n\n1. **Google Sheets**\n\n   * Connect your sheet to the **Google Sheets Trigger** node.\n   * Ensure columns: “Product Link” & “Facebook Upload” exist.\n\n2. **RapidAPI**\n\n   * Get your [RapidAPI Key](https://rapidapi.com/) and replace `YOUR_API_KEY` in the **Amazon Product Details** node.\n\n3. **OpenRouter**\n\n   * Add your OpenRouter credentials for AI caption generation.\n\n4. **Google Gemini API**\n\n   * Add your [Gemini API Key](https://aistudio.google.com/apikey) for image prompt generation & image creation.\n\n5. **Facebook Graph API**\n\n   * Connect your Facebook account to allow posting to your page/profile.\n\nOnce connected, the workflow is **ready to run automatically** every time you add a new product link to the sheet. 🚀\n\n---"
      },
      "typeVersion": 1
    },
    {
      "id": "ef61af2a-e0c5-4689-a05f-e7bd3c0662ce",
      "name": "Nota Adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1584,
        -464
      ],
      "parameters": {
        "width": 387,
        "height": 390,
        "content": "## Start here: Step-by Step Youtube Tutorial :star:\n\n[![Amazon Affiliate Marketing Automation](https://img.youtube.com/vi/7Gz4C0XbBK8/sddefault.jpg)](https://youtu.be/7Gz4C0XbBK8?si=RtW-ATYRF07C3o7_)"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "7f0c52ab-8b18-4fb6-99d4-963f3340fe4b",
  "connections": {
    "fd610152-2766-4a98-a279-d9143ef824c5": {
      "main": [
        [
          {
            "node": "b56e9f83-0da7-4655-af71-f7ada6c9a175",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ff4b215-8ee9-4546-9089-4793b14edbee": {
      "main": [
        [
          {
            "node": "0a1dc175-1109-475c-908d-f13c4876e5c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1122ff77-f6f2-46bb-b62c-f6060e1aaad9": {
      "main": [
        [
          {
            "node": "7c77fce7-01ef-4ab9-898c-f4378cfb12fb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0a1dc175-1109-475c-908d-f13c4876e5c1": {
      "main": [
        [
          {
            "node": "9150b652-f44a-45d4-83c7-3fd85a1cde48",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2c2b5f47-cc55-4d2a-9184-67fc16d28e73": {
      "main": [
        [
          {
            "node": "fd610152-2766-4a98-a279-d9143ef824c5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b56e9f83-0da7-4655-af71-f7ada6c9a175": {
      "main": [
        [
          {
            "node": "c10eba08-eedc-498f-8bf6-6bce81283408",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "71e48678-a38a-44c0-8222-eae6c3559b49": {
      "main": [
        [
          {
            "node": "2c2b5f47-cc55-4d2a-9184-67fc16d28e73",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1a625956-49b9-4d6c-98f5-cf26fdb8e64c": {
      "main": [
        [
          {
            "node": "1122ff77-f6f2-46bb-b62c-f6060e1aaad9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3d13ea66-ad45-49fa-bc9f-aa549bfa371e": {
      "main": [
        [
          {
            "node": "71e48678-a38a-44c0-8222-eae6c3559b49",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "51f82722-4ea3-423c-80be-fdb8ae8f1f15": {
      "ai_languageModel": [
        [
          {
            "node": "3d13ea66-ad45-49fa-bc9f-aa549bfa371e",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "7c77fce7-01ef-4ab9-898c-f4378cfb12fb": {
      "main": [
        [
          {
            "node": "5ff4b215-8ee9-4546-9089-4793b14edbee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9150b652-f44a-45d4-83c7-3fd85a1cde48": {
      "main": [
        [
          {
            "node": "3d13ea66-ad45-49fa-bc9f-aa549bfa371e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ab6aaa26-df15-4305-b509-a8a6c058ad0f": {
      "ai_languageModel": [
        [
          {
            "node": "5ff4b215-8ee9-4546-9089-4793b14edbee",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "2c432e37-5015-4f84-8765-58f8be937812": {
      "ai_languageModel": [
        [
          {
            "node": "1122ff77-f6f2-46bb-b62c-f6060e1aaad9",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}