YouTube Channel Monitor with Gemini AI Transcription & Summarization to Google Sheets

{
  "meta": {
    "instanceId": "b6be3264d10563f53f60f119665bef14019561878be2f73c07ebd4200e9255cf",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "23ed0a44-17f3-4ddd-98d7-667c813b8c26",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -2800,
        400
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "1f54c4f3-f673-40be-b40a-a1ebe1d95c8f",
      "name": "Google Gemini Chat Model13",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -2960,
        400
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "acc97cba-b203-42ef-9c88-b9f3c84e034e",
      "name": "youtube video summariser",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -3024,
        128
      ],
      "parameters": {},
      "retryOnFail": true,
      "typeVersion": 1.5
    },
    {
      "id": "bbfdd52b-e9ae-41e9-830e-ac080c661fc5",
      "name": "If4",
      "type": "n8n-nodes-base.if",
      "position": [
        -4928,
        64
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "80402260-bb85-42b9-84b1-05f4dcd27e88",
      "name": "Loop Over Videos",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -4624,
        48
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "5875d204-c4d9-4bf5-95a3-922f91c72293",
      "name": "Edit Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        -3216,
        128
      ],
      "parameters": {},
      "typeVersion": 3.4,
      "alwaysOutputData": true
    },
    {
      "id": "91a45e4e-1bc5-4bfc-ba87-83f55cf233fa",
      "name": "Youtube Transcriber Gemini",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        -3712,
        144
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "50bf5f8c-0451-47dc-bb87-1f58e091fe5d",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -6000,
        -384
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "ef915172-5a3b-412f-a499-99a73262783c",
      "name": "check if youtube link",
      "type": "n8n-nodes-base.if",
      "position": [
        -5632,
        -384
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "980c2c80-b9fd-454a-b8b5-737a45d93f01",
      "name": "Split into individual links",
      "type": "n8n-nodes-base.code",
      "position": [
        -5824,
        -384
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "5ddd6b95-2478-4fe2-87a0-c84ec9eff978",
      "name": "Loop Over channels",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -5360,
        -400
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "a6a4e066-3e32-4fdd-9e5e-5ff26324ecd0",
      "name": "set channel",
      "type": "n8n-nodes-base.set",
      "position": [
        -5152,
        -384
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "3e39e5bf-5308-41e9-8d14-0bd0188f1ff4",
      "name": "Get Channel details",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -4848,
        -384
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "83b56b40-54d7-45e4-ac7f-aa305d2e1ae4",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4960,
        -464
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c3b35667-6075-49ad-8ae6-5fe0fea9a393",
      "name": "RSS Read (youtube channel videos)",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        -4544,
        -384
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "8d3877bf-74d4-4181-9432-76816a356094",
      "name": "Videos Posted in Last X days (change on line 6)",
      "type": "n8n-nodes-base.code",
      "position": [
        -4352,
        -384
      ],
      "parameters": {},
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "12741747-d3cf-4d31-b8fd-eb34258ca2d9",
      "name": "video details",
      "type": "n8n-nodes-base.set",
      "position": [
        -4128,
        -384
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "771f493f-204e-493a-bca0-08ea4b961b13",
      "name": "If title?",
      "type": "n8n-nodes-base.if",
      "position": [
        -3904,
        -384
      ],
      "parameters": {},
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "f7eab8e8-1728-478c-bf80-79c74d628e82",
      "name": "all videos",
      "type": "n8n-nodes-base.set",
      "position": [
        -3616,
        -400
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "6c1a61e0-65f7-4d2f-b58c-c9ab72bfdc35",
      "name": "Video Data and criteria",
      "type": "n8n-nodes-base.set",
      "position": [
        -4432,
        160
      ],
      "parameters": {},
      "typeVersion": 3.4,
      "alwaysOutputData": true
    },
    {
      "id": "f96c44e3-c59d-406c-8988-d75574d3aeb7",
      "name": "Get row(s) in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -4224,
        160
      ],
      "parameters": {},
      "typeVersion": 4.7,
      "alwaysOutputData": true
    },
    {
      "id": "928e2dd5-c6a6-4bd2-875c-7a70e647de79",
      "name": "if not exist in sheet?",
      "type": "n8n-nodes-base.if",
      "position": [
        -4032,
        160
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "cce80df2-48e0-46f5-aada-cf4220876e0e",
      "name": "If transcript exists",
      "type": "n8n-nodes-base.if",
      "position": [
        -3440,
        144
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f035199a-b515-4ae6-b536-177cf6e84736",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2672,
        128
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "96e91e5b-52ff-49f3-9b89-fdd6f92de5f1",
      "name": "End",
      "type": "n8n-nodes-base.set",
      "position": [
        -4160,
        32
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "c2dc9bcc-7e97-4c9a-b775-a72dffc60941",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4688,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b3a5afe3-5fe5-47cc-94f3-b14feea2d956",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3120,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "45e914ff-808e-4596-bf69-6c6799324702",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3888,
        16
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "68dfb732-4799-46e7-8274-5749cd8dc807",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -6208,
        -384
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "1a29295c-be37-4b1f-b281-c9e00c6de8c5",
      "name": "Wait 2 sec",
      "type": "n8n-nodes-base.wait",
      "position": [
        -3408,
        -256
      ],
      "webhookId": "e7a42ad4-7cb0-4942-9709-d9dae054d8c6",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "27f95674-e042-4fd1-9d54-c34c70cd8fba",
      "name": "Wait 85 sec on fail",
      "type": "n8n-nodes-base.wait",
      "position": [
        -3232,
        256
      ],
      "webhookId": "8580d46f-0ff8-4687-a5f2-e71960000462",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "ddb1108d-c984-47be-bc43-0dedb3ced055",
      "name": "Wait 70 sec for next video",
      "type": "n8n-nodes-base.wait",
      "position": [
        -2240,
        352
      ],
      "webhookId": "999d44b4-113e-4dcf-bbf0-a0c3dcce7369",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "987ba628-ce7b-4ed0-967e-e00be26359ac",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -6288,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "If4": {
      "main": [
        [
          {
            "node": "Loop Over Videos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If title?": {
      "main": [
        [
          {
            "node": "all videos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 2 sec": {
      "main": [
        [
          {
            "node": "Loop Over channels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "all videos": {
      "main": [
        [
          {
            "node": "Wait 2 sec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "set channel": {
      "main": [
        [
          {
            "node": "Get Channel details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "youtube video summariser",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "video details": {
      "main": [
        [
          {
            "node": "If title?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Videos": {
      "main": [
        [
          {
            "node": "End",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Video Data and criteria",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over channels": {
      "main": [
        [
          {
            "node": "If4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "set channel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Channel details": {
      "main": [
        [
          {
            "node": "RSS Read (youtube channel videos)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Split into individual links",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 85 sec on fail": {
      "main": [
        [
          {
            "node": "Video Data and criteria",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet1": {
      "main": [
        [
          {
            "node": "if not exist in sheet?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If transcript exists": {
      "main": [
        [
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait 85 sec on fail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "check if youtube link": {
      "main": [
        [
          {
            "node": "Loop Over channels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "if not exist in sheet?": {
      "main": [
        [
          {
            "node": "Youtube Transcriber Gemini",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait 70 sec for next video",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Video Data and criteria": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "youtube video summariser": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "youtube video summariser",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model13": {
      "ai_languageModel": [
        [
          {
            "node": "youtube video summariser",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Wait 70 sec for next video": {
      "main": [
        [
          {
            "node": "Loop Over Videos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Youtube Transcriber Gemini": {
      "main": [
        [
          {
            "node": "If transcript exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split into individual links": {
      "main": [
        [
          {
            "node": "check if youtube link",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        [
          {
            "node": "Wait 70 sec for next video",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS Read (youtube channel videos)": {
      "main": [
        [
          {
            "node": "Videos Posted in Last X days (change on line 6)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Videos Posted in Last X days (change on line 6)": {
      "main": [
        [
          {
            "node": "video details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}