8
n8n Françaisamn8n.com

Export Fluentform

Intermédiaire

Ceci est unLead Generationworkflow d'automatisation du domainecontenant 9 nœuds.Utilise principalement des nœuds comme If, Set, Webhook, GoogleSheets, RespondToWebhook. Export automatique des prospects de Fluentform vers Google Sheets, avec classification de formulaires

Prérequis
  • •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
  • •Informations d'identification Google Sheets API

Nœuds utilisés (9)

If
Set
Webhook
StickyNote
GoogleSheets
RespondToWebhook

Catégorie

Génération de leads
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "utlCHj75iFNNfZRx",
  "meta": {
    "instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
    "templateCredsSetupCompleted": true
  },
  "name": "Fluentform Export",
  "tags": [],
  "nodes": [
    {
      "id": "f9a0fc6b-4644-4079-8c00-234a6a4e6e92",
      "name": "Répondre à Webhook",
      "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": "formulaire",
      "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": "Ajouter newsletter",
      "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 - Récupérer les prospects",
      "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": "Formulaire ou 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": "ajouter formulaire",
      "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": "Note adhésive",
      "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": "Note - Analyseur1",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Génération de leads

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Collecte automatisée de données de Leadfeeder et Apollo.io
Pipeline d'enrichissement de prospects : de Leadfeeder vers Apollo puis vers Google Sheets
If
Set
Code
+
If
Set
Code
23 NœudsKhairul Muhtadin
Génération de leads
Backend de billetterie
Billetage des événements : génération automatique de billets QR code avec Google Sheets et Gmail
If
Code
Gmail
+
If
Code
Gmail
35 NœudsKhairul Muhtadin
Création de contenu
Suite pour génération de prospects LinkedIn et automatisation CRM
Extraire les données des profils LinkedIn avec Apify et générer automatiquement des données de prospects pour le CRM Google Sheets
If
Set
Code
+
If
Set
Code
18 NœudsDavid Olusola
Génération de leads
intelligent资金gestion器
基于Telegram、Google SheetsetOpenAIdeAI驱动收据et支出追踪器
If
Set
Code
+
If
Set
Code
50 NœudsKhairul Muhtadin
Finance
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Automatisation du développement de partenaires commerciaux avec Google Maps, GPT-4 et WhatsApp
Automatisation du développement de partenaires commerciaux avec Google Maps, GPT-4 et WhatsApp
If
Set
Code
+
If
Set
Code
64 NœudsKhairul Muhtadin
Chatbot IA
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds9
Catégorie1
Types de nœuds6
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Khairul Muhtadin

Khairul Muhtadin

@khmuhtadin
Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34