Fluentform Export

Name: Fluentform Export
Rating: 4.5 (10 reviews)
Author: Khairul Muhtadin

Fortgeschritten

Dies ist ein Lead Generation-Bereich Automatisierungsworkflow mit 9 Nodes. Hauptsächlich werden If, Set, Webhook, GoogleSheets, RespondToWebhook und andere Nodes verwendet. Automatisierter Export von Leads von Fluentform zu Google Tabellen mit Unterstützung für Formularkategorien

Voraussetzungen

•HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
•Google Sheets API-Anmeldedaten

Verwendete Nodes (9)

Kategorie

Lead-Generierung

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Auf Webhook antworten

newsletter

form

Newsletter anhängen

POST - Leads abrufen

Formular oder Newsletter?

Formular anhängen

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "utlCHj75iFNNfZRx",
  "meta": {
    "instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
    "templateCredsSetupCompleted": true
  },
  "name": "Fluentform Export",
  "tags": [],
  "nodes": [
    {
      "id": "f9a0fc6b-4644-4079-8c00-234a6a4e6e92",
      "name": "Auf Webhook antworten",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        1080,
        0
      ],
      "parameters": {
        "options": {},
        "respondWith": "json",
        "responseBody": "={\n  \"status\": \"success\"\n}"
      },
      "typeVersion": 1.1
    },
    {
      "id": "bac186bc-e19d-431b-a6bb-e5cd3af9a031",
      "name": "newsletter",
      "type": "n8n-nodes-base.set",
      "position": [
        620,
        -100
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "5eecb1d8-1dde-4db6-9a99-c5ab39c58653",
              "name": "email",
              "type": "string",
              "value": "={{ $json.body.__submission.user_inputs.email }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "68dc8440-a45c-4577-b303-3c127e2bd880",
      "name": "form",
      "type": "n8n-nodes-base.set",
      "position": [
        620,
        100
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b7d088f7-6335-4390-b8cf-1e1caf4249bc",
              "name": "fullname",
              "type": "string",
              "value": "={{ $json.body.names.first_name }} {{ $json.body.names.last_name }}"
            },
            {
              "id": "ba15b685-5fdf-49c5-a5cf-0581355032b9",
              "name": "email",
              "type": "string",
              "value": "={{ $json.body.email }}"
            },
            {
              "id": "f8db42b1-3b5d-4b42-b5cd-c6d7696dba1a",
              "name": "no hp",
              "type": "string",
              "value": "={{ $json.body.numeric_field }}"
            },
            {
              "id": "c3b4c6d6-a227-4263-98ca-f3c20d09846d",
              "name": "subject",
              "type": "string",
              "value": "={{ $json.body.subject }}"
            },
            {
              "id": "279f2943-cb5d-4ed7-8ea8-a839e3c1b9cc",
              "name": "message",
              "type": "string",
              "value": "={{ $json.body.message }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "64383e9d-39ac-41b6-9369-88a8ac3cf441",
      "name": "Newsletter anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        840,
        -100
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.email }}"
          },
          "schema": [
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit#gid=0",
          "cachedResultName": "News Letter"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit?usp=drivesdk",
          "cachedResultName": "leads"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gnUSHhCw4cKx3pwo",
          "name": "khaisa sheet"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "25bc2a16-19d6-4e15-9735-316b9aea5e60",
      "name": "POST - Leads abrufen",
      "type": "n8n-nodes-base.webhook",
      "position": [
        180,
        0
      ],
      "webhookId": "1c16c205-1617-43ca-83de-207e5fcc6de6",
      "parameters": {
        "path": "your-path",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    },
    {
      "id": "19fa286d-10ae-4afc-bf19-113a085fc371",
      "name": "Formular oder Newsletter?",
      "type": "n8n-nodes-base.if",
      "position": [
        400,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "b096ba9d-1b60-47ab-ab9f-a4e83c953e8b",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.body._fluentform_2_fluentformnonce }}",
              "rightValue": "c40c9119f6"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "1a5b1211-c7cb-46b7-a108-4c9dca305d24",
      "name": "Formular anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        840,
        100
      ],
      "parameters": {
        "columns": {
          "value": {
            "email": "={{ $json.email }}",
            "no hp": "={{ $json['no hp'] }}",
            "message": "={{ $json.message }}",
            "subject": "={{ $json.subject }}",
            "full name": "={{ $json.fullname }}"
          },
          "schema": [
            {
              "id": "full name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "full name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "no hp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "no hp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "subject",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 799661662,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit#gid=799661662",
          "cachedResultName": "form"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit?usp=drivesdk",
          "cachedResultName": "leads"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gnUSHhCw4cKx3pwo",
          "name": "khaisa sheet"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "node_tuuo8spg6",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        -200
      ],
      "parameters": {
        "width": 320,
        "content": "## Guideline\n\n- adjust your ```webhook url``` on fluent form\n- configure your spreadsheet credentials"
      },
      "typeVersion": 1
    },
    {
      "id": "25381d46-98e9-49a1-911f-5d2928ed906b",
      "name": "Notiz - Parser1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1020,
        160
      ],
      "parameters": {
        "color": 4,
        "width": 280,
        "content": "### This Workflow is free!\n Got ideas, feedback, or just wanna chat? Hit me up [here](https://khmuhtadin.com)  \n\nFeeling generous? Buy me a  [coffee](coff.ee/khmuhtadin) to keep the buzz going! ☕"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6fc3feab-072e-4c00-92a9-b5d4399dd624",
  "connections": {
    "68dc8440-a45c-4577-b303-3c127e2bd880": {
      "main": [
        [
          {
            "node": "1a5b1211-c7cb-46b7-a108-4c9dca305d24",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bac186bc-e19d-431b-a6bb-e5cd3af9a031": {
      "main": [
        [
          {
            "node": "64383e9d-39ac-41b6-9369-88a8ac3cf441",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1a5b1211-c7cb-46b7-a108-4c9dca305d24": {
      "main": [
        [
          {
            "node": "f9a0fc6b-4644-4079-8c00-234a6a4e6e92",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "64383e9d-39ac-41b6-9369-88a8ac3cf441": {
      "main": [
        [
          {
            "node": "f9a0fc6b-4644-4079-8c00-234a6a4e6e92",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "19fa286d-10ae-4afc-bf19-113a085fc371": {
      "main": [
        [
          {
            "node": "bac186bc-e19d-431b-a6bb-e5cd3af9a031",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "68dc8440-a45c-4577-b303-3c127e2bd880",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "25bc2a16-19d6-4e15-9735-316b9aea5e60": {
      "main": [
        [
          {
            "node": "19fa286d-10ae-4afc-bf19-113a085fc371",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Lead-Generierung

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.