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-dz3jx3nr9g8 ай бұрын
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!
@saperis8 ай бұрын
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-dz3jx3nr9g8 ай бұрын
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
@marygloupadillo46752 жыл бұрын
The numerical value does not show in my email. So does the time of the email sent....
@saperis2 жыл бұрын
Interesting. Any guesses why? Check your code again. Did you make sure to use back ticks? Are any brackets missing?
@lovekumar-uo2yx2 жыл бұрын
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?
@saperis2 жыл бұрын
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-uo2yx2 жыл бұрын
@@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
@saperis2 жыл бұрын
@@lovekumar-uo2yx Line number 59: instead of getDataRange() you will have to use getRange().
@sooryakriz23963 жыл бұрын
Thanks :)
@saperis3 жыл бұрын
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.
@premierweddingsmediagroup25912 жыл бұрын
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?
@saperis2 жыл бұрын
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.
@angelcawili61383 жыл бұрын
Hello! Why is the mail merge not working on my subject line?
@saperis3 жыл бұрын
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).
@mantu4013 жыл бұрын
Hi is it possible to pop up the composed email before sending. Please help me thank you
@saperis3 жыл бұрын
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
@mantu4013 жыл бұрын
@@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
@saperis3 жыл бұрын
@@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
@yantiratnasari40832 жыл бұрын
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
@saperis2 жыл бұрын
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?
@yantiratnasari40832 жыл бұрын
@@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
@coreymccall29634 жыл бұрын
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 "
@saperis4 жыл бұрын
Hi Corey. I can have a quick look at your code to see if I can find the "bug". Write me an email to hello@saperis.io and I'll get back to you. Greetings, Chanel
@coreymccall29634 жыл бұрын
@@saperis Thank you will do right now.
@atlanticshield68133 жыл бұрын
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?
@atlanticshield68133 жыл бұрын
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?
@saperis3 жыл бұрын
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.
@rajeshn652 жыл бұрын
@@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?
@saperis2 жыл бұрын
@@rajeshn65 Sorry, can't do anything more than give you tips.
@rajeshn652 жыл бұрын
@@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.
@sumantjain60472 жыл бұрын
Could you please share the appscript code link?
@saperis2 жыл бұрын
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.
@sooryakriz23963 жыл бұрын
How can i get the script code?
@saperis3 жыл бұрын
I based my video on this script: developers.google.com/gsuite/solutions/mail-merge
@phuonguyennguyen37683 жыл бұрын
Hello, How I can mail merge with attach file
@saperis3 жыл бұрын
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
@phuonguyennguyen37683 жыл бұрын
@@saperis thanks a lot but this video doesn't have code script detail 😞
@saperis3 жыл бұрын
Sorry about that.
@TheLoukas772 жыл бұрын
@@saperis You are awesome, you saved me with that link! awesome lesson too
@jyotichoudhary93563 жыл бұрын
How to connect with you
@saperis3 жыл бұрын
Fill out the contact form on my website: saperis.io/contact/
@jyotichoudhary93563 жыл бұрын
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