{"id":38736,"date":"2022-01-26T16:49:35","date_gmt":"2022-01-26T15:49:35","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=38736"},"modified":"2026-04-20T21:57:23","modified_gmt":"2026-04-20T19:57:23","slug":"courriel-de-masse-personnalise","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/how-to-solve-with-sheetgo\/personalized-mass-email\/","title":{"rendered":"Comment envoyer des courriels de masse personnalis\u00e9s"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>The majority of us have experienced either sending or receiving a mass email in both our working and personal lives. There are many mass emailing solutions that already exist to help overcome certain limitations such as email limits, time-consuming email inputs, etc. However, it\u2019s important to note that many solutions don\u2019t offer one vital thing: the opportunity to personalize mass emails.<\/p>\n<p>Sending a personalized mass email is particularly important within a working environment, as it could be the make or break of reaching your business objectives. This may include acquiring new clients, receiving payment on time, or simply increasing your marketing campaign metrics. In this article, we will show you the importance of a personalized mass email, and how to successfully send these using the Sheetgo web app in just a few clicks of a button!<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#d3e3ff&#8221; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;44972&#8243; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; header_font_size=&#8221;33px&#8221; header_4_font_size=&#8221;24px&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Ready to <span style=\"background-color: rgba(41,121,255,0.2);\">streamline<\/span> your data?<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;START NOW&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h2>Why are personalized mass emails so important?<\/h2>\n<p>There are numerous advantages to sending out a personalized mass email, which can hugely impact the performance of your organization in almost any department.<\/p>\n<p>Here are just a few ways that a personalized mass email is important for your company:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul>\n<li><b>Increase in email open rate<\/b> &#8211; Generally, a personalized mass email is more likely to be opened as the recipient knows it was intended specifically for them.<\/li>\n<li><b>Personalization shows you care<\/b> &#8211; Personalized mass emails are a great way to quickly reach a large number of people but still show that you care. It\u2019s a great way to secure new clients or generate new leads.<\/li>\n<li><b>Customize to each recipient with specific data<\/b> &#8211; You can include specific data in each email whilst still experiencing the efficiency of a mass email.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>We can see how important these benefits are when looking at a use case. For example, let\u2019s say my objective is to send customized promotion deals to customers in order to prolong their subscription to my company\u2019s service.<\/p>\n<p>Using the database full of the details of my customers, I can transfer these into an email template so that each individual receives an in-depth email that is completely customized to them. It will include their name, their custom promotion offer and code, and even their account details.<\/p>\n<p>With this, I have a much higher chance of individuals opening the email, inputting their promotion code and extending their subscription, compared to a generic email offering a very basic promotion.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;2_5,3_5&#8243; custom_padding_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; custom_padding_tablet=&#8221;20px||||false|true&#8221; custom_padding_phone=&#8221;30px||||false|true&#8221; background_color_phone=&#8221;#f6f8f9&#8243; background_last_edited=&#8221;on|tablet&#8221; background_enable_color_phone=&#8221;on&#8221; background_enable_image_phone=&#8221;off&#8221; background_size_tablet=&#8221;cover&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;44987&#8243; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_padding_tablet=&#8221;|||200px|false|false&#8221; custom_padding_phone=&#8221;|||0px|false|false&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; text_orientation_tablet=&#8221;right&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|tablet&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Connect everything and <span style=\"background-color: rgba(41,121,255,0.2);\">automate<\/span> entire business processes<\/h4>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;START NOW&#8221; button_alignment=&#8221;left&#8221; button_alignment_tablet=&#8221;right&#8221; button_alignment_phone=&#8221;center&#8221; button_alignment_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;20px||0px||false|false&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>How to send personalized mass emails<\/h3>\n<p>The <a href=\"https:\/\/app.sheetgo.com\/\" target=\"_blank\" rel=\"noopener\">Sheetgo web app<\/a> offers a fantastic mail merging process that not only offers personalization, but a range of other benefits to help optimize and streamline your mass mailing process.<\/p>\n<p>Before we show how you can send personalized mass emails using Sheetgo, let\u2019s delve deeper into its added benefits.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h4>Benefits of Sheetgo as a mail merger<\/h4>\n<p>Other mail merging solutions help with some aspects of your mass email process, but often they limit you in other ways such as email limitations, lack of personalization etc.<\/p>\n<p>Google now does offer a <a href=\"https:\/\/support.google.com\/mail\/answer\/11243118\" target=\"_blank\" rel=\"noopener\">multi-send feature<\/a> for Gmail in order for users to send multiple emails at once for email marketing, announcements, and newsletters. Although any Google Account can access this feature and create its own mailing lists, it does have a few limitations. <\/p>\n<p>The main limitations of Google\u2019s multi-send feature include:[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul>\n<li><b>Unable to send individual custom messages:<\/b> Google does not offer a solution to create personalized messages for individual recipients. You can only send the exact same email content to your list of contacts.<\/li>\n<li><b>1500 send limit:<\/b> You can only send up to 1,500 emails to recipients per day using the multi-send feature, compared to the 2,000 limit for regular emails from a work account.<\/li>\n<li><b>Manual input:<\/b> Users still need to manually input their recipient email addresses into Gmail in order to send out the emails.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Here are some of the main benefits of Sheetgo that other mail mergers, including Google\u2019s multi-send feature, don\u2019t have:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul>\n<li><b>All-in-one workflow:<\/b> In the Sheetgo web app, your mass email process will be handled from beginning to end, with a connection directly between your data and your email.<\/li>\n<li><b>Customize your email content:<\/b> Sheetgo automatically pulls the dynamic data from your spreadsheet and adds it to your email template, so you have unique emails for every recipient.\n<li><b>Send data straight from a spreadsheet:<\/b> Send hundreds of emails in a matter of minutes from a simple spreadsheet. Just add the data related to your email content, create your email content, and Sheetgo handles the rest.<\/li>\n<li><b>Automated sending process:<\/b> Once you\u2019ve connected your data, added your email template and customized your settings, Sheetgo will send the emails for you. You don\u2019t have to worry about anything else!<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]Already convinced! Sign up to Sheetgo for free by clicking <a href=\"https:\/\/app.sheetgo.com\/\" target=\"_blank\" rel=\"noopener\">here.<\/a>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h4>How to send a mass email<\/h4>\n<p>In the Sheetgo web app, the dynamic data (the data that\u2019s different for each recipient), will be pulled from a spreadsheet and automatically inserted into the email template you create. As a result, each recipient will receive a personalized email that includes the data specific to them.<\/p>\n<p>Let\u2019s use the use case mentioned above as our example to demonstrate how to send a personalized mass email using the Sheetgo web app.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h5>Step 1. Add your data into a spreadsheet<\/h5>\n<p>First of all, make sure that all of your dynamic data related to your recipients is contained within a spreadsheet. Each category of data should have its own column. In our example, I\u2019d create a column for Client name, account number, promotion offer, promotion code, promotion deadline etc.<\/p>\n<p>You can see an example of our data spreadsheet below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email@2x.png&#8221; alt=&#8221;personalized mass email 0&#8243; title_text=&#8221;P Mass Email@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h5>Step 2. Sign up for Sheetgo<\/h5>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]It\u2019s easy to sign up for Sheetgo! Log in with your Google, Microsoft, or Dropbox account to get started.<\/p>\n<p>Simply click the blue button below.[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;SING UP FOR FREE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; global_module=&#8221;44753&#8243; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h5>Step 3. Create your workflow<\/h5>\n<p>In the Sheetgo web app, click <b>Create workflow<\/b>. Select <b>Connect files<\/b> and add your spreadsheet of data as a single file. Select the correct tab containing your data.<\/p>\n<p>Once finished, press <b>Continue<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-1@2x.png&#8221; alt=&#8221;personalized mass email 1&#8243; title_text=&#8221;P Mass Email \u2013 1@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>It\u2019s time to select your next step. Scroll down to the &#8216;Generate&#8217; section and select <b>Email<\/b>.<\/p>\n<p>This is where you will add your email template content and customize your settings.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-2@2x.png&#8221; alt=&#8221;personalized mass email 2&#8243; title_text=&#8221;P Mass Email \u2013 2@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;2_5,3_5&#8243; custom_padding_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; custom_padding_tablet=&#8221;20px||||false|true&#8221; custom_padding_phone=&#8221;30px||||false|true&#8221; background_color_phone=&#8221;#f6f8f9&#8243; background_last_edited=&#8221;on|tablet&#8221; background_enable_color_phone=&#8221;on&#8221; background_enable_image_phone=&#8221;off&#8221; background_size_tablet=&#8221;cover&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;44981&#8243; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_padding_tablet=&#8221;|||200px|false|false&#8221; custom_padding_phone=&#8221;|||0px|false|false&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; text_orientation_tablet=&#8221;right&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|tablet&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Connect, merge, filter or split your\u00a0 <span style=\"background-color: rgba(41, 121, 255, 0.2);\">spreadsheets<\/span><\/h4>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;START NOW&#8221; button_alignment=&#8221;left&#8221; button_alignment_tablet=&#8221;right&#8221; button_alignment_phone=&#8221;center&#8221; button_alignment_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;20px||0px||false|false&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h5>Step 4. Automatically add your email addresses<\/h5>\n<p>Sheetgo gives you two options to add the addresses of your recipients:<\/p>\n<h6>1. Get dynamically from column<\/h6>\n<p>If you tick this option, Sheetgo will automatically add all of the email address data from the spreadsheet. Simply select the correct column that contains all of the images, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-3@2x.png&#8221; alt=&#8221;personalized mass email 3&#8243; title_text=&#8221;P Mass Email \u2013 3@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6>2. Use custom recipients<\/h6>\n<p>If you prefer to manually add your recipient email addresses, then simply select this option. Here, you can copy and paste your data into the field.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-4@2x.png&#8221; alt=&#8221;personalized mass email 4&#8243; title_text=&#8221;P Mass Email \u2013 4@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h5>Step 5. Create your email content<\/h5>\n<p>It\u2019s time to create your email content. As you will be able to see, Sheetgo automatically turns the columns from your spreadsheet into buttons so you can easily input your smart tags into the email.<\/p>\n<p>Make sure that everything you write can be sent to all of your recipients. Then add the smart tags where you want the personalized information to be.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-5@2x.png&#8221; alt=&#8221;personalized mass email 5&#8243; title_text=&#8221;P Mass Email \u2013 5@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>You can also personalize the subject title of the email. When you want to add smart tags, remember to include the double brackets around the column name, e.g. <b>{{Client first name}}<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-6@2x.png&#8221; alt=&#8221;personalized mass email 6&#8243; title_text=&#8221;P Mass Email \u2013 6@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>When you\u2019re happy with your email content, press <b>Finish and save<\/b>.<\/p>\n<p>Sheetgo will automatically replace these smart tags with the correct data from the spreadsheet for each recipient. Furthermore, as the workflow is now complete, Sheetgo will automatically send out every single personalized email to its recipient!<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/01\/P-Mass-Email-\u2013-7@2x.png&#8221; alt=&#8221;personalized mass email 7&#8243; title_text=&#8221;P Mass Email \u2013 7@2x&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>How to send personalized mass emails in Gmail<\/h3>\n<p>And there you have it! By mass mailing from Sheetgo, not only can you personalize your email content, but you can do everything automatically through the Gmail integration.<\/p>\n<p>If you\u2019d like to learn more about mass emailing software, check out our article on the <a href=\"https:\/\/www.sheetgo.com\/blog\/productivity-tips\/best-mass-email-software\/\">Top 5 best mass emailing software in 2026<\/a>!<\/p>\n<p>Alternatively, take a look at our related articles below!<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;2_5,3_5&#8243; custom_padding_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_image=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; custom_padding_tablet=&#8221;20px||||false|true&#8221; custom_padding_phone=&#8221;30px||||false|true&#8221; background_color_phone=&#8221;#f6f8f9&#8243; background_last_edited=&#8221;on|tablet&#8221; background_enable_color_phone=&#8221;on&#8221; background_enable_image_phone=&#8221;off&#8221; background_size_tablet=&#8221;cover&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;44987&#8243; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_column][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_padding_tablet=&#8221;|||200px|false|false&#8221; custom_padding_phone=&#8221;|||0px|false|false&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; text_orientation_tablet=&#8221;right&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|tablet&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Connect everything and <span style=\"background-color: rgba(41,121,255,0.2);\">automate<\/span> entire business processes<\/h4>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;START NOW&#8221; button_alignment=&#8221;left&#8221; button_alignment_tablet=&#8221;right&#8221; button_alignment_phone=&#8221;center&#8221; button_alignment_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;20px||0px||false|false&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The majority of us have experienced either sending or receiving a mass email in both our working and personal lives. There are many mass emailing solutions that already exist to help overcome certain limitations such as email limits, time-consuming email inputs, etc. However, it\u2019s important to note that many solutions don\u2019t offer one vital thing: [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":38737,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-38736","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/38736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=38736"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/38736\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/38737"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=38736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=38736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=38736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}