Split Out Handling

Help me Build my Workflow
1

Hi,

What I want is to check if the company already exists in Airtable, if yes then add contacts.

Otherwise create company and then add contacts.

The only thing is when I run the Airtable node only the matching item remains. For which I only need to add contacts.

This way I can not do an action for the remaining items, the action will ben add company and add contacts.

What Can I do to solve this?

Thanks in advance.

Greetings,
Robin

OUTPUT Split:

[
  {
    "message.content.companies": "Uit Holland"
  },
  {
    "message.content.companies": "Nedmarine"
  },
  {
    "message.content.companies": "Jellice"
  }
]

OUTPUT Airtable:

[
  {
    "id": "recsjF4TVuLTyWWvA",
    "createdTime": "2025-02-24T18:20:30.000Z",
    "Name": "Uit Holland",
    "Country": [
      "rec0zBbuBb7yjqMtf"
    ],
    "Date added": "2025-02-24",
    "Contacts": [
      "recLQrLH7rj1lSopd"
    ],
    "Events": [
      "recStpUTPeQng0ssZ"
    ],
    "Domain": "uitholland.eu"
  },
  {
    "id": "recqIhsbZBuH7TTla",
    "createdTime": "2025-02-25T08:37:34.000Z",
    "Name": "Nedmarine",
    "Country": [
      "rec0zBbuBb7yjqMtf"
    ],
    "Date added": "2025-02-25"
  }
]
2

Hey Robin, I actually have a very similar problem and am also not too sure about how to solve this.

One option that came to my mind iterating over each company and processing them one by one, if nothing is found it should result in an error, simply tick the option in the Airtable module to continue the workflow in case of an error and then add a if node to check wether you need to create the company or not.

3

Iterate by using the loop node if I am not mistaken

4

@zynera Thanks! I will try the loop node.

5

Looping works…

6

Great, please mark my comment as the solution so that users can make use of this in the future!