AutomationFlowsData & Sheets › Satisfaction

Satisfaction

Satisfaction. Uses formTrigger, googleSheets, emailSend. Event-driven trigger; 4 nodes.

Event trigger★★☆☆☆ complexity4 nodesForm TriggerGoogle SheetsEmail Send
Data & Sheets Trigger: Event Nodes: 4 Complexity: ★★☆☆☆ Added:

This workflow follows the Emailsend → Form Trigger 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
{
  "active": true,
  "connections": {
    "n8n Form Trigger": {
      "main": [
        [
          {
            "node": "Date & Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Date & Time": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "createdAt": "2024-09-05T14:04:32.344Z",
  "id": "KY1UKbxDQOIMErEt",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Satisfaction",
  "nodes": [
    {
      "parameters": {
        "path": "Pujol-Auto",
        "formTitle": "Comment jugeriez-vous la prestation de Pujol Auto ?",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Merci de s\u00e9lectionner une r\u00e9ponse",
              "fieldType": "dropdown",
              "fieldOptions": {
                "values": [
                  {
                    "option": "\u2b50 M\u00e9diocre"
                  },
                  {
                    "option": "\u2b50\u2b50 Passable"
                  },
                  {
                    "option": "\u2b50\u2b50\u2b50 Bonne"
                  },
                  {
                    "option": "\u2b50\u2b50\u2b50\u2b50 Excellente"
                  },
                  {
                    "option": "\u2b50\u2b50\u2b50\u2b50\u2b50 Exceptionnelle !"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldLabel": "Commentaires",
              "fieldType": "textarea"
            },
            {
              "fieldLabel": "Votre nom",
              "requiredField": true
            },
            {
              "fieldLabel": "Votre adresse e-mail ?",
              "fieldType": "email",
              "requiredField": true
            }
          ]
        },
        "options": {
          "appendAttribution": false,
          "ignoreBots": true
        }
      },
      "id": "84681198-75fc-49b1-b2a3-40d717c03726",
      "name": "n8n Form Trigger",
      "type": "n8n-nodes-base.formTrigger",
      "typeVersion": 2.1,
      "position": [
        120,
        200
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "1h86ntYDITdeMTZlXXoE4BhsiR92YgNbiSDXuYplUyVo",
          "mode": "list",
          "cachedResultName": "Avis",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1h86ntYDITdeMTZlXXoE4BhsiR92YgNbiSDXuYplUyVo/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "avis",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1h86ntYDITdeMTZlXXoE4BhsiR92YgNbiSDXuYplUyVo/edit#gid=0"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "Avis": "={{ $json['Merci de s\u00e9lectionner une r\u00e9ponse'] }}",
            "Nom": "={{ $json['Votre nom'] }}",
            "Email": "={{ $json['Votre adresse e-mail ?'] }}",
            "Date": "={{ $json.Date }}"
          },
          "matchingColumns": [],
          "schema": [
            {
              "id": "Date",
              "displayName": "Date",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Nom",
              "displayName": "Nom",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "displayName": "Email",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "Avis",
              "displayName": "Avis",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            }
          ]
        },
        "options": {}
      },
      "id": "fd411713-1c29-4453-bc80-841565f5a02f",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        540,
        200
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "operation": "formatDate",
        "date": "={{ $json.submittedAt }}",
        "format": "custom",
        "customFormat": "dd/MM/yyyy",
        "outputFieldName": "Date",
        "options": {
          "includeInputFields": true
        }
      },
      "id": "7eee6660-3587-4c85-9981-3886c44a2b53",
      "name": "Date & Time",
      "type": "n8n-nodes-base.dateTime",
      "typeVersion": 2,
      "position": [
        320,
        180
      ]
    },
    {
      "parameters": {
        "fromEmail": "Hugo Gu\u00e9rinault <ventes@groupepujol.com>",
        "toEmail": "={{ $json.Email }}",
        "subject": "Merci pour votre confiance \ud83e\udd29 !",
        "emailFormat": "text",
        "text": "Bonjour\net merci pour votre commentaire \u2b50\u2b50\u2b50\u2b50\u2b50 !\nPour nous \u00eatre utile et valoriser notre concession vous pouvez aussi nous noter sur google :\n\u27a1\ufe0f https://g.page/r/CUqldOrSw-hYEAE/review\n\nHugo Gu\u00e9rinault\nChef des ventes",
        "options": {
          "appendAttribution": false
        }
      },
      "id": "d2706d4f-e5f0-4070-9b6c-0df7bd84a665",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 2.1,
      "position": [
        760,
        200
      ],
      "credentials": {
        "smtp": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "settings": {
    "executionOrder": "v1",
    "timezone": "Europe/Paris",
    "saveManualExecutions": true,
    "callerPolicy": "workflowsFromSameOwner"
  },
  "staticData": null,
  "tags": [],
  "triggerCount": 2,
  "updatedAt": "2024-09-05T14:55:20.380Z",
  "versionId": "634b648a-1ab0-4014-abe0-2f5d39b7c160"
}

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

Satisfaction. Uses formTrigger, googleSheets, emailSend. Event-driven trigger; 4 nodes.

Source: https://github.com/thibaultmahe/thibaultmahe/blob/ee13dee175d89d98a3fb589794f44a176e19ba68/workflows/Satisfaction.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

This n8n workflow automates the collection and processing of trip feedback data using Google Sheets as the backend. When new users are added to the system, they automatically receive feedback forms vi

Form Trigger, Google Sheets, Email Send +1
Data & Sheets

This template implements a professional Double Opt-In email verification system using Google Sheets as a database. The workflow collects user emails, generates unique verification codes, stores them s

Form Trigger, Form, Email Send +1
Data & Sheets

This automation streamlines the process of collecting user information using a Form Node, enabling individuals to join a waitlist managed via Google Sheets.

Google Sheets, Email Send, Form +2
Data & Sheets

Track website traffic and backlinks effortlessly using the Website Traffic Checker - Ahref API. This n8n workflow automates data retrieval and logging into Google Sheets, making it perfect for SEO pro

Form Trigger, HTTP Request, Email Send +1
Data & Sheets

Description: Easily automate your YouTube video giveaways using n8n and the YouTube Comments Scraper API. This workflow fetches comments, selects a random winner, logs results to Google Sheets, and no

Form Trigger, HTTP Request, Email Send +1