Use Google Sheets to send 10 different emails at the same time!


Hello everybody this is Oscar Leal and today I’m going to make a short tutorial on how you can send multiple emails in a very short amount of time using google spreadsheets. The first thing I’m going to do is open up my gmail. I’m already logged in. So let’s say I want to go to my sent folder – nothing we sent yet. What I’m going to do now let’s go to google.com/sheets. I’m going to open up a new blank spreadsheet. Now the first thing I’m going to do is label the first cell “Email Address”. Which I will do it in a second. The second one I’m going to call it “Subject” and this one will be “Message”. Alright. So the way this is going to work is that it’s going to let me send out 10 different emails at one time. You are able to send out more if you want to but this is all I’m going to do for now. Just going to spread that a little over here. So as long as you have these filled out, we can move on to the next step. Alright. Go ahead and go to the top and select Tools and select Script Editor. And when I include a script you going to paste into the script editor in the description. you’ll get this blank project. I already have my script already filled out here. Paste it over the existing function here. Save this – name it whatever you want. And now you’re ready to come back here and fill in your information. I’m going to go ahead and email myself, so I’m going to duplicate this ten times. I’m going to put here similar (repeating subject lines) and the message you can put whatever you want. I already have some things typed up, so that’s the convenient part about this method. So first person “Hey Bob bring chips.” “Eva pick up Lucy.” Third person “Bring soda.” “Remind Kelly about the party tonight, thanks.” “Pick up Richard five from work.” And “Will you be attending?” You can put any text that you want. Now that it’s filled out. I actually have an extra one here. You come back to your Google script and press Run. If this is the first time running your application it will ask you for permission. This is just set to your specific email address so only you can use it. Alright so let’s see what happens here. Go back to my email. As you can see it’s sent them all out. “Please let me know if you’re gonna make it.” “Will you be attending?” “Pick up Richard from work.” And all of the subject lines can be different as well. I’ll be including a little bit more about what you can do to modify the script if needed. But hopefully that saves you a lot of time in the future. Thanks again.

4 thoughts on “Use Google Sheets to send 10 different emails at the same time!

  1. My email is sending, but i receiving error "Failed to send email: no recipient (line 28, file "Code")Dismiss
    ". But the email is going well. Please suggest why i am receiving this error?

Leave a Reply

Your email address will not be published. Required fields are marked *