{
  "name": "Extract marketing testimonials from feedback with Gemini AI and Google Sheets",
  "nodes": [
    {
      "id": "a7fd4b4e-3642-43ee-9df7-34a291ff34b4",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        512,
        272
      ]
    },
    {
      "id": "818884ad-381e-413e-96a1-7a269828e4ed",
      "name": "Basic LLM Chain",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        784,
        272
      ]
    },
    {
      "id": "800bef4c-8ac7-459a-ae3b-95262f7c6fd9",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        768,
        528
      ]
    },
    {
      "id": "ab8f31c8-65ec-4829-829f-ee6ec355e077",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1200,
        272
      ]
    },
    {
      "id": "a07133e4-e94b-4d28-9284-0f38368a32c2",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1488,
        272
      ]
    },
    {
      "id": "3bf47f3b-da76-46c3-b72b-9e38d9e8f9d8",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1056,
        -112
      ],
      "parameters": {
        "width": 1300,
        "height": 320,
        "content": "=======================================\n            WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n    Yaron@nofluff.online\n\nExplore more tip"
      }
    },
    {
      "id": "0ff7790c-c741-4c9f-b97f-0ce72fa9b305",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1056,
        224
      ],
      "parameters": {
        "width": 1289,
        "height": 1726,
        "content": "# Extract Marketing Testimonials from Feedback with Gemini AI and Google Sheets\n\n### 🌍 **Overview**\n\nThis workflow automatically **extracts short emotional testimonials** from Google Form responses. I"
      }
    },
    {
      "id": "05696003-b784-4105-9414-0545041d8578",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -176
      ],
      "parameters": {
        "width": 324,
        "height": 656,
        "content": "## 🟢 Section 1: Trigger – Listen for New Feedback\n\n🔗 **Nodes:**\n\n* **Google Sheets Trigger** → Watches for new rows (new form responses).\n\n💡 **Beginner takeaway:**\nWhenever a customer submits feedback"
      }
    },
    {
      "id": "5ff54d6f-ce31-4df1-8a20-b56708e40aae",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        752,
        -272
      ],
      "parameters": {
        "width": 324,
        "height": 752,
        "content": "## 🟦 Section 2: Testimonial Extraction with AI\n\n🔗 **Nodes:**\n\n* **Basic LLM Chain** → Runs a custom prompt that tells the AI: *“Extract a short, emotional testimonial quote from the feedback.”*\n* **Go"
      }
    },
    {
      "id": "e0f1efff-19c1-47e3-9c39-bce1632896c7",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1136,
        -176
      ],
      "parameters": {
        "width": 484,
        "height": 656,
        "content": "## 🟣 Section 3: Store & Notify\n\n🔗 **Nodes:**\n\n* **Google Sheets (Write Back)** → Saves the extracted testimonial into the same Google Sheet.\n* **Gmail** → Sends an email with the new testimonial to yo"
      }
    }
  ],
  "connections": {
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}