Automatic Lead Categorization and Google Sheets Export from FluentForm - n8n Workflow

• Marketing teams using WordPress and FluentForm for lead capture.


• Developers needing robust, categorized data logging from multiple web forms.


• Users looking for advanced examples of conditional routing within an n8n workflow.


• Anyone seeking ready-to-use n8n templates for CRM integration.

Managing leads from various entry points—like contact forms and newsletter sign-ups—often requires manual segregation. This powerful n8n workflow automates this crucial step. By using a webhook as the primary n8n trigger, the workflow intercepts raw data sent by FluentForm immediately upon submission. It then uses core flow control logic (the If n8n node) to inspect a unique form identifier. Based on this identifier, the submission is correctly routed either to the detailed 'form' data processing path or the simplified 'newsletter' path. Both paths culminate in appending or updating records in segregated tabs within a master Google Sheet, ensuring your data is clean, categorized, and immediately available for sales or marketing follow-up. This reusable n8n template significantly streamlines lead management.

This automation begins with the POST - Retreive Leads n8n trigger, a Webhook n8n node configured to receive POST requests from your FluentForm setup.

1. Incoming Trigger: When a user submits a form on your website, FluentForm sends the payload to this webhook URL.


2. Form Categorization: The Form or newsletter? If n8n node analyzes the incoming JSON data, specifically checking the fluentform2_fluentformnonce field against a predefined value (c40c9119f6). This determines the form type.


3. Data Preparation (True Path - Newsletter): If the condition is true (Newsletter form), the newsletter Set n8n node extracts and sets only the email field.


4. Data Preparation (False Path - Contact Form): If the condition is false (Contact Form), the form Set n8n node extracts and structures multiple fields: full name (concatenated), email, phone number, subject, and message.


5. Google Sheets Export: The respective data paths utilize a Google Sheets n8n node (Append newsletter or append form). Both n8n node configurations are set to appendOrUpdate, ensuring new leads are added and existing ones can be updated if necessary. Data is written to separate sheets (e.g., 'News Letter' or 'form') within the target spreadsheet.


6. Response: Finally, the Respond to Webhook n8n node sends a successful JSON response back to FluentForm, confirming receipt and completion of the n8n workflow.

To deploy and utilize this n8n workflow successfully, follow these steps:

1. Import: Copy the provided JSON into your n8n instance using the 'New' menu and 'Import from JSON'.


2. Webhook Setup (n8n trigger): Navigate to the POST - Retreive Leads Webhook n8n node. Save the generated Test or Production webhook URL.


3. FluentForm Configuration: Go to your FluentForm settings (on WordPress) and configure the specific forms (contact and newsletter) to send a Webhook POST request to the URL generated in step 2. You must ensure the data sent matches the structure expected by the Form or newsletter? If n8n node.


4. Credential Setup: Configure the Google Sheets credentials in both Append newsletter and append form n8n node instances. Ensure they have access to the specified target spreadsheet (leads - ID: 1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII).


5. Spreadsheet Verification: Confirm that the destination Google Sheet has the correct tabs ('News Letter' and 'form') and matching column headers corresponding to the fields extracted by the Set n8n nodes.


6. Activation: Set the n8n workflow to 'Active' to start listening for lead submissions.

This n8n template relies on several key n8n nodes for its logic and execution:

POST - Retreive Leads (Webhook Trigger n8n node):
Function: Acts as the entry point or n8n trigger, listening for HTTP POST requests containing FluentForm submission data.
Key Configuration: HTTP Method is set to POST; Response Mode is 'responseNode' (handled later).

Form or newsletter? (If n8n node):
Function: Controls the flow based on form identity. It checks if the submission originated from the newsletter form by examining a unique nonce field.
Key Configuration: Condition checks ={{ $json.body.fluentform2fluentformnonce }} equals c40c9119f6.

newsletter / form (Set n8n node):
Function: Cleans and structures the data specific to the form type before export. The 'form' node concatenates first and last names into a single fullname field.
Key Configuration: Uses N8N expressions (e.g., ={{ $json.body.names.firstname }} {{ $json.body.names.last_name }}) to map nested incoming data fields to simplified output variables.

Append newsletter / append form (Google Sheets n8n node):
Function: Writes the processed lead data to the designated Google Sheet and tab.
Key Configuration: Operation is set to appendOrUpdate. The append form node maps multiple fields (email, no hp, message, subject, full name), while Append newsletter only maps Email. Matching column is set to Email to handle updates.