8
n8n Españolamn8n.com

Crear contactos y registros de actividades en SinergiaCRM desde Google Sheets

Avanzado

Este es unCRM, Multimodal AIflujo de automatización del dominio deautomatización que contiene 20 nodos.Utiliza principalmente nodos como If, Set, Merge, GoogleSheets, SinergiaCrm. De Google Sheets a SinergiaCRM: registro automático de participantes de eventos

Requisitos previos
  • •Credenciales de API de Google Sheets

Nodos utilizados (20)

If
Set
Merge
StickyNote
GoogleSheets
SinergiaCrm
GoogleSheetsTrigger

Categoría

CRM
IA Multimodal
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
React Flow
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "ekpF9klMhZsn7kDH",
  "meta": {
    "instanceId": "863f6f16da50abd2de4a658ee58a61c1f2392ca5348eff8a1ce770be81c4514b",
    "templateCredsSetupCompleted": true
  },
  "name": "Create contacts and event registrations in SinergiaCRM from Google Sheets",
  "tags": [
    {
      "id": "52gEP1RAeC1i5aJZ",
      "name": "n8n Creator",
      "createdAt": "2025-08-27T11:32:09.072Z",
      "updatedAt": "2025-08-27T11:32:09.072Z"
    }
  ],
  "nodes": [
    {
      "id": "9425f505-8d3e-43f7-bd40-c578a1eb6026",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -64,
        -848
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {
          "valueRender": "FORMATTED_VALUE"
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit?usp=drivesdk",
          "cachedResultName": "SinergiaCRM - Workflows"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "N5cHO7MFUHqbOE1E",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "92e25a51-e446-4a28-ba0a-fc9687d13c0c",
      "name": "SinergiaCRM: Crear Contacto",
      "type": "n8n-nodes-sinergiacrm.sinergiaCrm",
      "position": [
        1504,
        -752
      ],
      "parameters": {
        "data": "={\n  \"first_name\": \"{{ $json['First name'] }}\",\n  \"last_name\":  \"{{ $json['Last name'] }}\",\n  \"email1\":     \"{{ $json.Email }}\",\n  \"stic_identification_type_c\": \"nif\",\n  \"stic_identification_number_c\": \"{{ $json.NIF }}\"\n}\n",
        "module": "Contacts",
        "operation": "create"
      },
      "credentials": {
        "SinergiaCRMCredentials": {
          "id": "ojmiJxUk7IYJooG3",
          "name": "SinergiaCRM account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2700a9e3-1fc6-4b38-b6e6-6049e52d85a7",
      "name": "SinergiaCRM: Crear Relación",
      "type": "n8n-nodes-sinergiacrm.sinergiaCrm",
      "position": [
        1504,
        -944
      ],
      "parameters": {
        "data": "={\n  \"start_date\": \"{{ $json['Relation date'] }}\",\n  \"relationship_type\": \"{{ $json['Relation type'] }}\",\n  \"stic_contacts_relationships_contactscontacts_ida\": \"{{ $json.id }}\",\n  \"assigned_user_id\": \"2\"\n}",
        "module": "stic_Contacts_Relationships",
        "operation": "create"
      },
      "credentials": {
        "SinergiaCRMCredentials": {
          "id": "ojmiJxUk7IYJooG3",
          "name": "SinergiaCRM account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ff4db6a7-3545-4d1f-9c15-96cfd99b2cc0",
      "name": "SinergiaCRM: Crear Registro",
      "type": "n8n-nodes-sinergiacrm.sinergiaCrm",
      "position": [
        1728,
        -944
      ],
      "parameters": {
        "data": "={\n  \"stic_registrations_contactscontacts_ida\": \"{{ $('IF: Person exist').item.json.id }}\",\n  \"stic_registrations_stic_eventsstic_events_ida\": \"{{ $('IF: Person exist').item.json['Event ID'] }}\",\n  \"participation_type\": \"attendant\",\n  \"attendees\": \"1\",\n  \"assigned_user_id\": \"2\",\n  \"status\": \"confirmed\",\n  \"registration_date\": \"{{ $('IF: Person exist').item.json['Registration date'] }}\"\n}",
        "module": "stic_Registrations",
        "operation": "create"
      },
      "credentials": {
        "SinergiaCRMCredentials": {
          "id": "ojmiJxUk7IYJooG3",
          "name": "SinergiaCRM account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e9c8836d-8f17-421c-b28d-e6b5608bb682",
      "name": "Google Sheets: Marcar Procesado = Sí",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2176,
        -944
      ],
      "parameters": {
        "columns": {
          "value": {
            "NIF": "={{ $('IF: Person exist').item.json.NIF }}",
            "Processed": "Yes"
          },
          "schema": [
            {
              "id": "First name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "First name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Last name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NIF",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "NIF",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Relation type",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Relation type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Relation date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Relation date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Event ID",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Event ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Registration date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Registration date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "To CRM",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "To CRM",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Processed",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Processed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "NIF"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit?usp=drivesdk",
          "cachedResultName": "SinergiaCRM - Workflows"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "u5nmgtcJQ2F1YzhC",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "1fe200ba-1909-4c3b-925b-5b80340b712b",
      "name": "IF: to CRM == Yes",
      "type": "n8n-nodes-base.if",
      "position": [
        160,
        -848
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "140b0257-5336-4f90-aceb-ecae84dedb32",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['To CRM'] }}",
              "rightValue": "Yes"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "af5074a1-11ef-4a81-b167-dbf89dae317f",
      "name": "IF: Not processed == No",
      "type": "n8n-nodes-base.if",
      "position": [
        384,
        -848
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f174aa87-e1ee-4877-9de8-282b314724e4",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.Processed }}",
              "rightValue": "No"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "64c626cd-b7d0-4c87-a59f-77e06a8194aa",
      "name": "IF: Person exist",
      "type": "n8n-nodes-base.if",
      "position": [
        1280,
        -848
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "92d7b7c4-2564-4eec-ab05-586340a484ec",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.id }}",
              "rightValue": ""
            }
          ]
        }
      },
      "notesInFlow": false,
      "typeVersion": 2.2
    },
    {
      "id": "dfac6070-5bf8-4729-b4f8-fb9f419f63da",
      "name": "Find person by NIF",
      "type": "n8n-nodes-sinergiacrm.sinergiaCrm",
      "position": [
        608,
        -976
      ],
      "parameters": {
        "module": "Contacts",
        "options": {
          "filters": {
            "Filter": [
              {
                "field": "stic_identification_number_c",
                "value": "={{ $json.NIF }}"
              }
            ]
          }
        }
      },
      "credentials": {
        "SinergiaCRMCredentials": {
          "id": "ojmiJxUk7IYJooG3",
          "name": "SinergiaCRM account 2"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "92859515-4463-4c38-ba53-d0c4fdf426e8",
      "name": "Combinar ID del CRM",
      "type": "n8n-nodes-base.merge",
      "position": [
        832,
        -848
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "advanced": true,
        "joinMode": "enrichInput2",
        "mergeByFields": {
          "values": [
            {
              "field1": "attributes.stic_identification_number_c",
              "field2": "NIF"
            }
          ]
        }
      },
      "typeVersion": 3.2
    },
    {
      "id": "005a1758-b6ac-40ef-8951-57fbb715447e",
      "name": "SinergiaCRM: Create Relationship1",
      "type": "n8n-nodes-sinergiacrm.sinergiaCrm",
      "position": [
        1728,
        -752
      ],
      "parameters": {
        "data": "={\n  \"start_date\": \"{{ $('IF: Person exist').item.json['Relation date'] }}\",\n  \"relationship_type\": \"{{ $('IF: Person exist').item.json['Relation type'] }}\",\n  \"stic_contacts_relationships_contactscontacts_ida\": \"{{ $json.id }}\",\n  \"assigned_user_id\": \"2\"\n}",
        "module": "stic_Contacts_Relationships",
        "operation": "create"
      },
      "credentials": {
        "SinergiaCRMCredentials": {
          "id": "ojmiJxUk7IYJooG3",
          "name": "SinergiaCRM account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f1485c90-4ac8-45ce-b835-35ee6fe91399",
      "name": "SinergiaCRM: Create Registration1",
      "type": "n8n-nodes-sinergiacrm.sinergiaCrm",
      "position": [
        1952,
        -752
      ],
      "parameters": {
        "data": "={\n  \"stic_registrations_contactscontacts_ida\": \"{{ $('SinergiaCRM: Create Contact').item.json.id }}\",\n  \"stic_registrations_stic_eventsstic_events_ida\": \"{{ $('SinergiaCRM: Create Contact').item.json.id }}\",\n  \"participation_type\": \"attendant\",\n  \"attendees\": \"1\",\n  \"assigned_user_id\": \"2\",\n  \"status\": \"confirmed\",\n  \"registration_date\": \"{{ $('IF: Person exist').item.json['Relation date'] }}\"\n}",
        "module": "stic_Registrations",
        "operation": "create"
      },
      "credentials": {
        "SinergiaCRMCredentials": {
          "id": "ojmiJxUk7IYJooG3",
          "name": "SinergiaCRM account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "94312c1a-788a-407f-a07d-83a897ab3982",
      "name": "Google Sheets: Mark Procesado = Sí1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2176,
        -752
      ],
      "parameters": {
        "columns": {
          "value": {
            "NIF": "={{ $('SinergiaCRM: Create Contact').item.json.attributes.stic_identification_number_c }}",
            "Processed": "Yes"
          },
          "schema": [
            {
              "id": "First name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "First name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Last name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NIF",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "NIF",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Relation type",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Relation type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Relation date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Relation date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Event ID",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Event ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Registration date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Registration date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "To CRM",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "To CRM",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Processed",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Processed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "NIF"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit?usp=drivesdk",
          "cachedResultName": "SinergiaCRM - Workflows"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "u5nmgtcJQ2F1YzhC",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "523588fd-0d0e-4645-adac-5d58d3ea6a87",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        1056,
        -848
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "551c98ad-18dc-4123-8e7e-65f88de385e1",
              "name": "First name",
              "type": "string",
              "value": "={{ $json['First name'] }}"
            },
            {
              "id": "1c06fe43-c098-44bf-8701-130fa167ed34",
              "name": "Last name",
              "type": "string",
              "value": "={{ $json['Last name'] }}"
            },
            {
              "id": "0abf9847-0966-4fa9-8852-decd2c4e1b73",
              "name": "NIF",
              "type": "string",
              "value": "={{ $json.NIF }}"
            },
            {
              "id": "e32878ed-45a5-490d-8e4f-e53118da990b",
              "name": "Email",
              "type": "string",
              "value": "={{ $json.Email }}"
            },
            {
              "id": "78a239a1-7404-4135-bfbf-16186c509938",
              "name": "Relation type",
              "type": "string",
              "value": "={{ $json['Relation type'] }}"
            },
            {
              "id": "62a1c21d-410d-4008-9b88-37d9078d7a1e",
              "name": "Relation date",
              "type": "string",
              "value": "={{ $json['Relation date'] }}"
            },
            {
              "id": "e6081bb1-b353-41b6-8f04-bd4ce55786c7",
              "name": "Registration date",
              "type": "string",
              "value": "={{ $json['Relation date'] }}"
            },
            {
              "id": "c631ca9e-3c1a-47db-90a2-2c73dca606cc",
              "name": "Event ID",
              "type": "string",
              "value": "={{ $json['Event ID'] }}"
            },
            {
              "id": "632788f1-5b4c-4113-ae73-ee16421820c5",
              "name": "id",
              "type": "string",
              "value": "={{ $json.id }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "1369d32f-01d4-4167-8eaa-a22e5803d0a5",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        -976
      ],
      "parameters": {
        "width": 448,
        "height": 400,
        "content": "## Workflow Overview\n\nThis workflow listens for new rows in a Google Sheet and creates contact and event registration records in SinergiaCRM.\n\n### Key Steps:\n1. Google Sheets Trigger detects a new row.\n2. Checks if the row should be sent to CRM.\n3. Searches the contact by NIF.\n4. If found, registers the person and creates relationship.\n5. If not found, creates the contact first.\n6. Marks the row as processed.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4cc84d89-c396-4e91-a36c-8b7d474527aa",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -1344
      ],
      "parameters": {
        "width": 416,
        "height": 768,
        "content": "## Google Sheet Setup\n\nMake sure your Google Sheet includes these columns:\n\n- First name\n- Last name\n- NIF\n- Email\n- Relation type\n- Relation date\n- Event ID\n- Registration date\n- To CRM → must be \"Yes\"\n- Processed → should be \"No\" to trigger\n\nOnly rows with:\n- To CRM = Yes\n- Processed = No\nwill be processed.\n\nUpdate the document ID and sheet name in the trigger settings.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "de331bc1-7eca-4c76-a071-e8025a7dff81",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        -1344
      ],
      "parameters": {
        "width": 672,
        "height": 768,
        "content": "## SinergiaCRM Requirements\n\nEnsure you have the following modules available in your SinergiaCRM instance:\n\n- Contacts\n- stic_Contacts_Relationships\n- stic_Registrations\n\nEach node requires authenticated credentials.\nYou'll need to:\n1. Set up OAuth credentials for SinergiaCRM.\n2. Update the user ID (e.g. `\"assigned_user_id\": \"2\"`) if needed.\n\nCustom fields like `stic_identification_number_c` must be informed in your system.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "99bf98a7-ca7b-45ce-a4fb-7dfdf1385d0a",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -1344
      ],
      "parameters": {
        "width": 448,
        "height": 768,
        "content": "## Contact Check Logic\n\nThis IF node decides the path:\n\n- ✅ If contact exists: continue with relationship and registration.\n- ❌ If not: create the contact first, then continue.\n\nMatching is done by NIF ( `stic_identification_number_c`).\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9d101aeb-60a5-4405-a1c1-f979dbe4d8e6",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2080,
        -1344
      ],
      "parameters": {
        "width": 448,
        "height": 768,
        "content": "## Mark Row as Processed\n\nAfter a successful registration, the corresponding row in Google Sheets is updated:\n\n- Processed = \"Sí\"\n\nMatching is done by the NIF field.\nThis prevents duplicate processing of the same entry.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8fd28865-6c05-4637-b289-5dd948664915",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2544,
        -976
      ],
      "parameters": {
        "width": 448,
        "height": 400,
        "content": "## Troubleshooting Tips\n\n- Make sure your spreadsheet column names match exactly.\n- If no contact is created, check NIF formatting.\n- Confirm custom fields exist in your CRM.\n- Check logs for any errors returned by the API.\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "errorWorkflow": "u9Tk2Qoss5uVjdTl",
    "executionOrder": "v1",
    "executionTimeout": 900,
    "saveExecutionProgress": true,
    "timeSavedPerExecution": 5
  },
  "versionId": "6c8968d1-eb9c-4dc5-9591-d8c5784614dc",
  "connections": {
    "523588fd-0d0e-4645-adac-5d58d3ea6a87": {
      "main": [
        [
          {
            "node": "64c626cd-b7d0-4c87-a59f-77e06a8194aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "64c626cd-b7d0-4c87-a59f-77e06a8194aa": {
      "main": [
        [
          {
            "node": "2700a9e3-1fc6-4b38-b6e6-6049e52d85a7",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "92e25a51-e446-4a28-ba0a-fc9687d13c0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1fe200ba-1909-4c3b-925b-5b80340b712b": {
      "main": [
        [
          {
            "node": "af5074a1-11ef-4a81-b167-dbf89dae317f",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "dfac6070-5bf8-4729-b4f8-fb9f419f63da": {
      "main": [
        [
          {
            "node": "92859515-4463-4c38-ba53-d0c4fdf426e8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "92859515-4463-4c38-ba53-d0c4fdf426e8": {
      "main": [
        [
          {
            "node": "523588fd-0d0e-4645-adac-5d58d3ea6a87",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9425f505-8d3e-43f7-bd40-c578a1eb6026": {
      "main": [
        [
          {
            "node": "1fe200ba-1909-4c3b-925b-5b80340b712b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "af5074a1-11ef-4a81-b167-dbf89dae317f": {
      "main": [
        [
          {
            "node": "dfac6070-5bf8-4729-b4f8-fb9f419f63da",
            "type": "main",
            "index": 0
          },
          {
            "node": "92859515-4463-4c38-ba53-d0c4fdf426e8",
            "type": "main",
            "index": 1
          }
        ],
        []
      ]
    },
    "92e25a51-e446-4a28-ba0a-fc9687d13c0c": {
      "main": [
        [
          {
            "node": "005a1758-b6ac-40ef-8951-57fbb715447e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ff4db6a7-3545-4d1f-9c15-96cfd99b2cc0": {
      "main": [
        [
          {
            "node": "e9c8836d-8f17-421c-b28d-e6b5608bb682",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2700a9e3-1fc6-4b38-b6e6-6049e52d85a7": {
      "main": [
        [
          {
            "node": "ff4db6a7-3545-4d1f-9c15-96cfd99b2cc0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f1485c90-4ac8-45ce-b835-35ee6fe91399": {
      "main": [
        [
          {
            "node": "94312c1a-788a-407f-a07d-83a897ab3982",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "005a1758-b6ac-40ef-8951-57fbb715447e": {
      "main": [
        [
          {
            "node": "f1485c90-4ac8-45ce-b835-35ee6fe91399",
            "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 - CRM, IA Multimodal

¿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

Mi flujo de trabajo 9_vieja
Usar MagicHour y Gemini para crear videos de YouTube diariamente desde Google Sheets
If
Set
Code
+
If
Set
Code
31 NodosDivyansh Chauhan
Creación de contenido
Creación automatizada de clientes y estimaciones en QuickBooks
Automatizar la creación de clientes y estimaciones en QuickBooks desde Google Sheets
If
Set
Quickbooks
+
If
Set
Quickbooks
16 NodosIntuz
CRM
CRM de GSheets
De prospecto a cliente automatizado usando flujos de Google Sheets, notificaciones por correo y seguimiento de tiempo
If
Set
Code
+
If
Set
Code
24 NodosZiad Adel
CRM
Entrega automática de plantillas a clientes tras el pago de Stripe
Sistema automatizado de entrega de plantillas utilizando Stripe, GPT-4o y Gmail
If
Code
Gmail
+
If
Code
Gmail
44 NodosRahul Joshi
CRM
Registrador de pedidos automatizado con actualizaciones de estado en tiempo real
Registrar pedidos de comercio electrónico en Google Sheets, con paginación mensual y seguimiento de estado
If
Set
Webhook
+
If
Set
Webhook
16 NodosRuthwik Masina
CRM
Creación y carga de videos impulsada por IA para Instagram, TikTok y YouTube
Creación y subida de videos impulsada por IA desde Google Drive a Instagram, TikTok y YouTube
If
Set
Code
+
If
Set
Code
53 NodosDevCode Journey
Creación de contenido
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos20
Categoría2
Tipos de nodos7
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Javier Quilez Cabello

Javier Quilez Cabello

@javierquilez

As a specialist in automation for non-profits, I’m dedicated to driving efficiency through open source solutions that empower NGOs. Leveraging tools like Mautic, RocketChat, Cal.com, KoBoToolbox, Nextcloud, Taiga, WordPress, WooCommerce, and Baserow, I integrate these platforms with the third-sector CRM, SinergiaCRM. Passionate about #tech4good, I develop workflows that enhance collaboration and amplify social impact. My mission is to harness automation for meaningful change. #n8n4good

Enlaces externos
Ver en n8n.io →

Compartir este flujo de trabajo

Categorías

IA Multimodal
1540
Inteligencia Artificial
1108
Creación de contenido
695
Resumen de IA
516
Marketing
419
Chatbot de IA
251
Ingeniería
241
Investigación de mercado
203
Varios
193
Otros
176
Ventas
162
Operaciones de TI
156
Extracción de documentos
147
RAG de IA
146
Bloques de construcción
144
Redes sociales
137
Generación de leads
125
Productividad personal
117
DevOps
111
Recursos Humanos
101
Soporte
97
Nutrición de leads
87
CRM
82
Finanzas
81
Producto
77
Chatbot de soporte
76
Diseño
70
Gestión de tickets
67
Operaciones de seguridad
57
Procesamiento de facturas
53
Comercio de criptomonedas
49
Gestión de archivos
39
Gestión de proyectos
35
Wiki interno
32

Categorías: 34