Google Apps Script Examples - Create a Mail Merge for Gmail & Google Sheets

[@brandonkim4044]

thank you for Insightful video! I see this code send email individually even if there are several email addresses in google sheet. how can I send all together in one email? How to include A,B,C,D in one email like below? e.g. Sender : Tom Recipient : A,B,C,D ------------------------------ Subject: ddddddd ------------------------------

[@BlkDoc-cz7ni]

Thanks for this, super helpful. How can I add 2 or more recipients to each row? I tried editing line 28 with the additional recipient column and I tried duplicating row 28 to add a new row 29 with the other column header with the email I want to send. No luck.

[@saperis]

This will need a bit more editing as this script only is expecting one column with email addresses. I don't have a video showing what you are trying to achieve.

[@user-dz3jx3nr9g]

Thankyou for the explanation! by the way, how can i add different CC & attachment for every person? that will really help if i can do that. Thankyou!

[@saperis]

The sample code you can copy directly from the Apps Script documentation (the one used in this video) gives you the option of uncommenting the BCC and so on fields. So it's all already in the script.

[@user-dz3jx3nr9g]

Yes! but it can only put name of the email? what if i want to make it different for each recepient, example/ recepient A, CC to B and then recepient C, CC to H, recepient E, CC to Z. I tried to use row [CC] but it failed to work@@saperis

[@shineraj]

Wonderful video, just an ask, how can i add an image from a spreadsheet along with the email

[@saperis]

Well, we are using HTML here. So I'm not quite sure what the best way for this would be.

[@dshoangviet]

How to create spreadsheet with 7 rows like you create?

[@saperis]

Adapt the script to do so. Use the knowledge I've shared in this video and build upon that. Check the Apps Script documentation to find out more: developers.google.com/apps-script/reference/spreadsheet

[@marygloupadillo4675]

The numerical value does not show in my email. So does the time of the email sent....

[@saperis]

Interesting. Any guesses why? Check your code again. Did you make sure to use back ticks? Are any brackets missing?

[@lovekumar-uo2yx]

Hi, I want to run it for a particular row at one time not for whole range. Can you tell me which line to change in the code?

[@saperis]

A row is also just a range. A range of only one row instead of multiple rows. See the official documentation to find out how to get a specific range: developers.google.com/apps-script/reference/spreadsheet/sheet#getrangerow,-column

[@lovekumar-uo2yx]

@@saperis I know this part, but I can't seem to find the relevant line in the code where I'll have to replace the range. Can you help me with that

[@saperis]

@@lovekumar-uo2yx Line number 59: instead of getDataRange() you will have to use getRange().

[@sooryakriz2396]

Thanks :)

[@saperis]

Welcome! 😀

[@mrmychannel1]

Thank you for sharing. Do you know of a code variation that allows emails to be sent to contacts by picking up and flooding files contained in folders in google drive? Each folder is created for each individual contact and on each send cycle the attachments in the folders are updated manually. Kind regards

[@saperis]

No, haven't seen a project like that yet. You would have to write it from scratch.

[@mrmychannel1]

🔝♥Thanks for your feedback. Your video lessons allowed me to start writing a few lines and I was only able to create a script that sends a series of emails by retrieving the addresses from a Google Shet and attaching the .PDF attachments to each email that I insert in a google drive folder. However, I can't with the .zip files if I load them into the folder but this problem may not be solvable. In any case, the next steps will be as follows: - attach different PDF files (contained in different folders) for each different recipient Any of your suggestions are welcome.

[@premierweddingsmediagroup2591]

Do you know if it's possible to write a script where you can upload a CSV file containing email addresses you've SENT to, and then have the script filter that list and export a new CSV file that only includes the emails of those that have NOT replied from the original list?

[@saperis]

In theory, you can do almost everything with Apps Script. Off the top of my head I don't see why you couldn't upload a CSV file to Drive, check the content in Google Sheets, and then act upon it.

[@angelcawili6138]

Hello! Why is the mail merge not working on my subject line?

[@saperis]

Hi Angel. Make sure that you have no typos or extra spaces. The subject line of the draft message has to correspond to the subject line you pass in when you execute the merge (minute 8:40 in the video).

[@mantu401]

Hi is it possible to pop up the composed email before sending. Please help me thank you

[@saperis]

I checked the Google Apps Script documentation and found no possibility to make each message pop up before it is sent. Here you can also have a look yourself if you want to: developers.google.com/apps-script/reference/gmail

[@mantu401]

@@saperis Thank you for the information I have one more question like is it possible to copy data from ranges with same format to email body using script

[@saperis]

​@@mantu401 Yes, you can copy data from sheets to a Gmail message. If you need a hint on how to write that code check out this tutorial where I link a code template: kzbin.info/www/bejne/paKQdXx3fceHgq8

[@yantiratnasari4083]

Thanks for sharing! great video, reallly help me! Is there any fields limitation in this mail merge? I tried with 21 fields, somehow some of it does not want to appear in the mail merge, thanks

[@saperis]

I've never tried out the limits but I don't see why you shouldn't be able to use 21 fields. Maybe check the range in your Sheets again. Are you reading all of the 21 "fields" or columns?

[@yantiratnasari4083]

@@saperis thanks for replied, I found out that I need to copy paste the field name to notepad then to {{gmail draft}}, 19 already solved, the other 2 still does not successful

[@coreymccall2963]

I was wondering if you can help me get an understanding with a code. I'm using Google Forms script editor and I followed a video called "Google Forms - Email Notification Script - Send Confirmation Emails To Users" by another youtuber called Learn Google Spreadsheets. I did everything and that works fine. I found a code to send the respondents response in the email, but I inserted the code but it's not doing the action. I put it under the code that is able to send the confirmation email but it's showing "

[@saperis]

Hi Corey. I can have a quick look at your code to see if I can find the "bug". Write me an email to [e-mail] and I'll get back to you. Greetings, Chanel

[@coreymccall2963]

@@saperis Thank you will do right now.

[@atlanticshield6813]

Even after closing the gap between the {{First Name}} and clearing the email sent section, my emails still send out with out a first name. Any advice?

[@atlanticshield6813]

It works in the subject line but not the email body itself. very confusing. Any advise? Maybe the code is off somehow when I downloaded it?

[@saperis]

If it works in the subject line itself but not in the email body I'm guessing there's a typo in the latter place.

[@rajeshn65]

@@saperis No, i have copy pasted the same. It works well with address & Subject but not in the body.. is there something that u can help with?

[@saperis]

@@rajeshn65 Sorry, can't do anything more than give you tips.

[@rajeshn65]

@@saperis I found a way to do that, the thing is, we have to first put the fields in the subject line, then copy paste the same in the body and it works then.

[@sumantjain6047]

Could you please share the appscript code link?

[@saperis]

This is the original template: developers.google.com/apps-script/samples/automations/mail-merge You can copy the code by following along as I write my version of the script if that's the code you want.

[@sooryakriz2396]

How can i get the script code?

[@saperis]

I based my video on this script: developers.google.com/gsuite/solutions/mail-merge

[@phuonguyennguyen3768]

Hello, How I can mail merge with attach file

[@saperis]

I've never sent out a mail merge with attachments, so I don't have knowledge about it. But here I found a video tutorial that might be useful: kzbin.info/www/bejne/Z4LZmH-vZb9oobs

[@phuonguyennguyen3768]

@@saperis thanks a lot but this video doesn't have code script detail 😞

[@saperis]

Sorry about that.

[@TheLoukas77]

@@saperis You are awesome, you saved me with that link! awesome lesson too

[@jyotichoudhary9356]

How to connect with you

[@saperis]

Fill out the contact form on my website: saperis.io/contact/

[@jyotichoudhary9356]

I can't able to pay your fee for Google script but I want to learn Google script how can we use column data is null that row data not copy and which column data is not null then all row is paste other sheet