> ## Content Index
> Fetch the complete content index at: https://www.jeffsu.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# [Workspace] Send Personalized Bulk Email with Mail Merge!
- URL: https://www.jeffsu.org/productivity-ping-110/
- Published: 2023-08-08T13:00:58.000Z
- Updated: 2025-09-06T01:32:02.000Z
- Description: #110
- Author: Jeff
- Tags: #newsletter, Enterprise

*Workspace editions only apply for Google Workspace users (i.e. businesses), and are sent *in addition to* the regular weekly Productivity Pings*

*(you can always* [*filter previous issues*](https://www.jeffsu.org/filter-previous-editions-by-app/) *by application!)*

## How Mail Merge saved me \~50 minutes

I recently announced I was hiring for a [Video Editor](https://www.notion.so/Join-the-Team-Video-Editor-Job-Application-8b1a71dc5ce9449fb54f3d977dfa67df?pvs=21&ref=jeffsu.org) and received around 30 submissions in the first week.

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-9.png)

I wanted to **get back to each person with a personalized answer** whether or not they were short-listed for the position, but composing a new email for each applicant would have taken hours!

And so I created a Mail Merge email from within Gmail:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-10.png)

This only took me 10 minutes to set up and as you can see, I was able to include personalized messages through the use of tags!

## How this worked

First, I created a blank Google Spreadsheet and copied and pasted their information over (Columns D-K), and added my comments after watching their edits (Column C):

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-11.png)

💡

****Pro tip:** While it’s not necessary, I find it easiest to have just 1-2 words in the Column header

Then from within Gmail compose, click the “Mail Merge” icon, toggle the checkbox, and select “Add from a spreadsheet:”

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-12.png)

Select the corresponding Google Sheet, and now you can match the corresponding column with the relevant information (e.g. The “Email” column for email):

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-13.png)

💡

****Pro tip:** You can leave the “Last Name” field blank if you only have 1 name column

Now, you can use the “@” symbol to add a placeholder for any column from within the spreadsheet!

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-14.png)

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-15.png)

And the end result? I saved a bunch of time but I was still able to share personalized feedback for EACH applicant, talk about a win-win 💪🏻

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-16.png)

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2023/08/image-17.png)

[What will you use this feature for? Let me know in the comments!](https://www.jeffsu.org/productivity-ping-110/#ghost-comments-root)

---

**Follow up questions?** Click “View Online” and you can comment on this post directly! Or give anonymous feedback [here](https://forms.gle/4Dscq21VYF3fjCcn8?ref=jeffsu.org) 📝

**Want someone to be more productive?** Let them subscribe [here](https://www.jeffsu.org/#/portal/signup) 😉

Thanks for being a subscriber, and have a great day!