{"id":780,"date":"2022-11-03T18:25:40","date_gmt":"2022-11-03T17:25:40","guid":{"rendered":"https:\/\/wp.catedu.es\/zgzsur\/?p=780"},"modified":"2022-11-03T18:26:06","modified_gmt":"2022-11-03T17:26:06","slug":"personalized-mass-emails-with-gmail","status":"publish","type":"post","link":"https:\/\/wp.catedu.es\/zgzsur\/personalized-mass-emails-with-gmail\/","title":{"rendered":"PERSONALIZED MASS EMAILS WITH GMAIL"},"content":{"rendered":"\n
Twittear<\/a><\/div>\n
\n

Personalized mass emails with Gmail<\/h1>\n
\n

In the past, it was necessary to go through a long and tedious process to send personalized mass emails.\u00a0This process involved setting up email accounts, designing templates and then writing the content, finally sending them one by one.\u00a0Now we can send personalized mass emails with Gmail and\u00a0Google Sheets<\/a><\/strong>\u00a0for FREE and without installing anything!<\/p>\n

Today,\u00a0there are tools that make this process much easier and faster.<\/strong><\/p>\n

You just need to create a spreadsheet with all the information of your recipients (Google Sheets).\u00a0Once you have the information you can use tools for email marketing and mass mailing such as\u00a0Mailchimp<\/a>\u00a0, Sendinblue or\u00a0Campaign Monitor<\/a>\u00a0.<\/p>\n

But\u00a0all these tools have their limitations<\/strong>\u00a0(number of emails, number of registrations, trial days, etc.<\/p>\n

Why use Google Sheets with Gmail<\/h2>\n

Google Sheets<\/a>\u00a0has many features that will allow you to automate your workflow when it comes to mass emails.<\/strong><\/p>\n

For example, you can use formulas to automatically update specific cells whenever something changes in other spreadsheet cells.<\/p>\n

You can also set up various triggers that will automatically fire events when certain conditions are met (eg sending an email).<\/p>\n

In this case I proposeTOTALLY FREE with 3 real examples<\/mark><\/strong>, the use of Google Sheets with an APP that is installed in the spreadsheet itself.<\/p>\n

Personalized email blasts are a great way to make your email stand out from the crowd.<\/p>\n

How to create personalized mass emails with G.Sheets<\/h2>\n

The first thing to do is use the spreadsheet provided by Google for sending mass emails.\u00a0To do this you must create a copy in the following link.<\/p>\n

\n
\n
\n
\n
Copy sheet G. Sheets<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

 <\/p>\n

\n
\n

After granting the permissions and making the copy, you must fill in the different columns.\u00a0You can change the column titles except\u00a0Recipient<\/strong>\u00a0and\u00a0Email sent<\/strong>\u00a0.<\/p>\n<\/div>\n

\n
\n
\"personalized<\/figure>\n<\/div>\n<\/div>\n<\/div>\n

You can see, step by step, the entire process of sending personalized mass emails with the following guide.<\/p>\n

Configure the base template with Gmail<\/h2>\n

You must create a base template to send personalized emails<\/strong>\u00a0.\u00a0To do this, we will use the double braces {{ }} to refer to the column titles, which will be the ones that are replaced to create the personalized emails.<\/p>\n

With placeholders in double braces\u00a0{{ placeholder }}<\/em><\/strong>\u00a0that match Google Spreadsheet column titles, you can build a draft template for Gmail.<\/p>\n

A placeholder tag is represented by each column header in the spreadsheet<\/p>\n

\n
\"Gmail
Gmail Personalized Mass Email Template 1<\/mark><\/em><\/strong><\/figcaption><\/figure>\n<\/div>\n

Take a look at the template created to inform about the “News in the training offer”.<\/p>\n

The spreadsheet has a script (an internal program) that searches for the email in drafts that\u00a0matches the email title<\/strong>\u00a0.<\/p>\n

It then inserts the data from each placeholder tag in the email draft at the location specified by the corresponding placeholder tag in the spreadsheet.<\/p>\n

This creates personalized emails that can be sent to multiple people.<\/p>\n

\n
Gmail Personalized Mass Email Template 2<\/strong><\/mark><\/em><\/figcaption><\/figure>\n<\/div>\n

GMAIL Personalized Bulk Email Tutorial<\/h2>\n

If you want to save time and effort, you can see the following\u00a0tutorial on how to send personalized mass emails with Gmail and Google Sheets<\/strong>\u00a0that I have previously mentioned.\u00a0Simple, step by step and uncomplicated with\u00a03 real examples<\/strong>\u00a0.<\/p>\n

\n
<\/div>\n<\/figure>\n

\ud83d\udd25\ud835\udde6\ud835\uddf2\ud835\uddf0\ud835\uddf0\ud835\uddf6\ud835\uddfc\ud835\uddfb\ud835\uddf2\ud835\ude00 \ud835\uddf1\ud835\uddf2\ud835\uddf9 \ud835\ude03\u00ed\ud835\uddf1\ud835\uddf2\ud835\uddfc:<\/p>\n

00:00<\/a>\u00a0Introduction<\/p>\n

00:09<\/a>\u00a0Why not use BCC or blind copying to send personalized mass emails.<\/p>\n

00:35<\/a>\u00a0Mail Merge Gmail Sheets extension for spreadsheet.<\/p>\n

01:23<\/a>\u00a0Description of the spreadsheet to send personalized mass emails.<\/p>\n

02:09<\/a>\u00a0Example 1: Communication with students.<\/p>\n

03:19<\/a>\u00a0Email template used for Example 1.<\/p>\n

06:23<\/a>\u00a0Example 2: Communication of training offers.<\/p>\n

08:05<\/a>\u00a0Three common mistakes in sending personalized mass emails with Gmail<\/p>\n

09:00<\/a>\u00a0Example 3: Email marketing campaign sending article promotion.<\/p>\n

Pros and Cons of sending personalized mass emails with Gmail<\/h2>\n

The\u00a0benefits<\/strong>\u00a0of sending personalized email blasts are numerous.\u00a0On the one hand, it’s a great way to make your email stand out from the crowd.\u00a0Since it seems that you have sent it yourself to that person only.<\/p>\n

The recipient will also see the email more professional, which can help you build an email list by giving recipients incentives to subscribe to your emails.<\/p>\n

However, there are some\u00a0drawbacks<\/strong>\u00a0to mass emailing.<\/p>\n

One downside is that you may be missing out on a lot of potential customers because they may not want to receive promotional material from someone or something they know nothing about.<\/p>\n

Another drawback is that if you send too many emails, people will start unsubscribing from your list and never open your messages again.<\/p>\n<\/div>\n

<\/div>\n\n
Twittear<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

Personalized mass emails with Gmail \u00a0 In the past, it was necessary to go through a long and tedious process to send personalized mass emails.\u00a0This process involved setting up email…<\/p>\n","protected":false},"author":355,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"yes","footnotes":""},"categories":[17],"tags":[20,106,107],"class_list":["post-780","post","type-post","status-publish","format-standard","hentry","category-web","tag-gmail","tag-mass-mail","tag-personalized-mass-mail"],"_links":{"self":[{"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/posts\/780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/users\/355"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/comments?post=780"}],"version-history":[{"count":2,"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/posts\/780\/revisions"}],"predecessor-version":[{"id":782,"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/posts\/780\/revisions\/782"}],"wp:attachment":[{"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/media?parent=780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/categories?post=780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.catedu.es\/zgzsur\/wp-json\/wp\/v2\/tags?post=780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}