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

NDA Import. Uses httpRequest, googleSheets, jira, executeWorkflowTrigger. Event-driven trigger; 30 nodes.

HTTP Request, Google Sheets, Jira +1
Data & Sheets

12 - Market Intelligence Report Builder (Stakeholder v0.3). Uses googleSheets, httpRequest, executeWorkflowTrigger. Event-driven trigger; 27 nodes.

Google Sheets, HTTP Request, Execute Workflow Trigger
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

This workflow takes a list of Google Maps search queries, extracts candidate business website URLs from the search results, visits each site, scrapes email addresses from the page content, and appends

HTTP Request, Google Sheets, Execute Workflow Trigger