POST Webhook dont process the data?

Hello n8n,

I’m trying to use webhooks from this API but It seems that something is going wrong.

At the beginning I did the mistake to not setting up the webhook node with http method post, but now that it’s done, I don’t understand why the data don’t append in the gsheet.

The same test webhook on webhook.site is receiving data with the post method.

Moreover, I see some monthly executions are consumed in my dashboard but I have no tracks of it in my workflow executions.

See my workflow attached :

{
  "nodes": [
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "Campagne",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"campaignName\"]}}"
            },
            {
              "name": "Firstname",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"leadFirstName\"]}}"
            },
            {
              "name": "Lastname",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"leadLastName\"]}}"
            },
            {
              "name": "Gender",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"Gender\"]}}"
            },
            {
              "name": "Company",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"leadCompanyName\"]}}"
            },
            {
              "name": "Title",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"current_job_title\"]}}"
            },
            {
              "name": "linkedinUrl",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"linkedinUrl\"]}}"
            },
            {
              "name": "Type",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"type\"]}}"
            },
            {
              "name": "Email",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"leadEmail\"]}}"
            },
            {
              "name": "Owner",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"sendUserEmail\"]}}"
            },
            {
              "name": "Created at",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"createdAt\"]}}"
            },
            {
              "name": "SequenceStep",
              "value": "={{$node[\"Webhook\"].json[\"query\"][\"isFirst\"]}}"
            }
          ]
        },
        "options": {}
      },
      "name": "Set",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        970,
        340
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "sheetId": "1ShQxSW970nvvAdrf0dYH75aFMv65w9JNETvtnQndBXk",
        "range": "AllActivitiesReport!A:K",
        "options": {}
      },
      "name": "Append New Activity",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 1,
      "position": [
        1340,
        350
      ],
      "credentials": {
        "googleApi": "VBO Cloud"
      }
    },
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "lemlistglobalreport",
        "responseMode": "lastNode",
        "responseData": "allEntries",
        "options": {}
      },
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 1,
      "position": [
        560,
        340
      ],
      "webhookId": "65aabd5e-2534-4155-8538-a1dec20a9484"
    },
    {
      "parameters": {
        "dataType": "string",
        "value1": "={{$node[\"Webhook\"].json[\"query\"][\"type\"]}}",
        "rules": {
          "rules": [
            {
              "value2": "emailsReplied"
            },
            {
              "value2": "emailsOpened",
              "output": 1
            },
            {
              "value2": "emailsClicked",
              "output": 2
            },
            {
              "value2": "emailsBounced",
              "output": 3
            }
          ]
        }
      },
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "typeVersion": 1,
      "position": [
        1600,
        350
      ]
    },
    {
      "parameters": {
        "operation": "create",
        "additionalFields": {
          "company": "={{$node[\"Webhook\"].json[\"query\"][\"companyName\"]}}",
          "emailOptions": {
            "emailProperties": [
              {
                "subtype": "work",
                "email": "={{$node[\"Webhook\"].json[\"query\"][\"leadEmail\"]}}"
              }
            ]
          },
          "firstName": "={{$node[\"Webhook\"].json[\"query\"][\"leadFirstName\"]}}",
          "lastName": "={{$node[\"Webhook\"].json[\"query\"][\"leadLastName\"]}}",
          "title": "={{$node[\"Webhook\"].json[\"query\"][\"current_job_title\"]}}",
          "websiteOptions": {
            "websiteProperties": [
              {
                "subtype": "linkedin",
                "url": "={{$node[\"Webhook\"].json[\"query\"][\"linkedinUrl\"]}}"
              }
            ]
          },
          "customProperties": {
            "customProperty": [
              {
                "name": "Civilite",
                "value": "={{$node[\"Webhook\"].json[\"query\"][\"Gender\"]}}"
              }
            ]
          }
        }
      },
      "name": "AgileCRM",
      "type": "n8n-nodes-base.agileCrm",
      "typeVersion": 1,
      "position": [
        2100,
        30
      ],
      "credentials": {
        "agileCrmApi": "VBO"
      }
    },
    {
      "parameters": {},
      "name": "NoOp",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        1890,
        530
      ]
    },
    {
      "parameters": {
        "dataType": "string",
        "value1": "={{$node[\"Webhook\"].json[\"query\"][\"type\"]}}",
        "rules": {
          "rules": [
            {
              "value2": "emailsReplied"
            }
          ]
        }
      },
      "name": "Switch1",
      "type": "n8n-nodes-base.switch",
      "typeVersion": 1,
      "position": [
        1840,
        210
      ]
    }
  ],
  "connections": {
    "Set": {
      "main": [
        [
          {
            "node": "Append New Activity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append New Activity": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook": {
      "main": [
        [
          {
            "node": "Set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Switch1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "NoOp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "NoOp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "NoOp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch1": {
      "main": [
        [
          {
            "node": "AgileCRM",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Do I need to use a function node after my POST Webhook to process the data ?

Thanks for your help again, I feel like I’m really close to reach it.

Hi,

Have you used a set node before Google sheet for appending the content based on heading?

For tracking monthly executions in n8n.cloud, you can check whether the options in the Executions to Save item on Manage Tab are selected.

Hi, yes I did it and specified the output data from the webhook node.

Weirdly now I have an error 503 on my gsheet node :

Hey @vinceHq!

Did your issue got resolved? Please let me know if you’re still facing the issue.