Send Personalized BULK Emails in Gmail (for FREE)!
About this video
Su demonstrates Google’s free mail-merge sample, built by Martin Hawksey, which sends personalised bulk email from Gmail driven by a Google Sheet — the method he used as an account manager covering more than two hundred clients. The workflow: copy the sample spreadsheet, keep the Recipient and Email Sent columns untouched, and add your own columns such as first name, industry vertical and customer ID. Draft the email in Gmail using double curly brackets around column names anywhere in the recipient field, subject or body, copying headers exactly from the sheet to avoid typos, then run Mail Merge, authorise the script, paste the exact subject line, and watch the Email Sent column timestamp each delivery. He applies it to three scenarios: client updates personalised by industry and ID, school event confirmations using a formula-generated unique ID from the email prefix and event date, and personalised holiday greetings to colleagues. His closing pro tips are to colour-code the two protected columns, clear the Email Sent column before re-running, and always send yourself a test first, watching for single-bracket and header-mismatch mistakes.
Key takeaways
- Use Google’s free Sheets-and-Gmail mail merge instead of generic BCC blasts
- Never rename the Recipient or Email Sent columns; colour-code them as a warning
- Insert fields with double curly brackets, copying headers exactly from the sheet
- Test on yourself first; clear the Email Sent column before re-running
- Formula-generated IDs and per-row fields make each email feel individual
Episode details: published December 14, 2021 · 6:50 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Jeff Su’s own claims, shared for education — they are not typical or guaranteed.
← Previous: Write a Project Recap People Actually Want to Read · Next: Top 15 Canva Tips for Productivity! →
All Jeff Su videos · Jeff Su profile · Jeff Su (official site)
