Hi everyone!
I'm working on an app similar to a booking platform, and we have the following use case: Hosts need the ability to send SMS or emails to every guest currently on-site, triggered on demand (e.g., for a weather warning). Each host has a Zapier account, and we provide the integration with our booking system.
We tried using a polling trigger to fetch the "guests on site" list. The idea was that the host could leave the Zap off and activate it whenever they needed to send the message. However, this solution isn't ideal. The concept of "guests on site" doesn’t work as a reliable trigger, and we also encountered deduplication issue (when the host creates the Zap, the test trigger alters the "new record" logic, which prevents emails/SMS from being sent to all records).
Ideally, the host could set up a trigger similar to a Zapier schedule or form submission. This would be followed by an action that retrieves all current guests on-site (currently not possible, as actions don't support returning a list of values). Finally, another action would use that data to send a bulk SMS or email.
Does anyone have any suggestions or workarounds for this type of scenario?
Thanks in advance!