---
title: "Bulk send emails from a Google Sheet"
author: "Phil Bainbridge"
date: 2019-11-23T23:40:38+00:00
modified: 2019-11-25T22:20:06+00:00
canonical_url: https://pulse.appsscript.info/p/2019/11/bulk-send-emails-from-a-google-sheet/
markdown_url: https://pulse.appsscript.info/p/2019/11/bulk-send-emails-from-a-google-sheet.md
categories:
  - "Gmail"
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
description: "This is designed to loop through each row of a Google Sheet and send an email containing information from it. This means you can send personalised emails with ad-hoc information for each recipient quickly. It..."
---

# Bulk send emails from a Google Sheet

> This is designed to loop through each row of a Google Sheet and send an email containing information from it. This means you can send personalised emails with ad-hoc information for each recipient quickly.

It has been developed so that it is easily expandable for you to add further columns/rows. The script has a number of features to achieve this:

1. A menu option for easily selecting to send email, with a confirmation dialogue popup.
2. A timestamp as confirmation for when an email was sent.
3. A check that an Email Address is present and there is no current value in the Email Sent column – to prevent repeat email sending but also allow ad-hoc emailing by clearing this column for those you wish to send again.
4. A try/catch to help automatically deal with problematic emails that may break the script – an error message will be written into the Email Sent column and the script will continue on to the next row.

Source: *[The Gift of Script: Bulk send emails from Google Sheet*](https://www.pbainbridge.co.uk/2019/09/bulk-send-emails-from-google-sheet.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/11/bulk-send-emails-from-a-google-sheet/](https://pulse.appsscript.info/p/2019/11/bulk-send-emails-from-a-google-sheet/)*