8
n8n Deutschamn8n.com

Täglicher Import neuer Kontakte von NocoDB nach Brevo

Experte

Dies ist ein Social Media, Multimodal AI-Bereich Automatisierungsworkflow mit 16 Nodes. Hauptsächlich werden If, NocoDb, SendInBlue, SplitInBatches, ScheduleTrigger und andere Nodes verwendet. Täglicher Import überprüfter Kontakte von NocoDB nach Brevo

Voraussetzungen
  • •Keine besonderen Voraussetzungen, sofort nach Import nutzbar

Verwendete Nodes (16)

If
NocoDb
SendInBlue
StickyNote
SplitInBatches
ScheduleTrigger

Kategorie

Soziale Medien
Multimodales KI
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "MIAB9TEo4WAoEXhr",
  "meta": {
    "instanceId": "c24388df44432e8ff2c4acecd7ab0dd2faec628bd83c70beb384cea105f7a50a",
    "templateCredsSetupCompleted": true
  },
  "name": "Daily Import New Contacts from NocoDB to Brevo",
  "tags": [],
  "nodes": [
    {
      "id": "b5f8e6d7-960f-45d6-a15d-9161200b3993",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -280,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "f4f5e8bd-0e28-41c2-b0dd-342f68e4a74c",
      "name": "Check if parameters are not empty",
      "type": "n8n-nodes-base.if",
      "position": [
        340,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "edcfbe98-bc44-4400-9610-273b4b4ef999",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.first_name }}",
              "rightValue": ""
            },
            {
              "id": "1b5b2a35-277c-4970-ab32-a2b89185b2dc",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.last_name }}",
              "rightValue": ""
            },
            {
              "id": "58ac466e-4447-4a4b-8564-8ef14e388415",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "2a684591-5c13-42c2-a826-12c0305d3525",
      "name": "Check if email is Disposal",
      "type": "n8n-nodes-base.if",
      "position": [
        700,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "4d399880-7a22-4ecd-91f6-2e395de7e375",
              "operator": {
                "type": "string",
                "operation": "notRegex"
              },
              "leftValue": "={{ $json.email }}",
              "rightValue": ".*(temp|abc|1234|yopmail|protonmail|mailinator|\\.cc|bigbester|fake|spam|gdf|sdf|mr123|passinbox|landininbox|@inbox|random|anony|mymail|mail\\.ru|\\.buzz|asdasd|asf|simplelogin|simplelogin\\.com|silomails\\.com|slmails\\.com|simplelogin\\.fr|aleeas\\.com|slmail\\.me|8shield\\.net|dralias\\.com|passinbox\\.com|passfwd\\.com|passmail\\.com|passmail\\.net|simplelogin\\.co|simplelogin\\.io|duck\\.com|mozmail\\.com|anonaddy\\.com|anonaddy\\.me|trash|guerrilla|getnada|owly|mvrht|sharklasers|anonbox).*"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "dba5e2e9-17d3-4a3f-b0c2-fc23b68b0fa5",
      "name": "Über Elemente schleifen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1020,
        -200
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "0f6142d4-8aa1-4e2e-82a5-7adb0a89ba72",
      "name": "Brevo: Create Contact",
      "type": "n8n-nodes-base.sendInBlue",
      "position": [
        1320,
        -200
      ],
      "parameters": {
        "email": "={{ $json.email }}",
        "resource": "contact",
        "requestOptions": {},
        "createContactAttributes": {
          "attributesValues": [
            {
              "fieldName": "FIRSTNAME",
              "fieldValue": "={{ $json.first_name }}"
            },
            {
              "fieldName": "LASTNAME",
              "fieldValue": "={{ $json.last_name }}"
            }
          ]
        }
      },
      "credentials": {
        "sendInBlueApi": {
          "id": "YQK9pEnWrCzPOkw8",
          "name": "Brevo account - U-test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0e6921d1-3131-4ae9-ac50-783c57e61582",
      "name": "NocoDB: Get new users list",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        40,
        0
      ],
      "parameters": {
        "table": "m5mxqjs3ae68oyc",
        "options": {
          "where": "(status,eq,0-not-imported)"
        },
        "operation": "getAll",
        "projectId": "p4lnw5vwzf2yy3i",
        "authentication": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "OmiCzu1TOrJhZRIa",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "ec5753b4-d6fb-4444-b53d-1e6506c875bd",
      "name": "NocoDB: change status to 1-empty-fields",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        340,
        260
      ],
      "parameters": {
        "table": "m5mxqjs3ae68oyc",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldName": "id",
              "fieldValue": "={{ $json.Id }}"
            },
            {
              "fieldName": "status",
              "fieldValue": "1-empty-fields"
            }
          ]
        },
        "operation": "update",
        "projectId": "p4lnw5vwzf2yy3i",
        "authentication": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "OmiCzu1TOrJhZRIa",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "90227f77-8840-41ae-aaa9-fac355463c1f",
      "name": "NocoDB: change status to 2-disposal-email",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        700,
        260
      ],
      "parameters": {
        "table": "m5mxqjs3ae68oyc",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldName": "id",
              "fieldValue": "={{ $json.Id }}"
            },
            {
              "fieldName": "status",
              "fieldValue": "2-disposal-email"
            }
          ]
        },
        "operation": "update",
        "projectId": "p4lnw5vwzf2yy3i",
        "authentication": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "OmiCzu1TOrJhZRIa",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "3a539eb1-732a-4133-ac57-2760da656b5e",
      "name": "NocoDB: change status to 3-contact-created",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        1620,
        -200
      ],
      "parameters": {
        "table": "m5mxqjs3ae68oyc",
        "fieldsUi": {
          "fieldValues": [
            {
              "fieldName": "id",
              "fieldValue": "={{ $('Loop Over Items').item.json.Id }}"
            },
            {
              "fieldName": "status",
              "fieldValue": "3-contact-created"
            }
          ]
        },
        "operation": "update",
        "projectId": "p4lnw5vwzf2yy3i",
        "authentication": "nocoDbApiToken"
      },
      "credentials": {
        "nocoDbApiToken": {
          "id": "OmiCzu1TOrJhZRIa",
          "name": "NocoDB Token account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "de4b9326-03cc-4f33-b244-63de98fbbabc",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        -160
      ],
      "parameters": {
        "color": 7,
        "height": 340,
        "content": "Runs the workflow automatically once a day at the scheduled time."
      },
      "typeVersion": 1
    },
    {
      "id": "a56f0f46-8c7a-4895-b42f-175636ed7853",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -160
      ],
      "parameters": {
        "color": 7,
        "height": 340,
        "content": "Fetches all new user records from the NocoDB table where the status is 0-not-imported.\n\nThis status marks records that have not yet been processed by the flow (new users)."
      },
      "typeVersion": 1
    },
    {
      "id": "11d68333-74ff-4b32-8a1d-ffa918743a4d",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        260,
        -160
      ],
      "parameters": {
        "color": 7,
        "width": 280,
        "height": 740,
        "content": "Verifies that the required fields: first_name, last_name & email are all filled in before continuing.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nUpdates the record’s status to 1-empty-fields in NocoDB for entries missing any required information."
      },
      "typeVersion": 1
    },
    {
      "id": "2e1d7c71-d8ef-43e0-b601-ce5a5f8d3d60",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        -160
      ],
      "parameters": {
        "color": 7,
        "width": 280,
        "height": 740,
        "content": "Verifies that the email address is not from a known disposable or temporary email provider before continuing.\nWe don't want to send email to disposal email addresses.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nUpdates the record’s status to 2-disposal-email in NocoDB for entries identified as using disposable or temporary email addresses."
      },
      "typeVersion": 1
    },
    {
      "id": "f818f406-b2c8-487e-8bb2-bf02b57d3c3b",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        940,
        -340
      ],
      "parameters": {
        "color": 7,
        "height": 360,
        "content": "Runs one record at a time to avoid heavy load from creating contacts in bulk."
      },
      "typeVersion": 1
    },
    {
      "id": "ac098881-8bb3-4214-8502-bba7f92c3bed",
      "name": "Haftnotiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1240,
        -340
      ],
      "parameters": {
        "color": 7,
        "height": 360,
        "content": "Creates a new contact in Brevo using the provided first_name, last_name, and email."
      },
      "typeVersion": 1
    },
    {
      "id": "ac752d01-6d5c-44e0-abe0-b065a1d4bd40",
      "name": "Haftnotiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1540,
        -340
      ],
      "parameters": {
        "color": 7,
        "height": 360,
        "content": "Updates the record’s status to 3-contact-created in NocoDB after the contact is successfully added to Brevo."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "74b9415d-63fe-4bb2-b782-beeb6faf0dae",
  "connections": {
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "0f6142d4-8aa1-4e2e-82a5-7adb0a89ba72",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "0e6921d1-3131-4ae9-ac50-783c57e61582",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0f6142d4-8aa1-4e2e-82a5-7adb0a89ba72": {
      "main": [
        [
          {
            "node": "3a539eb1-732a-4133-ac57-2760da656b5e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2a684591-5c13-42c2-a826-12c0305d3525": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "90227f77-8840-41ae-aaa9-fac355463c1f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0e6921d1-3131-4ae9-ac50-783c57e61582": {
      "main": [
        [
          {
            "node": "f4f5e8bd-0e28-41c2-b0dd-342f68e4a74c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f4f5e8bd-0e28-41c2-b0dd-342f68e4a74c": {
      "main": [
        [
          {
            "node": "2a684591-5c13-42c2-a826-12c0305d3525",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ec5753b4-d6fb-4444-b53d-1e6506c875bd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3a539eb1-732a-4133-ac57-2760da656b5e": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte - Soziale Medien, Multimodales KI

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

Marketingautomatisierungssystem (eCRM) - NocoDB mit Brevo
Automatisierung von E-Mail-Marketingkampagnen mit NocoDB und Brevo
If
Set
Wait
+
If
Set
Wait
30 NodesNima Salimi
Soziale Medien
Brevo-Kontaktberichte in NocoDB einfügen
Brevo-Kontaktbericht in NocoDB einfügen
If
Set
Code
+
If
Set
Code
26 NodesNima Salimi
Content-Erstellung
Mehrere-Agenten-Intelligente Reddit-Automation von Arunava
Verwendung von AI-Mentions und Baserow zur automatischen Kommentierung von Reddit-Posts
If
Set
Code
+
If
Set
Code
35 NodesArunava
Soziale Medien
Automatisierte Reddit-Markenüberwachung und -antwort mit GPT-4o-mini, Tabellen und Slack
Automatisierung der Reddit-Markenüberwachung und -Antworten mit GPT-4o-mini, Tabellen und Slack
If
Code
Slack
+
If
Code
Slack
20 NodesDaniel Shashko
Soziale Medien
Massen-E-Mail-Versand mit Nachverfolgung und Antwortverfolgung
Automatisierte E-Mail-Massenkampagne mit Nachverfolgung von Follow-ups und Antworten
If
Gmail
Switch
+
If
Gmail
Switch
11 NodesOneclick AI Squad
Soziale Medien
Mein Workflow 79
Ein umfassendes E-Mail-CRM-System mit Google Sheets und MailerSend erstellen
If
Set
Wait
+
If
Set
Wait
34 NodesNima Salimi
Soziale Medien
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes16
Kategorie2
Node-Typen6
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Nima Salimi

Nima Salimi

@salimi

With a deep understanding of marketing processes and data flows, I create solutions that streamline user engagement, campaign management, and data synchronization across multiple platforms. My goal is to help businesses reduce manual effort, improve accuracy, and accelerate their marketing initiatives through smart automation.

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34