Automatically send email from Google Sheet

[Web Orders]

I have a Google Form. It fills in a spreadsheet. I need a script that looks at the response when submitted and, depending upon the answer in one of the columns, sends different emails to the respondent (right now I only have two different emails I need sending). I found a script at https://developers.google.com/workspace/solutions/content-signup that nearly does exactly what I want but I am not knowledgeable enough to modify it to get it to fill my needs. Any help would be greatly appreciated.

[Alan Wells]

Would you be interested in using an addon instead?

[cbmserv...@gmail.com]

It would be a simple change to do that. I can help you with that if you want.

 

Send me a private email to get started. cbmserv...@gmail.com

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5b51e424-b7b6-40cf-8ab1-96e32edfb344n%40googlegroups.com.

[Patson Musumali]

Please share that string with me too! 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/003a01d758a4%2458c86d50%240a5947f0%24%40gmail.com.

[cbmserv...@gmail.com]

Would be happy to share back the final result. But anything done would be just a customization of the template for his needs.

 

So depending on your needs, changes may be different. You are best to start with the template and go from there if you have some programming skills. If not, let me know and perhaps I can make the tweak for you as well.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAEpx38CXnrB3YBaKXVXcuyadbsm0MUnFZB3X0yju%2B8OgvTH4sQ%40mail.gmail.com.

[Patson Musumali]

I am trying to do exactly what he needs but I have very basic programming skills that’s why I joined. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/004101d758a5%24408cdae0%24c1a690a0%24%40gmail.com.

[cbmserv...@gmail.com]

Can you share what spreadsheet you have already and what changes you want to see done?

 

If you don’t want to share publicly on this forum, you can just send me an email privately and we can continue that way.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAEpx38C3_reiV%3DfvbZoVOoLdyeB2vwyqbC9jocnS0_bwsk%2BTFQ%40mail.gmail.com.

[Patson Musumali]

Yes please thanks. 

[Patson Musumali]

Hi,

This is the spreadsheet 

https://docs.google.com/spreadsheets/d/11tHPWrUMR8v6p0XDinEGweR-aKh2Gd-TI4SOaSslgcw/edit?usp=sharing

Thanks for accepting to help. Once one is done I will be able to do the others.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/005201d758a5%24f903e870%24eb0bb950%24%40gmail.com.

[CBMServices Web]

Will need details as to what sheets, what fields you want to look at and what actions you want done.

Do you have an email template(s) that you want to use for sending?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAEpx38ANUPmJfVctM47RRE%3DQdC9u87y%2B7ZiCaSYDRr%2BpYyn1Eg%40mail.gmail.com.

[Patson Musumali]

If not just advise and give guidance on how to link all these automated with possible responses. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFX%2Bz3VT%3Dum3_5qy%3Dc9VofNbGu4vmejvLRP8QLFkzz5f4ftdZg%40mail.gmail.com.

[Fer Tovar]

I use a script in the spreadsheet that can be configured every minute to find if there is a new record to send an email

[Web Orders]

Why would that be better?

[Alan Wells]

It might take less time to configure the add-on settings, than to write the code.

It depends on how much time/effort/money it takes you to get the code you need.

On the other side, if it's your own code then you have full control over it.

[Fernando Falcao]

Form Mule addon is great for that. It works very well with several different templates to be sent to your audience.

I use Form Mule for more the 2 years and it delivers to me this service of sending e-mails based on conditions you write in the template.

I suggest to give a try: https://workspace.google.com/marketplace/app/form_mule_email_merge_utility/968670674230

Cheers,

Fernando

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/cee26d52-c075-41e1-9c87-bdd7362bf97an%40googlegroups.com.