8
n8n Españolamn8n.com

Registrador de pedidos automatizado con actualizaciones de estado en tiempo real

Avanzado

Este es unCRM, Miscellaneous, Multimodal AIflujo de automatización del dominio deautomatización que contiene 16 nodos.Utiliza principalmente nodos como If, Set, Webhook, HttpRequest, GoogleSheets. Registrar pedidos de comercio electrónico en Google Sheets, con paginación mensual y seguimiento de estado

Requisitos previos
  • •Punto final de HTTP Webhook (n8n generará automáticamente)
  • •Pueden requerirse credenciales de autenticación para la API de destino
  • •Credenciales de API de Google Sheets

Nodos utilizados (16)

If
Set
Webhook
StickyNote
HttpRequest
GoogleSheets

Categoría

CRM
Varios
IA Multimodal
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
React Flow
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "OskOgJPf2GrczCTF",
  "meta": {
    "instanceId": "54982cbe9f8132ea9a4a7e9e8f355b9eb6ea3f69d2ba679cde0f482c65ee4fcb",
    "templateCredsSetupCompleted": true
  },
  "name": "📊 Automated Order Logger with Live Status Updates",
  "tags": [],
  "nodes": [
    {
      "id": "eb4915cc-2cbc-43cb-a1ee-0714066b19a7",
      "name": "Config (establecer spreadsheetId)",
      "type": "n8n-nodes-base.set",
      "position": [
        -208,
        160
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "spreadsheetId",
              "value": "<spreadsheetID>"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "56cfe15b-f599-4998-99e4-575c16511885",
      "name": "Crear Pestaña del Mes",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        912,
        256
      ],
      "parameters": {
        "url": "=https://sheets.googleapis.com/v4/spreadsheets/{{$node[\"Config (set spreadsheetId)\"].json.spreadsheetId}}:batchUpdate",
        "body": "={ \"requests\": [ { \"addSheet\": { \"properties\": { \"title\": \"{{ $json['Sheet name'].replace(/(?:\\r?\\n|\\\\n)+$/,'').trimEnd() }}\", \"gridProperties\": { \"frozenRowCount\": 1 } } } } ] }",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "raw",
        "authentication": "predefinedCredentialType",
        "rawContentType": "application/json",
        "nodeCredentialType": "googleSheetsOAuth2Api"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "qEgp5kyhWuhE456l",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "f866f538-850a-403f-8b94-dc46b6e4b27f",
      "name": "Escribir Encabezados (A1:I1)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1136,
        256
      ],
      "parameters": {
        "url": "=https://sheets.googleapis.com/v4/spreadsheets/{{$json.spreadsheetId}}:batchUpdate",
        "body": "={\n  \"requests\": [\n    {\n      \"updateCells\": {\n        \"start\": { \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"rowIndex\": 0, \"columnIndex\": 0 },\n        \"rows\": [\n          { \"values\": [\n            { \"userEnteredValue\": { \"stringValue\": \"OrderId\" } },\n            { \"userEnteredValue\": { \"stringValue\": \"Date\" } },\n            { \"userEnteredValue\": { \"stringValue\": \"Customer Name\" } },\n            { \"userEnteredValue\": { \"stringValue\": \"Order\" } },\n            { \"userEnteredValue\": { \"stringValue\": \"Order Value\" } },\n            { \"userEnteredValue\": { \"stringValue\": \"Status\" } }\n          ] }\n        ],\n        \"fields\": \"userEnteredValue\"\n      }\n    },\n  {\n  \"repeatCell\": {\n    \"range\": {\n      \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }},\n      \"startRowIndex\": 1,         \n      \"startColumnIndex\": 1,     \n      \"endColumnIndex\": 2\n    },\n    \"cell\": {\n      \"userEnteredFormat\": {\n        \"numberFormat\": {\n          \"type\": \"DATE\",\n          \"pattern\": \"dd mmm\"\n        }\n      }\n    },\n    \"fields\": \"userEnteredFormat.numberFormat\"\n  }\n},\n\n    { \"setDataValidation\": { \"range\": { \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 },\n      \"rule\": { \"condition\": { \"type\": \"ONE_OF_LIST\", \"values\": [\n        { \"userEnteredValue\": \"Not Shipped\" },\n        { \"userEnteredValue\": \"Pickup Scheduled\" },\n        { \"userEnteredValue\": \"Shipped\" },\n        { \"userEnteredValue\": \"InTransit\" },\n        { \"userEnteredValue\": \"Delivered\" },\n        { \"userEnteredValue\": \"Cancelled\" }\n      ] }, \"strict\": true, \"showCustomUi\": true } } },\n\n\n    { \"addConditionalFormatRule\": { \"rule\": { \"ranges\": [{ \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 }],\n      \"booleanRule\": { \"condition\": { \"type\": \"TEXT_EQ\", \"values\": [{ \"userEnteredValue\": \"Delivered\" }] },\n      \"format\": { \"backgroundColor\": { \"red\": 0.40, \"green\": 0.73, \"blue\": 0.42 } } } }, \"index\": 0 } },\n    { \"addConditionalFormatRule\": { \"rule\": { \"ranges\": [{ \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 }],\n      \"booleanRule\": { \"condition\": { \"type\": \"TEXT_EQ\", \"values\": [{ \"userEnteredValue\": \"Shipped\" }] },\n      \"format\": { \"backgroundColor\": { \"red\": 0.65, \"green\": 0.84, \"blue\": 0.66 } } } }, \"index\": 1 } },\n    { \"addConditionalFormatRule\": { \"rule\": { \"ranges\": [{ \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 }],\n      \"booleanRule\": { \"condition\": { \"type\": \"TEXT_EQ\", \"values\": [{ \"userEnteredValue\": \"InTransit\" }] },\n      \"format\": { \"backgroundColor\": { \"red\": 0.69, \"green\": 0.75, \"blue\": 0.77 } } } }, \"index\": 2 } },\n    { \"addConditionalFormatRule\": { \"rule\": { \"ranges\": [{ \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 }],\n      \"booleanRule\": { \"condition\": { \"type\": \"TEXT_EQ\", \"values\": [{ \"userEnteredValue\": \"Not Shipped\" }] },\n      \"format\": { \"backgroundColor\": { \"red\": 0.96, \"green\": 0.83, \"blue\": 0.40 } } } }, \"index\": 3 } },\n    { \"addConditionalFormatRule\": { \"rule\": { \"ranges\": [{ \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 }],\n      \"booleanRule\": { \"condition\": { \"type\": \"TEXT_EQ\", \"values\": [{ \"userEnteredValue\": \"Pickup Scheduled\" }] },\n      \"format\": { \"backgroundColor\": { \"red\": 0.88, \"green\": 0.88, \"blue\": 0.88 } } } }, \"index\": 4 } },\n    { \"addConditionalFormatRule\": { \"rule\": { \"ranges\": [{ \"sheetId\": {{ $json.replies[0].addSheet.properties.sheetId }}, \"startRowIndex\": 1, \"startColumnIndex\": 5, \"endColumnIndex\": 6 }],\n      \"booleanRule\": { \"condition\": { \"type\": \"TEXT_EQ\", \"values\": [{ \"userEnteredValue\": \"Cancelled\" }] },\n      \"format\": { \"backgroundColor\": { \"red\": 0.94, \"green\": 0.33, \"blue\": 0.31 } } } }, \"index\": 5 } }\n  ]\n}\n",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "raw",
        "authentication": "predefinedCredentialType",
        "rawContentType": "application/json",
        "nodeCredentialType": "googleSheetsOAuth2Api"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "qEgp5kyhWuhE456l",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "ad5a0bd0-81d8-46e8-8e2a-3e2cce0a8be1",
      "name": "Pedido creado",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -432,
        160
      ],
      "webhookId": "0ad91e1c-4e03-499c-9376-c096c30a354d",
      "parameters": {
        "path": "0ad91e1c-4e03-499c-9376-c096c30a354d",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2.1
    },
    {
      "id": "4e47467b-2dcf-4837-bb83-557ceae7e58f",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        464,
        160
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "ef13dc32-becb-4456-b67e-1820c057817b",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              },
              "leftValue": "={{\n  (() => {\n    const target = String($node[\"Generate Sheet Name\"].json[\"Sheet name\"] ?? \"\")\n      .replace(/[\\r\\n\\u2028\\u2029]/g,\"\").replace(/\\\\n/g,\"\").trim();\n\n    const titles = ($node[\"Get Order Sheets metadata\"].json.sheets || [])\n      .map(s => String(s.properties?.title ?? \"\")\n        .replace(/[\\r\\n\\u2028\\u2029]/g,\"\").replace(/\\\\n/g,\"\").trim());\n\n    return titles.includes(target);   // <-- boolean\n  })()\n}}",
              "rightValue": true
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "7289baf5-cd38-48b2-923e-b98b48f95468",
      "name": "Google Sheets Row values",
      "type": "n8n-nodes-base.set",
      "position": [
        1360,
        256
      ],
      "parameters": {
        "values": {
          "number": [
            {
              "name": "Date",
              "value": "={{\n  (() => {\n    const tz='Asia/Kolkata';\n    const d = new Date($('Order created').item.json.body.updated_at);\n    const y = +d.toLocaleString('en-US',{year:'numeric',  timeZone:tz});\n    const m = +d.toLocaleString('en-US',{month:'2-digit', timeZone:tz});\n    const day = +d.toLocaleString('en-US',{day:'2-digit', timeZone:tz});\n    const serial = Date.UTC(y, m-1, day) / 86400000 + 25569;\n    return Math.round(serial * 1e5) / 1e5;   // number; no leading apostrophe\n  })()\n}}"
            }
          ],
          "string": [
            {
              "name": "OrderName",
              "value": "={{\n  (( $('Order created').item.json.body.line_items ?? $json.line_items) || [])\n    .map(li => {\n      const t = (li.name ?? '').trim();\n      const q = Number(li.quantity ?? 1);\n      return `${t}${q>1 ? ' x'+q : ''}`;\n    })\n    .filter(Boolean)\n    .join('\\n')\n}}"
            },
            {
              "name": "PaymentMode",
              "value": "={{   (() => {     const s = String($('Order created').item.json.body.financial_status ?? '');      if (s === 'paid') return 'Prepaid';     if (s === \"partially_paid\") return 'COD';     if (s === \"voided\") return 'voided';     return s;   })() }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "6f268d17-bfe3-4ac6-a18a-ecff9d258733",
      "name": "Generar Nombre de Pestaña",
      "type": "n8n-nodes-base.set",
      "position": [
        240,
        160
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "Sheet name",
              "value": "={{\n  ( () => {\n    const tz = 'Asia/Kolkata';\n    const d  = new Date(); // or new Date($json.date || Date.now())\n    const MONTH = d.toLocaleString('en-US', { month: 'long', timeZone: tz }).toUpperCase();\n    const YY    = String(d.getFullYear()).slice(-2);\n     const raw   = `${MONTH} ORDERS'${YY}`;\n    // remove real newlines \\n or \\r, literal \"\\n\", and any stray unicode line separators\n   return raw.split(/(?:\\r?\\n|\\\\n|[\\u2028\\u2029])/)[0].trim();\n  })()\n}}\n"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "8e2059e0-3412-4fba-a629-b627d90814f2",
      "name": "Google Sheets Row values existing",
      "type": "n8n-nodes-base.set",
      "position": [
        688,
        64
      ],
      "parameters": {
        "values": {
          "number": [
            {
              "name": "Date",
              "value": "={{\n  (() => {\n    const tz='Asia/Kolkata';\n    const d = new Date($('Order created').item.json.body.updated_at);\n    const y = +d.toLocaleString('en-US',{year:'numeric',  timeZone:tz});\n    const m = +d.toLocaleString('en-US',{month:'2-digit', timeZone:tz});\n    const day = +d.toLocaleString('en-US',{day:'2-digit', timeZone:tz});\n    const serial = Date.UTC(y, m-1, day) / 86400000 + 25569;\n    return Math.round(serial * 1e5) / 1e5;   // number; no leading apostrophe\n  })()\n}}"
            }
          ],
          "string": [
            {
              "name": "OrderName",
              "value": "={{\n  (( $('Order created').item.json.body.line_items ?? $json.line_items) || [])\n    .map(li => {\n      const t = (li.name ?? '').trim();\n      const q = Number(li.quantity ?? 1);\n      return `${t}${q>1 ? ' x'+q : ''}`;\n    })\n    .filter(Boolean)\n    .join('\\n')\n}}"
            },
            {
              "name": "PaymentMode",
              "value": "={{   (() => {     const s = String($('Order created').item.json.body.financial_status ?? '');      \nif (s === 'paid') \nreturn 'Prepaid';     if (s === \"partially_paid\") return 'COD';     if (s === \"voided\") return 'voided';     return s;   })() }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "d068bf77-aecd-4a12-a969-b880d9912b7d",
      "name": "Establecer Fila y Columna Inicial de Pestaña",
      "type": "n8n-nodes-base.set",
      "position": [
        688,
        256
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "Sheet Starting Row Col",
              "value": "={{\n  (() => {\n    // take whatever you stored earlier as \"Sheet name\"\n    const raw = String($json['Sheet name'] ?? '');\n\n    // 1) remove real line breaks + literal \"\\n\"\n    const clean = raw\n      .replace(/[\\r\\n\\u2028\\u2029]/g, '')  // real newlines\n      .replace(/\\\\n/g, '')                 // literal backslash+n\n      .trim();\n\n    // 2) escape apostrophes for A1 and wrap in single quotes\n    const quoted = `'${ clean.replace(/'/g, \"''\") }'`;\n\n    // 3) return A1 range\n    return `${quoted}!A1`;\n  })()\n}}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "cdbf4821-1a28-410b-8811-3cf94aec8acc",
      "name": "Obtener Metadatos de Pestañas de Pedidos",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        16,
        160
      ],
      "parameters": {
        "url": "=https://sheets.googleapis.com/v4/spreadsheets/{{$json.spreadsheetId}}?fields=sheets.properties.title",
        "options": {},
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "googleSheetsOAuth2Api"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "qEgp5kyhWuhE456l",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "4dcf159b-4292-462d-9df9-2c7b27a2beae",
      "name": "Añadir a Pestaña de Pedidos Existente",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        912,
        64
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $json.Date }}",
            "Order": "={{ $json.OrderName }}",
            "Status": "={{ \"Not Shipped\" }}",
            "OrderId": "={{ $('Config (set spreadsheetId)').item.json.body.name }}",
            "Order Value": "={{ $('Order created').item.json.body.current_total_price }}",
            "Customer Name": "={{ $('Order created').item.json.body.billing_address.name }}"
          },
          "schema": [
            {
              "id": "OrderId",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "OrderId",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Customer Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Customer Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Order",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Order",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Order Value",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Order Value",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Payment mode",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Payment mode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Packing status",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Packing status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Remittance status",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Remittance status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Confirmation",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Confirmation",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "={{ $('Generate Sheet Name').item.json['Sheet name'].replace(/(?:\\r?\\n|\\\\n)+$/,'').trimEnd() }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('Config (set spreadsheetId)').item.json.spreadsheetId }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "qEgp5kyhWuhE456l",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "5a05849a-d37c-4411-8146-6213bdd78210",
      "name": "Añadir a Pestaña de Pedidos",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1584,
        256
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $json.Date }}",
            "Order": "={{ $json.OrderName }}",
            "Status": "={{ \"Not Shipped\" }}",
            "OrderId": "={{ $('Config (set spreadsheetId)').item.json.body.name }}",
            "Order Value": "={{ $('Order created').item.json.body.current_total_price }}",
            "Customer Name": "={{ $('Order created').item.json.body.billing_address.name }}"
          },
          "schema": [
            {
              "id": "OrderId",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "OrderId",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Customer Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Customer Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Order",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Order",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Order Value",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Order Value",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Payment mode",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Payment mode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Packing status",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Packing status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Remittance status",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Remittance status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Confirmation",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Confirmation",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "={{ $('Generate Sheet Name').item.json['Sheet name'].replace(/(?:\\r?\\n|\\\\n)+$/,'').trimEnd()}}"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.spreadsheetId }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "qEgp5kyhWuhE456l",
          "name": "N8n Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "aaca5f17-a1cf-449d-b322-7af562087bd1",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -960,
        64
      ],
      "parameters": {
        "color": 3,
        "width": 460,
        "height": 328,
        "content": "## Input\n- Shopify → Webhook URL (add in Settings → Notifications → Webhooks)\n- Events: Order creation, update, fulfillment\n\n![](https://ik.imagekit.io/tscnqj8zf/shopify_ordersample.png?updatedAt=1756972462275)"
      },
      "typeVersion": 1
    },
    {
      "id": "80d21450-be10-426a-a5e9-12a93473cec8",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        0
      ],
      "parameters": {
        "width": 272,
        "height": 144,
        "content": "### Update your google spreedsheet Id\nGoogle Sheet → spreadsheetId (docs.google.com/spreadsheets/d/<id>/)"
      },
      "typeVersion": 1
    },
    {
      "id": "b9fe7e61-3f90-404c-9a07-661bdbb83f9a",
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        336
      ],
      "parameters": {
        "width": 352,
        "height": 240,
        "content": "### Fetch the existing sheet details\n\n![](https://ik.imagekit.io/tscnqj8zf/Excel%20sheet.png?updatedAt=1756974906066)"
      },
      "typeVersion": 1
    },
    {
      "id": "4f0222b4-b959-458c-ae58-82e204eb451e",
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1808,
        0
      ],
      "parameters": {
        "color": 4,
        "width": 672,
        "height": 560,
        "content": "## Output \n- Auto-create monthly sub-sheet (name = current month)\n- Append order rows into month tab\n- Status column with options:\nNot Shipped, Pickup Scheduled, Shipped, InTransit, Delivered, Cancelled\n\n\n![](https://ik.imagekit.io/tscnqj8zf/sheets_with_orders.png?updatedAt=1756974957910)"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c27e7ae9-6acb-47cb-bd20-1ac84b127e76",
  "connections": {
    "4e47467b-2dcf-4837-bb83-557ceae7e58f": {
      "main": [
        [
          {
            "node": "8e2059e0-3412-4fba-a629-b627d90814f2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "d068bf77-aecd-4a12-a969-b880d9912b7d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ad5a0bd0-81d8-46e8-8e2a-3e2cce0a8be1": {
      "main": [
        [
          {
            "node": "eb4915cc-2cbc-43cb-a1ee-0714066b19a7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "56cfe15b-f599-4998-99e4-575c16511885": {
      "main": [
        [
          {
            "node": "f866f538-850a-403f-8b94-dc46b6e4b27f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6f268d17-bfe3-4ac6-a18a-ecff9d258733": {
      "main": [
        [
          {
            "node": "4e47467b-2dcf-4837-bb83-557ceae7e58f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f866f538-850a-403f-8b94-dc46b6e4b27f": {
      "main": [
        [
          {
            "node": "7289baf5-cd38-48b2-923e-b98b48f95468",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7289baf5-cd38-48b2-923e-b98b48f95468": {
      "main": [
        [
          {
            "node": "5a05849a-d37c-4411-8146-6213bdd78210",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cdbf4821-1a28-410b-8811-3cf94aec8acc": {
      "main": [
        [
          {
            "node": "6f268d17-bfe3-4ac6-a18a-ecff9d258733",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "eb4915cc-2cbc-43cb-a1ee-0714066b19a7": {
      "main": [
        [
          {
            "node": "cdbf4821-1a28-410b-8811-3cf94aec8acc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d068bf77-aecd-4a12-a969-b880d9912b7d": {
      "main": [
        [
          {
            "node": "56cfe15b-f599-4998-99e4-575c16511885",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8e2059e0-3412-4fba-a629-b627d90814f2": {
      "main": [
        [
          {
            "node": "4dcf159b-4292-462d-9df9-2c7b27a2beae",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - CRM, Varios, IA Multimodal

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.

Flujos de trabajo relacionados recomendados

Mi flujo de trabajo 4
Crear una integración bidireccional de WhatsApp + Telegram para más de 10,000 chats de soporte al cliente
If
Set
Merge
+
If
Set
Merge
30 NodosRuthwik
Chatbot de soporte
Analizador de brechas de contenido de la competencia: mapeo automático de temas del sitio web
Analizar brechas de contenido de competidores con Gemini AI, Apify y Google Sheets
If
Set
Code
+
If
Set
Code
30 NodosMychel Garzon
Varios
Análisis inteligente diario de grupos de WhatsApp: Análisis con GPT-4.1 y transcripción de mensajes de voz
Análisis inteligente diario de grupos de WhatsApp: análisis con GPT-4.1 y transcripción de mensajes de voz
If
Set
Code
+
If
Set
Code
52 NodosDaniel Lianes
Varios
Soporte al cliente de WhatsApp impulsado por IA para marcas de Shopify
Soporte al cliente de WhatsApp para marcas Shopify impulsado por AI (agente LLM)
Set
Slack
Switch
+
Set
Slack
Switch
30 NodosRuthwik
Varios
Clasificación y etiquetado de correos electrónicos con IA en Zoho Mail
Clasificación y etiquetado automático de correos en Zoho Mail con GPT-4o-mini
Set
Code
Merge
+
Set
Code
Merge
17 NodosRuthwik Masina
Varios
Generar automáticamente presentaciones de ventas con GPT-4o y Google Slides basadas en llamadas de Claap
Usar GPT-4o y Google Slides para generar automáticamente presentaciones de ventas a partir de llamadas de Claap
If
Set
Code
+
If
Set
Code
20 NodosRobin Bonduelle
CRM
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos16
Categoría3
Tipos de nodos6
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Ruthwik Masina

Ruthwik Masina

@ruthwik
Enlaces externos
Ver en n8n.io →

Compartir este flujo de trabajo

Categorías

IA Multimodal
1540
Inteligencia Artificial
1108
Creación de contenido
695
Resumen de IA
516
Marketing
419
Chatbot de IA
251
Ingeniería
241
Investigación de mercado
203
Varios
193
Otros
176
Ventas
162
Operaciones de TI
156
Extracción de documentos
147
RAG de IA
146
Bloques de construcción
144
Redes sociales
137
Generación de leads
125
Productividad personal
117
DevOps
111
Recursos Humanos
101
Soporte
97
Nutrición de leads
87
CRM
82
Finanzas
81
Producto
77
Chatbot de soporte
76
Diseño
70
Gestión de tickets
67
Operaciones de seguridad
57
Procesamiento de facturas
53
Comercio de criptomonedas
49
Gestión de archivos
39
Gestión de proyectos
35
Wiki interno
32

Categorías: 34