KI-gesteuerte automatisierte Feedback-Verarbeitung

• •Google Sheets API-Anmeldedaten

{
  "id": "h47UJYYjZeKuBLTn",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "AI Automation in Feedback",
  "tags": [],
  "nodes": [
    {
      "id": "553d9f71-a750-4152-84bb-9d2956441aa8",
      "name": "Bei Formularübermittlung",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        260,
        220
      ],
      "webhookId": "998e3daa-1e42-4a50-913f-e0dfb10b66b7",
      "parameters": {
        "options": {
          "path": "feedback",
          "customCss": "",
          "appendAttribution": false
        },
        "formTitle": "Customer Feedback Questions for IT Services",
        "formFields": {
          "values": [
            {
              "fieldLabel": "What is your Name?",
              "requiredField": true
            },
            {
              "fieldType": "email",
              "fieldLabel": "Email ID",
              "requiredField": true
            },
            {
              "fieldLabel": "Contact Number",
              "placeholder": "(e.g, +1234567890)",
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "How satisfied are you with the quality of our IT services or solutions?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Very Dissatisfied"
                  },
                  {
                    "option": "Dissatisfied"
                  },
                  {
                    "option": "Neutral"
                  },
                  {
                    "option": "Satisfied"
                  },
                  {
                    "option": "Very Satisfied"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Did our team understand your technical requirements clearly?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Yes"
                  },
                  {
                    "option": "No"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "How would you rate our communication throughout the project/support process?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Poor"
                  },
                  {
                    "option": "Fair"
                  },
                  {
                    "option": "Good"
                  },
                  {
                    "option": "Excellent"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Was your project/service delivered on time and within the expected timeline?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Yes"
                  },
                  {
                    "option": "No"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Did our solution meet your business needs or solve your problem effectively?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Yes"
                  },
                  {
                    "option": "No"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "How responsive was our support team when you needed assistance?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Slow"
                  },
                  {
                    "option": "Average"
                  },
                  {
                    "option": "Fast"
                  },
                  {
                    "option": "Very Fast"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "How would you rate the technical expertise of our team?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "1"
                  },
                  {
                    "option": "2"
                  },
                  {
                    "option": "3"
                  },
                  {
                    "option": "4"
                  },
                  {
                    "option": "5"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "textarea",
              "fieldLabel": "What could we do to improve your experience with our IT services?",
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Would you recommend our IT services to others?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Yes"
                  },
                  {
                    "option": "=No"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "textarea",
              "fieldLabel": "Any additional comments or suggestions?",
              "requiredField": true
            }
          ]
        }
      },
      "notesInFlow": false,
      "typeVersion": 2.2
    },
    {
      "id": "0f02714d-0da3-4f86-ba62-97ce92883201",
      "name": "Wenn sowohl E-Mail als auch Telefonnummer angegeben sind",
      "type": "n8n-nodes-base.if",
      "position": [
        520,
        440
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "8cc5cb6d-8aee-4547-bb67-aa8465789473",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Phone.toString() }}",
              "rightValue": ""
            },
            {
              "id": "2a0ba5ea-f76c-4cf2-9b77-6fc0e2d269da",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "2890694e-c503-4eda-825b-b569e7f8831a",
      "name": "Wenn nur Telefonnummer angegeben ist",
      "type": "n8n-nodes-base.if",
      "position": [
        520,
        640
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "84c363c4-8ae2-4b56-b9f7-a83de196be4b",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Phone.toString() }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "cf9d2612-b582-4352-809e-31a38f4126b5",
      "name": "Nachricht senden über Whatsapp",
      "type": "n8n-nodes-base.whatsApp",
      "notes": "Set the WhatsApp template from the WhatsApp Business Account.",
      "position": [
        780,
        620
      ],
      "webhookId": "857eab1a-f5e2-4937-be2c-90b47bae3947",
      "parameters": {
        "template": "feedback_n8n|en_US",
        "components": {
          "component": [
            {
              "bodyParameters": {
                "parameter": [
                  {
                    "text": "={{ $('Google Sheets Trigger').item.json.User }}"
                  }
                ]
              }
            }
          ]
        },
        "phoneNumberId": "550325331503475",
        "recipientPhoneNumber": "={{ $json.Phone.toString() }}"
      },
      "credentials": {
        "whatsAppApi": {
          "id": "3hy4gzpVJrY1sFcR",
          "name": "WhatsApp account API"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ce02dda2-111e-4bde-99a9-393547c40435",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "notes": "Set Google Credentials and then select Google Sheets.\nSelect the Sheet on which you want to set the trigger.\n\nIf any changes are made to the selected Sheet. Node will trigger.",
      "position": [
        200,
        520
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "9XWklJMdHOljJ9Ar",
          "name": "Google Sheets Trigger account"
        }
      },
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "153adc14-68c1-4b4d-bb93-8dc5204ec7e9",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Follow this steps:\n- Set Google Credentials and then select Google Sheets account.\n- Select \"Sheet Within Document\" option in Resource tab.\n- Select \"Append or Update Row\" in Operation tab.\n- In Document tab select your google sheets which you want to update.\n- In Sheets tab select sheet from your google sheets document.\n- In Mapping select \"Map Each Column Manually\"\n- Now from list of colums select colum which you want to match from selected sheet. The column to use when matching rows in Google Sheets to the input items of this node. Usually an ID.\n- Now you can see all colume in \"Values to Send\" section. Here you need to map (using drag and drop) the filed  with the form filed name. ",
      "position": [
        520,
        220
      ],
      "parameters": {
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "65b5cb47-12d0-42a5-bb95-c023710dd310",
      "name": "E-Mail",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        780,
        420
      ],
      "webhookId": "4f5aacbc-7967-44c0-9e24-00472ec25b48",
      "parameters": {
        "text": "Please give us your valuable feedback at:\n<<< Your Form Production URL >>>",
        "options": {
          "appendAttribution": false
        },
        "subject": "Feedback",
        "toEmail": "={{ $json.Email }}",
        "fromEmail": "XYZ@gmail.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "3QSx1pWoS0BZcK4c",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "457b43d6-fa50-4259-bf56-b637b1819445",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        140
      ],
      "parameters": {
        "width": 380,
        "height": 600,
        "content": "## Google Sheets Integration \n#### Create Google Cloud Credentials\nTo connect Google Sheets to n8n, you need to set up OAuth2 authentication through Google Cloud:\n\n**1. Create a Google Cloud Project:**\n - Go to the Google Cloud Console (https://console.cloud.google.com/).\n - Create a new project or select an existing one.\n - Enable the Google Sheets API under APIs & Services > Library.\n\n**2. Set Up OAuth Consent Screen:**\n - Navigate to APIs & Services > OAuth consent screen.\n - Select External user type and fill in required details (e.g., app name, support email).\n - Add the following scopes: .../auth/spreadsheets (for full access to Google Sheets).\n - Save and proceed.\n\n**3. Create OAuth2 Credentials:**\n - Go to APIs & Services > Credentials > Create Credentials > OAuth 2.0 Client IDs.\n - Choose Web application as the application type.\n - Add an Authorized redirect URI (you’ll get this from n8n in the next step).\n - Save to obtain your Client ID and Client Secret."
      },
      "typeVersion": 1
    },
    {
      "id": "cc0786b3-2340-4fa1-812b-49dc76a3ef0d",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        20
      ],
      "parameters": {
        "width": 380,
        "height": 100,
        "content": "## Integration Notes\nKindly see the node **notes** in the **setting** tab for more information."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "481b316a-890a-4a24-812a-b402638ff547",
  "connections": {
    "553d9f71-a750-4152-84bb-9d2956441aa8": {
      "main": [
        [
          {
            "node": "153adc14-68c1-4b4d-bb93-8dc5204ec7e9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ce02dda2-111e-4bde-99a9-393547c40435": {
      "main": [
        [
          {
            "node": "0f02714d-0da3-4f86-ba62-97ce92883201",
            "type": "main",
            "index": 0
          },
          {
            "node": "2890694e-c503-4eda-825b-b569e7f8831a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cf9d2612-b582-4352-809e-31a38f4126b5": {
      "main": [
        []
      ]
    },
    "2890694e-c503-4eda-825b-b569e7f8831a": {
      "main": [
        [
          {
            "node": "cf9d2612-b582-4352-809e-31a38f4126b5",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "0f02714d-0da3-4f86-ba62-97ce92883201": {
      "main": [
        [
          {
            "node": "65b5cb47-12d0-42a5-bb95-c023710dd310",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    }
  }
}