Help Needed: Retell AI + Make.com + Airtable Integration - Array Aggregator Issues

I'm building a voice AI real estate agent using Retell AI that searches properties via Make.com and Airtable. The flow works partially, but I'm getting empty results despite having matching data.

The Flow

Retell AI voice agent calls find_properties function

Make.com webhook receives the parameters

Airtable searches properties with dynamic formula

Array aggregator collects the results

Webhook response sends data back to Retell AI

My Retell AI Prompt

The agent "Lena" asks users about:

(Translated from German)

Location (city)

District (optional)

Property type (apartment, house, etc.)

Number of rooms

Budget

If users say "doesn't matter", the agent suggests defaults like:

"I'll search for apartments in the city center with at least 2 rooms up to €500,000. Is that okay?"

Then calls find_properties with concrete values.

Function Parameters

json{

"ort": "Straubing", // City

"stadtteil": "Zentrum", // District

"immobilientyp": "Wohnung", // Property type

"min_zimmer": 2, // Min rooms

"max_preis_eur": 500000 // Max price

}

Make.com Setup

Module 1: Webhooks (Custom webhook)

Module 2: Airtable (Search Records)

Module 6: Array aggregator

Module 9: Webhooks (Webhook response)

Airtable Database

I have 15 properties with fields:

Ort (Straubing, Regensburg)

Stadtteil (Zentrum, Ittling, Nord, etc.)

Art der Behausung (Wohnung, Einfamilienhaus, etc.)

Zimmer (1-5)

Preis (€) (167,310 - 1,152,300)

My Airtable Formula

AND(

{Ort} = "{{1.args.ort}}",

{Stadtteil} = "{{1.args.stadtteil}}",

{Art der Behausung} = "{{1.args.immobilientyp}}",

{Zimmer} >= {{1.args.min_zimmer}},

{Preis (€)} <= {{1.args.max_preis_eur}}

)

The Problem

Expected: Should find 4 matching properties for "Straubing + Zentrum + Wohnung + ≥2 rooms + ≤€500,000"

Actual Results:

Airtable Output: Total number of bundles: 0

Array Aggregator Input: All fields show *empty*

Final Response: Returns null values to Retell AI

What I've Tested

✅ Simple formula works: {Ort} = "Straubing" returns 10 bundles

✅ Parameters arrive correctly: Webhook shows proper values

✅ Data exists: Manual verification shows 4 matching records

❌ Complex AND formula: Always returns 0 bundles

Array Aggregator Config

Source Module: Airtable - Search Records

Target structure type: Array

Mappings:

Ort → 2.Ort

Zimmer → 2.Zimmer

Adresse → 2.Adresse

etc.

Questions

Why does my Airtable formula return 0 bundles when the data clearly exists?

Could the issue be with field names or data types in Airtable?

Is my Array Aggregator configuration correct for this use case?

Any suggestions for debugging this step by step?

Any help would be greatly appreciated! This is driving me crazy. 🤯

0 comments

Brendan's AI Community

skool.com/brendan

Learn To Make Money With AI!

- 50+ Free AI Agent Templates

- 60+ Free AI Course Videos

(n8n, Make, Vapi, Voiceflow)

- AI Software Discounts 💰

Leaderboard (30-day)

+77

+69

+60

+58

+57