Google Sheets Mail Merge - Email - No Addons - Tutorial

Поділитися
Вставка
  • Опубліковано 27 лис 2024

КОМЕНТАРІ • 242

  • @brettjones8004
    @brettjones8004 4 роки тому +5

    I have been needing to know how to this for years. The things I have learned from these videos has saved the nonprofit I work an absurd amount of time by not having to do repetitive , automatable things like this. Thank you!

  • @WardyHoot
    @WardyHoot 5 років тому +6

    A very easy to follow step by step instruction. I've used it to send out yearly and half yearly dues for a Lions service club. Excellent and highly recommended.

  • @lexiriam
    @lexiriam 8 місяців тому +1

    How can this video only have 1.5k thumb-ups? It should be in the millions! Thank you for your video. It was perfect and exactly what I needed. #Subscribed!

  • @abdullahquhtani4247
    @abdullahquhtani4247 5 років тому +3

    Great but it would be greater if you extend it more to add these following task:
    1- add one field so the script can write a value in after sending each email so I can know who I sent email to and didn’t.
    2- how to write values in email body in an alternating colored rows in a table.
    3- make an option to trigger the script after each submission if I use it with google forms.
    I’m sure most ppl need these complete in one script instead of using multi scripts.
    Thank you for your appreciated efforts.

  • @rgetsy1
    @rgetsy1 3 роки тому

    The best explanation to date. Paid for courses that wasn't near as good as this.

  • @marcelcharest7662
    @marcelcharest7662 3 роки тому +6

    You are an excellent teacher. You explain very well. The explanations are clear. The sound of your voice and your diction are excellent. Thank you for the services you render us. It's very appreciated.
    Bon baiser de Montréal

  • @jross380
    @jross380 5 років тому

    Great tutorial. What I like best is that you quickly show the steps without lingering or saying the same thing 10 different ways. If we don't understand something or it's too quick we can always stop and go back. Unfortunately other videos may mean well but are soooo slow to explain or get to the point. Thanks again

  • @kylemoore3804
    @kylemoore3804 3 роки тому

    This entire series is AMAZING!!!! It has changed the way I do business because there are so many remedial tasks I can automate! Thank you!

  • @abdulfatiraziz369
    @abdulfatiraziz369 4 роки тому +1

    1000000000000000000000000000000000000000 TIMES out of 5. You just saved my Thousands of Dollars!! Bring more videos like this man! Subscribed, liked and shared!

  • @mithunmusabbir9444
    @mithunmusabbir9444 5 років тому +3

    I don't have words to thank u enough for this video.. specially the last part.. awesome...

  • @deals4platter
    @deals4platter 5 років тому +4

    Can't wait to set this up for some upcoming projects I have. Thank you for sharing.

  • @fttx6673
    @fttx6673 3 роки тому

    This is what I have been searching for for a long time

  • @liangmale
    @liangmale 5 років тому +3

    Excellent tutorial as always, you are doing great work, please create more content like this one

  • @Parthkushwaha
    @Parthkushwaha 4 роки тому +1

    Thank you so much, looked at a bunch of videos before finding yours. Successful!

  • @hirenkakkad3747
    @hirenkakkad3747 5 років тому +1

    Really fantastic video. Your all videos are informative and I never miss it.

  • @mcan543
    @mcan543 5 років тому

    You are one of the best channel on UA-cam

  • @sxswutah-ww6dr
    @sxswutah-ww6dr 4 місяці тому

    This was awesome and very informative. Thank you

  • @Markd4Comment
    @Markd4Comment 4 роки тому +1

    Looks great. I have to learn scripting to understand what you’re saying.

  • @DILEEPKUMAR-is1vi
    @DILEEPKUMAR-is1vi 3 роки тому +1

    Very good tutorial for custom email. Thanks a lot.

  • @diasmuchon
    @diasmuchon 3 роки тому +3

    I love your videos and they're making me very productive with GSHEETS. I'd like to ask a favor. Whenever you teach us a Script, could you insert on the description the finished sample so we can copy and work on.

  • @leticiaandradepieronipaes5564

    It helped me a lot. Thanks!!!

  • @johnklaassen1260
    @johnklaassen1260 2 роки тому

    Thanks for the video. Do you have any trouble embedding images in the template and then having them show up when sent?

  • @DinoRodriguez
    @DinoRodriguez 5 років тому +1

    This was an amazing video, thank you for all your hard work. Super useful!!

  • @wkportfolio3765
    @wkportfolio3765 2 роки тому

    I liked the video and the idea of how you got it working

  • @lionelchng881
    @lionelchng881 3 роки тому +2

    A very warm thank you. I appreciate it.

  • @stefanocancinovargas7870
    @stefanocancinovargas7870 4 роки тому +3

    I need attach different PDF file for each e-mail, help me please.

  • @gregking3086
    @gregking3086 3 роки тому

    Your videos have helped greatly. Keep up the good work. I do have a need to make something like this non-container bound as other processes need to utilize mail merge. My company has blacklisted all mail merge add-ons and need to find a way to make this readily available without duplicating code in spreadsheets.

  • @isaaccruzguido592
    @isaaccruzguido592 4 роки тому +3

    Great Tutorial! Quick Question, if we want to CC people, how could I write it in the script?

  • @JimmySale-z3k
    @JimmySale-z3k 9 місяців тому

    Hey there, thanks for the info however i need to schedule emails for particular date , do you know how should I do it?

  • @erikarupert3181
    @erikarupert3181 3 роки тому +1

    Thank you for the video, it has helped me on most of the email I am trying to send out. Now to figure out how to put the html code in for a different link to go to each person.

  • @priyankajoshi6906
    @priyankajoshi6906 4 роки тому +1

    Thank you for sharing. It's really helpful.

  • @tosattam
    @tosattam 6 місяців тому

    In this exactly same set up can we send attachments from Google drive using file id as another column in the main sheet

  • @pallabkumardas6514
    @pallabkumardas6514 4 роки тому +2

    Thank you for this amazing tutorial. What about personalized subjects and personalized pdfs (like certificates)...?

  • @thareqabdulaziz6564
    @thareqabdulaziz6564 4 роки тому +1

    great tutorial! I have a question, Is it possible if we make a button to upload a pdf file to a spreadsheet? then we can press the email button and the uploaded pdf file will be sent to the name "checked in the box.

  • @RevanthSai09-d2v
    @RevanthSai09-d2v Рік тому

    Thank you for the amazing video really helpful. Could also help how can we add CC mail id to the same scripts while sending bulk mails.

  • @tedjammers
    @tedjammers 5 років тому +3

    10 out of 5 stars

  • @rectimm
    @rectimm 2 роки тому

    This is wonderful. I am a part of a massive spreadsheet and its hard for me to see each detail. Is there a way to only send an email for the cell that's been edited?

  • @rugusat6266
    @rugusat6266 2 роки тому

    Hey,
    I coded as it is in video still throwing an error syntax error missing ) after argument list (line 9, file code.gs". What could be the problem Can you please fix this ?

  • @josealexandrefilho3527
    @josealexandrefilho3527 4 роки тому +2

    Parabéns pela aula! Fantástico!

  • @RenatoDias
    @RenatoDias 3 роки тому

    I have a question. When you set it to send email only the box are checked, could it be date for exemple? Whenever get today date the email would be send? I couldn’t find any comment about it.
    Thank you

  • @PrathamInCloud
    @PrathamInCloud 4 роки тому

    Hi, thanks a lot for this tutorial! I am looking forward to using this on one of my marketing campaigns. Can you please tell if it is possible to change the form address? Or else it is simply the address which we are using to access the spreadsheet and press the button?

  • @AldoDavinReinardi
    @AldoDavinReinardi Рік тому

    Hey i have a question, what if i just want to send email when i checklist the checkbox (without trigger button 'Send Emails')? Thanks!

  • @samichouchane9985
    @samichouchane9985 2 роки тому

    This helped me so much, thank you!

  • @ManojKumarMandal-mk2hz
    @ManojKumarMandal-mk2hz 2 роки тому

    Thanks a lot, it is helping to a great extent.
    If this can be amended with file attachments in the same mail

  • @yasserquwaider4779
    @yasserquwaider4779 3 роки тому

    Very informative..!! It worked for me. Thanks alot ! SUBSCRIBED!

  • @ravinalravisjr.4674
    @ravinalravisjr.4674 3 роки тому

    Thanks for this,
    May I ask if there is any way I can add attachments (taken from my Google drive) to this mail merge, wherein each email will receive different files from each other?

  • @2010Sheb
    @2010Sheb 4 роки тому

    Greetings, I watched your video and am delighted, I have a question when I need to transfer means, google script, formatted text to a variable like , How to do this? I just need to add hyphens as , I take the body email itself from the cell

  • @ajayf
    @ajayf 4 роки тому +1

    Hi, my mails are being received blank except the words "[object Object]". Pls Help

  • @Xmarket77
    @Xmarket77 2 роки тому

    hello, thanks a lot for this tutorial, easy to follow & understand. can i add "Mail Request a read receipt" if this function available?

  • @sujanavan_mvsr
    @sujanavan_mvsr 3 роки тому

    Well Explained. Well Appreciated.

  • @juzfunpartystore
    @juzfunpartystore 5 років тому

    Wonderful lesson. Very useful. Thanks a lot

  • @swapnilsajwan322
    @swapnilsajwan322 2 роки тому

    Can we send mail merge with ATTACHMENTS? The attachments will be from google drive

  • @EduardoBicelisGarcia
    @EduardoBicelisGarcia 3 роки тому

    Thank you for the time you take for the videos!

    • @EduardoBicelisGarcia
      @EduardoBicelisGarcia 3 роки тому

      min 11:20 there is no 'row' function...

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 роки тому

      I don't understand the question.

    • @EduardoBicelisGarcia
      @EduardoBicelisGarcia 3 роки тому

      @@ExcelGoogleSheets thank you for answering hope not to bother you. I am just trying to learn spreadsheets. I was trying to make the video work for the 2nd (I am slow to learn) and found that error message -there is no 'row' function. I just got stuck there. Probably I'll try again tomorrow. I am sure it is my fault.

    • @EduardoBicelisGarcia
      @EduardoBicelisGarcia 3 роки тому

      perhaps it is that the 'row' no longer exist as a function.

    • @EduardoBicelisGarcia
      @EduardoBicelisGarcia 3 роки тому

      ahh, I marked it with the min 11:20 so I could find it next time.

  • @rubenmonsterman4044
    @rubenmonsterman4044 5 років тому +2

    Thanks for this amazing tutorial. 1 question ..... I have a list of 100 people and I send random 10 people an e-mail. Can I get a checkpoint of 10 randompeople?

  • @mr.a.7372
    @mr.a.7372 3 роки тому

    Brilliant! Thank you.

  • @meetadii
    @meetadii 4 роки тому

    You have great help. A lot of learning from all your tutorials. I was looking for something like this. Can we pick draft from GMail draft directly?

  • @sketzhbookid
    @sketzhbookid 3 роки тому

    great tutorial.
    how to combine it with google form, when "submit" directly send to the person who submitted it

  • @MaryTrinh-ih8fg
    @MaryTrinh-ih8fg 4 місяці тому

    is it possible to do this with different subject and different attachments?

  • @StephenDysonUK
    @StephenDysonUK 4 роки тому

    This is great. Thanks. But is their a solution for the step before which brings your emails from gmail into google sheets automatically (respecting your filters and labels)

  • @urol_k
    @urol_k 4 роки тому +3

    AMAZING TOOL!
    Is it possible to add a script that allows mail tracking and bounce?

  • @CreativeSolutionExpert
    @CreativeSolutionExpert 5 років тому

    Thanks for another great tutorial

  • @kkramer2195
    @kkramer2195 4 роки тому

    This a great tutorial video!!! I was able to get the functionally working on the first try!!! Now, I am trying to enhance it a little further, by adding the ability to email to a Group of Emails from the Label option withing Google Contacts, any tips or suggestions on how this can be done? I am still digging and doing some googling, I can't be the first person to want to have the ability to enter an email address OR to multiple emails set up with the same label in Google Contacts.

  • @MaryTrinh-ih8fg
    @MaryTrinh-ih8fg 3 місяці тому

    is there an updated version of this? I think it's under "appscripts" now in google sheets and there's no long a view logs or file menu or anything. It looks very different and unfortunately doesn't seem to work anymore.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 місяці тому

      Logs are now under Executions on the left menu and script is under Extensions->Apps Script. I don't think the code is any different though, should work the same.

  • @netboy1102
    @netboy1102 5 років тому +9

    I'd like to learn how to generate a pdf to be attached into the mail. Without using addon

  • @shailjadav3147
    @shailjadav3147 4 роки тому +1

    Thanks man !

  • @abdullahquhtani4247
    @abdullahquhtani4247 5 років тому

    Well, here.s another question in spite you didn’t answer the previous one!!
    My question is there a code that I can use which can save user account who edit my sheet. For example, I shared a sheet with about 20 friends. All of them can edit a certain field in the sheet. I want to know who edited values in the sheet and save his account in a pen another sheet. I hope you got what I mean.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  5 років тому

      Isn't that what Google Sheets version history does? File->Version History. I haven't seen any other questions.

  • @jakobfiler7225
    @jakobfiler7225 4 роки тому

    is there an easy way to populate the cell value to confirm an email has been sent for the rows you have checked. So, if you want to send the email to a couple of people first, then when you return to send it to the others you will see that some people have already been sent the email?

  • @netboy1102
    @netboy1102 5 років тому

    thanks for another nice video

  • @gcteam9607
    @gcteam9607 4 роки тому

    Hi, thanks for the tutorial. Tried it, its simply awesome. One query, how about if I want to sent it through an alias email of the account.

  • @lokanethracharyakn
    @lokanethracharyakn 7 місяців тому

    Can you help me with adding the font edit , my aim is to change the words to bold letters

  • @jordanwille6579
    @jordanwille6579 5 років тому

    So good. Thank you!

  • @thejoeroganexperiencepodcast
    @thejoeroganexperiencepodcast 4 роки тому

    Thank you so much, for this.

  • @kris13113
    @kris13113 3 роки тому

    Is it possible to schedule the email as per our preferred time?

  • @learningbegins
    @learningbegins 4 роки тому +1

    Thanks a lot!!

  • @smartcrow1291
    @smartcrow1291 4 роки тому

    hi dear, can we use AWS SES to send email from our custom email address with app script

  • @BhagyaarishCreations
    @BhagyaarishCreations 4 роки тому

    Hi, can we use this email app for outlook? Can you please suggest me?

  • @drewhutchison1756
    @drewhutchison1756 2 роки тому

    thank you, how can you have the script pause for 10 seconds between executions?

    • @drewhutchison1756
      @drewhutchison1756 2 роки тому

      also btw guys I just figured out you can add a variable to your subject line by add + row[your variable here]
      like this: "Checking in with you regarding "+ row[account number]

    • @drewhutchison1756
      @drewhutchison1756 2 роки тому

      nevermind i found it: Utilities.sleep(10000);
      if this isn't good please correct me, it worked for mine
      awesome video ty

  • @boidey
    @boidey 4 роки тому

    I dont get the body of the email shows in my email. I receive emails empty. what could be wrong?

  • @changanu
    @changanu 5 років тому

    can we create a delay between emails or can we schedule them in the script?
    Thank you

  • @nicobosonis
    @nicobosonis 3 роки тому

    How can you fix the Script delayed (1.0 min) waiting for quota. i can't figure it out with Memory Properties.

  • @juzfunpartystore
    @juzfunpartystore 5 років тому

    Hi, I tried some of the codes but got stuck. The following are the problems
    I am not able to add Google Script as add on in my sheet. It is not appearing in the search at all.
    So the command ".getActivSpreadsheet().getSheetByName("Customers"); is not working. I get the following error - TypeError: Cannot call method "getSheetByName" of null. (line 7, file "Code")
    Can you pls help me to rectify. Also if you can explain the function of each command it would be good for people like me.
    Thanks

  • @AbeNajiD
    @AbeNajiD 4 роки тому

    thanks for sharing, but i have question, how can add the attachment, and the attacment was different for different receiver...

  • @alexahavounson1628
    @alexahavounson1628 4 роки тому +1

    data.forEach( function(row){} not working anymore....whats the alternative

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 роки тому

      forEach should work the same way.

    • @benoitdeclercq925
      @benoitdeclercq925 3 роки тому +1

      @@ExcelGoogleSheets I ve got the same problem, data.forEach doesnt t work : Uncaught TypeError: a.forEach is not a function. What i can do ?

    • @shirleymkcscc7901
      @shirleymkcscc7901 3 роки тому

      could you share if you have fixed it? I have same problem.

  • @ardavalilable
    @ardavalilable 4 роки тому

    it's a great tutorial, I wonder if you can send the notifications via SMS as well, I don't mind paying for the service!

  • @andreaguerri4886
    @andreaguerri4886 4 роки тому

    Hi, I have a problem, what's the error 429? I have a code that works with cycle to find if an employee is active at work on that day, but after sending several emails, he gets stuck with this code, how come? Thanks so much

  • @stanleyphilippe
    @stanleyphilippe 4 роки тому

    Hi how to record a macro in which I have to use a published google addon?

  • @SarahStill
    @SarahStill 4 роки тому

    Is it possible to checking opening and clicking rate from this campaign???

  • @rickpionkowski5082
    @rickpionkowski5082 3 роки тому

    Is it easy to add a CC: line to the html with one or more names?

  • @vanusafeitosa3234
    @vanusafeitosa3234 3 роки тому +1

    data.forEach doesn't work, so I use .map and work, very thanks

    • @menuts7526
      @menuts7526 2 роки тому

      data.map it's work!, thank you so much.

  • @slowmov5659
    @slowmov5659 4 роки тому +1

    hey man thanks for the video, im getting this error tho and im unsure how to fix it ?
    SyntaxError: Unexpected token ';' (line 35, file "Code"),
    same code and everything but few more variables

    • @InsideMyWall
      @InsideMyWall 3 роки тому

      @Thierry Dion im having similiar problem with an = but Im declaring variables with it. SyntaxError: Unexpected token '=' (line 32, file "Code")

  • @rangwalacreations9612
    @rangwalacreations9612 4 роки тому

    what does this mean "Exception: Invalid argument: : Invalid To header (line 43, file "Code")"?

  • @vishalmarwaha7474
    @vishalmarwaha7474 5 років тому

    Hi Can you please help me out with exporting email subject lines from Gmail App using App Scripting? Please advise or please make a new session about this.

  • @tonyjohnson7058
    @tonyjohnson7058 3 роки тому

    My bad. I got an error through my own fault. It works very nicely.

  • @therealjamesmccrary
    @therealjamesmccrary 4 роки тому

    Worked through it, but stuck at running the first log for data. It is only showing one item from the range I defined and there should be two. Any thoughts?

  • @valentino0472
    @valentino0472 5 років тому

    Hi.. is it possoble to create a script that will parse gmail into google sheets? Thank you in advance

  • @jomilianowicz
    @jomilianowicz 4 роки тому +3

    How can I add a CC email?

    • @netboy1102
      @netboy1102 4 роки тому

      {........., cc:"theEmail1ToCC,heEmail2ToCC,heEmail3ToCC"}

  • @stanleyphilippe
    @stanleyphilippe 4 роки тому

    How to mail a range of data in the same format from google sheet using macros?

  • @AliAhmed-ob2ly
    @AliAhmed-ob2ly 3 роки тому

    I have multiple domains set up in my gmail. i want to send email with one of domain email setted up in gmail. please help

  • @kiarashzamirian887
    @kiarashzamirian887 2 роки тому

    How can I send qr code which exist in google sheets with this type of sending email?

  • @lashramtinilam9078
    @lashramtinilam9078 4 роки тому

    So we still need to do the script ?