Análisis diario de asuntos de UPSC

• •Pueden requerirse credenciales de autenticación para la API de destino
• •Credenciales de API de Google Sheets
• •Clave de API de Google Gemini

{
  "name": "Daily UPSC Current Affairs Analysis from The Hindu to Google Sheets",
  "tags": [],
  "nodes": [
    {
      "name": "Al hacer clic en 'Ejecutar flujo de trabajo'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -64,
        160
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Al-hacer-clic-en-Ejecutar-flujo-de-trabajo--0"
    },
    {
      "name": "HTTP Request: Obtener Portada de The Hindu",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        272,
        16
      ],
      "parameters": {
        "url": "https://www.thehindu.com/latest-news/",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "User-Agent",
              "value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36"
            }
          ]
        }
      },
      "typeVersion": 4.2,
      "id": "HTTP-Request-Obtener-Portada-de-The-Hindu-1"
    },
    {
      "name": "Agente de IA: Filtrar y Analizar Noticias UPSC",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1616,
        16
      ],
      "parameters": {
        "text": "=Please analyze only those news article which is important for upsc exam (left others) (Only 5-6 most important article needed.) and provide the following information in a structured JSON format.\nOnly 5-6 most important article needed.\n\nArticle URL: {{ $('Code in JavaScript: Pair URL & Title').item.json.url }}\nArticle Content:\n{{ $json.articleText }}\n\nBased on the content, provide:\n1.  A brief summary (2-3 sentences).\n2.  What is important for the UPSC exam (1 sentence).\n3.  The main subject (e.g., Polity, Economy, International Relations, Science & Tech, Environment).\n\nUpload on the google sheet in following columns:\nDate;\tURL;\tSubject;\tBrief Summary;\tWhat is Important",
        "options": {
          "systemMessage": "You are an AI expert in Current Affairs analysis for the UPSC Civil Services Examination. Your task is to filter, analyze, and summarize news articles from The Hindu based *strictly* on their relevance to the official UPSC syllabus (GS Papers I, II, III, IV) and Current Affairs. For every article provided, you must first assess its importance. If it is not one of the *top 5-6 most important* articles, output a rejection statement and do not call the Append tool. If it is relevant, call the Append tool with the extracted and analyzed data.",
          "returnIntermediateSteps": true
        },
        "promptType": "define"
      },
      "typeVersion": 2.2,
      "id": "Agente-de-IA-Filtrar-y-Analizar-Noticias-UPSC-2"
    },
    {
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1600,
        160
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {},
      "typeVersion": 1,
      "id": "Google-Gemini-Chat-Model-3"
    },
    {
      "name": "HTML: Extraer Enlaces y Títulos de Artículos",
      "type": "n8n-nodes-base.html",
      "position": [
        512,
        16
      ],
      "parameters": {
        "options": {},
        "operation": "extractHtmlContent",
        "extractionValues": {
          "values": [
            {
              "key": "url",
              "attribute": "href",
              "cssSelector": "h3.title > a",
              "returnArray": true,
              "returnValue": "attribute"
            },
            {
              "key": "title",
              "cssSelector": "h3.title > a",
              "returnArray": true
            }
          ]
        }
      },
      "typeVersion": 1.2,
      "id": "HTML-Extraer-Enlaces-y-T-tulos-de-Art-culos-4"
    },
    {
      "name": "HTTP Request1: Obtener Contenido Completo del Artículo",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1104,
        16
      ],
      "parameters": {
        "url": "={{ $json.url }}",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "User-Agent",
              "value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36"
            }
          ]
        }
      },
      "typeVersion": 4.2,
      "id": "HTTP-Request1-Obtener-Contenido-Completo-del-Art-culo-5"
    },
    {
      "name": "HTML1: Extraer Cuerpo del Artículo",
      "type": "n8n-nodes-base.html",
      "position": [
        1376,
        16
      ],
      "parameters": {
        "options": {},
        "operation": "extractHtmlContent",
        "extractionValues": {
          "values": [
            {
              "key": "articleText",
              "cssSelector": "div[id^=\"content-body-\"]"
            }
          ]
        }
      },
      "typeVersion": 1.2,
      "id": "HTML1-Extraer-Cuerpo-del-Art-culo-6"
    },
    {
      "name": "Añadir fila en hoja",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1920,
        16
      ],
      "parameters": {
        "columns": {
          "value": {
            "URL": "={{ $json.intermediateSteps[0].action.toolInput.URL || $json.URL }}",
            "Date": "={{ $json.intermediateSteps[0].action.toolInput.Date || $json.Date }}",
            "Subject": "={{ $json.intermediateSteps[0].action.toolInput.Subject || $json.Subject }}",
            "Brief Summary": "={{ $json.intermediateSteps[0].action.toolInput.Brief_Summary || $json['Brief Summary'] }}",
            "What is Important": "={{ $json.intermediateSteps[0].action.toolInput.What_is_Important || $json['What is Important'] }}"
          },
          "schema": [
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subject",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Brief Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Brief Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "What is Important",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "What is Important",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "<GOOGLE_SHEET_GID_UPSC_NEWS>",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit#gid=<GOOGLE_SHEET_GID_UPSC_NEWS>",
          "cachedResultName": "UPSC Hindu News"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "<GOOGLE_SHEET_ID_UPSC_NEWS>",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit?usp=drivesdk",
          "cachedResultName": "Untitled spreadsheet"
        }
      },
      "credentials": {},
      "typeVersion": 4.7,
      "id": "A-adir-fila-en-hoja-7"
    },
    {
      "name": "Añadir fila en hoja en Google Sheets1",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        1776,
        160
      ],
      "parameters": {
        "columns": {
          "value": {
            "URL": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', ``, 'string') }}",
            "Date": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Date', ``, 'string') }}",
            "Subject": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}",
            "Brief Summary": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Brief_Summary', ``, 'string') }}",
            "What is Important": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('What_is_Important', ``, 'string') }}"
          },
          "schema": [
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subject",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Brief Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Brief Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "What is Important",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "What is Important",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "useAppend": true
        },
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "<GOOGLE_SHEET_GID_UPSC_NEWS>",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit#gid=<GOOGLE_SHEET_GID_UPSC_NEWS>",
          "cachedResultName": "UPSC Hindu News"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "<GOOGLE_SHEET_ID_UPSC_NEWS>",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit?usp=drivesdk",
          "cachedResultName": "Untitled spreadsheet"
        },
        "descriptionType": "manual",
        "toolDescription": "Append row in sheet in Google Sheets"
      },
      "credentials": {},
      "typeVersion": 4.7,
      "id": "A-adir-fila-en-hoja-en-Google-Sheets1-8"
    },
    {
      "name": "Código en JavaScript: Emparejar URL y Título",
      "type": "n8n-nodes-base.code",
      "position": [
        832,
        16
      ],
      "parameters": {
        "jsCode": "// Get the JSON output from the previous node, which is named \"HTML: Extract Article Links & Titles\"\nconst inputData = $('HTML: Extract Article Links & Titles').first().json;\n\n// Get the arrays from that data\nconst urls = inputData.url;\nconst titles = inputData.title;\n\nconst pairedItems = [];\n\n// Loop through the URLs and pair each one with its title\nfor (let i = 0; i < urls.length; i++) {\n  pairedItems.push({\n    json: {\n      url: urls[i],\n      title: titles[i]\n    }\n  });\n}\n\n// Return the new list of paired items\nreturn pairedItems;"
      },
      "typeVersion": 2,
      "id": "C-digo-en-JavaScript-Emparejar-URL-y-T-tulo-9"
    },
    {
      "name": "Activador Programado: Diariamente a las 7 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -64,
        -16
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 7
            }
          ]
        }
      },
      "typeVersion": 1.2,
      "id": "Activador-Programado-Diariamente-a-las-7-AM-10"
    },
    {
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -128
      ],
      "parameters": {
        "width": 480,
        "height": 816,
        "content": "Automated Daily UPSC Current Affairs Compilation\n\nThis workflow automates the process of creating daily current affairs notes for the Competitive Exams like UPSC.\n\nIt scrapes the latest news from The Hindu, uses an **AI Agent (powered by Google Gemini)** to filter only the **most relevant articles** (5-6 per run), generates a concise summary and UPSC-specific importance note, and automatically logs the analyzed data to a **Google Sheet**.\n\n## Who’s it for\n\n* **UPSC/CSE Aspirants** who want a curated, concise, and focused daily current affairs digest.\n* **Coaching Institutes** who need to automate the creation of daily study material.\n* **Educators** focused on Governance, Economy, and International Relations topics.\n\n## Requirements\n\n* **Google Gemini API Key:** For the Chat Model node.\n* **Google Sheets:** To store the final compiled current affairs digest.\n\n## How to set up\n\n1.  **Credentials:** Connect your **Google Gemini** and **Google Sheets** credentials.\n2.  **Google Sheet Setup:** Link the two Google Sheets nodes to your spreadsheet. Ensure your sheet has the column headers: `Date`, `URL`, `Subject`, `Brief Summary`, and `What is Important`.\n3.  **Scheduling:** Adjust the **Schedule Trigger** time (default is 7 AM) if needed."
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva-11"
    },
    {
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -96
      ],
      "parameters": {
        "width": 288,
        "height": 416,
        "content": "Sets the time for the workflow to run every morning."
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva1-12"
    },
    {
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        144,
        -96
      ],
      "parameters": {
        "width": 288,
        "height": 400,
        "content": "Sends a request to the latest news section of Newspaper Web."
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva2-13"
    },
    {
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        448,
        -96
      ],
      "parameters": {
        "width": 272,
        "height": 384,
        "content": "Parses the received HTML "
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva3-14"
    },
    {
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        736,
        -96
      ],
      "parameters": {
        "width": 272,
        "height": 384,
        "content": "Creates a separate data item for every single news article for individual processing"
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva4-15"
    },
    {
      "name": "Nota Adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1024,
        -96
      ],
      "parameters": {
        "width": 272,
        "height": 384,
        "content": "Retrieve its full text/HTML content."
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva5-16"
    },
    {
      "name": "Nota Adhesiva6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        -96
      ],
      "parameters": {
        "height": 384,
        "content": "Isolates and extracts the clean, primary article text"
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva6-17"
    },
    {
      "name": "Nota Adhesiva7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1568,
        -96
      ],
      "parameters": {
        "width": 304,
        "height": 384,
        "content": "Filter for UPSC relevance, summarize, categorize, and prepare the data for the sheet"
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva7-18"
    },
    {
      "name": "Nota Adhesiva8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1888,
        -96
      ],
      "parameters": {
        "width": 256,
        "height": 368,
        "content": "Ensuring the structured data is physically written to the Google Sheet."
      },
      "typeVersion": 1,
      "id": "Nota-Adhesiva8-19"
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "Google-Gemini-Chat-Model-3": {
      "ai_languageModel": [
        [
          {
            "node": "Agente-de-IA-Filtrar-y-Analizar-Noticias-UPSC-2",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "HTML1-Extraer-Cuerpo-del-Art-culo-6": {
      "main": [
        [
          {
            "node": "Agente-de-IA-Filtrar-y-Analizar-Noticias-UPSC-2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Activador-Programado-Diariamente-a-las-7-AM-10": {
      "main": [
        [
          {
            "node": "HTTP-Request-Obtener-Portada-de-The-Hindu-1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Agente-de-IA-Filtrar-y-Analizar-Noticias-UPSC-2": {
      "main": [
        [
          {
            "node": "A-adir-fila-en-hoja-7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "C-digo-en-JavaScript-Emparejar-URL-y-T-tulo-9": {
      "main": [
        [
          {
            "node": "HTTP-Request1-Obtener-Contenido-Completo-del-Art-culo-5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTML-Extraer-Enlaces-y-T-tulos-de-Art-culos-4": {
      "main": [
        [
          {
            "node": "C-digo-en-JavaScript-Emparejar-URL-y-T-tulo-9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Al-hacer-clic-en-Ejecutar-flujo-de-trabajo--0": {
      "main": [
        [
          {
            "node": "HTTP-Request-Obtener-Portada-de-The-Hindu-1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "A-adir-fila-en-hoja-en-Google-Sheets1-8": {
      "ai_tool": [
        [
          {
            "node": "Agente-de-IA-Filtrar-y-Analizar-Noticias-UPSC-2",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "HTTP-Request-Obtener-Portada-de-The-Hindu-1": {
      "main": [
        [
          {
            "node": "HTML-Extraer-Enlaces-y-T-tulos-de-Art-culos-4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP-Request1-Obtener-Contenido-Completo-del-Art-culo-5": {
      "main": [
        [
          {
            "node": "HTML1-Extraer-Cuerpo-del-Art-culo-6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}