AutomationFlowsData & Sheets › Fluxo B - Pós-consentimento + PDF (luz Da Lua)

Fluxo B - Pós-consentimento + PDF (luz Da Lua)

Fluxo B - Pós-consentimento + PDF (Luz da Lua). Uses executeWorkflowTrigger, httpRequest, googleSheets. Event-driven trigger; 5 nodes.

Event trigger★★★★☆ complexity5 nodesExecute Workflow TriggerHTTP RequestGoogle Sheets
Data & Sheets Trigger: Event Nodes: 5 Complexity: ★★★★☆ Added:

This workflow follows the Execute Workflow Trigger → Google Sheets 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
{
  "name": "Fluxo B - P\u00f3s-consentimento + PDF (Luz da Lua)",
  "nodes": [
    {
      "parameters": {},
      "id": "b1",
      "name": "When Executed by Another Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "typeVersion": 1.1,
      "position": [
        240,
        300
      ],
      "notes": "Recebe os campos: telefone, nome, segmento (vindos do Fluxo C)."
    },
    {
      "parameters": {
        "method": "POST",
        "url": "=https://graph.facebook.com/v21.0/{{$env.WHATSAPP_PHONE_NUMBER_ID}}/messages",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"messaging_product\": \"whatsapp\",\n  \"to\": \"{{ $json.telefone }}\",\n  \"type\": \"text\",\n  \"text\": {\n    \"body\": \"Separei um cat\u00e1logo com {{ $json.segmento || 'novidades' }} da Luz da Lua que est\u00e3o em promo\u00e7\u00e3o e queria te mostrar.\\nSe gostar de algum modelo, me manda um print por aqui que eu te ajudo na escolha.\\nSe preferir n\u00e3o receber mais mensagens assim, \u00e9 s\u00f3 me avisar.\\n\\nAnni.\"\n  }\n}",
        "options": {}
      },
      "id": "b2",
      "name": "WhatsApp - Mensagem texto",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        480,
        300
      ],
      "credentials": {
        "httpHeaderAuth": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "amount": 3,
        "unit": "seconds"
      },
      "id": "b3",
      "name": "Wait 3s",
      "type": "n8n-nodes-base.wait",
      "typeVersion": 1.1,
      "position": [
        720,
        300
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "=https://graph.facebook.com/v21.0/{{$env.WHATSAPP_PHONE_NUMBER_ID}}/messages",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"messaging_product\": \"whatsapp\",\n  \"to\": \"{{ $('When Executed by Another Workflow').item.json.telefone }}\",\n  \"type\": \"document\",\n  \"document\": {\n    \"link\": \"{{$env.CATALOGO_PDF_URL}}\",\n    \"filename\": \"catalogo-luz-da-lua.pdf\"\n  }\n}",
        "options": {}
      },
      "id": "b4",
      "name": "WhatsApp - Envia PDF",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        960,
        300
      ],
      "credentials": {
        "httpHeaderAuth": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "operation": "update",
        "documentId": {
          "__rl": true,
          "value": "PLACEHOLDER_SPREADSHEET_ID",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": "PLACEHOLDER_SHEET_NAME",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "telefone"
          ],
          "value": {
            "telefone": "={{ $('When Executed by Another Workflow').item.json.telefone }}",
            "ultima_campanha": "catalogo_pdf_inicial",
            "data_ultimo_envio": "={{ $now.toISO() }}",
            "status_contato": "campanha_enviada",
            "resposta_ultima_campanha": "",
            "interessado": ""
          }
        },
        "options": {}
      },
      "id": "b5",
      "name": "Sheets - Update campanha_enviada",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        1200,
        300
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "WhatsApp - Mensagem texto",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WhatsApp - Mensagem texto": {
      "main": [
        [
          {
            "node": "Wait 3s",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 3s": {
      "main": [
        [
          {
            "node": "WhatsApp - Envia PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WhatsApp - Envia PDF": {
      "main": [
        [
          {
            "node": "Sheets - Update campanha_enviada",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  }
}

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

Fluxo B - Pós-consentimento + PDF (Luz da Lua). Uses executeWorkflowTrigger, httpRequest, googleSheets. Event-driven trigger; 5 nodes.

Source: https://github.com/rodrigogr/shared-projects/blob/3a68abe13ba87467d3fc5fa0e72f91a2686d4bd3/whatsapp-mvp/n8n-workflows/fluxo-b-pos-consentimento.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

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

Data & Sheets

Google Maps Email Scraper Template. Uses removeDuplicates, splitInBatches, httpRequest, splitOut. Event-driven trigger; 26 nodes.

HTTP Request, Google Sheets, Execute Workflow Trigger
Data & Sheets

Email Scapper. Uses httpRequest, googleSheets, executeWorkflowTrigger. Event-driven trigger; 26 nodes.

HTTP Request, Google Sheets, Execute Workflow Trigger
Data & Sheets

ITHome比賽進程. Uses httpRequest, googleSheets, executeWorkflowTrigger, n8n. Event-driven trigger; 25 nodes.

HTTP Request, Google Sheets, Execute Workflow Trigger +1
Data & Sheets

25-scrape-business-emails-from-google-maps-without-the-use-of-any-third-party-apis. Uses httpRequest, googleSheets, executeWorkflowTrigger. Event-driven trigger; 23 nodes.

HTTP Request, Google Sheets, Execute Workflow Trigger
Data & Sheets

Intelligent URL Validation - Validates PDF URLs before attempting download, extracting filenames from URLs and generating fallback names when needed, preventing wasted processing time Binary File Hand

Execute Workflow Trigger, Google Sheets, HTTP Request +1