Hi, I’m working on a listing directory whereby potential guests can send hosts a request to book using a form component.
I have a dedicated sheet containing all listing data including the email for the host and have set it up to work so that the submissions successfully arrive in a separate designated sheet called ‘Booking Requests’.
However, the problem I’m trying to find a solution for is how to send the submission to the host?
I can’t work out how to automatically capture the host’s email into the Booking Request sheet.
I realise Glide doesn’t enable us to bring our own SMTP (we usually use Postmark), so the plan is to hook up Zapier to trigger whenever a submission is added to the Sheet and construct and send an email to the host.
I just can’t work out how to capture the email from a different sheet relating to the booking request.
Has anyone tried something similar?