What is your goal?
I want to look up email addresses from Google Sheets for each meeting participant (extracted from a Claude AI JSON response), collect all matched emails using an Array Aggregator, and send a single group email via Gmail.
The part I’m most confused about is that the Iterator runs 3 times and outputs 3 bundles, but the next module (Google Sheets Search Rows) only runs 1 operation instead of 3. I don’t understand why it’s not processing all 3 bundles.
Also, I’m not sure if the function I put in the Gmail ‘To’ field is correct.
The flow I’m trying to build:
Iterator (loops through participants array) → Google Sheets Search Rows (finds email by name) → Array Aggregator (collects all emails) → Gmail (sends one email to all)
What is the problem & what have you tried?
The Iterator outputs 3 bundles correctly:
- Bundle 1: “participant 1”
- Bundle 2: “participant 2”
- Bundle 3: “participant 3”
However, Google Sheets Search Rows only runs 1 operation (not 3), and only returns a result for Bundle 1. Bundles 2 and 3 are never processed.
I have confirmed:
- Iterator is directly connected to Google Sheets (no module in between)
- The filter is set to: Column B / Text operators: Contains / {{28.Value}}
- The Google Sheets names exactly match the Iterator values (e.g. “participant1”)
- The scenario structure is: Router → Iterator → Google Sheets → Array Aggregator → Gmail
I’ve tried:
- Reconnecting the Iterator → Google Sheets connection
- Changing the filter value
- Checking if there’s an extra Router between Iterator and Google Sheets
Error messages or input/output bundles
Google Sheets INPUT (only processes Bundle 1):
{
“Filter”: [{“a”: “B”, “b”: “VALUE”, “o”: “text:contain”}]
}
Google Sheets OUTPUT:
{
“이름 (B)”: “participant1”,
“이메일 (D)”: “abc@gmail.com”,
“Total number of bundles”: 1
}
Array Aggregator OUTPUT:
{
“Array”: [{“이메일 (D)”: “abc@gmail.com”}]
}
Gmail error:
BundleValidationError: Missing value of required parameter ‘to’
Screenshots (scenario flow, module settings, errors)
