AutomationFlowsEmail & Gmail › Addendo — Inteligencia De Mercado Semanal

Addendo — Inteligencia De Mercado Semanal

Addendo — Inteligencia de Mercado Semanal. Uses httpRequest, gmail. Scheduled trigger; 8 nodes.

Cron / scheduled trigger★★★★☆ complexity8 nodesHTTP RequestGmail
Email & Gmail Trigger: Cron / scheduled Nodes: 8 Complexity: ★★★★☆ Added:

This workflow follows the Gmail → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "updatedAt": "2026-04-10T17:54:50.418Z",
  "createdAt": "2026-04-10T17:44:36.386Z",
  "id": "aOV4y4GB7nmRVzo4",
  "name": "Addendo \u2014 Inteligencia de Mercado Semanal",
  "description": null,
  "active": true,
  "isArchived": false,
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 6 * * 1"
            }
          ]
        }
      },
      "id": "ed6d27ff-cf93-4e8d-af2e-469a69f31800",
      "name": "Schedule Lunes 6AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        -576,
        64
      ]
    },
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "inteligencia-mercado-manual",
        "responseMode": "lastNode",
        "options": {}
      },
      "id": "ff846cbd-3b58-485f-be49-2b6c46e4db4f",
      "name": "Webhook Manual",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        -576,
        304
      ]
    },
    {
      "parameters": {
        "jsCode": "// Lista de clientes activos de Addendo Growth Partner\nconst clientes = [\n  {\n    nombre: 'Don Jacinto Nahual',\n    industria: 'brujo',\n    ciudad: 'Los Angeles',\n    sitio_web: 'donjacintonahual.com',\n    keywords_principales: [\n      'brujo en Los Angeles',\n      'brujeria Los Angeles',\n      'curandero Los Angeles',\n      'spiritual healer Los Angeles',\n      'witch doctor near me',\n      'limpia espiritual Los Angeles',\n      'amarres de amor Los Angeles'\n    ],\n    competidores: [\n      'https://www.yelp.com/search?find_desc=brujo&find_loc=Los+Angeles',\n      'https://www.google.com/search?q=brujo+los+angeles'\n    ]\n  },\n  {\n    nombre: 'Addendo',\n    industria: 'agencia marketing digital',\n    ciudad: 'Los Angeles',\n    sitio_web: 'addendo.io',\n    keywords_principales: [\n      'marketing agency Los Angeles',\n      'digital marketing agency LA',\n      'SEO agency Los Angeles',\n      'PPC management Los Angeles',\n      'web design agency Los Angeles',\n      'social media agency Los Angeles',\n      'Hispanic marketing agency'\n    ],\n    competidores: [\n      'https://www.google.com/search?q=marketing+agency+los+angeles',\n      'https://www.google.com/search?q=hispanic+marketing+agency+los+angeles'\n    ]\n  }\n];\n\nreturn clientes.map(c => ({ json: c }));"
      },
      "id": "8d40bc79-1a1c-4386-bab6-a0cebd937a68",
      "name": "Clientes Activos",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        -288,
        160
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.dataforseo.com/v3/keywords_data/google_ads/keywords_for_keywords/live",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "=[\n  {\n    \"keywords\": {{ JSON.stringify($json.keywords_principales) }},\n    \"language_code\": \"en\",\n    \"location_name\": \"United States\",\n    \"include_seed_keyword\": true,\n    \"sort_by\": \"search_volume\",\n    \"limit\": 50\n  }\n]",
        "options": {
          "timeout": 30000
        }
      },
      "id": "3777624b-ec5b-4e34-af9f-b56e13ac271f",
      "name": "DataForSEO Keywords Semanal",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        0,
        0
      ],
      "credentials": {
        "httpBasicAuth": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.apify.com/v2/acts/apify~google-ads-transparency-scraper/runs?token={{$credentials.apifyApi.token}}&waitForFinish=120",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"queries\": {{ JSON.stringify($json.keywords_principales.slice(0, 3)) }},\n  \"maxResults\": 30,\n  \"language\": \"en\",\n  \"country\": \"US\"\n}",
        "options": {
          "timeout": 180000
        }
      },
      "id": "4b5171af-0044-4fea-b78e-fdaab536b148",
      "name": "Apify Ads Transparency Semanal",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        0,
        208
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.apify.com/v2/acts/apify~website-content-crawler/runs?token={{$credentials.apifyApi.token}}&waitForFinish=120",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"startUrls\": [\n    { \"url\": \"https://{{ $json.sitio_web }}\" },\n    { \"url\": \"{{ $json.competidores[0] }}\" }\n  ],\n  \"maxCrawlPages\": 5,\n  \"crawlerType\": \"cheerio\",\n  \"maxConcurrency\": 5\n}",
        "options": {
          "timeout": 180000
        }
      },
      "id": "dfa26e6f-7aef-4bb6-98f7-33a54f978d42",
      "name": "Apify Scraping Competidores Semanal",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        0,
        400
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.anthropic.com/v1/messages",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "x-api-key",
              "value": "={{$credentials.httpHeaderAuth.value}}"
            },
            {
              "name": "anthropic-version",
              "value": "2023-06-01"
            },
            {
              "name": "content-type",
              "value": "application/json"
            }
          ]
        },
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"model\": \"claude-sonnet-4-20250514\",\n  \"max_tokens\": 4096,\n  \"messages\": [\n    {\n      \"role\": \"user\",\n      \"content\": \"Eres el analista de inteligencia de mercado de Addendo Growth Partner.\\n\\nGenera el REPORTE SEMANAL DE INTELIGENCIA DE MERCADO para el siguiente cliente.\\n\\n## CLIENTE\\nNombre: {{ $('Clientes Activos').item.json.nombre }}\\nIndustria: {{ $('Clientes Activos').item.json.industria }}\\nCiudad: {{ $('Clientes Activos').item.json.ciudad }}\\nSitio Web: {{ $('Clientes Activos').item.json.sitio_web }}\\n\\n## DATOS DE KEYWORDS (DataForSEO)\\n{{ JSON.stringify($('DataForSEO Keywords Semanal').item.json, null, 2).substring(0, 3000) }}\\n\\n## ANUNCIOS ACTIVOS COMPETIDORES (Google Ads Transparency)\\n{{ JSON.stringify($('Apify Ads Transparency Semanal').item.json, null, 2).substring(0, 3000) }}\\n\\n## SCRAPING PAGINAS COMPETIDORES\\n{{ JSON.stringify($('Apify Scraping Competidores Semanal').item.json, null, 2).substring(0, 3000) }}\\n\\n---\\n\\nGenera el reporte con estas secciones:\\n\\n1. **RESUMEN EJECUTIVO** \u2014 Estado del mercado esta semana\\n2. **IDEAS DE BLOGS** \u2014 5 ideas de blog posts basadas en keywords trending y gaps de contenido. Incluir: titulo sugerido, keyword target, volumen estimado, y angulo unico\\n3. **OPORTUNIDADES DE KEYWORDS** \u2014 Keywords nuevas o con cambios significativos de volumen. Tabla con: keyword, volumen, competencia, CPC, y recomendacion\\n4. **MEJORAS AL SITIO WEB** \u2014 Basado en el scraping del sitio del cliente vs competidores, que mejorar en UX, contenido, CTAs, velocidad\\n5. **ANALISIS DE ANUNCIOS COMPETIDORES** \u2014 Que estan anunciando, copy que usan, landing pages, presupuesto estimado, y oportunidades para el cliente\\n6. **ACCIONES RECOMENDADAS ESTA SEMANA** \u2014 Top 3 acciones priorizadas por impacto\\n\\nFormato: HTML profesional listo para email. Usa tablas, colores sutiles, y formato limpio.\"\n    }\n  ]\n}",
        "options": {
          "timeout": 120000
        }
      },
      "id": "72dfe796-c465-430a-ad17-458725b4fdde",
      "name": "Claude Reporte Semanal",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        320,
        208
      ]
    },
    {
      "parameters": {
        "sendTo": "admin@addendo.io",
        "subject": "=Reporte Inteligencia de Mercado \u2014 {{ $('Clientes Activos').item.json.nombre }} \u2014 {{ new Date().toLocaleDateString('es-MX', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' }) }}",
        "message": "=<div style=\"font-family: Arial, sans-serif; max-width: 800px; margin: 0 auto;\">\n<div style=\"background: #1a1a2e; color: white; padding: 20px; text-align: center;\">\n  <h1 style=\"margin: 0;\">Addendo Growth Partner</h1>\n  <p style=\"margin: 5px 0 0; opacity: 0.8;\">Reporte Semanal de Inteligencia de Mercado</p>\n</div>\n<div style=\"padding: 20px; background: #f5f5f5;\">\n  <p><strong>Cliente:</strong> {{ $('Clientes Activos').item.json.nombre }}</p>\n  <p><strong>Industria:</strong> {{ $('Clientes Activos').item.json.industria }}</p>\n  <p><strong>Ciudad:</strong> {{ $('Clientes Activos').item.json.ciudad }}</p>\n  <p><strong>Fecha:</strong> {{ new Date().toLocaleDateString('es-MX', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' }) }}</p>\n</div>\n<div style=\"padding: 20px;\">\n{{ $json.content ? $json.content[0].text : JSON.stringify($json, null, 2) }}\n</div>\n<div style=\"background: #1a1a2e; color: white; padding: 15px; text-align: center; font-size: 12px;\">\n  <p>Generado automaticamente por Addendo Growth Partner | addendo.io</p>\n</div>\n</div>",
        "options": {}
      },
      "id": "8ae2e579-b012-407f-8b31-7e3084497031",
      "name": "Gmail Reporte Semanal",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2.1,
      "position": [
        608,
        208
      ],
      "credentials": {
        "gmailOAuth2": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "Schedule Lunes 6AM": {
      "main": [
        [
          {
            "node": "Clientes Activos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook Manual": {
      "main": [
        [
          {
            "node": "Clientes Activos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clientes Activos": {
      "main": [
        [
          {
            "node": "DataForSEO Keywords Semanal",
            "type": "main",
            "index": 0
          },
          {
            "node": "Apify Ads Transparency Semanal",
            "type": "main",
            "index": 0
          },
          {
            "node": "Apify Scraping Competidores Semanal",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "DataForSEO Keywords Semanal": {
      "main": [
        [
          {
            "node": "Claude Reporte Semanal",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apify Ads Transparency Semanal": {
      "main": [
        [
          {
            "node": "Claude Reporte Semanal",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apify Scraping Competidores Semanal": {
      "main": [
        [
          {
            "node": "Claude Reporte Semanal",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Reporte Semanal": {
      "main": [
        [
          {
            "node": "Gmail Reporte Semanal",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1",
    "binaryMode": "separate",
    "availableInMCP": false
  },
  "staticData": {
    "node:Schedule Lunes 6AM": {
      "recurrenceRules": []
    }
  },
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "versionId": "b19af88a-0a22-4e40-affd-973e4ce57980",
  "activeVersionId": "b19af88a-0a22-4e40-affd-973e4ce57980",
  "versionCounter": 10,
  "triggerCount": 2,
  "shared": [
    {
      "updatedAt": "2026-04-10T17:44:36.390Z",
      "createdAt": "2026-04-10T17:44:36.390Z",
      "role": "workflow:owner",
      "workflowId": "aOV4y4GB7nmRVzo4",
      "projectId": "kOz4cM3t590yiTX0",
      "project": {
        "updatedAt": "2026-04-06T19:49:50.605Z",
        "createdAt": "2026-04-06T05:13:47.025Z",
        "id": "kOz4cM3t590yiTX0",
        "name": "Jose Raul  Ramirez  <admin@addendo.io>",
        "type": "personal",
        "icon": null,
        "description": null,
        "creatorId": "22729d36-131e-405e-8267-dcd82aca785f"
      }
    }
  ],
  "tags": [
    {
      "updatedAt": "2026-04-10T17:41:59.202Z",
      "createdAt": "2026-04-10T17:41:59.202Z",
      "id": "ApBWYelWArSgusFX",
      "name": "addendo"
    },
    {
      "updatedAt": "2026-04-10T17:44:34.691Z",
      "createdAt": "2026-04-10T17:44:34.691Z",
      "id": "yRhyx62SuzbRRsGA",
      "name": "inteligencia-mercado"
    }
  ],
  "activeVersion": {
    "updatedAt": "2026-04-10T18:00:15.000Z",
    "createdAt": "2026-04-10T17:54:50.423Z",
    "versionId": "b19af88a-0a22-4e40-affd-973e4ce57980",
    "workflowId": "aOV4y4GB7nmRVzo4",
    "nodes": [
      {
        "parameters": {
          "rule": {
            "interval": [
              {
                "field": "cronExpression",
                "expression": "0 6 * * 1"
              }
            ]
          }
        },
        "id": "ed6d27ff-cf93-4e8d-af2e-469a69f31800",
        "name": "Schedule Lunes 6AM",
        "type": "n8n-nodes-base.scheduleTrigger",
        "typeVersion": 1.2,
        "position": [
          -576,
          64
        ]
      },
      {
        "parameters": {
          "httpMethod": "POST",
          "path": "inteligencia-mercado-manual",
          "responseMode": "lastNode",
          "options": {}
        },
        "id": "ff846cbd-3b58-485f-be49-2b6c46e4db4f",
        "name": "Webhook Manual",
        "type": "n8n-nodes-base.webhook",
        "typeVersion": 2,
        "position": [
          -576,
          304
        ],
        "webhookId": "7bb99a76-283e-4fb8-ab3c-e23c0786d148"
      },
      {
        "parameters": {
          "jsCode": "// Lista de clientes activos de Addendo Growth Partner\nconst clientes = [\n  {\n    nombre: 'Don Jacinto Nahual',\n    industria: 'brujo',\n    ciudad: 'Los Angeles',\n    sitio_web: 'donjacintonahual.com',\n    keywords_principales: [\n      'brujo en Los Angeles',\n      'brujeria Los Angeles',\n      'curandero Los Angeles',\n      'spiritual healer Los Angeles',\n      'witch doctor near me',\n      'limpia espiritual Los Angeles',\n      'amarres de amor Los Angeles'\n    ],\n    competidores: [\n      'https://www.yelp.com/search?find_desc=brujo&find_loc=Los+Angeles',\n      'https://www.google.com/search?q=brujo+los+angeles'\n    ]\n  },\n  {\n    nombre: 'Addendo',\n    industria: 'agencia marketing digital',\n    ciudad: 'Los Angeles',\n    sitio_web: 'addendo.io',\n    keywords_principales: [\n      'marketing agency Los Angeles',\n      'digital marketing agency LA',\n      'SEO agency Los Angeles',\n      'PPC management Los Angeles',\n      'web design agency Los Angeles',\n      'social media agency Los Angeles',\n      'Hispanic marketing agency'\n    ],\n    competidores: [\n      'https://www.google.com/search?q=marketing+agency+los+angeles',\n      'https://www.google.com/search?q=hispanic+marketing+agency+los+angeles'\n    ]\n  }\n];\n\nreturn clientes.map(c => ({ json: c }));"
        },
        "id": "8d40bc79-1a1c-4386-bab6-a0cebd937a68",
        "name": "Clientes Activos",
        "type": "n8n-nodes-base.code",
        "typeVersion": 2,
        "position": [
          -288,
          160
        ]
      },
      {
        "parameters": {
          "method": "POST",
          "url": "https://api.dataforseo.com/v3/keywords_data/google_ads/keywords_for_keywords/live",
          "authentication": "genericCredentialType",
          "genericAuthType": "httpBasicAuth",
          "sendBody": true,
          "specifyBody": "json",
          "jsonBody": "=[\n  {\n    \"keywords\": {{ JSON.stringify($json.keywords_principales) }},\n    \"language_code\": \"en\",\n    \"location_name\": \"United States\",\n    \"include_seed_keyword\": true,\n    \"sort_by\": \"search_volume\",\n    \"limit\": 50\n  }\n]",
          "options": {
            "timeout": 30000
          }
        },
        "id": "3777624b-ec5b-4e34-af9f-b56e13ac271f",
        "name": "DataForSEO Keywords Semanal",
        "type": "n8n-nodes-base.httpRequest",
        "typeVersion": 4.2,
        "position": [
          0,
          0
        ],
        "credentials": {
          "httpBasicAuth": {
            "id": "ged1wEVjgqEGsjq0",
            "name": "DATA FOR SEO API"
          }
        }
      },
      {
        "parameters": {
          "method": "POST",
          "url": "https://api.apify.com/v2/acts/apify~google-ads-transparency-scraper/runs?token={{$credentials.apifyApi.token}}&waitForFinish=120",
          "sendBody": true,
          "specifyBody": "json",
          "jsonBody": "={\n  \"queries\": {{ JSON.stringify($json.keywords_principales.slice(0, 3)) }},\n  \"maxResults\": 30,\n  \"language\": \"en\",\n  \"country\": \"US\"\n}",
          "options": {
            "timeout": 180000
          }
        },
        "id": "4b5171af-0044-4fea-b78e-fdaab536b148",
        "name": "Apify Ads Transparency Semanal",
        "type": "n8n-nodes-base.httpRequest",
        "typeVersion": 4.2,
        "position": [
          0,
          208
        ]
      },
      {
        "parameters": {
          "method": "POST",
          "url": "https://api.apify.com/v2/acts/apify~website-content-crawler/runs?token={{$credentials.apifyApi.token}}&waitForFinish=120",
          "sendBody": true,
          "specifyBody": "json",
          "jsonBody": "={\n  \"startUrls\": [\n    { \"url\": \"https://{{ $json.sitio_web }}\" },\n    { \"url\": \"{{ $json.competidores[0] }}\" }\n  ],\n  \"maxCrawlPages\": 5,\n  \"crawlerType\": \"cheerio\",\n  \"maxConcurrency\": 5\n}",
          "options": {
            "timeout": 180000
          }
        },
        "id": "dfa26e6f-7aef-4bb6-98f7-33a54f978d42",
        "name": "Apify Scraping Competidores Semanal",
        "type": "n8n-nodes-base.httpRequest",
        "typeVersion": 4.2,
        "position": [
          0,
          400
        ]
      },
      {
        "parameters": {
          "method": "POST",
          "url": "https://api.anthropic.com/v1/messages",
          "sendHeaders": true,
          "headerParameters": {
            "parameters": [
              {
                "name": "x-api-key",
                "value": "={{$credentials.httpHeaderAuth.value}}"
              },
              {
                "name": "anthropic-version",
                "value": "2023-06-01"
              },
              {
                "name": "content-type",
                "value": "application/json"
              }
            ]
          },
          "sendBody": true,
          "specifyBody": "json",
          "jsonBody": "={\n  \"model\": \"claude-sonnet-4-20250514\",\n  \"max_tokens\": 4096,\n  \"messages\": [\n    {\n      \"role\": \"user\",\n      \"content\": \"Eres el analista de inteligencia de mercado de Addendo Growth Partner.\\n\\nGenera el REPORTE SEMANAL DE INTELIGENCIA DE MERCADO para el siguiente cliente.\\n\\n## CLIENTE\\nNombre: {{ $('Clientes Activos').item.json.nombre }}\\nIndustria: {{ $('Clientes Activos').item.json.industria }}\\nCiudad: {{ $('Clientes Activos').item.json.ciudad }}\\nSitio Web: {{ $('Clientes Activos').item.json.sitio_web }}\\n\\n## DATOS DE KEYWORDS (DataForSEO)\\n{{ JSON.stringify($('DataForSEO Keywords Semanal').item.json, null, 2).substring(0, 3000) }}\\n\\n## ANUNCIOS ACTIVOS COMPETIDORES (Google Ads Transparency)\\n{{ JSON.stringify($('Apify Ads Transparency Semanal').item.json, null, 2).substring(0, 3000) }}\\n\\n## SCRAPING PAGINAS COMPETIDORES\\n{{ JSON.stringify($('Apify Scraping Competidores Semanal').item.json, null, 2).substring(0, 3000) }}\\n\\n---\\n\\nGenera el reporte con estas secciones:\\n\\n1. **RESUMEN EJECUTIVO** \u2014 Estado del mercado esta semana\\n2. **IDEAS DE BLOGS** \u2014 5 ideas de blog posts basadas en keywords trending y gaps de contenido. Incluir: titulo sugerido, keyword target, volumen estimado, y angulo unico\\n3. **OPORTUNIDADES DE KEYWORDS** \u2014 Keywords nuevas o con cambios significativos de volumen. Tabla con: keyword, volumen, competencia, CPC, y recomendacion\\n4. **MEJORAS AL SITIO WEB** \u2014 Basado en el scraping del sitio del cliente vs competidores, que mejorar en UX, contenido, CTAs, velocidad\\n5. **ANALISIS DE ANUNCIOS COMPETIDORES** \u2014 Que estan anunciando, copy que usan, landing pages, presupuesto estimado, y oportunidades para el cliente\\n6. **ACCIONES RECOMENDADAS ESTA SEMANA** \u2014 Top 3 acciones priorizadas por impacto\\n\\nFormato: HTML profesional listo para email. Usa tablas, colores sutiles, y formato limpio.\"\n    }\n  ]\n}",
          "options": {
            "timeout": 120000
          }
        },
        "id": "72dfe796-c465-430a-ad17-458725b4fdde",
        "name": "Claude Reporte Semanal",
        "type": "n8n-nodes-base.httpRequest",
        "typeVersion": 4.2,
        "position": [
          320,
          208
        ]
      },
      {
        "parameters": {
          "sendTo": "admin@addendo.io",
          "subject": "=Reporte Inteligencia de Mercado \u2014 {{ $('Clientes Activos').item.json.nombre }} \u2014 {{ new Date().toLocaleDateString('es-MX', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' }) }}",
          "message": "=<div style=\"font-family: Arial, sans-serif; max-width: 800px; margin: 0 auto;\">\n<div style=\"background: #1a1a2e; color: white; padding: 20px; text-align: center;\">\n  <h1 style=\"margin: 0;\">Addendo Growth Partner</h1>\n  <p style=\"margin: 5px 0 0; opacity: 0.8;\">Reporte Semanal de Inteligencia de Mercado</p>\n</div>\n<div style=\"padding: 20px; background: #f5f5f5;\">\n  <p><strong>Cliente:</strong> {{ $('Clientes Activos').item.json.nombre }}</p>\n  <p><strong>Industria:</strong> {{ $('Clientes Activos').item.json.industria }}</p>\n  <p><strong>Ciudad:</strong> {{ $('Clientes Activos').item.json.ciudad }}</p>\n  <p><strong>Fecha:</strong> {{ new Date().toLocaleDateString('es-MX', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' }) }}</p>\n</div>\n<div style=\"padding: 20px;\">\n{{ $json.content ? $json.content[0].text : JSON.stringify($json, null, 2) }}\n</div>\n<div style=\"background: #1a1a2e; color: white; padding: 15px; text-align: center; font-size: 12px;\">\n  <p>Generado automaticamente por Addendo Growth Partner | addendo.io</p>\n</div>\n</div>",
          "options": {}
        },
        "id": "8ae2e579-b012-407f-8b31-7e3084497031",
        "name": "Gmail Reporte Semanal",
        "type": "n8n-nodes-base.gmail",
        "typeVersion": 2.1,
        "position": [
          608,
          208
        ],
        "webhookId": "d382ee1f-7a6b-4e01-8a21-8d42ef823d90",
        "credentials": {
          "gmailOAuth2": {
            "id": "rD8DDJhSiG1dpOwO",
            "name": "Gmail API"
          }
        }
      }
    ],
    "connections": {
      "Schedule Lunes 6AM": {
        "main": [
          [
            {
              "node": "Clientes Activos",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "Webhook Manual": {
        "main": [
          [
            {
              "node": "Clientes Activos",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "Clientes Activos": {
        "main": [
          [
            {
              "node": "DataForSEO Keywords Semanal",
              "type": "main",
              "index": 0
            },
            {
              "node": "Apify Ads Transparency Semanal",
              "type": "main",
              "index": 0
            },
            {
              "node": "Apify Scraping Competidores Semanal",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "DataForSEO Keywords Semanal": {
        "main": [
          [
            {
              "node": "Claude Reporte Semanal",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "Apify Ads Transparency Semanal": {
        "main": [
          [
            {
              "node": "Claude Reporte Semanal",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "Apify Scraping Competidores Semanal": {
        "main": [
          [
            {
              "node": "Claude Reporte Semanal",
              "type": "main",
              "index": 0
            }
          ]
        ]
      },
      "Claude Reporte Semanal": {
        "main": [
          [
            {
              "node": "Gmail Reporte Semanal",
              "type": "main",
              "index": 0
            }
          ]
        ]
      }
    },
    "authors": "Jose Raul  Ramirez ",
    "name": "Version b19af88a",
    "description": "",
    "autosaved": true,
    "workflowPublishHistory": [
      {
        "createdAt": "2026-04-10T18:00:15.564Z",
        "id": 1,
        "workflowId": "aOV4y4GB7nmRVzo4",
        "versionId": "b19af88a-0a22-4e40-affd-973e4ce57980",
        "event": "activated",
        "userId": "22729d36-131e-405e-8267-dcd82aca785f"
      }
    ]
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Addendo — Inteligencia de Mercado Semanal. Uses httpRequest, gmail. Scheduled trigger; 8 nodes.

Source: https://github.com/AddendoGrowthPartner/addendo-website/blob/main/workflows/archived/aOV4y4GB7nmRVzo4-Addendo--Inteligencia-de-Mercado-Semanal-20260506.json — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.

Gmail, Google Drive, Google Sheets +1
Email & Gmail

14310 Send Overdue Invoice Payment Reminders With Ifirma Gmail Postgrid And Slack. Uses httpRequest, stopAndError, slack, gmail. Scheduled trigger; 53 nodes.

HTTP Request, Stop And Error, Slack +1
Email & Gmail

Addendo — Blog Automatico Don Jacinto Nahual. Uses httpRequest, redis, github, gmail. Scheduled trigger; 51 nodes.

HTTP Request, Redis, GitHub +1
Email & Gmail

Addendo — Blog Automatico Don Jacinto Nahual. Uses httpRequest, redis, github, gmail. Scheduled trigger; 51 nodes.

HTTP Request, Redis, GitHub +1
Email & Gmail

Instead of providing a routine check, it focuses on significant movements by: Sending a Slack alert only if a query crosses a defined movement threshold. Emailing a structured report with the Top 25 i

HTTP Request, Slack, Gmail