How to conditionally append records to Airtable based on existing eventURL

Help me Build my Workflow
1

Hello! I’m building an automation and I’m stuck on implementing conditional logic after a particular node (groupName loop).

Current Setup:

The output of my node is a JSON array containing multiple objects. Here’s an example of what each object contains:

json

{
  "eventName": "Some event name",
  "eventDescription": "Some event description",
  "eventDate": "2025-11-20T17:30:00-05:00",
  "eventEndTime": "2025-11-20T20:00:00-05:00",
  "eventLocation": "Event address here",
  "eventUrl": "https://eventurl",
  "isOnline": false,
  "groupName": "Some group name"
}

What I’m Trying to Achieve:

I need to check each event against an Airtable table and only add new records:

  • If the eventUrl already exists in my Airtable table → Skip (do NOT append)

  • If the eventUrl does NOT exist in the Airtable table → Append the full record

My Airtable Setup:

My Airtable table already contains columns for: eventName, eventDescription, eventDate, eventLocation, eventURL (note the capitalization), and groupName.

My Question:

What’s the best approach for this conditional logic in n8n? Should I:

  1. Use an IF node to check for existence?

  2. Use filtering logic within the Airtable node itself?

  3. Use a Loop Over Items node to process each event individually?

I’m particularly confused about:

  • How to properly search Airtable for matching eventURL values

  • How to pass the full event data through the conditional check

  • Whether I need to use the Split Out node or if there’s a better way

Any guidance on the node structure and configuration would be greatly appreciated!

image
image1101×450 35.3 KB

1 Like
2

{

“eventName”: “Some event name”,

“eventDescription”: “Some event description”,

“eventDate”: “2025-11-20T17:30:00-05:00”,

“eventEndTime”: “2025-11-20T20:00:00-05:00”,

“eventLocation”: “Event address here”,

“eventUrl”: “https://eventurl”,

“isOnline”: false,

“groupName”: “Some group name”

}