--- title: What is Mail Merge In Google Workspace and how to do a mail merge in Google Workspace? description: Mail Merge --- [Skip to content](https://support.econz.net/customer/what-is-mail-merge-in-google-workspace-and-how-to-do-a-mail-merge-in-google-workspace#main-content) English Show submenu for translations [Customer portal](https://support.econz.net/portal?hsLang=en) ![logo.jpg\]](https://support.econz.net/hs-fs/hubfs/logo.jpg?height=40&name=logo.jpg) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://support.econz.net/portal) - Go to Econz Website Go to Econz Website Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://support.econz.net/customer?hsLang=en) 2. [Google Workspace](https://support.econz.net/customer/google-workspace?hsLang=en) 3. [Gmail](https://support.econz.net/customer/google-workspace?hsLang=en#gmail) # What is Mail Merge In Google Workspace and how to do a mail merge in Google Workspace? ## Mail Merge   Mail merge is a feature in Google Workspace that allows you to send personalized emails or letters to multiple recipients. It's a great way to save time and effort when sending mass communications. **Steps to do a mail merge in Google Workspace:-**  :- Click the following button to make a copy of the Gmail/Sheets Mail Merge sample spreadsheet. The Apps Script project for this solution is attached to the spreadsheet. [Make a copy](https://docs.google.com/spreadsheets/d/1w8bnEEei0U5fYcOJXfA7ItdyXxnUGnQGJ4vFZrZE04Q/copy) :- In your copied spreadsheet, update the Recipients column with email addresses you want to use in the mail merge. :- (Optional) Add, edit, or remove columns to customize the data you want to include in your email template. If you change the name of the Recipient or Email Sent columns, you must update the corresponding code in the Apps Script project. You can open the Apps Script project from the spreadsheet by clicking Extensions \> Apps Script. ![](https://lh4.googleusercontent.com/9E9n2UkXnI8FRy0sGtdSzz0E31bWiW5xCXVJGkWpOig_i2uDX-xl2tUDaiHo3B5S87CVFqGUJ-YLO0PvzIwUDN2oaOocyrx2mQHN3P56L1Uwop3s-axiFpWI9dJfT3U7YdgkqFg52rp_-GRTOdHAowE) ### **Create an email template** :- In your Gmail account, create an email draft. To include data from the spreadsheet in your email, use placeholders that correspond to column names surrounded by curly braces, such as **.** - If you format the text in the email, you must also format the placeholder brackets. - Placeholders are case sensitive and must exactly match the column headers. :- Copy the subject line of your email draft. ![](https://lh3.googleusercontent.com/NkNUkHNJQek1AU5k6Hh9wsv2uqxiyrndOdERuFBVRNUM4GORIkcqLTGnb4ShetdNQ-x-5br5HeMnc5f7Rp8y2q6qzp6rjxP96mFohW0bdRz_bkd3IcVQtU4Ax1lw0vuHwbU3OzMtjpkSGR7o6mqmeds) ![](https://lh3.googleusercontent.com/bzKBnTXk9rak_dYbDu3Gzt9WoRBFCZP9zucdmRIUevSjWfC9eB5_S24Ew17hLJkcpEmNIZWtjk0wMlSekNdCkJWnRoZLhHSSOt3sBmlaRncfEXgUr70jXsK4KQgEch4wBI5LosjxC0tPeq-BrVKUSzk) #### **Run the script** :- In the spreadsheet, click Mail Merge \> Send Emails. You might need to refresh the page for this custom menu to appear. ![](https://lh3.googleusercontent.com/NRJTnm5jmQ0c8TYxTgVmdk8gLAorQMAwGcmpIEnkP4gQJCWdmHIZuipZDdMxC4FaoZ6N4PEWdX0It7RSRMbNjWp80gV8cz1iBTETnvKaPEEfLU3tCqBAbY-kFsloV6_ArnU_iSTvomV1SgFdfQ7BS_4) :- When prompted, authorize the script. If the OAuth consent screen displays the warning, This app isn't verified, continue by selecting Advanced \> Go to {Project Name} (unsafe). ![](https://lh5.googleusercontent.com/ZVNgWiRpIpyziX-HspVVIvgXGNLvjqo3J5LB-g6amLj1CfyxfRycUZ_3qFp_rgphpcX7wSRaFLyc6mG7Jgo2TOfLEjYU83DlTKZ6CtR-ZoAtXfQbntVeqbYyzG5X5gqHrAWgffPPxJQ-OQwY-pxg568) ![](https://lh6.googleusercontent.com/Ruj6lHrF4ZP-vB_AVDjw2-CGlHAsmkq-ItWHMm39mJa61r-rd2hsoXq77l9sm5U835CZza_JvvGbB4m7ZzkL0uqBRUf10SwslCxg5edZ9-ZJEFNa0LbhYRsx34IhR89Z_txbzOChy3DTKB4uixRvKFg) ![](https://lh4.googleusercontent.com/RJIPNygDcZcJMGJYEo6DcP8McY2VV5ajiQ_2So3EC5M8AmBYBEvd5_JI2k9Pc1urblZhMfvnyXSG4pkGZJ7Mblv6yUTAvfJQyMTyIq2VeaVaIrZH-jYBKyrC6lcse_bvIDl_-vjmr2icnF4Rw3PSI5U) ![](https://lh6.googleusercontent.com/LAgyKydpeKq3TAJoz1TRc_OJbrnLoNH3RfpSQkcKRUR0RZPNa-Y2XTtjB6g6WyGqITn9PIGkCFgDYusNKAMUAjuJN4L_Mm8mDQUcDCkxHCNDWxVk55fzjynHl3ssjIpiAD4yMhcG4HvSeHAynxcY9Os) :- Click Mail Merge \> Send Emails again. ![](https://lh5.googleusercontent.com/4ZQjGaXC36VIFpndWNwKjZhW0cJogZlKvrNWfU4-tpcoUw47aG5ciyWqY7r-2otFLPOs4HELtykXBxXThi2rGlpbsf9Vbj_JSI9M_lRaCVVDxVtFnVoPxmQCj4JgE66pXefyP9l9RrHEQmmtg-w2Wgo) ![](https://lh6.googleusercontent.com/avrF0Yk1G0IwqV1WwlCTNAck8ZARgShI4e2nxMra7nUyO0tUcHsPRF_iGBXh0WgF6XeEddxQGTHxlLpzG-OgX8NqPzR_1qtfeaVZxxRNBCRjZUGd1r3nK-uq_Ut_bhJt-r2dRQVJfmswhN050MjD5A0) ![](https://lh4.googleusercontent.com/QMCwPEhVo9Gjjjdb9m03l4kZMBA3yNM3AkoErq3SpPrOg0PGY44gPl4iYw-2oVfVhjX018huam4sKN9GMh8uBOUAKVf6FCiwGhrxBDjd0HhRXqtBuVeFDBcvCiLk2ec4DCHFmq5XMOMfeY_qwWy-PTw) :- Paste the email template subject line and click OK. If you applied a filter to the sheet, the script still emails the filtered participants, but it won't add the timestamp. ![](https://lh6.googleusercontent.com/tz27tXNvskd6PkeQkQV-1Rb5_pBuzwRKQOqBX2kn4zgN3nauYILcHUFpm_WxnOjq5nC0OsK_bfdnMih053R6duZH-W9_D5D6JbLkaQVqW2SOS1-PC26ypxu9mcd2xNdvk5M6JDyWG41oTObvx2Ab9Ss) Please find the below support article for your reference:-  [https://developers.google.com/apps-script/samples/automations/mail-merge](https://developers.google.com/apps-script/samples/automations/mail-merge) - [Google Workspace](https://support.econz.net/customer/google-workspace?hsLang=en#main-content) - [Reset and recover passwords](https://support.econz.net/customer/google-workspace?hsLang=en#reset-and-recover-passwords) - [Email issue](https://support.econz.net/customer/google-workspace?hsLang=en#email-issue) - [catch-all address](https://support.econz.net/customer/google-workspace?hsLang=en#catch-all-address) - [Download Google Data](https://support.econz.net/customer/google-workspace?hsLang=en#download-google-data) - [Gmail](https://support.econz.net/customer/google-workspace?hsLang=en#gmail) - [MX Records](https://support.econz.net/customer/google-workspace?hsLang=en#mx-records) - [Company Logo](https://support.econz.net/customer/google-workspace?hsLang=en#company-logo) - [Sharing drive files to the trusted domains](https://support.econz.net/customer/google-workspace?hsLang=en#sharing-drive-files-to-the-trusted-domains) - [Mobile Device Management](https://support.econz.net/customer/google-workspace?hsLang=en#mobile-device-management) - [Restrict emails based on a size](https://support.econz.net/customer/google-workspace?hsLang=en#restrict-emails-based-on-a-size) - [Create Google Calendar Event](https://support.econz.net/customer/google-workspace?hsLang=en#create-google-calendar-event) - [less secure app](https://support.econz.net/customer/google-workspace?hsLang=en#less-secure-app) - [Drive & Docs](https://support.econz.net/customer/google-workspace?hsLang=en#drive-docs) - [Users](https://support.econz.net/customer/google-workspace?hsLang=en#users) - [Install GCPW](https://support.econz.net/customer/google-workspace?hsLang=en#install-gcpw) - [Add email aliases for user from google admin console](https://support.econz.net/customer/google-workspace?hsLang=en#add-email-aliases-for-user-from-google-admin-console) - [Set up Google Workspace user signatures in Gmail](https://support.econz.net/customer/google-workspace?hsLang=en#set-up-google-workspace-user-signatures-in-gmail) - [Add or remove printers](https://support.econz.net/customer/google-workspace?hsLang=en#add-or-remove-printers) - [New updates to Google Workspace](https://support.econz.net/customer/google-workspace?hsLang=en#new-updates-to-google-workspace) - [DNS](https://support.econz.net/customer/google-workspace?hsLang=en#dns) - [DNS Records](https://support.econz.net/customer/google-workspace?hsLang=en#dns-records) - [Admin roles](https://support.econz.net/customer/google-workspace?hsLang=en#admin-roles) - [Security](https://support.econz.net/customer/google-workspace?hsLang=en#security) - [Forms & Surveys](https://support.econz.net/customer/google-workspace?hsLang=en#forms-surveys) - [password](https://support.econz.net/customer/google-workspace?hsLang=en#password) - [Calendar](https://support.econz.net/customer/google-workspace?hsLang=en#calendar) - [Google vault](https://support.econz.net/customer/google-workspace?hsLang=en#google-vault) - [har file](https://support.econz.net/customer/google-workspace?hsLang=en#har-file) - [Cloud Data Sync](https://support.econz.net/customer/google-workspace?hsLang=en#cloud-data-sync) - [LDAP](https://support.econz.net/customer/google-workspace?hsLang=en#ldap) - [Routing](https://support.econz.net/customer/google-workspace?hsLang=en#routing) - [Data Migration](https://support.econz.net/customer/google-workspace?hsLang=en#data-migration) - [Organizational Unit(OU)](https://support.econz.net/customer/google-workspace?hsLang=en#organizational-unitou) - [License and subscription](https://support.econz.net/customer/google-workspace?hsLang=en#license-and-subscription) - [GWSMO](https://support.econz.net/customer/google-workspace?hsLang=en#gwsmo) - [Report and Audit](https://support.econz.net/customer/google-workspace?hsLang=en#report-and-audit) - [SMTP](https://support.econz.net/customer/google-workspace?hsLang=en#smtp) - [GWMME](https://support.econz.net/customer/google-workspace?hsLang=en#gwmme) - [password sync](https://support.econz.net/customer/google-workspace?hsLang=en#password-sync) - [Google Sites](https://support.econz.net/customer/google-workspace?hsLang=en#google-sites) - [Google services](https://support.econz.net/customer/google-workspace?hsLang=en#google-services) - [jamboard](https://support.econz.net/customer/google-workspace?hsLang=en#jamboard) - [Google Add-ons](https://support.econz.net/customer/google-workspace?hsLang=en#google-add-ons) - [GCPW](https://support.econz.net/customer/google-workspace?hsLang=en#gcpw) - [Keep](https://support.econz.net/customer/google-workspace?hsLang=en#keep) - [outlook](https://support.econz.net/customer/google-workspace?hsLang=en#outlook) - [Devices](https://support.econz.net/customer/google-workspace?hsLang=en#devices) - [Apps](https://support.econz.net/customer/google-workspace?hsLang=en#apps) - [Spam, phishing, and malware](https://support.econz.net/customer/google-workspace?hsLang=en#spam-phishing-and-malware) - [Windows](https://support.econz.net/customer/google-workspace?hsLang=en#windows) - [Meet Hardware](https://support.econz.net/customer/google-workspace?hsLang=en#meet-hardware) - [user settings](https://support.econz.net/customer/google-workspace?hsLang=en#user-settings) - [Google takeout](https://support.econz.net/customer/google-workspace?hsLang=en#google-takeout) - [Chrome Device Management](https://support.econz.net/customer/google-workspace?hsLang=en#chrome-device-management) - [networks](https://support.econz.net/customer/google-workspace?hsLang=en#networks) - [Chrome Enterprise Management](https://support.econz.net/customer/google-workspace?hsLang=en#chrome-enterprise-management) [![](https://support.econz.net/hs-fs/hubfs/econz%20logo.png?width=600&height=164&name=econz%20logo.png)](http://econz.cloud) Help Center Copyright © 2026, Econz IT Services Pvt Ltd