If you have activated another script/add-on that is triggered upon form submission, you might want this script to finish its work before beginning the mail merge.
Some general use cases
For example, you can use this delay mail merge option to:
- Wait until a particular calculation is made in one column based on the data entered by the user + some other variables.
- Wait until a file is created so it can be attached to the email.
How to activate this delay option?
In the configuration panel for notification rules, you can see a checkbox 'Wait until a specific column is filled before sending the email'. Check this box, select the appropriate column to control and save.
When the mail merge begins, if the value is missing in the column that you have selected, it will wait for 60 seconds to let another process to complete its task, and then start the merge.
If for some reason the other process can't finish during those 60 seconds, an error will be displayed, but no mail will be sent. Next time someone submit a form, it will try again on all rows tagged with an error.
Comments
7 comments
I was able to get it to send emails to the person I want them to go to, but I still get a "Failed to send email: no recipient - error code:157" error every time, which means on next form submission it sends the notification email again.
Help?
This function is great by the way, but would love to see it use this method to "filter" if a message needs to be sent or not, rather than just waiting for another script to run.
I have a form submission that may or may not have a certain field filled in depending on the submission. If it is I'd like to send the email, if not, then it doesn't need to be sent. The "wait until" works in this situation, but takes about 2-3 minutes to move on from a blank field, and can get a bit "stuck" every now and again.
As the forms can be filled out at any time, this can cause a few issues with times of email delivery
i don't have this option in my menu....
i don't have this option in my menu....
i added the notification correctly without ticking the second option but it not working instantly to send the thank you mail to the mail submitted in the form . Start merging is working but automatically its not working . Its take time to send automatically a mail more than a day. why it occurs?
Hi gokul raj,
I can see you are having difficulty using the delay function.
Please use the following contact form link with exact details of your issue and our Support Team will look to help you at the soonest opportunity.
https://yamm.zendesk.com/agent/tickets/7438
Regards,
YAMM Suppport
Hello!
I want to send an email notification depending on a specific question's response on Google Forms.
We are a school in Mexico City and we want to notify the sales team about the new prospects for them to make contact as the form is filled. The notification has to be sent to the sales person in charge of the selected educational program in the form.
Can I use the DELAY MAIL MERGE functionality if I set a formula with this tool: https://cloudlab.newvisions.org/copy-down ???
The formula would be a conditional (=IF) to display the email of the sales person in charge of the selected program in the Google Form.
I hope I was clear.
Thank you in advance and regards from Mexico City.
Please sign in to leave a comment.