Búsqueda automática de perfiles de redes sociales usando IA y Google Sheets

Intermedio

Este es unLead Generation, AI Summarizationflujo de automatización del dominio deautomatización que contiene 13 nodos.Utiliza principalmente nodos como Limit, Filter, GoogleSheets, ExecuteWorkflow, ScheduleTrigger. Búsqueda automatizada en redes sociales multiplataforma a partir de Google Sheets con Gemini AI

Requisitos previos
  • Credenciales de API de Google Sheets
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "dZP8oRCxoLytRJDF",
  "meta": {
    "instanceId": "26bd595441827fb23edb0643d6d240e79b0b8993d278e90950f16e18bf9e3c4a"
  },
  "name": "Automate social media profile lookup from Google Sheets with AI",
  "tags": [],
  "nodes": [
    {
      "id": "f1a23673-c623-4406-9372-904ab0b8fbdd",
      "name": "Disparador programado",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -192,
        -32
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "89d5752d-ac86-4644-ad41-40600bb919ac",
      "name": "OpenRouter Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        976,
        160
      ],
      "parameters": {
        "model": "google/gemini-2.5-flash",
        "options": {}
      },
      "credentials": {
        "openRouterApi": {
          "id": "QqgKARn52qQiKICN",
          "name": "OpenRouter account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "42035af6-2e15-424a-86b6-9c536476b52d",
      "name": "Get All Contacts",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        32,
        -32
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit?usp=drivesdk",
          "cachedResultName": "Contact List Template"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "vWEw7oberM64Wqxn",
          "name": "sam@openpaws.ai Google Sheets"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "4ac06442-ecd0-465d-ba9c-4830198b1783",
      "name": "Filtrar Out Processed Contacts",
      "type": "n8n-nodes-base.filter",
      "position": [
        256,
        -32
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "2fe5592c-8923-4409-b32a-b591acf7f85f",
              "operator": {
                "type": "boolean",
                "operation": "false",
                "singleValue": true
              },
              "leftValue": "={{ $json['Analysed?'] }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "8b250c01-9509-4c12-9d2a-d7bc68f9c06c",
      "name": "Limitar to 1",
      "type": "n8n-nodes-base.limit",
      "position": [
        464,
        -32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "22d033ce-6163-4618-a4f7-18d346bc842b",
      "name": "Find Social Media Links",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        672,
        -32
      ],
      "parameters": {
        "options": {},
        "workflowId": {
          "__rl": true,
          "mode": "list",
          "value": "k053fXGjIF7dUIQZ",
          "cachedResultName": "♻️ 🧩 📚 General Research Agent"
        },
        "workflowInputs": {
          "value": {
            "chatInput": "=Find the social media profile URLs for this individual or company across all major platforms. Return the results in a structured JSON format with null values for any platforms where the profile couldn't be found. Include the following platforms:\n\n1. Twitter/X\n2. LinkedIn\n3. Facebook\n4. Instagram\n5. YouTube\n6. TikTok\n7. Reddit\n8. Mastodon\n9. Truth Social\n10. Threads\n11. Bluesky\n12. Pinterest\n13. Snapchat\n14. Telegram\n15. WhatsApp Business\n16. Medium\n17. GitHub\n18. Twitch\n\nFor each platform, provide either:\n- The direct URL to the verified profile\n- Null if no profile exists or couldn't be found\n\nFormat the response as a JSON object with platform names as keys:\n\n{\n  \"twitter\": \"https://twitter.com/example\",\n  \"linkedin\": \"https://linkedin.com/in/example\",\n  \"facebook\": \"https://facebook.com/example\",\n  \"instagram\": \"https://instagram.com/example\",\n  \"youtube\": \"https://youtube.com/example\",\n  \"tiktok\": \"https://tiktok.com/@example\",\n  \"reddit\": \"https://reddit.com/user/example\",\n  \"mastodon\": \"https://mastodon.social/@example\",\n  \"truth_social\": \"https://truthsocial.com/@example\",\n  \"threads\": \"https://threads.net/@example\",\n  \"bluesky\": \"https://bsky.app/profile/example.bsky.social\",\n  \"pinterest\": \"https://pinterest.com/example\",\n  \"snapchat\": \"https://snapchat.com/add/example\",\n  \"telegram\": \"https://t.me/example\",\n  \"whatsapp_business\": \"https://wa.me/example\",\n  \"medium\": \"https://medium.com/@example\",\n  \"github\": \"https://github.com/example\",\n  \"twitch\": \"https://twitch.tv/example\"\n}\n\nWhen searching:\n\n    Prioritize verified accounts when available\n    Check common variations of the name (first name, last name, initials, nicknames)\n    If multiple potential matches exist, choose the most likely one based on context\n\nAdditional instructions:\n\n    If the contact is a business or organization, look for official company pages\n    For public figures, check both personal and official accounts\n    For researchers or academics, check ResearchGate and Academia.edu\n    For developers, check Stack Overflow and Dev.to\n    For journalists, check Substack and other publishing platforms\n\n# INPUT (this is the individual or company whose social media links you are looking for)\n\n{{ JSON.stringify($json) }}",
            "sessionId": "={{ (Math.random().toString(36).substring(2) + Date.now().toString(36)) }}"
          },
          "schema": [
            {
              "id": "chatInput",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "chatInput",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sessionId",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "sessionId",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e244c667-8205-48cd-9821-a6b1519b6902",
      "name": "Structure Response",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        896,
        -32
      ],
      "parameters": {
        "text": "={{ $json.output }}",
        "options": {},
        "schemaType": "manual",
        "inputSchema": "{\n  \"$schema\": \"http://json-schema.org/draft-07/schema#\",\n  \"title\": \"Social Media Profiles Schema\",\n  \"description\": \"A schema for capturing social media profile URLs for any contact\",\n  \"type\": \"object\",\n  \"required\": [\n    \"twitter\",\n    \"linkedin\",\n    \"facebook\",\n    \"instagram\",\n    \"youtube\",\n    \"tiktok\",\n    \"reddit\",\n    \"mastodon\",\n    \"truth_social\",\n    \"threads\",\n    \"bluesky\",\n    \"pinterest\",\n    \"snapchat\",\n    \"telegram\",\n    \"whatsapp_business\",\n    \"medium\",\n    \"github\",\n    \"twitch\"\n  ],\n  \"properties\": {\n    \"twitter\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Twitter/X profile. Must be null if no profile exists.\"\n    },\n    \"linkedin\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to LinkedIn profile. Must be null if no profile exists.\"\n    },\n    \"facebook\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Facebook profile. Must be null if no profile exists.\"\n    },\n    \"instagram\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Instagram profile. Must be null if no profile exists.\"\n    },\n    \"youtube\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to YouTube channel. Must be null if no profile exists.\"\n    },\n    \"tiktok\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to TikTok profile. Must be null if no profile exists.\"\n    },\n    \"reddit\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Reddit profile. Must be null if no profile exists.\"\n    },\n    \"mastodon\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Mastodon profile. Must be null if no profile exists.\"\n    },\n    \"truth_social\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Truth Social profile. Must be null if no profile exists.\"\n    },\n    \"threads\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Threads profile. Must be null if no profile exists.\"\n    },\n    \"bluesky\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Bluesky profile. Must be null if no profile exists.\"\n    },\n    \"pinterest\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Pinterest profile. Must be null if no profile exists.\"\n    },\n    \"snapchat\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Snapchat profile. Must be null if no profile exists.\"\n    },\n    \"telegram\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Telegram profile. Must be null if no profile exists.\"\n    },\n    \"whatsapp_business\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to WhatsApp Business profile. Must be null if no profile exists.\"\n    },\n    \"medium\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Medium profile. Must be null if no profile exists.\"\n    },\n    \"github\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to GitHub profile. Must be null if no profile exists.\"\n    },\n    \"twitch\": {\n      \"type\": [\"string\", \"null\"],\n      \"format\": \"uri\",\n      \"description\": \"URL to Twitch profile. Must be null if no profile exists.\"\n    }\n  },\n  \"additionalProperties\": false,\n  \"examples\": [\n    {\n      \"twitter\": \"https://twitter.com/example\",\n      \"linkedin\": null,\n      \"facebook\": \"https://facebook.com/example\",\n      \"instagram\": null,\n      \"youtube\": \"https://youtube.com/example\",\n      \"tiktok\": null,\n      \"reddit\": \"https://reddit.com/user/example\",\n      \"mastodon\": null,\n      \"truth_social\": null,\n      \"threads\": null,\n      \"bluesky\": null,\n      \"pinterest\": null,\n      \"snapchat\": null,\n      \"telegram\": null,\n      \"whatsapp_business\": null,\n      \"medium\": \"https://medium.com/@example\",\n      \"github\": null,\n      \"twitch\": null\n    },\n    {\n      \"twitter\": null,\n      \"linkedin\": \"https://linkedin.com/in/example\",\n      \"facebook\": null,\n      \"instagram\": null,\n      \"youtube\": null,\n      \"tiktok\": null,\n      \"reddit\": null,\n      \"mastodon\": null,\n      \"truth_social\": null,\n      \"threads\": null,\n      \"bluesky\": null,\n      \"pinterest\": null,\n      \"snapchat\": null,\n      \"telegram\": null,\n      \"whatsapp_business\": null,\n      \"medium\": null,\n      \"github\": \"https://github.com/example\",\n      \"twitch\": null\n    }\n  ]\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "22503521-d238-4912-bd9f-3f50c2c1b933",
      "name": "Update Contact",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1264,
        -32
      ],
      "parameters": {
        "columns": {
          "value": {
            "github": "={{ $json.output.github }}",
            "medium": "={{ $json.output.medium }}",
            "reddit": "={{ $json.output.reddit }}",
            "tiktok": "={{ $json.output.tiktok }}",
            "twitch": "={{ $json.output.twitch }}",
            "bluesky": "={{ $json.output.bluesky }}",
            "threads": "={{ $json.output.threads }}",
            "twitter": "={{ $json.output.twitter }}",
            "youtube": "={{ $json.output.youtube }}",
            "facebook": "={{ $json.output.facebook }}",
            "linkedin": "={{ $json.output.linkedin }}",
            "mastodon": "={{ $json.output.mastodon }}",
            "snapchat": "={{ $json.output.snapchat }}",
            "telegram": "={{ $json.output.telegram }}",
            "instagram": "={{ $json.output.instagram }}",
            "pinterest": "={{ $json.output.pinterest }}",
            "row_number": "={{ $('Limit to 1').item.json.row_number }}",
            "truth_social": "={{ $json.output.truth_social }}",
            "whatsapp_business": "={{ $json.output.whatsapp_business }}"
          },
          "schema": [
            {
              "id": "Analysed?",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Analysed?",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "twitter",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "twitter",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "linkedin",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "linkedin",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "facebook",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "facebook",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "instagram",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "instagram",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "youtube",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "youtube",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "tiktok",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "tiktok",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "reddit",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "reddit",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "mastodon",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "mastodon",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "truth_social",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "truth_social",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "threads",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "threads",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "bluesky",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "bluesky",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "pinterest",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "pinterest",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "snapchat",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "snapchat",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "telegram",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "telegram",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "whatsapp_business",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "whatsapp_business",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "medium",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "medium",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "github",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "github",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "twitch",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "twitch",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PASTE ALL NAMES & KNOWN CONTACT DETAILS HERE",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "PASTE ALL NAMES & KNOWN CONTACT DETAILS HERE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit?usp=drivesdk",
          "cachedResultName": "Contact List Template"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "vWEw7oberM64Wqxn",
          "name": "sam@openpaws.ai Google Sheets"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "13d7a754-aa74-4975-a489-fd1e4e307525",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        -496
      ],
      "parameters": {
        "width": 448,
        "height": 416,
        "content": "# 🧭 Workflow Overview\n\nThis n8n workflow automates the process of finding and storing social media profile links for a list of contacts.\n\n## 💡 How It Works\n1. Pulls unprocessed contacts from a Google Sheet.\n2. Sends the contact info to a research subworkflow that uses AI tools to find social media profiles.\n3. Validates and structures the results.\n4. Updates the original sheet with found links and marks the contact as \"Analysed\".\n\n🔁 The workflow runs automatically on a schedule and processes one contact per execution.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "24536b2b-f0ac-4897-afa4-9a05bfb663a8",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -272,
        -496
      ],
      "parameters": {
        "width": 624,
        "height": 416,
        "content": "# 📄 Google Sheet Setup Instructions\n\n📋 Template:  \nhttps://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit?usp=sharing\n\n## ✅ How to Use the Template\n1. **Make a copy** of the Google Sheet into your own Drive.\n2. Paste your contact list beside the preset columnns\n3. In the `Analysed?` column, enter `false` (no quotes) for every new row.\n4. Do not remove or rename existing columns except for the `PASTE ALL NAMES & KNOWN CONTACT DETAILS HERE` column\n\nThe workflow updates each row once processed. Make sure the \"Analysed?\" flag is set properly.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "644a7f23-8c59-45e3-8a92-6f112cad326f",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -496
      ],
      "parameters": {
        "width": 448,
        "height": 416,
        "content": "# 🧠 Subworkflow: Find Social Media Links\n\nCalls this reusable agent:  \n🔗 https://n8n.io/workflows/5588-multi-tool-research-agent-for-animal-advocacy-with-openrouter-serper-and-open-paws-db/\n\n## What It Does:\n- Searches for the contact’s profiles on 18+ platforms:\n  Twitter, LinkedIn, Facebook, YouTube, Reddit, TikTok, GitHub, etc.\n- Prioritizes verified or official accounts\n- Outputs a JSON object with either a link or `null` per platform"
      },
      "typeVersion": 1
    },
    {
      "id": "7033615b-efdc-4d34-b6a3-063d9d3ef14d",
      "name": "Nota adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        -496
      ],
      "parameters": {
        "width": 336,
        "height": 416,
        "content": "# 🧱 Structure and Validate Response\n\nUses a strict schema to:\n- Ensure the JSON is valid and well-formed\n- Normalize missing profiles to `null`\n- Confirm all 18+ platforms are present as keys\n\n✅ Prevents malformed or unexpected results from reaching the sheet.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "474fd9e7-36c7-4502-9e6a-f88a91f56028",
      "name": "Nota adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1232,
        -496
      ],
      "parameters": {
        "width": 320,
        "height": 416,
        "content": "# 📝 Google Sheets: Update Contact\n\nWrites the results back into the **same row** in the original sheet.\n\n- Fills in all social media columns with URLs or `null`\n- Sets `Analysed?` to `true`\n- Uses `row_number` to update the correct contact\n\n📌 Final step to mark the contact as completed!\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1a5e2061-4cf6-493b-8ee9-8f3e4aa3c71d",
  "connections": {
    "Limit to 1": {
      "main": [
        [
          {
            "node": "22d033ce-6163-4618-a4f7-18d346bc842b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "42035af6-2e15-424a-86b6-9c536476b52d": {
      "main": [
        [
          {
            "node": "Filter Out Processed Contacts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "42035af6-2e15-424a-86b6-9c536476b52d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e244c667-8205-48cd-9821-a6b1519b6902": {
      "main": [
        [
          {
            "node": "22503521-d238-4912-bd9f-3f50c2c1b933",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "89d5752d-ac86-4644-ad41-40600bb919ac": {
      "ai_languageModel": [
        [
          {
            "node": "e244c667-8205-48cd-9821-a6b1519b6902",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "22d033ce-6163-4618-a4f7-18d346bc842b": {
      "main": [
        [
          {
            "node": "e244c667-8205-48cd-9821-a6b1519b6902",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Out Processed Contacts": {
      "main": [
        [
          {
            "node": "Limit to 1",
            "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?

Intermedio - Generación de leads, 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.

Flujos de trabajo relacionados recomendados

Extracción de Datos de Negocios en Google Maps Impulsada por IA y Exportación a Tablas
Extracción de datos de negocios en Google Maps basada en IA, con soporte para enriquecimiento de datos y exportación a tablas
If
Code
Wait
+
If
Code
Wait
25 NodosMsaid Mohamed el hadi
Generación de leads
Generación de un boletín semanal de acciones por los derechos animales a partir de proyectos de ley de la Cámara de Representantes de EE. UU. usando Gemini IA
Generar un boletín semanal de acciones por los derechos animales usando Gemini AI basado en proyectos de ley de la Cámara de Representantes de EE. UU.
If
Set
Html
+
If
Set
Html
26 NodosOpen Paws
Redes sociales
Desarrollo de leads y flujos de correo electrónico
Usar Google Maps, SendGrid e IA para automatizar el desarrollo de leads B2B y el marketing por correo electrónico
If
Set
Code
+
If
Set
Code
141 NodosEzema Kingsley Chibuzo
Generación de leads
Boletín semanal de derechos animales
Investigación automatizada de noticias sobre derechos animales y resumen semanal, usando Claude AI y Serper
Set
Email Send
Execute Workflow
+
Set
Email Send
Execute Workflow
11 NodosOpen Paws
Redes sociales
Analizar sostenibilidad corporativa y bienestar animal con automatización de IA
Analizar sostenibilidad y bienestar animal de la empresa con OpenRouter AI y investigación multisource
Set
Merge
Aggregate
+
Set
Merge
Aggregate
15 NodosOpen Paws
Investigación de mercado
08 - Análisis inteligente de contactos impulsado por IA
Clasificar y enriquecer información de contactos en Google Sheets, Airtable y HubSpot usando GPT-4o-mini
Code
Filter
Hubspot
+
Code
Filter
Hubspot
15 NodosAvkash Kakdiya
Generación de leads
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos13
Categoría2
Tipos de nodos8
Descripción de la dificultad

Adecuado para usuarios con experiencia intermedia, flujos de trabajo de complejidad media con 6-15 nodos

Autor
Open Paws

Open Paws

@openpaws

Open Paws is a nonprofit building open-source AI tools to accelerate animal advocacy. We create machine learning models and automation workflows trained on real-world campaign data to help end industrial animal exploitation. All tools are free, transparent, and designed for real-world impact.

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34