Name: 在 Gmail 中發送個性化批量電子郵件（免費）！ (Send Personalized BULK Emails in Gmail (for FREE)!)
Uploaded: 2025-08-30T09:38:55.000Z
Duration: 6 min 50 s

Hey friends, in this video, I'll go over how to use Gmail and Google Sheets to send personalized emails in bulk.

朋友們，在本視頻中，我將介紹如何使用 Gmail 和 Google Sheets 批量發送個性化電子郵件。

情態副詞

I'll then leave you with three realistic situations where you might want to apply this new technique immediately.

然後，我會給你留下三種現實情況，在這些情況下，你可能想要立即應用這種新技巧。

My name is Jeff and welcome back to another episode of Think Outside the Box, where I show you creative ways to stand out at work.

我是傑夫，歡迎收看新一期的 "跳出框框思考 "節目，在這裡我將向你展示在工作中脫穎而出的創意方法。

I actually first used this mail merge method back when I was an account manager in the sales team and covering more than 200 clients per quarter.

實際上，我第一次使用這種郵件合併方法是在我還是銷售團隊客戶經理的時候，當時我每季度要接待 200 多位客戶。

Sometimes I would need to send a mass communication to all my clients, and at first, I just used the BCC method, where you add your own email in the to field and all the actual recipients in the BCC field, so they don't see each other's email addresses.

有時，我需要向所有客戶群發郵件，起初，我只是使用 BCC 方法，即在收件人資料欄中添加自己的電子郵件，在 BCC 資料欄中添加所有實際收件人，這樣他們就不會看到對方的電子郵件地址。

But I thought there must be a less generic and more efficient way to do this, and that's where Google's very own mail merge script comes in.

但我想，一定有一種不那麼通用、更有效率的方法，這就是谷歌自己的郵件合併腳本的用武之地。

Huge thanks to Martin Hoxie for building this and helping me receive some extra recognition at work.

非常感謝馬丁-霍西（Martin Hoxie）製作了這臺設備，讓我在工作中得到了額外的認可。

Go to this Google workspace for developers webpage, I'll link it down below, and scroll down to the try it section and click create a copy of sample spreadsheet.

請訪問谷歌開發人員工作區網頁，我將在下面提供鏈接，然後向下滾動到 "試用 "部分，點擊 "創建示例電子表格副本"。

Confirm you want to make a copy, and you'll see this sample mail merge spreadsheet appear.

確認要複製一份，然後就會看到這個郵件合併電子表格示例。

By the way, mail merge is the technical name for sending customized bulk emails, so if you want to sound smart at work, use that phrase.

順便說一句，郵件合併是發送定製批量電子郵件的技術名稱，所以如果你想在工作中顯得聰明，就用這個詞吧。

Right off the bat, you can change any of these column headers except for these two that I'll highlight in a different color.

一開始，你就可以更改任何一列的標題，除了這兩列，我將用不同的顏色突出顯示這兩列。

收件人欄，已發送電子郵件欄。

Recipient is where you input the email addresses, and email sent has a confirmation pop-up when the email has been successfully sent.

收件人是您輸入電子郵件地址的地方，發送電子郵件成功後會彈出確認窗口。

In my first sales example, I have my client's first name, their last name, their email addresses, their industry verticals, and their unique customer ID, CID.

在我的第一個銷售示例中，我有客戶的名、姓、電子郵件地址、垂直行業和唯一的客戶 ID（CID）。

With all this filled out, I can go to my Gmail and compose a new draft.

填寫好這些資訊後，我就可以進入 Gmail，撰寫新的草稿。

In the to field, I can start by typing two open curly brackets, go back to my mail merge sheet, copy the recipient header cell to ensure no typo can possibly occur, and paste that back here, and close this with two more curly brackets.

在 "至 "資料欄中，我可以先輸入兩個開放的大括號，然後返回郵件合併表，複製收件人標題單元格，確保不會出現錯別字，並將其粘貼到這裡，最後再用兩個大括號將其關閉。

For the subject line of the email, I want to tell them we have research reports for their specific industries.

對於電子郵件的主題行，我想告訴他們我們有針對他們特定行業的研究報告。

So I have read top vertical trends of the 22nd century, but the word vertical is enclosed within curly brackets because my clients are in different verticals.

是以，我讀到了 22 世紀垂直領域的頂級趨勢，但垂直一詞是用大括號括起來的，因為我的客戶處於不同的垂直領域。

In the body of the email, you can see I have their first name in curly brackets, their vertical in curly brackets, and their customer ID, CID, in curly brackets to prove that this is a legit email from their account manager and not spam or something, right?

在郵件正文中，您可以看到我把他們的名字放在了大括號裡，把他們的垂直名字放在了大括號裡，把他們的客戶 ID（CID）放在了大括號裡，以證明這是一封來自他們客戶經理的合法郵件，而不是垃圾郵件，對嗎？

And now we're ready to go back to the mail merge sheet to start sending the emails.

現在我們可以回到郵件合併表單，開始發送郵件了。

So you click mail merge here, click send emails, you'll see you need to provide authorization, press continue, choose your Google account.

點擊郵件合併，點擊發送郵件，你會看到需要提供授權，按繼續，選擇你的谷歌賬戶。

And although this says Google hasn't verified this app, we got the script from the official Google developer website, right?

雖然上面寫著谷歌尚未驗證這款應用，但我們從谷歌開發者官方網站上獲得了腳本，不是嗎？

更重要的是，我是一名優酷用戶。

So click advanced, go down and go to Gmail sheets mail merge, which is safe.

是以，點擊 "高級"，向下轉到 "Gmail 表單郵件合併"，這樣就安全了。

And now you should have the ability to click mail merge again.

現在你應該可以再次點擊郵件合併了。

But before we do that, go back to your Gmail draft, copy the subject line, command or control C, go back to the mail merge sheet, click mail merge, send emails.

但在此之前，請返回 Gmail 草稿，複製主題行、命令或控制 C，然後返回郵件合併表，點擊郵件合併，發送郵件。

And this time, command or control V, paste the subject line like exactly as you have it here and press okay.

這一次，用命令或控制 V 粘貼主題行，就像你在這裡粘貼的那樣，然後按 "確定"。

And in a few seconds, you'll see the email sent or will hopefully see the email sent column populate with a date and time the email has been sent.

幾秒鐘後，你就會看到電子郵件已發送，或者有望看到電子郵件已發送一欄中彈出電子郵件已發送的日期和時間。

Hopefully you decided to test this with your own email first.

希望您決定先用自己的電子郵件測試一下。

So you can go back to your inbox and confirm the mail merge has run successfully.

這樣你就可以返回收件箱，確認郵件合併已成功運行。

In my case, the vertical for me is fashion, which is correct.

就我而言，我的垂直方向是時尚，這是正確的。

I am also very fashionable and my name is correct here and my customer ID CID is correct also.

我也很時尚，我的名字在這裡是正確的，我的客戶 ID CID 也是正確的。

Now, without watching the next part of this video, let me know down the comments how you might use this tool and we'll see if my examples cover your use case.

現在，在不觀看本視頻下一部分的情況下，請在評論中告訴我你可能如何使用這個工具，我們將看看我的示例是否涵蓋了你的用例。

Second example, you're in school and you're organizing events for your fellow classmates.

第二個例子，你在學校為同學組織活動。

You have their first name, last name, their email address, the date of their specific event and their unique ID or UID.

您有他們的名、姓、電子郵件地址、特定活動的日期和唯一 ID 或 UID。

Pro tip, I created a dynamic UID here by using a combination of the left and and functions.

小貼士，我在這裡使用 left 和 and 函數的組合創建了一個動態 UID。

This is basically just taking the left two characters from their email address and combining that with their event date and number format to create an ID, you know, specific to them to use when they check in or something.

這基本上只是從他們的電子郵件地址中提取左側的兩個字元，然後將其與他們的活動日期和數字格式相結合，創建一個 ID，你知道，這是他們簽到時使用的特定 ID。

And it's important to note that this dynamic output works with the mail merge function as well.

值得注意的是，這種動態輸出也可與郵件合併功能一起使用。

The recipient in the to field doesn't change title, hi, first name, you're confirmed for tryouts.

轉到字段中的收件人不會更改標題、您好、名字，您已確認參加選拔賽。

Hi, first name, last name, please join us on this date for tryouts and you can check in with your unique ID, UID seen here.

您好，名，姓，請在此日期參加我們的選拔賽，您可以使用您的唯一 ID（UID）簽到。

All right, this last example is for professional suck ups.

好了，最後一個例子是給專業的 "笨蛋 "舉的。

I'm just including it here for the sake of being comprehensive, no judgment.

我只是為了全面起見才把它寫在這裡，並無評判之意。

And this is where you get to send, you know, personalized holiday greeting emails to colleagues, managers, directors, people who can give you a promotion and raise.

在這裡，你可以向同事、經理、主管以及那些能給你升職加薪的人發送個性化的節日問候郵件。

You have their first name, last name, email, team they're currently on and the years you've known them for.

你有他們的名字、姓氏、電子郵件、目前所在的團隊以及你認識他們的年數。

And in the email, hi, first name, I can't believe it's been this many years since we've met.

在郵件裡，你好，我的名字，真不敢相信我們已經這麼多年沒見了。

Jokes aside, here's some last pro tips if you want to use this free mail merge tool.

玩笑歸玩笑，如果你想使用這款免費的郵件合併工具，這裡還有一些最後的專業提示。

First, make sure to highlight the two columns you can't delete in another color like I did in this tutorial.

首先，確保用另一種顏色突出顯示無法刪除的兩列，就像我在本教程中所做的那樣。

So you can remind yourself to be extra careful with the recipient and email sent columns.

是以，您可以提醒自己格外小心收件人和電子郵件發送欄。

Second, whenever you want to rerun the script, clear out the email sent column by deleting the cell contents like this.

其次，每當要重新運行腳本時，就像這樣刪除單元格內容，清除已發送電子郵件列。

I'm not sure whether this is completely necessary, but it's better safe than sorry.

我不確定這是否完全必要，但安全總比遺憾好。

Finally, always remember to send a test email first to yourself before sending the final copy to others.

最後，在向他人發送最終副本之前，一定要記得先向自己發送測試郵件。

Common mistakes I've seen include using one curly bracket instead of two.

我見過的常見錯誤包括使用一個大括號而不是兩個。

Second, not copy pasting the column header exactly.

第二，不完全複製粘貼列標題。

And third, not giving this video a like if you found it helpful.

第三，如果您覺得這段視頻對您有幫助，請點個贊。

If you enjoyed this episode of Think Outside the Box, make sure to check out the entire playlist where I share even more creative ways to stand out at work.

如果您喜歡本期 "跳出框框思考 "節目，請務必查看整個播放列表，我將與您分享更多在工作中脫穎而出的創意方法。

同時，祝你有一個愉快的假期。