I’m trying to get the Google Search Rows Module to send an email using the Brevo Send an Email Module, for every lead that is older than 24 hours, and if the field Follow-up is equal to No, and Email exists (Or is not equal to blank)
What is the problem & what have you tried?
What is the problem:
I’m currently struggling with a BundleValidationError when trying to map Google Sheet’s Search a Row module’s fields into Brevo to send a Brevo Email after a 24-hour time period, despite tagging the fields properly.
What I’ve tried:
Remapping the tags in the appropriate fields - Brevo module still returns the BundleValidationError
Confirmed that the email field/header in the Google Sheets has no issue - It works with the Brevo Module in another Scenario.
Tested hardcoding an email into the Brevo Email module’s email field - Got sent successfully
Error messages or input/output bundles
A required field is empty or in the wrong format
Validation failed for 1 parameter(s).
The “BundleValidationError” isn’t actually a Brevo mapping issue because your Google Sheets module is returning 0 bundles. This means no data ever reaches Brevo and the email field arrives empty by default.
The culprit is your third filter condition: “Email (C) not equal to (blank).” You would expect Make to interpret the blank field as an empty value, but in reality it usually matches nothing and drops all rows. You should try replacing that condition with a formula-based filter instead. Use “Text operators”: “Match pattern” and use basic regex like `.+@.+` which will only pass rows that actually contain an email address.
Once your Google Sheets module returns bundles again, the Brevo error should resolve itself since your field mapping looks correct from what I can tell.
I’m certain that the lead in the Google Sheets has an email in the field and is formatted correctly, and the email is valid. I don’t think it’s the 24-hour formatting, however, since Module 1’s Search Rows is picking up data. I may be wrong, though.
I tested changing the date in the Timestamp to 24 hours prior, and the Brevo Module happened to fire successfully. The problem was the fact that 24 hours hadn’t passed yet, and I wasn’t testing it under conditions where it should have actually fired . I believe it’s solved for now. I appreciate your input and will be incorporating the regex edit you suggested into my scenario. Thanks!
What is your goal?
What is the problem & what have you tried?
Error messages or input/output bundles
Screenshots (scenario flow, module settings, errors)
. I believe it’s solved for now. I appreciate your input and will be incorporating the regex edit you suggested into my scenario. Thanks!