{
  "name": "Analyze Google Forms feedback with Gemini AI and send weekly reports",
  "nodes": [
    {
      "id": "27c5a163-c0e8-4a6e-8a92-46ef3c8858c5",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        -176
      ],
      "parameters": {
        "width": 540,
        "height": 820,
        "content": "## Customer feedback analyzer\n\nAutomatically analyze new Google Forms responses using Gemini AI for sentiment analysis, categorization, and actionable insights. Results are logged in Google Sheets, sa"
      }
    },
    {
      "id": "3d727898-8861-4866-8e57-f2ebd97ddd94",
      "name": "Collection section note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -176
      ],
      "parameters": {
        "width": 500,
        "height": 380,
        "content": "## Data collection\nReads new form responses from Google Sheets and filters unprocessed rows."
      }
    },
    {
      "id": "2f5950c9-a722-4929-ad86-9b4b7187f351",
      "name": "AI section note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        608,
        -176
      ],
      "parameters": {
        "width": 344,
        "height": 552,
        "content": "## AI analysis\nGemini analyzes each response for sentiment, category, and key themes."
      }
    },
    {
      "id": "3e83b5be-0f6e-4861-a4d9-d5f3fa496214",
      "name": "Output section note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -176
      ],
      "parameters": {
        "width": 788,
        "height": 556,
        "content": "## Reporting\nWrites results back to Sheets, logs insights in Notion, and emails the summary."
      }
    },
    {
      "id": "7d6011fd-40c0-491b-ba28-4a51147ac23f",
      "name": "Daily feedback check",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        128,
        0
      ]
    },
    {
      "id": "dcc02c60-9600-4bcd-a772-655ce3d937b5",
      "name": "Read feedback responses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        304,
        0
      ]
    },
    {
      "id": "fa7eb92a-48f6-4b06-b270-aeb2510e12cd",
      "name": "Filter unprocessed responses",
      "type": "n8n-nodes-base.code",
      "position": [
        464,
        0
      ]
    },
    {
      "id": "91bd04ed-60f2-448e-8031-4a33616f78a0",
      "name": "Analyze feedback with Gemini",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        672,
        0
      ]
    },
    {
      "id": "bd24942e-1d59-4a95-9f7f-ac9e64835737",
      "name": "Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        672,
        144
      ]
    },
    {
      "id": "ea186a1a-6d32-458b-b715-911a6fd551c0",
      "name": "Parse results and build report",
      "type": "n8n-nodes-base.code",
      "position": [
        1120,
        0
      ]
    },
    {
      "id": "305d9aa9-e043-412a-a8ef-ec5c807960ba",
      "name": "Update feedback sheet with results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1344,
        0
      ]
    },
    {
      "id": "46137cfe-cb9a-4851-911b-d2baae8e840b",
      "name": "Log insights to Notion",
      "type": "n8n-nodes-base.notion",
      "position": [
        1568,
        0
      ]
    },
    {
      "id": "f3aa5cef-9c71-483a-9ed0-0d5f5bd0c00f",
      "name": "Email report to team",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1568,
        224
      ]
    }
  ],
  "connections": {
    "Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Analyze feedback with Gemini",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Daily feedback check": {
      "main": [
        [
          {
            "node": "Read feedback responses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read feedback responses": {
      "main": [
        [
          {
            "node": "Filter unprocessed responses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze feedback with Gemini": {
      "main": [
        [
          {
            "node": "Parse results and build report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter unprocessed responses": {
      "main": [
        [
          {
            "node": "Analyze feedback with Gemini",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse results and build report": {
      "main": [
        [
          {
            "node": "Update feedback sheet with results",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log insights to Notion",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update feedback sheet with results": {
      "main": [
        [
          {
            "node": "Email report to team",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}