{
  "name": "Automate CSAT surveys with Freshdesk & store responses in Google Sheets",
  "nodes": [
    {
      "id": "7e821a77-1db8-4d91-8500-7785b195151b",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        -260
      ]
    },
    {
      "id": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
      "name": "If ticket resolved",
      "type": "n8n-nodes-base.if",
      "position": [
        880,
        -360
      ]
    },
    {
      "id": "fbe9f747-e591-491e-b47d-4a1875daa898",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1980,
        -360
      ]
    },
    {
      "id": "fdc22898-b6ad-4489-8562-fe29e68a0832",
      "name": "get client",
      "type": "n8n-nodes-base.freshdesk",
      "position": [
        1320,
        -360
      ]
    },
    {
      "id": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
      "name": "get tickets",
      "type": "n8n-nodes-base.freshdesk",
      "position": [
        660,
        -360
      ]
    },
    {
      "id": "053a1afe-5f25-418e-936a-7770d9bb487e",
      "name": "Updates status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1100,
        -360
      ]
    },
    {
      "id": "2f192048-9b73-4687-a357-e84d1818209e",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        -460
      ]
    },
    {
      "id": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
      "name": "Set your data",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        -360
      ]
    },
    {
      "id": "013c1ba5-d3ff-4304-88c5-ec824686a372",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -540
      ],
      "parameters": {
        "width": null,
        "height": 340,
        "content": "## Set your data here\n- Put as Survey link the Production URL of the \"Survey\" Node and set the workflow to \"Active\""
      }
    },
    {
      "id": "cfcc442f-e885-43dc-ae0e-0bf27443c6ac",
      "name": "Survey",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "cc3f18ff-6967-42f4-aa2a-23ec503a9b43",
      "name": "get existing tickets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        440,
        -360
      ]
    },
    {
      "id": "a6590283-4b5c-44d7-9384-40708e38a8e4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -540
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "## Save tickets\n- Create an empty google sheet and put it here"
      }
    },
    {
      "id": "878ba0f7-cad0-443a-884e-8ff1259fa02f",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        -540
      ],
      "parameters": {
        "width": 200,
        "height": 340,
        "content": "## Get tickets\n- Connect here to Freshdesk with your credentials"
      }
    },
    {
      "id": "c114af56-5686-40fa-b63d-158d14f87131",
      "name": "Create the email text",
      "type": "n8n-nodes-base.set",
      "position": [
        1540,
        -360
      ]
    },
    {
      "id": "c5c217d5-7d2e-4c27-828f-a758a35c0f9c",
      "name": "Convert the email text to HTML",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1760,
        -360
      ]
    },
    {
      "id": "64bebbc9-a8a3-459f-8938-d9b17b1c64a2",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        -540
      ],
      "parameters": {
        "width": 200,
        "height": 340,
        "content": "## Email send settings\n- Here you can change this node for a gmail node for eaxmple. "
      }
    },
    {
      "id": "1372a887-042f-401c-bc39-38bccdb943e8",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1260,
        -540
      ],
      "parameters": {
        "width": 200,
        "height": 340,
        "content": "## Get Client\n- Connect here to Freshdesk with your credentials"
      }
    },
    {
      "id": "07287a6a-16e8-40da-a45e-bdc0e01f14d5",
      "name": "Save survey to google sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        200,
        0
      ]
    },
    {
      "id": "78fa9cde-7135-4dd2-8d74-9b6c826fbd6b",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -100
      ],
      "parameters": {
        "width": 220,
        "height": 340,
        "content": "## Save survey\n- Create an empty google sheet and put it here"
      }
    },
    {
      "id": "001ff1c0-515c-410f-a460-c52867af8cb9",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -780
      ],
      "parameters": {
        "width": 880,
        "height": 220,
        "content": "## Contact me\n- If you need any modification to this workflow\n- if you need some help with this workflow\n- Or if you need any workflow in n8n, Make, or Langchain / Langgraph\n\nWrite to me: [thomas@poll"
      }
    },
    {
      "id": "e5420f8a-b734-4d7c-af02-204c3d263457",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -100,
        -100
      ],
      "parameters": {
        "width": 220,
        "height": 340,
        "content": "##  Modify Survey\n- Set all the survey's question you need here"
      }
    }
  ],
  "connections": {
    "Survey": {
      "main": [
        [
          {
            "node": "Save survey to google sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get client": {
      "main": [
        [
          {
            "node": "Create the email text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get tickets": {
      "main": [
        [
          {
            "node": "If ticket resolved",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set your data": {
      "main": [
        [
          {
            "node": "get existing tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Updates status": {
      "main": [
        [
          {
            "node": "get client",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Set your data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If ticket resolved": {
      "main": [
        [
          {
            "node": "Updates status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get existing tickets": {
      "main": [
        [
          {
            "node": "get tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create the email text": {
      "main": [
        [
          {
            "node": "Convert the email text to HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert the email text to HTML": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Set your data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}