"Mail Merge" is the process of sending bulk emails while using variables to personalize the message.
This Workflow shows how to use a Google Sheets Template (made by Google) for anyone to easily use with Gmail to send custom messages at scale.
1. Go to Gmail/Sheets Mail Merge - Make a copy
This Template was given by Google for anyone to use!
2. Click on Make a copy
![Click on Make a copy](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd01820e9ee2db09f2b9_eafa3471-eb94-487a-aab2-723e8671ebbd.webp)
3. Fill out your recipient info here
Use some examples, like the ones that are shown. This is just practice!
![Fill out your recipient info here](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd024311273dda0ae5e8_edited_image_49ed0d7e-5303-4f81-af23-5de353724606.webp)
4. ⭐Change the existing column headers or create new ones
Column headers = Variable names
Any data in columns will be "referenced" when you mail merge later.
(This is what allows you to fully take advantage of personalizing messages in mail merge!)
![⭐Change the existing column headers or create new ones](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd01b94dae417d1d7012_edited_image_f1e9f679-df46-4769-9930-7d07d48fb94e.webp)
5. Go to Gmail - Compose a draft message with subject and body text
![Go to Gmail - Compose a draft message with subject and body text](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd01c2eb8d26649af0aa_edited_image_0794c780-3f9f-449a-8140-5549011a5c36.webp)
6. ⭐ Use bracket markers to insert variables {{ }}
This is the power of Mail Merge!
Create a draft message using markers like {{First name}}, which correspond to column names, to indicate text you’d like to be replaced with data from the copied spreadsheet.
This allows you to personalize your messages based on the variables you choose!
![⭐ Use bracket markers to insert variables {{ }}](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd01c8c8fa396979b603_edited_image_6d043af8-4e97-4036-9419-fecab06f9ed7.webp)
7. ❗ Column names are caps sensitive
Make sure the Letter case within Markers corresponds to Column headers in the spreadsheet!
![❗ Column names are caps sensitive](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd01eac561b6883079fe_edited_image_7df2e8ca-e4cb-4292-9e8b-c25d41d77ed5.webp)
8. Go to Copy of Gmail/Sheets Mail Merge - Google Sheets
9. Click on Mail Merge
![Click on Mail Merge](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd02684e5287347dfe48_screenshot_ff138269-aa1e-46f4-81de-ae6384a4d559.webp)
10. Click on Send Emails
![Click on Send Emails](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd027baff01349e9078f_edited_image_d72ae5d2-e7e0-483a-804f-6419f55b7424.webp)
11. Click on "Continue"
This is normal!
![Click on "Continue"](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd0241014418978c228d_screenshot_32362c71-d716-4666-9d70-c9be1bdeefa2.webp)
12. Select account to send from
![Select account to send from](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd026174bc9ab6b44db1_0dc6dcd6-049c-409f-ac40-530f84781cf7.webp)
13. Click on Allow
![Click on Allow](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd02df60830cc70b7c1f_edited_image_b476d4c3-ea9f-4f87-9f14-f51d66541c91.webp)
14. Click on Mail Merge and Send Emails
![Click on Mail Merge and Send Emails](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd02421948a5b13c3230_screenshot_bf2bcab4-ad89-404b-baeb-fd3f6534933e.webp)
15. Paste subject line from Draft email ("Mail Merge Demo!") into text box
Make sure it's exactly the same, so Mail Merge can find the correct message in your Drafts folder.
![Paste subject line from Draft email ("Mail Merge Demo!") into text box](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd034311273dda0ae6c7_screenshot_6c019af8-e3a5-492f-ae55-492af51da552.webp)
16. Click Ok
![Click Ok](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd03b94dae417d1d72db_screenshot_f36f6cc0-e608-4538-a6e6-3e92ddeb6661.webp)
17. Boom! Google will populate a time stamp to confirm emails were sent
![Boom! Google will populate a time stamp to confirm emails were sent](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd0241014418978c2331_edited_image_315001d3-914f-46bf-847e-0ed5bbdadb0d.webp)
18. 👀 Let's check what was sent... Navigate to your Sent Mail folder
19. The first name here was personalized! ("Oprah")
![The first name here was personalized! ("Oprah")](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd03684e5287347dff29_f3e29d85-17d8-4284-ab13-b6020e6c97fb.webp)
20. Oprah's profession "mogul" was also dynamically inserted!
![Oprah's profession "mogul" was also dynamically inserted!](https://cdn.prod.website-files.com/60859bd6bcdbd1376fd8504b/6465bd038baeb9c8eb921b58_e4cd5e75-4a27-4597-bbd3-e288a41f3eac.webp)
21. 🎉That's it! You're a Mail Merge pro 🙌🏽