8
n8n Españolamn8n.com

Notificador de actualizaciones de menú de alimentos enviado por WhatsApp, correo electrónico y Twilio SMS

Avanzado

Este es unSocial Media, Multimodal AIflujo de automatización del dominio deautomatización que contiene 22 nodos.Utiliza principalmente nodos como If, Set, Code, Wait, EmailSend. Notificador de actualizaciones de menús de restaurantes

Requisitos previos
  • •Pueden requerirse credenciales de autenticación para la API de destino
  • •Credenciales de API de Google Sheets

Nodos utilizados (22)

If
Set
Code
Wait
EmailSend
StickyNote
HttpRequest
GoogleSheets
SplitInBatches
ScheduleTrigger

Categoría

Redes sociales
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": "nZ4j1Y5HdguFrisS",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Food Menu Update Notifier via WhatsApp, Email & Twilio SMS",
  "tags": [],
  "nodes": [
    {
      "id": "7e2bce2a-74b1-4f6d-af45-87e4e9b67739",
      "name": "Enviar notificación WhatsApp",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -280,
        -160
      ],
      "parameters": {
        "url": "https://api.whatsapp.com/send",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "to",
              "value": "={{ $json['WhatsApp Number'] }}"
            },
            {
              "name": "message",
              "value": "={{ $node['Merge Menu with Customer Data'].json.messageData.whatsappMessage }}"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer YOUR_WHATSAPP_API_TOKEN"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "f7ce15a2-4f0e-4547-ab59-5ea71c9cea16",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1660,
        -620
      ],
      "parameters": {
        "color": 3,
        "width": 880,
        "height": 220,
        "content": "## Automatically detects changes in the restaurant's special menu from Google Sheets and notifies customers via their preferred channel – WhatsApp, Email, or SMS (Twilio).\n\n## This ensures real-time updates to all customers about new or updated food offers.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "5a177091-496b-46e2-8243-a2aef1d7a877",
      "name": "Programador diario de actualización de menú",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2260,
        40
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 30
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "90184fe7-7c85-4e1c-8a50-db72dfbbeab6",
      "name": "Obtener datos de menú especial",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2040,
        40
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit#gid=0",
          "cachedResultName": "Special Menu"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit?usp=drivesdk",
          "cachedResultName": "Special Offers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "4f38bdba-10fb-4664-bd82-0562fb5c1236",
      "name": "Detectar cambios en el menú",
      "type": "n8n-nodes-base.code",
      "position": [
        -1820,
        40
      ],
      "parameters": {
        "jsCode": "// Check if menu data has changed since last check\nconst currentData = $input.all();\nconst lastCheckKey = 'last_menu_check';\n\n// Get stored last check data from workflow static data\nconst lastCheckData = $getWorkflowStaticData('global')[lastCheckKey] || null;\n\n// Convert current data to string for comparison\nconst currentDataString = JSON.stringify(currentData);\n\n// Initialize result\nlet hasChanged = false;\nlet newItems = [];\nlet updatedItems = [];\nlet removedItems = [];\n\nif (lastCheckData) {\n  // Compare with previous data\n  if (currentDataString !== lastCheckData.dataString) {\n    hasChanged = true;\n    \n    // Detailed comparison logic\n    const previousItems = JSON.parse(lastCheckData.dataString);\n    const currentItems = currentData;\n    \n    // Find new items (compare by Item ID)\n    newItems = currentItems.filter(current => \n      !previousItems.some(prev => prev['Item ID'] === current['Item ID'])\n    );\n    \n    // Find updated items (same ID but different content)\n    updatedItems = currentItems.filter(current => {\n      const prevItem = previousItems.find(prev => prev['Item ID'] === current['Item ID']);\n      return prevItem && JSON.stringify(prevItem) !== JSON.stringify(current);\n    });\n    \n    // Find removed items (existed before but not now)\n    removedItems = previousItems.filter(prev => \n      !currentItems.some(current => current['Item ID'] === prev['Item ID'])\n    );\n  }\n} else {\n  // First run - all items are considered new\n  hasChanged = true;\n  newItems = currentData;\n}\n\n// Store current data for next comparison\n$getWorkflowStaticData('global')[lastCheckKey] = {\n  dataString: currentDataString,\n  timestamp: new Date().toISOString()\n};\n\n// Return results\nreturn [{\n  json: {\n    hasChanged,\n    newItems,\n    updatedItems,\n    removedItems,\n    totalItems: currentData.length,\n    checkTime: new Date().toISOString()\n  }\n}];"
      },
      "typeVersion": 2
    },
    {
      "id": "9453db00-32a5-4077-9e2c-dd581bdcc151",
      "name": "Generar mensaje de alerta de menú",
      "type": "n8n-nodes-base.code",
      "position": [
        -1600,
        40
      ],
      "parameters": {
        "jsCode": "// Format menu updates for notifications\nconst data = $json;\nlet message = \"🍽️ **SPECIAL MENU UPDATE** 🍽️\\n\\n\";\n\n// Helper function to extract item data from the nested structure\nfunction extractItemData(items) {\n  if (!items || !Array.isArray(items)) return [];\n  \n  return items.map(item => {\n    // Check if item has a 'json' property (nested structure)\n    if (item.json) {\n      return item.json;\n    }\n    // Otherwise, assume it's already the item data\n    return item;\n  });\n}\n\n// Add new items\nif (data.newItems && data.newItems.length > 0) {\n  message += \"🆕 **NEW ITEMS:**\\n\";\n  const newItemsData = extractItemData(data.newItems);\n  newItemsData.forEach(item => {\n    message += `• ${item['Item Name']} - $${item['Price']}\\n`;\n    if (item['Description']) message += `  ${item['Description']}\\n`;\n  });\n  message += \"\\n\";\n}\n\n// Add updated items\nif (data.updatedItems && data.updatedItems.length > 0) {\n  message += \"📝 **UPDATED ITEMS:**\\n\";\n  const updatedItemsData = extractItemData(data.updatedItems);\n  updatedItemsData.forEach(item => {\n    message += `• ${item['Item Name']} - $${item['Price']}\\n`;\n    if (item['Description']) message += `  ${item['Description']}\\n`;\n  });\n  message += \"\\n\";\n}\n\n// Add removed items\nif (data.removedItems && data.removedItems.length > 0) {\n  message += \"❌ **REMOVED ITEMS:**\\n\";\n  const removedItemsData = extractItemData(data.removedItems);\n  removedItemsData.forEach(item => {\n    message += `• ${item['Item Name']}\\n`;\n  });\n  message += \"\\n\";\n}\n\nmessage += `📊 Total Menu Items: ${data.totalItems}\\n`;\nmessage += `🕐 Updated: ${new Date(data.checkTime).toLocaleString()}\\n\\n`;\nmessage += \"Visit our restaurant or call to place your order! 📞\";\n\n// Create different formats for different channels\nconst whatsappMessage = message;\nconst emailMessage = message.replace(/\\*\\*/g, '').replace(/🍽️|🆕|📝|❌|📊|🕐|📞/g, '');\nconst smsMessage = message.replace(/\\*\\*/g, '').replace(/🍽️|🆕|📝|❌|📊|🕐|📞/g, '').substring(0, 160);\n\n// Calculate lengths properly\nconst newItemsLength = data.newItems ? data.newItems.length : 0;\nconst updatedItemsLength = data.updatedItems ? data.updatedItems.length : 0;\nconst removedItemsLength = data.removedItems ? data.removedItems.length : 0;\n\nreturn [{\n  json: {\n    whatsappMessage,\n    emailMessage,\n    smsMessage,\n    hasNewItems: newItemsLength > 0,\n    hasUpdatedItems: updatedItemsLength > 0,\n    hasRemovedItems: removedItemsLength > 0,\n    totalChanges: newItemsLength + updatedItemsLength + removedItemsLength\n  }\n}];"
      },
      "typeVersion": 2
    },
    {
      "id": "bc83e5ce-dce8-4873-8d0a-9a7a7180c88c",
      "name": "Obtener lista de contactos de clientes",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1380,
        40
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1419004309,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit#gid=1419004309",
          "cachedResultName": "Customers"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit?usp=drivesdk",
          "cachedResultName": "Special Offers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "a7f5a4ab-415d-45aa-b83e-c4e000ea06ee",
      "name": "Combinar menú con datos de clientes",
      "type": "n8n-nodes-base.set",
      "position": [
        -940,
        40
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "customer-data",
              "name": "customers",
              "type": "array",
              "value": "={{ $(\"Fetch Customer Contact List\").all() }}"
            },
            {
              "id": "message-data",
              "name": "=messageData",
              "type": "array",
              "value": "={{ [$(\"Generate Menu Alert Message\").first()] }}"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "fcb2d175-6f06-4dae-8db6-5f10aa998f1b",
      "name": "Dividir por preferencia de notificación",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -720,
        40
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "36c04dee-c856-412b-9477-f51bf2f9be7a",
      "name": "Filtrar usuarios WhatsApp",
      "type": "n8n-nodes-base.if",
      "position": [
        -500,
        -160
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "whatsapp-condition",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['WhatsApp Notifications'] }}",
              "rightValue": "Yes"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "ccada993-edbe-4cd5-8d0e-53b3e1b7454b",
      "name": "Registrar estado WhatsApp",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        -160
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "Sent",
            "Message": "={{ $node['Merge Menu with Customer Data'].json.messageData.whatsappMessage.substring(0, 100) }}...",
            "Timestamp": "={{ new Date().toISOString() }}",
            "Customer Name": "={{ $json['Customer Name'] }}",
            "Notification Type": "WhatsApp"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Customer Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Customer Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Notification Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Notification Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1731532192,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit#gid=1731532192",
          "cachedResultName": "Notification Logs"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit?usp=drivesdk",
          "cachedResultName": "Special Offers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "8ca7e47b-219a-4be1-8ca1-5aea15b4e0c8",
      "name": "Filtrar usuarios de correo electrónico",
      "type": "n8n-nodes-base.if",
      "position": [
        -500,
        40
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "email-condition",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.customers[0].json['Email Notifications'] }}",
              "rightValue": "Yes"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "1510f575-b745-485f-9eaa-10ec1e7e1896",
      "name": "Enviar correo electrónico de menú",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -280,
        40
      ],
      "webhookId": "95c603c6-4b4a-4fcf-861b-d1dc81df76fe",
      "parameters": {
        "text": "={{ $json.messageData[0].json.emailMessage }}",
        "options": {},
        "subject": "🍽️ Special Menu Update - Your Favorite Restaurant",
        "toEmail": "={{ $json.customers.map(customer => customer.json.Email).join(', ') }}",
        "fromEmail": "vrushti@itoneclick.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "3QSx1pWoS0BZcK4c",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "45fa2573-9b05-4f64-976f-e4693d40b7d7",
      "name": "Filtrar usuarios de SMS",
      "type": "n8n-nodes-base.if",
      "position": [
        -500,
        240
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "sms-condition",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['SMS Notifications'] }}",
              "rightValue": "Yes"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "91eca46b-30ca-4e83-8897-cff4ae3d2f1b",
      "name": "Registrar estado de correo electrónico",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        40
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "Sent",
            "Message": "={{ $('Filter Email Users').item.json.messageData[0].emailMessage }}",
            "Timestamp": "={{ new Date().toISOString() }}",
            "Customer Name": "={{ $('Filter Email Users').item.json.customers[0]['Customer Name'] }}",
            "Notification Type": "Email"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Customer Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Customer Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Notification Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Notification Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1731532192,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit#gid=1731532192",
          "cachedResultName": "Notification Logs"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit?usp=drivesdk",
          "cachedResultName": "Special Offers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "e3fe9db7-df90-491a-b471-e1a0eafc4f86",
      "name": "Enviar alerta SMS Twilio",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -280,
        240
      ],
      "parameters": {
        "url": "https://api.twilio.com/2010-04-01/Accounts/YOUR_TWILIO_ACCOUNT_SID/Messages.json",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "From",
              "value": "YOUR_TWILIO_PHONE_NUMBER"
            },
            {
              "name": "To",
              "value": "={{ $json['Phone Number'] }}"
            },
            {
              "name": "Body",
              "value": "={{ $node['Merge Menu with Customer Data'].json.messageData.smsMessage }}"
            }
          ]
        },
        "genericAuthType": "httpBasicAuth",
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/x-www-form-urlencoded"
            }
          ]
        }
      },
      "credentials": {
        "httpBasicAuth": {
          "id": "SS8MHWya3vb8KVFr",
          "name": "temporary cred"
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "36a469d9-6966-4d14-917d-9d619c4220b7",
      "name": "Registrar estado de SMS",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        240
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "Sent",
            "Message": "={{ $node['Merge Menu with Customer Data'].json.messageData.smsMessage.substring(0, 100) }}...",
            "Timestamp": "={{ new Date().toISOString() }}",
            "Customer Name": "={{ $json['Customer Name'] }}",
            "Notification Type": "SMS"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Customer Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Customer Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Notification Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Notification Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1731532192,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit#gid=1731532192",
          "cachedResultName": "Notification Logs"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/185-CpBG7aVkoiq25NXjTW5gnNJC75n7w3TOBH9HpzhQ/edit?usp=drivesdk",
          "cachedResultName": "Special Offers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "14957f37-83b2-48b6-b61d-0244147f77db",
      "name": "Esperar por todos los datos",
      "type": "n8n-nodes-base.wait",
      "position": [
        -1160,
        40
      ],
      "webhookId": "162f6374-f15b-465c-9e71-0f52131bfab8",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "3694a6bc-9a67-4b03-a1ea-cb059e330431",
      "name": "Nota adhesiva 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2320,
        -240
      ],
      "parameters": {
        "color": 5,
        "width": 620,
        "height": 660,
        "content": "## Automatically checks the special menu sheet on a schedule (daily/hourly) and detects any updates or changes in menu items."
      },
      "typeVersion": 1
    },
    {
      "id": "5ece58c5-bec4-4b12-bf45-b75654a032c0",
      "name": "Nota adhesiva 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1660,
        -240
      ],
      "parameters": {
        "height": 660,
        "content": "## Creates a custom message (with updated menu info) to be sent to customers in a readable and attractive format."
      },
      "typeVersion": 1
    },
    {
      "id": "bf1b3482-a6cb-4015-942d-45277284575e",
      "name": "Nota adhesiva 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1380,
        -240
      ],
      "parameters": {
        "color": 6,
        "width": 780,
        "height": 660,
        "content": "## Reads customer contact info and communication preferences (WhatsApp, Email, or SMS), then prepares data for each user."
      },
      "typeVersion": 1
    },
    {
      "id": "984c9afc-655e-45e1-a0de-aea5a2fe7bfb",
      "name": "Nota adhesiva 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        -400
      ],
      "parameters": {
        "color": 4,
        "width": 680,
        "height": 820,
        "content": "## Sends the menu update to customers via their selected channel and logs the status for confirmation and audit.\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "0ef23c49-3d4e-4a28-91a9-19037f3121c2",
  "connections": {
    "1510f575-b745-485f-9eaa-10ec1e7e1896": {
      "main": [
        [
          {
            "node": "91eca46b-30ca-4e83-8897-cff4ae3d2f1b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "45fa2573-9b05-4f64-976f-e4693d40b7d7": {
      "main": [
        [
          {
            "node": "e3fe9db7-df90-491a-b471-e1a0eafc4f86",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "91eca46b-30ca-4e83-8897-cff4ae3d2f1b": {
      "main": [
        []
      ]
    },
    "14957f37-83b2-48b6-b61d-0244147f77db": {
      "main": [
        [
          {
            "node": "a7f5a4ab-415d-45aa-b83e-c4e000ea06ee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8ca7e47b-219a-4be1-8ca1-5aea15b4e0c8": {
      "main": [
        [
          {
            "node": "1510f575-b745-485f-9eaa-10ec1e7e1896",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4f38bdba-10fb-4664-bd82-0562fb5c1236": {
      "main": [
        [
          {
            "node": "9453db00-32a5-4077-9e2c-dd581bdcc151",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ccada993-edbe-4cd5-8d0e-53b3e1b7454b": {
      "main": [
        []
      ]
    },
    "36c04dee-c856-412b-9477-f51bf2f9be7a": {
      "main": [
        [
          {
            "node": "7e2bce2a-74b1-4f6d-af45-87e4e9b67739",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e3fe9db7-df90-491a-b471-e1a0eafc4f86": {
      "main": [
        [
          {
            "node": "36a469d9-6966-4d14-917d-9d619c4220b7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "90184fe7-7c85-4e1c-8a50-db72dfbbeab6": {
      "main": [
        [
          {
            "node": "4f38bdba-10fb-4664-bd82-0562fb5c1236",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7e2bce2a-74b1-4f6d-af45-87e4e9b67739": {
      "main": [
        [
          {
            "node": "ccada993-edbe-4cd5-8d0e-53b3e1b7454b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5a177091-496b-46e2-8243-a2aef1d7a877": {
      "main": [
        [
          {
            "node": "90184fe7-7c85-4e1c-8a50-db72dfbbeab6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bc83e5ce-dce8-4873-8d0a-9a7a7180c88c": {
      "main": [
        [
          {
            "node": "14957f37-83b2-48b6-b61d-0244147f77db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9453db00-32a5-4077-9e2c-dd581bdcc151": {
      "main": [
        [
          {
            "node": "bc83e5ce-dce8-4873-8d0a-9a7a7180c88c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a7f5a4ab-415d-45aa-b83e-c4e000ea06ee": {
      "main": [
        [
          {
            "node": "fcb2d175-6f06-4dae-8db6-5f10aa998f1b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fcb2d175-6f06-4dae-8db6-5f10aa998f1b": {
      "main": [
        [
          {
            "node": "36c04dee-c856-412b-9477-f51bf2f9be7a",
            "type": "main",
            "index": 0
          },
          {
            "node": "45fa2573-9b05-4f64-976f-e4693d40b7d7",
            "type": "main",
            "index": 0
          },
          {
            "node": "8ca7e47b-219a-4be1-8ca1-5aea15b4e0c8",
            "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 - Redes sociales, 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

Automatización inteligente de Reddit multi-agente de Arunava
Usar mención de marca de IA y Baserow para rastrear automáticamente comentarios publicados en Reddit
If
Set
Code
+
If
Set
Code
35 NodosArunava
Redes sociales
Automatización de la entrega y el cumplimiento de contratos de influencers de Instagram
Automatizar la conformidad contractual de influencers de Instagram con Claude AI y recordatorios de Slack
If
Set
Code
+
If
Set
Code
26 NodosOneclick AI Squad
Redes sociales
Promoción automática de marca en Twitter
Promoción automática de marca en Twitter utilizando Anthropic Claude AI y Google Sheets
Set
Code
Wait
+
Set
Code
Wait
26 NodosPavlo Hurhu
Redes sociales
Motor de recomendación de libros impulsado por IA
Sistema de recomendación de libros basado en correos, usando el modelo de lenguaje grande Ollama y la API de OpenLibrary
If
Set
Code
+
If
Set
Code
21 NodosOneclick AI Squad
Chatbot de soporte
Supervisión automatizada del tiempo de actividad de la API y alertas de inactividad instantáneas
Monitoreo de tiempo de actividad de la API, con alertas de WhatsApp y gestión en Google Sheets
If
Code
Wait
+
If
Code
Wait
17 NodosOneclick AI Squad
DevOps
Investigador de creatividad de MetaAds v1.4
Usar Google Vision y Video Intelligence API para analizar las creatividades de anuncios de Meta
If
Set
Code
+
If
Set
Code
32 NodosKirill Khatkevich
Investigación de mercado
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos22
Categoría2
Tipos de nodos10
Descripción de la dificultad

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

Autor
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

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