Send bulk mails | google script | google sheets | excel | how to | e-mail marketing
Hello,
Welcome to my Blog. Today, I have something new and exciting to share with you.
We all know how to send a mail to a friend , business client,and other. But today i will tell you a new and easy way to send a mail to many in just a few clicks.
Have you ever send mails using gmail sheets. Yes,you read right..using google sheets to send mails.
You can control how to send, what to send, when to send, how many times to send, all these things on google sheets apps. it would be very easy to control.
Let's start
1. Login to your your google Drive.
Firstly,you need to login Google Drive account using your gmail account. And then one a new blank google sheet.
2. Create Menu
After opening google sheet, Add column of Name, Email address, Status, Subject.
And on right side merge few cell into one. In which Type your message. Below the Cell type your Subject(you can skip this )
or You can type your message and subject in columns of message and subject.
3. Now, your sheet looks complete to operate but it won't work. You have to write or paste the script in script editor. Go to tools , then go to script and write or paste this script. Now save the file and run the script. Grant permission to google script editor.
4. Now you are ready to send mails.
You need to a trigger to auto run this script. Add a trigger and your file is fully complete.
5. You don't need to repeat these for sending mails again.
Just clear status column text. it will start sending again. You can selectively send mails, just clear the column text of that person you want to send mail.
THANK YOU FOR READING
Comments
Post a Comment