Extracción de datos estructurados de HackerNews y exportación a Google Docs con Google Gemini

Name: Extracción de datos estructurados de HackerNews y exportación a Google Docs con Google Gemini
Rating: 4.5 (10 reviews)
Author: Ranjan Dailata

Avanzado

Este es unMarket Research, AI Summarizationflujo de automatización del dominio deautomatización que contiene 16 nodos.Utiliza principalmente nodos como Set, GoogleDocs, HackerNews, HttpRequest, ManualTrigger. Extraer y convertir datos de HackerNews a Google Docs con Gemini 2.0 Flash

Requisitos previos

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

Nodos utilizados (16)

Categoría

Investigación de mercado

Resumen de IA

Vista previa del flujo de trabajo

Visualización de las conexiones entre nodos, con soporte para zoom y panorámica

Al hacer clic en 'Ejecutar flujo de trabajo'

Hacker News

Recorrer elementos

Modelo de chat Google Gemini

Crear un Doc de Google

Actualizar Docs de Google

Establecer campos de entrada

Extraer datos legibles por humanos

Establecer url, autor

Crear una solicitud HTTP

React Flow

Exportar flujo de trabajo

Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo

{
  "id": "qgOiQsPSKD08eiB3",
  "meta": {
    "instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract Structured Data from HackerNews, Export to Google Docs with Google Gemini",
  "tags": [
    {
      "id": "Kujft2FOjmOVQAmJ",
      "name": "Engineering",
      "createdAt": "2025-04-09T01:31:00.558Z",
      "updatedAt": "2025-04-09T01:31:00.558Z"
    },
    {
      "id": "ZOwtAMLepQaGW76t",
      "name": "Building Blocks",
      "createdAt": "2025-04-13T15:23:40.462Z",
      "updatedAt": "2025-04-13T15:23:40.462Z"
    },
    {
      "id": "ddPkw7Hg5dZhQu2w",
      "name": "AI",
      "createdAt": "2025-04-13T05:38:08.053Z",
      "updatedAt": "2025-04-13T05:38:08.053Z"
    }
  ],
  "nodes": [
    {
      "id": "2f6e390d-47d2-46c0-b032-00e1541a8def",
      "name": "Al hacer clic en 'Ejecutar flujo de trabajo'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -380,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "da17296e-a0b0-423f-8f6a-6636f77ff79e",
      "name": "Hacker News",
      "type": "n8n-nodes-base.hackerNews",
      "position": [
        60,
        0
      ],
      "parameters": {
        "limit": "={{ $json.Count }}",
        "resource": "all",
        "additionalFields": {}
      },
      "typeVersion": 1
    },
    {
      "id": "8481d533-2ef1-4e97-afe1-8f182d17b390",
      "name": "Recorrer elementos",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        280,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "5d88db37-0e3b-4900-af10-78a4f7152231",
      "name": "Modelo de chat Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        940,
        240
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.0-flash-exp"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "YeO7dHZnuGBVQKVZ",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0fcf5b56-87f8-4dca-9478-7f0753c195e7",
      "name": "Crear un Doc de Google",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1320,
        20
      ],
      "parameters": {
        "title": "={{ $('Set the url, author').item.json.author }}-HackerNews",
        "folderId": "default"
      },
      "credentials": {
        "googleDocsOAuth2Api": {
          "id": "39XPsztp1DX0svZQ",
          "name": "Google Docs account"
        }
      },
      "executeOnce": false,
      "retryOnFail": true,
      "typeVersion": 2,
      "alwaysOutputData": false
    },
    {
      "id": "2855e7e7-ea99-4acc-901a-54bffa7b3113",
      "name": "Actualizar Docs de Google",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1500,
        20
      ],
      "parameters": {
        "actionsUi": {
          "actionFields": [
            {
              "text": "={{ $('Extract Human Readable Data').item.json.text }}",
              "action": "insert"
            }
          ]
        },
        "operation": "update",
        "documentURL": "={{ $json.id }}"
      },
      "credentials": {
        "googleDocsOAuth2Api": {
          "id": "39XPsztp1DX0svZQ",
          "name": "Google Docs account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "ef59d4a1-4176-4702-996d-5a710b432b4b",
      "name": "Establecer campos de entrada",
      "type": "n8n-nodes-base.set",
      "position": [
        -160,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "52ddafbb-536f-45d6-9697-7ddf5b9b3869",
              "name": "Count",
              "type": "string",
              "value": "5"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "aa74a371-94cf-4a0b-93d9-fd503f1abbed",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        200,
        -320
      ],
      "parameters": {
        "content": "## Step 1\n\nSet the input field with the \"Count\", how many record needs to be feteched."
      },
      "typeVersion": 1
    },
    {
      "id": "79674295-f331-4e5b-81d4-09d45aedb883",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        -320
      ],
      "parameters": {
        "content": "## Step 2\n\nSet the Google Gemini Credentials as part of the human readable data extraction"
      },
      "typeVersion": 1
    },
    {
      "id": "80ed14eb-6ead-46d8-81d0-5502cb5f44db",
      "name": "Extraer datos legibles por humanos",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        980,
        20
      ],
      "parameters": {
        "text": "=Extract a human readable content. \n\nHere's the context :\n\n{{ $json.data }}",
        "batching": {},
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 1.7
    },
    {
      "id": "d922ad6e-0959-465f-810f-3f0e8d8a3626",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -360,
        -400
      ],
      "parameters": {
        "color": 6,
        "width": 540,
        "height": 240,
        "content": "## Extract Structured Data from Hacker News, Export to Google Docs with Google Gemini\n\nHacker news data extraction with Google Gemini. Export the clean data to Google Document."
      },
      "typeVersion": 1
    },
    {
      "id": "79f3eca6-df7d-4e72-816e-b17452f476b5",
      "name": "Nota adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -320
      ],
      "parameters": {
        "content": "## Step 3\n\nSet the Google Document Credentials for the Hacker News data export"
      },
      "typeVersion": 1
    },
    {
      "id": "b3cfee88-735c-4474-b7c0-75511d44e26c",
      "name": "Nota adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        200,
        -140
      ],
      "parameters": {
        "color": 5,
        "width": 1060,
        "height": 520,
        "content": "## Hacker News Data Extraction"
      },
      "typeVersion": 1
    },
    {
      "id": "36302c89-82a4-4098-9ca6-7822bb4d6c33",
      "name": "Nota adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -360,
        -140
      ],
      "parameters": {
        "color": 3,
        "width": 540,
        "height": 120,
        "content": "## LLM Usages\n\nGoogle Gemini -> Gemini 2.0 Flash Exp Model"
      },
      "typeVersion": 1
    },
    {
      "id": "80c3a993-6c82-43c9-9612-e20e989012ef",
      "name": "Establecer url, autor",
      "type": "n8n-nodes-base.set",
      "position": [
        500,
        20
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "267f21f5-d483-4e74-9773-b1d8a02dd984",
              "name": "author",
              "type": "string",
              "value": "={{ $json.author }}"
            },
            {
              "id": "667a3ffb-a07c-4f66-b253-a7c64b2aa8e0",
              "name": "url",
              "type": "string",
              "value": "={{ $json._highlightResult.url.value }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "ad6eb942-17a1-48af-9d41-f728c9127106",
      "name": "Crear una solicitud HTTP",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        720,
        20
      ],
      "parameters": {
        "url": "={{ $json.url }}",
        "options": {}
      },
      "retryOnFail": true,
      "typeVersion": 4.2,
      "alwaysOutputData": true
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "640bfa35-72c3-4d4d-8e38-a98fee2248e9",
  "connections": {
    "da17296e-a0b0-423f-8f6a-6636f77ff79e": {
      "main": [
        [
          {
            "node": "8481d533-2ef1-4e97-afe1-8f182d17b390",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8481d533-2ef1-4e97-afe1-8f182d17b390": {
      "main": [
        [],
        [
          {
            "node": "80c3a993-6c82-43c9-9612-e20e989012ef",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2855e7e7-ea99-4acc-901a-54bffa7b3113": {
      "main": [
        [
          {
            "node": "8481d533-2ef1-4e97-afe1-8f182d17b390",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0fcf5b56-87f8-4dca-9478-7f0753c195e7": {
      "main": [
        [
          {
            "node": "2855e7e7-ea99-4acc-901a-54bffa7b3113",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "80c3a993-6c82-43c9-9612-e20e989012ef": {
      "main": [
        [
          {
            "node": "ad6eb942-17a1-48af-9d41-f728c9127106",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ef59d4a1-4176-4702-996d-5a710b432b4b": {
      "main": [
        [
          {
            "node": "da17296e-a0b0-423f-8f6a-6636f77ff79e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ad6eb942-17a1-48af-9d41-f728c9127106": {
      "main": [
        [
          {
            "node": "80ed14eb-6ead-46d8-81d0-5502cb5f44db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "80ed14eb-6ead-46d8-81d0-5502cb5f44db",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "80ed14eb-6ead-46d8-81d0-5502cb5f44db": {
      "main": [
        [
          {
            "node": "0fcf5b56-87f8-4dca-9478-7f0753c195e7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2f6e390d-47d2-46c0-b032-00e1541a8def": {
      "main": [
        [
          {
            "node": "ef59d4a1-4176-4702-996d-5a710b432b4b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - Investigación de mercado, Resumen de IA

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.