How to get email to send on date/time inputted in google form (Mailersend)

I am selling digital gift vouchers which are delivered with mailersend.

I have made a google form where I can manually input the recipients email address, variables and order details to customise the email. I can’t automate this due to how I take the order.

My current scenario looks like this

My google form has a separate date and a time entry that looks like this
Make image 2

I want the email to send on this time/date (or 15 mins after given the scenario schedule) but I have no idea how to do this.
I also don’t know what format the date/time is in from google forms. I do know that they are two separate variables.

There is a box in the Mailersend config. which looks like this
Make image 3
but I don’t know if this is what I need.

Any tips would be greatly appreciated.

Welcome to the Make community!

If you have a paid make subscription, you can simply use three sleep modules to wait for 5 mins each.

If you want to add minutes to a date, you can also use the built-in function addMinutes.

For more information, see the function documentation in the help center.

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

1 Like

Thank you so much for the reply.
I actually want to make the email send on a specific time and date collected in the google form.
Sorry if I wasn’t clear. :slight_smile:

Hey @Z-Create

This kind of automation needs to use list modules and then filter matching with the date for {{now}}. However, in your case, that won’t be effective as the time can be any and the automation will skip the entries that won’t match.

That will work only if you want to send by the date mentioned in the form at anytime.

Regards,
Msquare Automation - Gold Partner of Make

2 Likes

Thanks for the answer :slight_smile:
I ended up deciding not to use make for this particular automation but your solution will help for my other emails so thank you!

1 Like

Hey @Z-Create

Thanks for the acknowledgement. :dizzy:

Regards,
Msquare Automation - Gold Partner of Make