When submitting form, Submitter is not Sender. How to make submitter equal to sender?

Question

I am a bit lost here.

My script intends to send an Email and create calender entries when submitting a form. This works perfectly fine. However, the Email is always sent from my account. But eventually, I want different users in my company to use this script and each submitter needs to be the according sender of the email sent out. Otherwise I will always receive all replies, this won't be fun!!

I am sure this works somehow, but how?

Any ideas or recommendations?

Thanks

Answer 1

This is normal behavior : when a script sends an email it is sent by the author of the script (in this case : you). That's mainly to respect privacy rules since users filling a form are not asked to grant access to their email , neither to authorize for sending emails in their name.

There are 2 possible solutions :

1. Use the optional replyTo parameter in the MailApp line (you will always be the sender but when people reply using the 'reply' button the mail will be sent to that address instead of yours.(I assumed you know the submitter's email adress either by asking him in the form or retrieving it automatically if you work in the context of a domain account)
2. build your form using UiApp or HTMLService as a standalone webapp that will be executed as "the user executing the app" and ask each user for explicit authorization to send email using their account". But that will be a bit more complex to setup compared with normal Google Forms Service.

Knowing that it's up to you to choose the better approach.